Insert Not Working - Programming

Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,148,850 members, 7,802,724 topics. Date: Friday, 19 April 2024 at 08:03 PM

Insert Not Working - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / Insert Not Working (820 Views)

How To Insert Pictures Or Images In Textedit (webdesign) / Please Help On How To Insert Smiley In An Output Text In Java Script / Insert Image Into Mysql (2) (3) (4)

(1) (Reply) (Go Down)

Insert Not Working by ckdoublene: 7:27pm On Apr 14, 2011

can someone help me figure out why this code doesn't insert data into the database ?
My other problem here is that I dont know how to determine a date a month in the future(duedate). It doesn't have to be concise.

<?php?>
<html><head>
<?php
include("getinvno.php"; 
?>
<script type="text/javascript">
var today = new Date();
var date = today.getMonth() + " / " + today.getDate() + " / " + today.getFullYear();
</script>
</head>
<body onload="document.form.ordernum.focus()">

<!--increment date to create due date (next month)-->

<br><script type="text/javascript">
document.write(date);
</script>
<form name="form">
<input type="text" size="5" name="ordernum" id="ordernum"MAXLENGTH=5 
onkeyup="getResults();if(this.value.length==this.size)document.form.invnum.focus();" />Order No:

<input type="text" size="5" name="invnum" id="invnum" />Invoice No:

AR/AP: <SELECT name=payrec>
<OPTION class=highlight value=ar selected>R
<OPTION class=highlight value=ap>P
</OPTION></SELECT><br>
<b>Bill</b> - Name: <INPUT TYPE="text" name=bname>
Street: <INPUT TYPE="text" name=bstreet>
State: <SELECT name=bstate>
<OPTION class=highlight value=fl selected>Florida
<OPTION class=highlight value=ga>Georgia
<OPTION class=highlight value=al>Alabama
<OPTION class=highlight value=la>Louisiana
<OPTION class=highlight value=sc>South Carolina
</OPTION></SELECT>
City: <INPUT TYPE="text" name="bcity"><br>
</OPTION></SELECT>
Zip: <INPUT TYPE="text" size=5name="bzip" MAXLENGTH=5
onKeyUp="if(this.value.length==this.size)document.form.contact.focus();"><br>
<b>Contact: </b><INPUT TYPE="text" name=contact><BR>
<b>Ship</b> - Name: 
<INPUT TYPE="text" name=sname>
Street <INPUT TYPE="text" name=sstreet>
State <SELECT name=sstate>
<OPTION class=highlight value=fl selected>Florida
<OPTION class=highlight value=ga>Georgia
<OPTION class=highlight value=al>Alabama
<OPTION class=highlight value=la>Louisiana
<OPTION class=highlight value=sc>South Carolina
</OPTION></SELECT>
City: <INPUT TYPE="text" name="scity"><br>
</OPTION></SELECT>
Zip: <INPUT TYPE="text" size=5name="szip" MAXLENGTH=5
onKeyUp="if(this.value.length==this.size)document.form.terms.focus();"><p>
Terms: <SELECT name=terms>
<OPTION class=highlight value=net 10 selected>Net 10
<OPTION class=highlight value=1_10_30ga>1 10 Net 30
<OPTION class=highlight value=2_10_30>2 10 Net 30
<OPTION class=highlight value=cash>Cash
</OPTION></SELECT>
FOB: <SELECT name=fob>
<OPTION class=highlight value=Destination selected>Destination
<OPTION class=highlight value=Origin>Origin
</OPTION></SELECT><p>
<b>Dates</b> - Ordered: 
<INPUT TYPE="text" size=10 name="dateord" MAXLENGTH=10
onKeyUp="if(this.value.length==this.size)document.form.datecomp.focus();">
Completed: <INPUT TYPE="text" size=10 name="datecomp" MAXLENGTH=10
onKeyUp="if(this.value.length==this.size)document.form.duedate.focus();">
Due: <INPUT TYPE="text" size=10 name="duedate" MAXLENGTH=10
onKeyUp="if(this.value.length==this.size)document.form.datepaid.focus();">
Paid: <INPUT TYPE="text" size=10 name="datepaid" MAXLENGTH=10
onKeyUp="if(this.value.length==this.size)document.form.qty.focus();"><p>
Qty: <INPUT TYPE="text" size=5 name=qty>
Description: <INPUT TYPE="text" size=25 name=descr>
Charges: <INPUT TYPE="text" size=7 name=charges>
Paid Amt: <INPUT TYPE="text" size=7 name=paidamt>
Tax: <INPUT TYPE="text" size=6 name tax><p>
<b>Shipping</b> - Date:
<INPUT TYPE="text" size=10 name "shipdate" MAXLENGTH=10
onKeyUp="if(this.value.length==this.size)document.form.shipamt.focus();">
Amt:<INPUT TYPE="text" size=7 name shipamt><p>
<b>Amount Due</b>: <INPUT TYPE="text" size=7 name=amtdue><p>
<input type="submit" value="submit data" />
</p>
</form>
</body></html> 
<?php
if (isset( $_POST['payrec']) ) 
{
$pd=$_POST['pd'];
$payrec=$_POST['payrec'];
$ordernum=$_POST['ordernum'];
$invnum=$_POST['invnum'];  
$bname=$_POST['bname'];  
$bstreet=$_POST['bstreet'];  
$bstate=$_POST['bstate'];
$bcity=$_POST['bcity'];
$bzip=$_POST['bzip'];
$sname=$_POST['sname'];  
$sstreet=$_POST['sstreet'];  
$sstate=$_POST['sstate'];
$scity=$_POST['scity'];
$szip=$_POST['szip'];
$contact=$_POST['contact'];
$terms=$_POST['terms'];
$fob=$_POST['fob'];
$shipdate=$_POST['shipdate'];
$shipamt=$_POST['shipamt'];  
$dateord=$_POST['dateord'];
$datecomp=$_POST['datecomp'];
$duedate=$_POST['duedate'];  
$datepaid=$_POST['datepaid'];
$qty=$_POST['qty'];  
$desc=$_POST['descr'];  
$charges=$_POST['charges'];  
$paidamt=$_POST['paidamt'];
$dayslate=$_POST['dayslate'];  
$tax=$_POST['tax'];
$amtdue=$_POST['amtdue'];
$paidsum=$_POST['paidsum'];
}
mysql_connect(localhost,root,"";
mysql_select_db(oodb) or die( "Unable to select database"; 
$query = "
INSERT INTO oocust (pd,payrec,ordernum,invnum,bname,bstreet,bstate,bcity,bzip,sname,sstreet,sstate,scity,szip,contact,terms,fob,shipdate,shipamt,dateord,datecomp,duedate,datepaid,qty,descr,charges,paidamt,
dayslate,tax,amtdue,paidsum)
VALUES('$pd','$payrec','$ordernum','$invnum','$bname','$bstreet','$bstate','$bcity','$bzip','$sname','$sstreet','$sstate','$scity','$szip','$contact','$terms','$fob','$shipdate','$shipamt','$dateord','$datecomp','$duedate','$datepaid','$qty','$descr',
'$charges','$paidamt','$dayslate','$tax','$amtdue','$paidsum')";
echo "data inserted</font>

"; 
$stat = mysql_query($query) or die('Query failed: ' . mysql_error()); 
mysql_close();
?>

Re: Insert Not Working by wavemaster(m): 8:52pm On Apr 19, 2011

TRY THIS
$conn= mysql_connect('localhost', 'root', "" wink

;

// oodb should be in form of "oodb" or $oodb
// Use this
mysql_select_db("oodb", $conn);
// or this
mysql_select_db($oodb, $conn);

// Note: Authentication is needed to select a database.

// For the SQL syntax
$query = "INSERT INTO oocust
VALUES ('$pd', '$payrec', '$ordernum', '$invnum', '$bname', '$bstreet', '$bstate', '$bcity', '$bzip', '$sname', '$sstreet', '$sstate', '$scity', '$szip', '$contact', '$terms', '$fob', '$shipdate', '$shipamt', '$dateord', '$datecomp', '$duedate', '$datepaid', '$qty', '$descr', '$charges', '$paidamt', '$dayslate', '$tax', '$amtdue', '$paidsum')";

// Use this
$stat= mysql_query($query, $conn);
if($stat) {
echo 'Successful';
} else {
die('Query failed: ' . mysql_error());
}
// Or this
mysql_query($query, $conn) or die('Query failed: ' . mysql_error());
// =========

mysql_close();

Hope this help.

Re: Insert Not Working by wavemaster(m): 9:12pm On Apr 19, 2011

To determine future date and month

$24hrFromNow= time()*(60*60*24);

$date= date("d", $24hrFromNow); // This will return 20

$Month= date("m", $24hrFromNow); // This will return 4

$DateMonth= date("m-d", $24hrFromNow); // This will return 20-04

$DateMonthYear= date("m-d-Y", $24hrFromNow); // This will return 20-04-2011

Hope this also helps.
Best regards.

Re: Insert Not Working by kodewrita(m): 1:39pm On Apr 20, 2011

@Poster

Just a few thoughts.
seems your table is too big. you have too many fields. split into a few tables with common key and use a JOIN to retrieve when necessary.

(1) (Reply)

How Well Do You Understand And Write Your Local Language? / Every Writer Needs A Reader(Java inclined assistance) / Download Over 5,000 Free Software Packages

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 29
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.