Category : pdo

I need some help with my PHP as I have a hard time with my code. I have upgraded to mysql 8.0 but I am unable to insert the data into the database following by: //Connect to the database require_once(‘config.php’); $tracking_sql = $link->prepare(‘INSERT INTO tracking (firstname) VALUES (?)’); $firstname = ‘Ben’; if ($tracking_sql->execute([$firstname])) { echo ..

Read more

I am trying a few days ago to make a dynamic filter in QUERY using PDO and IN (); More I am trying problems when joining the two scripts if I already use separately. Where am I wrong? $conn = &$pdo; $conditions = Array(); $parameters = Array(); $words = [‘linux’,’windows’]; if (!empty($words)) { $IN = ..

Read more

I’ve got a docker container setup running on a machine, which has: A PHP Web Server Container A MySQL 8.0 Container A PHPMyAdmin Container Here’s roughly what my docker-compose.yml file has: version: ‘3.3’ services: front: build: context: ./front dockerfile: Dockerfile container_name: front-end depends_on: – db ports: – 8000:80 # phpmyadmin phpmyadmin: container_name: phpmyadmin depends_on: – ..

Read more