php mysqlié-connect

# MySql improved <?php $mysqli = new mysqli("localhost", "username", "password", "dbname"); $result = $mysqli->query("SELECT lastname FROM employees"); ?> # Connection with PDO <?php $myPDO = new PDO('mysql:host=localhost;dbname=dbname', 'username', 'password'); $result = $myPDO->query("SELECT lastname FROM employees"); ?> # With PHP legacy functions: <?php mysql_connect('localhost','username','password'); mysql_select_db("dbname"); $result = mysql_query('SELECT lastname FROM employees'); ?>

php mysql connect

$host = 'localhost'; // URL to the server
$user = 'root'; // Username (xampp = root)
$pw = ''; // Password (xampp = )
$dbname = 'database'; // The name of your database 
$dsn = "mysql:host=$host;dbname=$dbname";
$options = [PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8']; // If you want to use utf-8 use this line

$db = new PDO($dsn, $user, $pw, $options); // Database Object
$db -> setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); // Use this if you want an associate array
// $db -> setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); Use this if you want an indexed array

$qry = 'select * from table;'; // Your query
$result = $db -> query($qry); // execute query

while ($row = $result -> fetch()) {
    $id = $row[/*column-name*/];
}

Posted by: Guest on March-03-2021

Code answers related to "php mysqlié-connect"

Code answers related to "PHP"

PHP Answers by Framework

Browse Popular Code Answers by Language

Answers for "php mysqlié-connect"

Code answers related to "php mysqlié-connect"

Code answers related to "PHP"

PHP Answers by Framework

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us