Jump to content

MySQL Error while trying to insert into database


georgebates

Recommended Posts

Hi There,

 

I am trying to get this code working and have sat here for hours trying to figure out whats wrong. Every time I try to add to a mysql database with this is just returns the error "Unable to insert record into database". I can't figure out whats wrong with it.

 

Here's the code.

<?php
/*************************************************
* Micro Upload
*
* Version: 0.1
* Date: 2006-10-27
*
* Usage:
* Set the uploadLocation variable to the directory
* where you want to store the uploaded files.
* Use the version which is relevenat to your server OS.
*
****************************************************/

//Windows way
//$uploadLocation = "c:\\";
//Unix, Linux way
$uploadLocation = "/var/www/html/galleryadmin/upload/";

?>


<?php
$hostUrl = 'l*****';
$userName = '*****';
$password = '******';
// connect to database
$connectID = mysql_connect($hostUrl, $userName, $password)
  or die ("Sorry, can't connect to database");

//select the database to read from
mysql_select_db("majubagallery_-_data", $connectID)
  or die ("Unable to select database");	
  
  

$name=($_POST['name']);
$namen=($_POST['price']);
$thumb_url=($_POST['thumb_url']);	
$big_url=($_POST['big_url']);

if (($_POST['submitted']) && (!$_GET['modify_id'])) {
// the user has submitted a new listing
  //write to database
mysql_query ("INSERT into art_glass (name, price, thumb_url, big_url) VALUES ('$name', '$price', '$thumb_url', '$big_url')", $connectID)
  or die ("Unable to insert record into database");
if ($success) { 
print "Record Successfully Added";
header ('Location: microUpload.php');
       	}
}  else {
// The user has loaded the page to enter a new listing
// do nothing - just let the page load
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Edit links</title>
<style type="text/css">
body {font-family:verdana, arial, sans-serif; font-size:80%}
h2 {font-size:1.4em; }
h3 {padding:10px 0 0 0; margin:0;}
label {display:block; margin:8px 0 2px 0;}
a {display:block; color:#066; margin:3px 0 10px;}
a:hover {color:#000; text-decoration:none;}
input[type="submit"] {display:block; margin-top:8px;}
</style>


</head>

<body>
<h2><img src="http://www.majubagallery.co.nz/images/header.jpg" alt="" width="790" height="228" /></h2>
<h2>Add an Art Glass Piece</h2>
<a href="main.php">Back</a>
<form method="post" action="<?php $_SERVER['PHP_SELF'] ?>">


<!--topic_name-->
<p>Name</p>
<p>
  <input name="name" type="text" size="30" id="name" />
  <!--topic_description-->
</p>
<p>Price</p>
<p>
  <input name="price" />
  <!--topic_url-->
</p>
<p>
  <a href="microUpload.php" target="_blank">Upload Photos </a></p>

<p>Thumbnail Image Filename</p>
<p>
  <input name="thumb_url" type="text" size="30" id="topic_url" />
</p>
<p>Large Image Filename </p>
<input name="big_url" type="text" size="30" id="pic_big" />
<p>
  <input type="submit" value="Submit" name="submitted" />
</p>
</form>
</form>
<p>Administration and Content Management Script | ©  Copyright George Bates 2009 | All Rights Reserved</p>
</body>
</html>
<?php
// close the connection
mysql_close($connectID);
?>

 

Try changing....

 

or die ("Unable to insert record into database");

 

to....

 

or die (mysql_error());

 

so you can at least get feedback on what the problem might actually be.

 

You should then also probably investigate using trigger_error in place of or die as or die is a poor method of debugging.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.