Here we are connecting to our database using mysqli.
I'm doing two ways but basically the same, simply you can have:
<?php
$db_conx = new mysqli('localhost', 'db_user', 'db_password', 'db_name');
As I tend to add more into the file like the website name and slogan amoungst other things, I use define.
<?php
define('DATAB_HOST', 'IPADDRESS'); = Add the IP address or localhost
define('DATAB_PORT', '3306'); = Normally 3306
define('DATAB_DB', 'DATABASE-NAME'); = The Database Name
define('DATAB_UNAME', 'USRNAME'); = Database Username
define('DATAB_PASS', 'DB-PASSWORD'); = Database Password
$db_conx = new mysqli(''.DATAB_HOST.':'.DATAB_PORT.'', DATAB_UNAME, DATAB_PASS, DATAB_DB);
Once you have you're database connection
You can check using the database and port checker at: databaseportcheck.php
Save the document as "dbconnection.php"
Content by: Steve Stewart
Posted a year ago with 1145 views
Database Connect with MySQLi
Here we are connecting to our database using mysqli.
I'm doing two ways but basically the same, simply you can have:
<?php $db_conx = new mysqli('localhost', 'db_user', 'db_password', 'db_name');As I tend to add more into the file like the website name and slogan amoungst other things, I use define.
<?php define('DATAB_HOST', 'IPADDRESS'); = Add the IP address or localhost define('DATAB_PORT', '3306'); = Normally 3306 define('DATAB_DB', 'DATABASE-NAME'); = The Database Name define('DATAB_UNAME', 'USRNAME'); = Database Username define('DATAB_PASS', 'DB-PASSWORD'); = Database Password $db_conx = new mysqli(''.DATAB_HOST.':'.DATAB_PORT.'', DATAB_UNAME, DATAB_PASS, DATAB_DB);Once you have you're database connection
You can check using the database and port checker at: databaseportcheck.php
Save the document as "dbconnection.php"