[SOLVED] gatting the max id

[kev wood]

i am trying to get the max id out of a mysql table using the following code

 

			if ($db == "fxxxxxxx") {

			$con = mysql_connect("localhost","xxxxxxx","xxxxxxx");
				if (!$con)
					{
					die('Could not connect: ' . mysql_error());
					}

				mysql_select_db($db, $con);


			$run=mysql_query("select max(id) as maxnum from '$table'");
			$lastid = mysql_fetch_row($run);
			$lastid=$lastid[0];
			$sql="UPDATE '$table' SET image= '$consname2'  WHERE id= '$lastid'";
			$query = mysql_query($sql);	
			}

 

the image i am trying to upload is uploading onto the server but it will not store the path to the image inside the db.

[trq]

$sql="UPDATE $table SET image= '$consname2'  WHERE id= '$lastid'";

[zenag]

 no single quotes for $table
$run=mysql_query("select max(id) as maxnum from $table");

[priti]

to assured u are getting Next auto_increment do as follow

 

SHOW TABLE STATUS LIKE 'tabl_name'

 

it will return a array which contain the auto_increment latest value.

 

Thanks

[kev wood]

made those changes and it is still not entering the data into the db.

 

i am trying to run this code on a image upload page for a cms.  the user enters a news article and then once they have done the text sections of the article they then press the submit article page.  the user is then directed to a page which process the information they have entered.

 

from this page the user is then asked if they want to upload an image if the do want to then they are taken to the page which this code is on.

[kev wood]

priti i am not trying to get the amount of rows in the table i just want the last row in the table so i can perform an update on the last entered information if the user would like to add an image to it.

[trq]

Take a look at mysql_insert_id for a safer option.

 

Also, at least make an attempt to catch any errors. eg;

 

$query = mysql_query($sql) or die(mysql_error());

[kev wood]

i do usually get the errors but i had this code working then change the order of things happening and it is just laughing at me now.

[kev wood]

i got no errors and the image was still not entered into the into the db?

 

how can this be.  if it not getting entered into the db and the table is defo the correct table i am checking what is going on. 

[kev wood]

here is my code now and it still aint working and i still aint getting any errors.

 

			if ($db == "flashtestdb") {

			$con = mysql_connect("localhost","flashtest","flash");
				if (!$con)
					{
					die('Could not connect: ' . mysql_error());
					}

				mysql_select_db($db, $con) ;


			$run=mysql_query("select max(id) as maxnum from $table") or die(mysql_error());
			$lastid = mysql_fetch_row($run) or die(mysql_error());
			$lastid=$lastid[0] or die(mysql_error());
			$sql="UPDATE $table SET image= '$consname2'  WHERE id= '$lastid'" or die(mysql_error());
			$query = mysql_query($sql) or die(mysql_error());	
			}

[kev wood]

i have changed my insert into section on the last page to now look like this

 

$sql= "INSERT INTO $table (date, title, article) VALUES ('$a', '$b', '$c')";
$lastid = mysql_insert_id();

 

when i echo out the $lastid variable on the next page i just get 0 all the time.  i am sending the value over in a hidden form field like this

 

echo "<form action=\"image_up.php\" method=\"post\">";
echo "<input type=\"hidden\" name=\"dropdown\" value=\"$db\" />";
echo "<input type=\"hidden\" name=\"radio\" value=\"$table\" />";
echo "<input type=\"hidden\" name=\"lastid\" value=\"$lastid\" />";
echo "<input type=\"submit\" value=\"Save Article\"/>";
echo "</form>";

 

why wont this work!

[revraz]

because you don't execute the query?

[kev wood]

fixed that my i just put it in the wrong place thanks for pointing that out.  it still not putting the image inside the db tho.

 

here is the full page of code

 

<?php
		$db = $_POST['dropdown'];

		$table = $_POST['radio'];

		$lastid = $_POST['lastid'];		

	 	echo $db;
		echo $table;
		echo $lastid;



		 //define a maxim size for the uploaded images
define ("MAX_SIZE","500"); 
// define the width and height for the thumbnail
// note that theese dimmensions are considered the maximum dimmension and are not fixed, 
// because we have to keep the image ratio intact or it will be deformed
define ("WIDTH","150"); 
define ("HEIGHT","120"); 

  // this is the function that will create the thumbnail image from the uploaded image
// the resize will be done considering the width and height defined, but without deforming the image
function make_thumb($img_name,$filename,$new_w,$new_h)
{
	//get image extension.
	$ext=getExtension($img_name);
	//creates the new image using the appropriate function from gd library
	if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext))
		$src_img=imagecreatefromjpeg($img_name);

  	if(!strcmp("png",$ext))
		$src_img=imagecreatefrompng($img_name);

