[RESOLVED] PDO error

[kingdm]

$sql = "UPDATE users
					SET	`stcw_endonum`=:stcwendonum,
						`stcw_endocap`=:stcwendocap,
						`stcw_endolimit`=:stcwendolimit,
						`stcw_endombday`=:stcwendombday,
						`stcw_endodbday`=:stcwendodbday,
						`stcw_endoybday`=:stcwendoybday,
						`goc_num`=:gocnum,
						`goc_capacity`=:goccapacity,
						`goc_mbday`=:gocmbday,
						`goc_dbday`=:gocdbday,
						`goc_ybday`=:gocybday,
						`stcw_ratenum`=:stcwratenum,
						`stcw_ratecap`=:stcwratecap,
						`stcw_ratelimit`=:stcwratelimit,
						`stcw_ratembday`=:stcwratembday,
						`stcw_ratedbday`=:stcwratedbday,
						`stcw_rateybday`=:stcwrateybday
					WHERE
						id=:id";
			$stmt = $db->prepare($sql);			
			$stmt->bindValue(':stcwendonum', $db_stcwendonum, PDO::PARAM_STR);
			$stmt->bindValue(':stcwendocap', $db_stcwendocap, PDO::PARAM_STR);
			$stmt->bindValue(':stcwendolimit', $db_stcwendolimit, PDO::PARAM_STR);
			$stmt->bindValue(':stcwendombday', $db_stcwendombday, PDO::PARAM_STR);
			$stmt->bindValue(':stcwendodbday', $db_stcwendodbday, PDO::PARAM_STR);
			$stmt->bindValue(':stcwendoybday', $db_stcwendoybday, PDO::PARAM_STR);
			$stmt->bindValue(':gocnum', $db_gocnum, PDO::PARAM_STR);
			$stmt->bindValue(':goccapacity', $db_goccapacity, PDO::PARAM_STR);
			$stmt->bindValue(':gocmbday', $db_gocmbday, PDO::PARAM_STR);
			$stmt->bindValue(':gocdbday', $db_gocdbday, PDO::PARAM_STR);
			$stmt->bindValue(':gocybday', $db_gocybday, PDO::PARAM_STR);
			$stmt->bindValue(':stcwratenum', $db_stcwratenum, PDO::PARAM_STR);
			$stmt->bindValue(':stcwratecap', $db_stcwratecap, PDO::PARAM_STR);
			$stmt->bindValue(':stcwratelimit', $db_stcwratelimit, PDO::PARAM_STR);
			$stmt->bindValue(':stcwratembday', $db_stcwratembday, PDO::PARAM_STR);
			$stmt->bindValue(':stcwratedbday', $db_stcwratedbday, PDO::PARAM_STR);
			$stmt->bindValue(':stcwrateybday', $db_stcwrateybday, PDO::PARAM_STR);
			$stmt->bindValue(':id', $_SESSION['id'], PDO::PARAM_STR);
			$stmt->execute();

I'm getting an error on this one, what seems to be the problem?

Fatal error: Call to a member function prepare() on a non-object in C:\xampp\htdocs\myproject\verify2.php on line 219

This is the error, the line 219 it pertains to is the:

$stmt = $db->prepare($sql);

Anyone? Thanks.

[laserlight]

Post the code that connects to the database and makes $db the PDO object.

[kingdm]

this is my include where it connects to the database

db_connect.php

<?php

$con = mysql_connect("localhost","root","") or die(mysql_error());
$db = mysql_select_db("myproject_db",$con);

date_default_timezone_set('Asia/Manila');

function cleanString($str, $encode_ent = false) {
	$str  = @trim($str);
	if($encode_ent) {
		$str = htmlentities($str);
	}
	if(version_compare(phpversion(),'4.3.0') >= 0) {
		if(get_magic_quotes_gpc()) {
			$str = stripslashes($str);
		}
		if(@mysql_ping()) {
			$str = mysql_real_escape_string($str);
		}
		else {
			$str = addslashes($str);
		}
	}
	else {
		if(!get_magic_quotes_gpc()) {
			$str = addslashes($str);
		}
	}
	return $str;
}
?>

[halojoy]

You can not use ordinary mysql functions with PDO.
You can not use PDO functions with ordinary mysql.

Here is how you create one PDO object.
$db = new PDO()
http://www.php.net/manual/en/pdo.construct.php

<?php
/* Connect to an ODBC database using driver invocation */
$dsn = 'mysql:dbname=testdb;host=localhost';
$user = 'dbuser';
$password = 'dbpass';

try {
    $db = new PDO($dsn, $user, $password);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

?>

[kingdm]

Seems like I've got to read the whole php thing. 😕

Thanks halojoy that solves my problem. I thought ordinary mysql functions work with PDO's. 😃

[Weedpacket]

kingdm wrote:

I thought ordinary mysql functions work with PDO's.

That would negate one of the main points of having PDO. From the manual:

PDO provides a data-access abstraction layer, which means that, regardless of which database you're using, you use the same functions to issue queries and fetch data.