I’m thinking I need to use a while loop within a while loop, but when I do I receive bizarre results. I have the following PHP: $sql = “SELECT c.id, c.title, c.image, u.profileImage, u.fname, u….
Tag: mysql
How can i insert these multiple row data into mysql database
This is my html ajax and js code, it’s dynamic input field form i want to insert multiple data into mysql database following these column “pro” “des” “qty” “price” “sub_total” . “qty” and “price” used auto sum value to &…
“ MySQL Service detected with wrong path ” After opening xampp
I install Mysql server in my pc to practice j2ee and after some days i uninstalled it and installed xampp for PHP development but it is showing port not free error. I already try using cmd and …
PHP 7.1 on Docker PDO Driver not installed – Verified it is on the image
I am always getting an error that PDO driver not found. I tried restarting, installing PDO extensions directly. Note that this docker setup works on my Linux box last night. Only difference is I did it from scratch compared to on my Windows box I already has images. After getting the error initially I tried t…
Dynamic MySQL Query with PHP
I am looking for a way to make dynamic queries to my MySQL server. At the moment this is the code I use to update data on the server: As you can see, the SQL column names are the same as thedeskAttrkeys. I’m looking for a way to make this line a loop so, that I don’t need to change
Where to put custom SQL code in CakePHP 3?
I’m building an application in CakePHP 3. It uses a number of legacy databases which are not built in the Cake conventions. I do not want to use any of the ORM features Cake provides, as it’s more tedious to set up all the relations than just write “Raw SQL”. We are also not going to m…
Symfony 1.4 connect to mysql via SSL
I need to change an old Symfony 1.4 application so that it’s able to connect to mysql via ssl-connection. I found a lot about this for Symfony >= 2. But unfortunately not for this dusty one. For validation purposes I already made it work by editing ./apps/frontend/lib/vendor/symfony/lib/plugins/sfDoc…
Laravel – PDO Prepared Statement – Cannot execute queries while other unbuffered queries are active
I am having trouble running the following prepared statement in Laravel: I get the following error: [2017-06-08 03:41:35] local.ERROR: PDOException: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if…
Invalid datetime format: 1292 Incorrect datetime value – Laravel 5.2
I’m getting this error when I insert these value into my database table: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ’24/06/2017′ for column ‘registration_from’ at row 1 (SQL: insert into `campus_registrations` (`campus_major_class_id`, `registration_…
404 Page Not Found when run Codeigniter project inside var/www/html/ on Ubuntu 16.04 LTS?
I have installed LAMP (Linux, Apache2, MySQL, and PHP) stack. I have a project directory named ‘mahasiswa’. When i ran it on Windows 8 was working well (using XAMPP). Then, when i run it on my …