[SOLVED] Into The Database

crapol · June 7, 2008

I want to add the code to my image path that is uploaded, as well as the ip who submitted the picture, and also a little description into the database as well, I can add it to the form on my own, but how do I connect ant and add it to my database?

Here is my code

<?php
//define a maxim size for the uploaded images
define ("MAX_SIZE","100"); 
// 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","640"); 
define ("HEIGHT","480"); 

  // 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);

	 	//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); 

  	//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 errro 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['image']['name'];
	// if it is not empty
	if ($image) 
	{
		// get the original name of the file from the clients machine
		$filename = stripslashes($_FILES['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"))	
		{
			echo '<h1>Unknown extension!</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['image']['tmp_name']);
			$sizekb=filesize($_FILES['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 size limit!</h1>';
				$errors=1;
			}

  			//we will give an unique name, for example the time in unix time format
			$image_name=time().'.'.$extension;
			//the new name will be containing the full path where will be stored (images folder)
		 	$newname="images/".$image_name;
			$copied = copy($_FILES['image']['tmp_name'], $newname);
			//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='images/thumbs/small_'.$image_name;
				// 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($newname,$thumb_name,WIDTH,HEIGHT);
			}}	}}

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

  ?>

DarkWater · June 7, 2008

A MySQL database, correct? And do you have MySQLi support on your server, or not? You can use the regular MySQL functions if you don't.

crapol · June 7, 2008

A MySQL database, correct? And do you have MySQLi support on your server, or not? You can use the regular MySQL functions if you don't.

Yeah a MySQL one, I have a go daddy account, so it's MySQL

.josh · June 7, 2008

http://us3.php.net/mysql

DarkWater · June 7, 2008

Okay. You should probably read a tutorial on MySQL connections, but here's how I'd start it:

(Two ways. One short, simple way, and one to appease Daniel0. =P)

1)

<?php
$conn = mysql_connect("IP of DB", "username", "pass");
if (!$conn) {
die("Couldn't connect to DB.<br />");
}
mysql_select_db("a_db_name");
?>

2)

MySQLException.class.php:

<?php
class MySQLException extends Exception
{

    public function __construct($message, $code = 0) {

        parent::__construct($message, $code);
    }


    public function __toString() {
        return __CLASS__ . ": [{$this->code}]: {$this->message}\n";
    }

    public function MySQLError($live = FALSE) {
       $msg = parent::getMessage() . "\n<br />\n";
if ($live != TRUE) {
	$msg .= mysql_error() . "\n<br />\nOccured on line: " . parent::getLine();
}
return $msg;
    }
    public static function throwMySQL($msg, $code = 0) {
       throw new MySQLException($msg, $code);
    }
}
?>

test.php:

<?php
include 'MySQLException.class.php';
try {
@mysql_connect("localhost") or MySQLException::throwMySQL("Couldn't connect to DB:")
;
}
catch (MySQLException $e) {
echo $e->MySQLError();
}
?>

There you go. Take your pick.

Btw, Daniel0, this is why I don't recommend Exceptions for MySQL error handling for beginners. =P

crapol · June 8, 2008

I ended up writing it for myself, but it does not work, can you help me again please

Here is my form code

newad.php

   <form name="newad" method="post" enctype="multipart/form-data"  action="processor.php">
<table>

Name:   <input type="text" name="name"><br>
Description:    <input type="text" name="info"><br>
	<tr><td><input type="file" name="image" ></td></tr>
	<tr><td><input name="Submit" type="submit" value="Upload image"></td></tr>
</table>	
</form>

and here is my processor code

processor.php

<?php

//For My Database

$username="";
$password="";
$database="";

$id=$_POST['id'];
$date=$_POST['date'];
$name=$_POST['name'];
$info=$_POST['info'];
$image=$_FILES['image']['name'];

mysql_connect("my hose name",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO contacts VALUES ('',NOW(),'$name','$info','$image')";
mysql_query($query);

//define a maxim size for the uploaded images
define ("MAX_SIZE","100"); 
// 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","100"); 

  // 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);

	 	//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); 

  	//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 errro 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['image']['name'];
	// if it is not empty
	if ($image) 
	{
		// get the original name of the file from the clients machine
		$filename = stripslashes($_FILES['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"))	
		{
			echo '<h1>Unknown extension!</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['image']['tmp_name']);
			$sizekb=filesize($_FILES['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 size limit!</h1>';
				$errors=1;
			}

  			//we will give an unique name, for example the time in unix time format
			$image_name=time().'.'.$extension;
			//the new name will be containing the full path where will be stored (images folder)
		 	$newname="images/".$image_name;
			$copied = copy($_FILES['image']['tmp_name'], $newname);
			//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='images/thumbs/thumb_'.$image_name;
				// 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($newname,$thumb_name,WIDTH,HEIGHT);
			}}	}}

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

  ?>

It just does not go in the database at all

NOTE: it does do what I want to the picture, just no info goes into the database

.josh · June 8, 2008

- add or trigger_error(); after all your mysql function calls.

- echo out your variables, including $query to make sure everything is holding what you expect

- make sure your table name is correct, db name is correct, etc..

- make sure you are putting the variables in the same order as what's in your table

- try the echoed $query directly into your db in phpmyadmin or whatever

If you still can't figure it out, post error messages, and other relevant oddities

crapol · June 8, 2008

- add or trigger_error(); after all your mysql function calls.

- echo out your variables, including $query to make sure everything is holding what you expect

- make sure your table name is correct, db name is correct, etc..

- make sure you are putting the variables in the same order as what's in your table

- try the echoed $query directly into your db in phpmyadmin or whatever

If you still can't figure it out, post error messages, and other relevant oddities

You are a genius!!!

I got it working because of this forum

1. I do have one question though, how can I log their IP in the database incase they upload a child porn picture or something else bad so I can report it?

2. the image name in my database is the image name I uploaded, not the one that it is changed to by the code, how do I get it to do that?

DarkWater · June 8, 2008

1) The IP accessing the page is stored in $_SERVER['REMOTE_ADDR'].

2) I'm pretty sure that if someone is uploading child porn onto your server, they'd be using a proxy. But meh.

.josh · June 8, 2008

You need to reorder your code to do your query after where you change the name in your script so you can use that instead.

DarkWater · June 8, 2008

Woops, he edited that in after I posted. =P

crapol · June 8, 2008

1) The IP accessing the page is stored in $_SERVER['REMOTE_ADDR'].

2) I'm pretty sure that if someone is uploading child porn onto your server, they'd be using a proxy. But meh.

Ok have it all working but two things, the id part)it does not fill it in in the database) and the ip thing you told me about, where would I put in in the code again?

crapol · June 8, 2008

Got the IP thing to work, no I just need to know how to get the id to work, so it shows what number it is in the database

Here is the code I have for it

$username="";
$password='";
$database="";


$id=$_POST['id'];
$date=$_POST['date'];
$REMOTE_ADDR=$_SERVER['REMOTE_ADDR'];
$name=$_POST['name'];
$info=$_POST['info'];
$image=$_FILES['image']['name'];


mysql_connect("",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO randomshoop VALUES ('',NOW(),'$REMOTE_ADDR','$name','$info','$thumb_name')";
mysql_query($query);

crapol · June 8, 2008

got it, how do I put that this is solved?

Also thanks so much

Sign In

[SOLVED] Into The Database

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information