Category : mysqli

Invalid request message. My query is carried out on a single table having 5 columns. The 5 forms are not necessarily filled in. The result is therefore related to the forms entered. Unfortunately there must be some errors in my code. If you can help me … Thank you very much. <!doctype html> <html> <head> ..

Read more

<?php include (‘header.php’); if(count($_POST)>0) { $cons_no=$_POST[cons_no]; $result = mysqli_query($conn,"SELECT * FROM tbl_courier_track where cons_no=’$cons_no’"); } //?> Above code is in my header, but am having this below error display "assumed ‘cons_no’ (this will throw an Error in a future version of PHP) in C:wamp64wwwresultadminresult.php on line 12 Please what can i do to correct this. ..

Read more

I made the first page where the customer will enter the flight information form and input. and here where flight information will show. ` <?php if(!$connect){ echo "not connected"; } $db = mysqli_select_db($connect,’flight-booking’); if(isset($_POST[‘search’])){ $from =$_POST[‘from’]; $query = "SELECT * FROM ‘vols’ WHERE :De=’$from’ AND :A=’$to’;"; $query_run = mysqli_query($connect,$query); while($row = mysqli_fetch_array($query_run)){ ?> <tr> <td> ..

Read more

I have written this code, yet I don’t know how to update the database after I perform a transaction, based on the product I purchase. Here is the MySQLi, where I think the problem is: <?php $total = $total + ($product[‘quantity’] * $product[‘price’]); mysqli_query($db, "UPDATE product set quantity = quantity-".$product[‘quantity’]." WHERE PRODUCT_ID = ‘".$product[‘id’]."’"); //$db::table(‘product’)->decrement(‘quantity’); ..

Read more