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 ..
Category : pdo
I learning mysql pdo requests and now came up to this: $query= "SELECT * FROM table WHERE name=:name"; $params= [‘:name’=> $name]; $result= $pdo->prepare($query); $result->execute($params); So, there are two questions. Does this code good enough or how to make it better? May be in one line or so. I use PHP to connect with mysql. Is ..
I’m trying to set a (single) bit field to true / 1 in MariaDB > 10.2.4. With older versions MariaDB gave a warning but updated the record. Now I keep getting 1406 / Data too long for column …". If I hardcode the statement with something like $sql .= ‘, active_flag = true’; it works ..
please be patient with me I am still learning, see attached code. this works perfectly for my application but now i want to take it live and in the odd occasion that there is an error i would like the user not to see a long string of SQL warning errors if that makes sense. ..
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 = ..
I want to insert a new dataset into a MySQL table tab with external data, but also with data from another table otherTab using the others’ table primary key and another condition. However, it could be that the requested row simply does not exist (anymore) or the result set is empty due to a mismatch ..
I want to run a php script using command line in Ubuntu (command: php /var/www/test.php), it runs ok in browser (url: http://example.com/test.php), but when running in command while pdo tried to connect to mysql, exception "could not find driver" was thrown, I checked the including paths everthing is correct, could somebody please help me about ..
I have written my php query using PDO inside a try and catch, and I want to show user alert message whether form has been submitted or not. Here is the code I have written, Although record is successfully inserted but my closable div message is not showing in browser. <?php include(‘conn.php’); if(isset($_POST["save"])) { try ..
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: – ..
I’m new to PHP PDO oop. I’m trying to create a database connection using __constructor. It’s my database class code. <?php // database class class Database { // database host name private $db_host = "localhost"; // database username private $db_user = "root"; // database name private $db_name = "project_crud"; // database password private $db_pass = ..