I'm trying to send a SQL command from a HTML button to copy contents of one table into another table, then delete the those contents from the original table. My SQL works if I run through PHPMyAdmin, but not from…
I already checked in php.ini that extension=mbstring extension=exif extension=pdo_mysql are uncommented. The mysqli.dll file is at ext folder in PHP. I restarted my server and run as administrator. I also restarted my PC but the error is still there. I…
I am creating a webservice where I need to get some data from mysql and retrieve it in a mobile app. I have been trying all day to do a query with a WHERE statement, but no success. The normal…
I'm using Opencart 3.0.2 on FreeBSD. I need to install a zip module to be able to install the OpenCart extension, but PHP 7.1 is out of date and no longer supports module installation. So I decided to upgrade the…
After having converted this code from mysql to mysqli, there appears an error while executing through the login page with the error: Fatal error: Call to a member function real_escape_string() on a non-object in dbc.php on line 127. Unfortunately I…
This is not about 'localhost'. Both the command line version of 'mysql' as well as a script I wrote in Perl (using perl-DBD-MySQL) can login, get to this database and work with it. Only PHP gives the permission denied error,…
Similar questions have been asked many times, but after reading almost every of these for over 5 hours, i have not found a suitable reply for my problem. Im not an experience php / mysql developer, but i ve managed…
My php knowledge is fairly limited but I've recently needed to update a number of web pages from an older version of php 5.2 to php 7.3. I've managed to update most of the mysql references to mysqli etc and…
I've copied the W3 schools code for performing a mysqli row count function, but when I input my variables, the returned result is always '1'. I have checked my SQL code by entering it directly into phpMyAdmin, which returns the…
My question is just similar to this question but I am using PHP version 7.4.1 in Windows 7 [32bit]. <?php if(!function_exists('mysqli_init') && !extension_loaded('mysqli')){ echo 'We dont have mysqli'; } else{ echo'Yes'; } mysqli_connect('localhost', "root", "", "akash"); ?> It returns: We…