What do you want to save?
Add Code snippet
New code examples
-
PHP 2022-03-19 04:35:01
php query pdo
const DB_HOST = 'localhost'; const DB_NAME = 'DB_Name'; //Name of the database const DB_USERNAME = 'username'; //Username to use const DB_PASSWORD = 'Password'; //Password for that user // Data Source Name $dsn = "mysql:host=" . DB_HOST . ... Add solution -
Other 2022-03-03 01:35:14
code for searching and displaying data database
<?php // (A) DATABASE CONFIG - CHANGE TO YOUR OWN! define('DB_HOST', 'localhost'); define('DB_NAME', 'test'); define('DB_CHARSET', 'utf8'); define('DB_USER', 'root'); define('DB_PASSWORD', ''); // (B) CONNECT TO DATABASE try { $pdo = new PDO( &q... Add solution -
PHP 2022-01-30 14:50:17
database connection in php pdo
<?php $servername = "localhost"; $username = "username"; $password = "password"; try { $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password); // set the PDO error mode to exception ... Add solution -
Other 2021-11-21 17:48:18
php-pdo-returning-single-row
$DBH = new PDO( "connection string goes here" ); $STH - $DBH -> prepare( "select figure from table1 ORDER BY x LIMIT 1" ); $STH -> execute(); $result = $STH -> fetch(); echo $result ["figure"]; $DBH = null; Add solution -
PHP 2021-11-09 06:55:08
number of rows in a mysql table pdo
//Instantiate the PDO object and connect to MySQL. $pdo = new PDO( 'mysql:host=127.0.0.1;dbname=my_database', 'username', 'password' ); //The COUNT SQL statement that we will u... Add solution -
PHP 2021-11-05 21:16:07
Uncaught Error: Call to a member function prepare() on null in C:\xampp\htdocs\facultate\CosCump\product.php:5 Stack trace: #0 {main} thrown in C:\xampp\htdocs\facultate\CosCump\product.php on line 5
try{ $conn = new PDO("mysql: host = localhost; dbname = php_crud", 'root', ''); $pdo = $conn->query("SELECT * FROM data"); $pdo->setFetchMode(PDO:: FETCH_ASSOC); while($row = $pdo->fetch()) {... Add solution -
PHP 2021-11-05 01:10:12
connect php to mysql pdo
<?php $servername = "localhost"; $username = "username"; $password = "password"; try { $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password); // set the PDO error mode to exception ... Add solution -
PHP 2021-11-03 13:02:09
php connect to postgresql
<?php $db_connection = pg_connect("host=localhost dbname=dbname user=username password=password"); $result = pg_query($db_connection, "SELECT lastname FROM employees"); ?> <?php // with PDO $myPDO = new PDO('pgsql:ho... Add solution