values won't insert into database

MsKazza · November 15, 2011

Hi all,

I've made a page the variables are being recieved and echo'd ok, however they are not being inserted into the database. below is the file with the insert statement.

any help really appreciated.

MsKazza

<?php
// Database connect
$con = mysql_connect("mysql1.myhost.ie","admin_book","root123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("book_test", $con);

$orderid=$_GET['orderid'];



//Parse Values from Coupon.php Form
$orderid  = mysql_real_escape_string(trim($_POST['orderid']));
$design  = mysql_real_escape_string(trim($_POST['design']));
$childname  = mysql_real_escape_string(trim($_POST['childname']));
$address = mysql_real_escape_string(trim($_POST['address']));

echo $orderid;
echo $design;
echo $childname;
echo $address;

$sql="INSERT INTO details (orderid, design, childname, address)
VALUES
('$orderid','$design','$childname','$address')";


?>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Digital Scribe Books</title>
<link href="style.css" rel="stylesheet" type="text/css" />

<script type="text/javascript">
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
</script>


</head>

<body onload="MM_preloadImages('images/buttons/home_over.png','images/buttons/books_over.png','images/buttons/cards_over.png','images/buttons/letters_over.png')">


<div id="snow">
<div id="wrapper">


<div id="header">

<div id="logo"><img src="images/digital_scripe.png" width="218" height="91" /></div>


<div id="menu"><a href="index.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Home','','images/buttons/home_over.png',1)"><img src="images/buttons/home_act.png" name="Home" width="131" height="132" border="0" id="Home" /></a><a href="books.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Books','','images/buttons/books_over.png',1)"><img src="images/buttons/books_act.png" name="Books" width="131" height="132" border="0" id="Books" /></a><a href="cards.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Cards','','images/buttons/cards_over.png',1)"><img src="images/buttons/cards_act.png" name="Cards" width="131" height="132" border="0" id="Cards" /></a><a href="letters.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Letters','','images/buttons/letters_over.png',1)"><img src="images/buttons/letters_act.png" name="Letters" width="131" height="132" border="0" id="Letters" /></a></div>
</div>




<div id="content">
<div id="info_bar"><br /><br /><br />
<p>Your personal order number is:</p><br />

<br />
<p>Please fill out the details of where you would like your order to be shipped to.</p>
</div>


<form action="card_paynow.php" method="POST" name="custdetails" id="custdetails">
  <table width="60%"  border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td width="19%">orderid</td>
      <td width="81%"><input name="orderid" type="hidden" value="<? echo $orderid; ?>"></td>
    </tr>
    <tr>
      <td>name</td>
      <td><input name="name" type="text" id="name"></td>
    </tr>
    <tr>
      <td>surname</td>
      <td><input name="surname" type="text" id="surname"></td>
    </tr>
    <tr>
      <td>address 1 </td>
      <td><input name="add1" type="text" id="add1"></td>
    </tr>
    <tr>
      <td>address 2 </td>
      <td><input name="add2" type="text" id="add2"></td>
    </tr>
    <tr>
      <td>town</td>
      <td><input name="town" type="text" id="town"></td>
    </tr>
    <tr>
      <td>county</td>
      <td><input name="county" type="text" id="county"></td>
    </tr>
    <tr>
      <td>postcode</td>
      <td><input name="postcode" type="text" id="postcode"></td>
    </tr>
    <tr>
      <td>number</td>
      <td><input name="phone" type="text" id="phone"></td>
    </tr>
    <tr>
      <td>email</td>
      <td><input name="email" type="text" id="email"></td>
    </tr>
    <tr>
      <td> </td>
      <td> </td>
    </tr>
    <tr>
      <td> </td>
      <td><input type="submit" name="Submit" value="Continue..."></td>
    </tr>
    <tr>
      <td> </td>
      <td> </td>
    </tr>
  </table>
  
  
</form>

</div>


<div id="footer" class="clear"><div id="sign"><div id="sign_text">Personalised<br />
Books</div>
</div></div>

</div></div>






</body>
</html>

litebearer · November 15, 2011

You aren't executing your query (ie $result = mysql_query($sql); )

MsKazza · November 15, 2011

thanks very much, got it working now

Sign In

values won't insert into database

Recommended Posts

MsKazza

Link to comment

Share on other sites

litebearer

Link to comment

Share on other sites

MsKazza

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information