georgebates Posted March 21, 2010 Share Posted March 21, 2010 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); ?> Link to comment https://forums.phpfreaks.com/topic/195980-mysql-error-while-trying-to-insert-into-database/ Share on other sites More sharing options...
trq Posted March 21, 2010 Share Posted March 21, 2010 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. Link to comment https://forums.phpfreaks.com/topic/195980-mysql-error-while-trying-to-insert-into-database/#findComment-1029471 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.