if(!strcmp("gif",$ext))
	$src_img=imagecreatefromgif($img_name);

	 	//gets the dimmensions of the image
	$old_x=imageSX($src_img);
	$old_y=imageSY($src_img);

	 // next we will calculate the new dimmensions for the thumbnail image
	// the next steps will be taken: 
	// 	1. calculate the ratio by dividing the old dimmensions with the new ones
	//	2. if the ratio for the width is higher, the width will remain the one define in WIDTH variable
	//		and the height will be calculated so the image ratio will not change
	//	3. otherwise we will use the height ratio for the image
	// as a result, only one of the dimmensions will be from the fixed ones
	$ratio1=$old_x/$new_w;
	$ratio2=$old_y/$new_h;
	if($ratio1>$ratio2)	{
		$thumb_w=$new_w;
		$thumb_h=$old_y/$ratio1;
	}
	else	{
		$thumb_h=$new_h;
		$thumb_w=$old_x/$ratio2;
	}

  	// we create a new image with the new dimmensions
	$dst_img=ImageCreateTrueColor($thumb_w,$thumb_h);
// resize the big image to the new created one
	imagecopyresampled($dst_img,$src_img,0,0,0,0,$thumb_w,$thumb_h,$old_x,$old_y); 

	// output the created image to the file. Now we will have the thumbnail into the file named by $filename
	if(!strcmp("png",$ext))
		imagepng($dst_img,$filename); 
	else
		imagejpeg($dst_img,$filename);

if (!strcmp("gif",$ext))
	imagegif($dst_img,$filename); 

  	//destroys source and destination images. 
	imagedestroy($dst_img); 
	imagedestroy($src_img); 
}

// This function reads the extension of the file. 
// It is used to determine if the file is an image by checking the extension. 
function getExtension($str) {
         $i = strrpos($str,".");
         if (!$i) { return ""; }
         $l = strlen($str) - $i;
         $ext = substr($str,$i+1,$l);
         return $ext;
}
  // This variable is used as a flag. The value is initialized with 0 (meaning no error found) 
//and it will be changed to 1 if an error occures. If the error occures the file will not be uploaded.
$errors=0;
// checks if the form has been submitted
if(isset($_POST['Submit']))
{
//reads the name of the file the user submitted for uploading
	$image=$_FILES['cons_image']['name'];
	// if it is not empty
	if ($image) 
	{
		// get the original name of the file from the clients machine
		$filename = stripslashes($_FILES['cons_image']['name']);

		// get the extension of the file in a lower case format
	 	$extension = getExtension($filename);
		$extension = strtolower($extension);
		// if it is not a known extension, we will suppose it is an error, print an error message 
		//and will not upload the file, otherwise we continue
		if (($extension != "jpg")  && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif"))	
		{
			echo '<h1>Unknown extension!  Please use .gif, .jpg or .png files only.</h1>';
			$errors=1;
		}
		else
		{
			// get the size of the image in bytes
			// $_FILES[\'image\'][\'tmp_name\'] is the temporary filename of the file in which 
		//the uploaded file was stored on the server
			$size=getimagesize($_FILES['cons_image']['tmp_name']);
			$sizekb=filesize($_FILES['cons_image']['tmp_name']);

			//compare the size with the maxim size we defined and print error if bigger
			if ($sizekb > MAX_SIZE*1024)
			{
				echo '<h1>You have exceeded the 1MB size limit!</h1>';
				$errors=1;
			}


		$rand= rand(0, 100);
  			//we will give an unique name, for example a random number
			$image_name=cons.'.'.$extension;
			//the new name will be containing the full path where will be stored (images folder)
		 	$consname="image/".$image_name;
		 	$consname2="image/thumbs/thumb_".$image_name;
			$copied = copy($_FILES['cons_image']['tmp_name'], $consname);
			$copied = copy($_FILES['cons_image']['tmp_name'], $consname2);

		if ($db == "xxxxxxxx") {

			$con = mysql_connect("localhost","xxxxxx","xxxxx");
				if (!$con)
					{
					die('Could not connect: ' . mysql_error());
					}

				mysql_select_db($db, $con);


			$sql="UPDATE '$table' SET image= '$consname2'  WHERE id= '$lastid'";
			$query = mysql_query($sql);	
			}
			//we verify if the image has been uploaded, and print error instead
			if (!$copied) {
				echo '<h1>Copy unsuccessfull!</h1>';
				$errors=1;
			}
			else
			{
				// the new thumbnail image will be placed in images/thumbs/ folder
				$thumb_name=$consname2;
				// call the function that will create the thumbnail. The function will get as parameters 
				//the image name, the thumbnail name and the width and height desired for the thumbnail
				$thumb=make_thumb($consname,$thumb_name,WIDTH,HEIGHT);
			}
		}	
	}
}

  //If no errors registred, print the success message and show the thumbnail image created
if(isset($_POST['Submit']) && !$errors) 
{
	echo "<h5>Thumbnail created Successfully!</h5>";
	echo '<img src="'.$thumb_name.'">';
echo $lastid; 
}
?>

	<form name="newad" method="post" enctype="multipart/form-data"  action="">
		<input type="file" name="cons_image"  >
		<input name="Submit" type="submit"  id="image1" value="Upload image" />
	</form>
	<p>
	<form name="remove_file" method="post" action="unlink_file_broad.php">
		<input name="delete" type="submit" id="delete" value="remove image" />
	</form>

[kev wood]

it looks like i have sorted it out.  i originally had it working with just one db and as soon as it tried to get it to work by passing the variables across for three db's it stopped working.

 

it might be the long way round but i now have three different image upload pages one for each db and its set of tables.