January 8th, 2013, 02:08 PM
|
|
|
You are using the syntax of old mysql extension. I am still getting the hang of MySqlI however i preffer using object oriented code and i use the following connection method
PHP Code:
$mysqli = new mysqli("127.0.0.1", "user", "password", "database", 3306);
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
sorry just read the procedural methodand your syntax was correct
Quote: | Originally Posted by nbasso713  I'm not sure why i'm having such a difficult time, but my mysqli $link keeps returning null even after I have declared it as a variable.
I'm able to connect to my database using everything inline on the same page, but my function files are producing the null errors.
I have also added the following to the top of a function file:
PHP Code:
require (dirname(__FILE__).'/../*/*/*/*/*/*.php')
$host= $Host; // Host name
$username= $Username; // mysqli username
$password= $Password; // mysqli password
$db_name= $Database; // Database name
// Connect to server and select databse.
global $link;
$link = mysqli_connect($host, $username, $password, $db_name)or die("cannot connect");
Even with the global $link being set on the same page as the functions being used null is still being returned.
Any help would be greatly appreciated because at this point it seems like such a pain in the *** that I should just to go back to mysql functions. |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
