Page 1 of 1

Hey,i have a problem with DATABASE CONNECTION :\

Posted: Sun Aug 05, 2012 4:57 am
by mekha
hi, i have a MYSQLi connection code:

Code: Select all

<?php
	$dbhost = 'localhost';
	$dbuser = 'user';
	$dbpass = 'pass';
	$dbname = 'dbname';
	
	$mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
	if ($mysqli->connect_errno) {
		printf("Connect failed: %s\n", $mysqli->connect_error);
		exit();
	}
	
	//$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
	
    //mysql_select_db($dbname,$conn);
	//$mysqli->query("SET NAMES 'utf8' COLLATE 'utf8_general_ci'");
	function runQuery($sql)
	{
		 if($stmt = $mysqli -> prepare($sql)) {

		 $stmt->execute();
		 $stmt -> bind_result($result);
		 }
	}
	function exeQuery($stmt)
	{
		
		//$mysqli->query($sql);
	}
?>
, can u tell me what the errors in my code :\ ?
this is a mysqli not mysql!!!
---
thank you.

Re: Hey,i have a problem with DATABASE CONNECTION :\

Posted: Sun Aug 05, 2012 2:41 pm
by social_experiment
what happens when you use the code