Jump to content


Photo

MYQLI ERROR


  • Please log in to reply
No replies to this topic

#1 afaaro

afaaro

    New member

  • New Members
  • 1 posts

Posted 20 February 2012 - 06:52 PM

Hello everyone

about 4 days am experiencing this problem if you can help me out this is the code; it's not updating at all it's just redirecting me to the page

$db = new mysqli($dbHost, $dbUser, $dbPass, $dbName) or die (mysql_error());

function editcat($cid,$name,$desc,$ok=false) {
	global $db;
	
	$cid = intval($cid);
	
	if (!$ok) {
		$result = $db->query("SELECT * FROM category WHERE cid='$cid'");
		$row = $result->fetch_object();
	        $cid = $row->cid;
		$name = $row->name;
		$desc = $row->desc;

		echo "<table width='100%' align='center' cellspacing='0' cellpadding='1'>\n";
		echo "<form name='form_editcat' method='post' action='index.php?page=articles&op=editCategory&cid=$cid&ok=true'>";
		
			echo "<tr><td><b>Name</b><td><input type='text' name='name' size='40' maxlength='255' value=\"$name\">\n";
			echo "<tr><td><b>Description</b><td><input type='text' name='desc' size='40' maxlength='255' value=\"$desc\">\n";
			echo "<tr><td colspan='2'><input type='submit' name='Submit' value='Modify'>\n";

		echo "</form>\n";
		echo "</table>\n";
	} else {	
		$save = true;
        
        if ($name=="") { $save = false; $msg = "Name field is empty!";}
        if ($desc=="") { $save = false; $msg = "Description field is empty!";}
	
		if ($save) {
			$db->query("UPDATE category SET name='$name',desc='$desc' WHERE cid='$cid'");
			echo "<meta http-equiv='refresh' content='0;URL=index.php?page=articles'>";
		} else {
			echo "<div align='center' id='errorText'><b>$msg</b></div>";
		}
	}
}




  • 0




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users