PHP Forum

**ckdoublenecks** · 11-24-2010, 03:42 PM

Why won't the apartment# echo?

Code:

 
</body></html> 
<?php
if (isset( $_POST['apt']) ) {
$dep=$_POST['dep'];
$apt=$_POST['apt'];
$name=$_POST['name'];
$amtpaid=$_POST['amtpaid'];
$damage=$_POST['damage'];
$month=$_POST['month'];
$courtcost=$_POST['courtcost'];
$nsf=$_POST['nsf'];
$latechg=$_POST['latechg'];
$secdep=$_POST['secdep'];
$comments=$_POST['comments'];
$stat = mysql_connect(localhost,root,"") or die('Unable to connect to database: ' . mysql_error()); 
$stat = mysql_select_db(mschgdb) or die('Unable to select database: ' . mysql_error()); 
$query = "INSERT INTO miscdata VALUES 
('','$dep','$apt','$name','$amtpaid','$damage','$month','$courtcost','$nsf','$latechg','$secdep','$comments')"; 
$stat = mysql_query($query) or die('Query failed: ' . mysql_error());
// *******************************************************************
echo '<p style="color: red; text-align: center">data has been inserted in apartment $apt</p>';
// *****************************************************
mysql_close();
}
?>

**lynxus** · 11-24-2010, 03:46 PM

Do you get any errors in the http server error log file?

**ckdoublenecks** · 11-24-2010, 04:56 PM

no, I just get "data has been inserted in apartment $apt" . Could it have to do with the HTML code associated with it? :

Quote:

<html>
<head>
<style type="text/css">
</style>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs...n.js"></script>
<script type="text/javascript">
function getResults() {
var search_val = $("#apt").val();
$.post("prerentget.php", { search_term: search_val }, function(data) {
if (data.length > 0) {
$("#name")[0].value = data;
}
})
}
</script>
<script type="text/javascript">
window.google_analytics_uacct = "UA-256751-2";
</script>
<script type="text/javascript">
window.google_analytics_uacct = "UA-256751-2";
</script>
</head>
<body onload="document.form.apt.focus()">
<form name="form" action="<?php $_SERVER[PHP_SELF] ?>" method="post">
<INPUT TYPE="text" name=dep>Dep#<BR>
<input type="text" size="2" name="apt" id="apt"
onkeyup="getResults();if(this.value.length==this.s ize)document.form.name.focus();" />Apt<br />
<input type="text" name="name" id="name" />Name<br />
<INPUT TYPE="text" name=amtpaid>Amount Paid<BR>
<INPUT TYPE="text" name=damage>Damage Chg<BR>
<INPUT TYPE="text" name=month>Month Incurred<BR>
<INPUT TYPE="text" name=courtcost>Court Costs<BR>
<INPUT TYPE="text" name=nsf>NSF<BR>
<INPUT TYPE="text" name=latechg>Late Charges<BR>
<INPUT TYPE="text" name=secdep>Sec Deposit<BR>
<INPUT TYPE="text" name=comments>Comments<BR>
<p>
<INPUT type="submit" value="submit data" />
</p>
</form>
<script type="text/javascript">
</script>
<script type="text/javascript">
</script>

**Gakoyu Ojima** · 11-24-2010, 06:30 PM

You did not add concatenations.

Change:

PHP Code:


			
echo '<p style="color: red; text-align: center">data has been inserted in apartment $apt</p>';

Into:

PHP Code:


			
echo '<p style="color: red; text-align: center">data has been inserted in apartment' . $apt . '</p>';