Hey. Iam learning PHP and MYSQL atm. So i wrote already code which will display everything from my database nicely into HTML. I create also a button which says Delete. Now i want to write a Code which actually Deletes the specific entry (all have an ID ) but iam kinda lost. i know the command is: $sql = ̶…
Tag: mysql
WordPress PHP get_results query from MySQL DB not working
I’m using the following PHP code to attempt to fetch values from the DB of all entries with ‘ID’ equal to 5055. It doesn’t return any result, and I’m not sure what’s wrong… Answer I presume this is a local webpage you’re working on. If so, here’s a couple …
How do I remove a comma from a variable in php so I can save it as a float value? [closed]
I take data from steam and this is what I get outputed {“success”:true,”lowest_price”:”$0.82″,”volume”:”17,485″,”median_price”:”$0.82&…
How often must timezone be set for a php web application, using mysql’s session time-zone
I might be lazy, but this question seems easier to just ask than to go laborating for. I have been able to set time-zone with mysql cli, with the query I wonder, for a php web application (that keeps a users time-zone), how often must this query be made. Is it for every connection to the MySql/MariaSql databa…
Page refresh after click on register in jquery ajax php
page refreshes after data submitted. register.php Bootstrap Example
Database Schema Treeview PHP MYSQL
I am trying to create a treeview (ideally using bootstrap) from a MYSQL database table that is essentially a data dictionary structure. Every example I have seen creates a parentid in order to create the json/array input for the treeview however my data structure has all of the hierarchy levels on each line. …
php loop problems
noob problem: i have some issues with a loop in php…here is the code (i used the same methodology for other pages and it works); the code it is supposed to display the names of the products from a order, it works, but it is not showing the very first product , i don’t know why : and here is
PHP How to extract non serialize array into variables
How can I convert the following array stored in my database into a PHP array, and then extract them into PHP variables: {“wpversion”:”5.4.2″,”debug_mode”:false,”…
Inserting date in null [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 1 year ago. Improve this question I am inserting date. It works when date is set, otherwise, it doesn’t work. DateBirth t…
PHP Reporting on Hours Worked
I was wondering if anyone could help me please? I have a PHP employee timesheet that tracks hours they have worked by entering the start and end time, code is below; Is there anyway that I can generate a report and get the total hours worked for each employee in a 4 week period please? Many thanks 🙂 Answer As…