my code: $newElements=json_encode(['name'=>'jorge','age'=>23]); mysqli_query($db, "UPDATE dl SET data=json_replace(data, '$.list', cast('$newElements' as json)) WHERE id = '$ID' ") my Error: Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server…
I'm trying to run a php file in Vscode And this error keeps appear ? what I'm I suppose to do ? PHP Warning: PHP Startup: Unable to load dynamic library 'mysqli' (tried: C:xamppphpextmysqli (The specified module could not be…
i want to get the order id maximum by the relative user id $order_id = "select * from products_orders where order_user_id = $user_id AND MAX(order_id) "; $ord_del = mysqli_query($con,$order_id) ; $ord_row = mysqli_fetch_assoc($ord_del); i try this method but this wont…
With some help, I made a truck check form with buttons for pass, warning, and fail. As well as a comment button that adds a line for a comment. This is all being done in a while loop from mysqli_fetch_array.…
I am currently learning PHP and trying to figure out how to connect my MySQL database named (lead_gen_business) using OOP. I was given a task to get the specific output by the way. My problem is I am having a…
I have an array of column headers and an array of corresponding values at the same index I need to update a row using both those arrays in SQL. I know this might not be the neatest way of doing…
trying to make the user login by getting details but not working please check this here is my connection code <?php $server = "localhost"; $username = "root"; $password = ""; $database = "atm"; $conn = new mysqli($server ,$username ,$password ,"atm");…
I'm using the new mysqli::execute_query in PHP 8.2 and want to get the total number of orders placed by a customer and an array of the orders. Simplified code: $MySQLi = new mysqli( "host", "username", "password", "database"); $sql = "select…
Struggling to understand how to get the ID of the newly inserted row. This is my procedural mysqli connection and SQL INSERT statement: class DB { var $conn; function __construct($servername, $username, $password, $dbname, $dbport = 0000) { $this->conn = new…
My current computer has XAMPP installed and I have used it successfully to test PHP programs for some years. I recently bought a new computer and have installed the latest version of XAMPP on it, as well as transferring a…