mysqli query returns true but fetch_assoc doesn't work – Phpmyadmin
I am using PHP and MySQL (mysqli) in XAMPP, I have a drop down, and the user must choose one, then a query is used to find the id of the value that has been chosen but it does not…
MySQL COUNT Giving DIfferent Results – Phpmyadmin
If I use this in PHP to count records, it gives a count of 1 when there are, in fact, no records. However, when I run the same query in HeidiSQL, phpmyadmin or any other, it gives the proper 0.…
adding data from a form to a database – Phpmyadmin
I have created a webform to allow a user to request to see my CV, once the user hits submit I want to store their input inside a database in phpMyAdmin. Since I am new to PHP and using databases…
Faster way to pull averages from results of MySQL queries nested in loops – Phpmyadmin
Working on building out a php file to create a JSON for usage in a web application for keeping track of trucking margins for specific shipping routes. The goal is to have a set of data which I can insert…
Prepared statement return false always – CPanel
While trying to insert data into the database using prepared statement the prepared statement always returns false and not complete the connection. I'm using this connection on cpanel (not sure if that's related) tried to change the order tried to…
MyISAM racing conditions / LOCK TABLES – Phpmyadmin
My 'invoices' table: CREATE TABLE `invoices` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `invoice_id` int(11) NOT NULL, PRIMARY KEY (`id`,`invoice_id`), UNIQUE KEY `invoice_id` (`invoice_id`), KEY `order_id` (`order_id`) ) ENGINE=MyISAM AUTO_INCREMENT=115 DEFAULT CHARSET=utf8 When I try the query : mysqli_query($conn, "LOCK…
How to display user accounts picture and name inside a box from database in html page using php and mysqli? – Phpmyadmin
I want to display all the user account photo and name from database and put one user photo and name in a div tag and similarly with all the accounts with a link that redirect to the clicked account. But…
PHP preg_replace() is returning null when string includes a single quote but works otherwise – Phpmyadmin
The code below is very simple. PHP uses POST to collect a string from a form, which I am then looking to trim and run a preg_replace function which will strip any special characters except a single quote or a…
How to fix my MySQLi database when inserting rows to a table from php – Phpmyadmin
I'm setting up a new web application, and i want to find out a way to insert a row from PHP in Greek language I make the connection with MySQLi from PHP like this: $con = mysqli_connect("localhost", "root", "", "Mydb");…
SQL insert statement with user input to Phpmyadmin isnt working
I was trying to make a site and people could sign up/subscribe and i would store their email adresses in a database. I searched online for a solution but couldnt find anything My code: <html> <?php include_once('include/html/hoofd.php') ?> <body> <h1…