anyone spot whats wrong with this script?
Posted: Mon Jun 14, 2004 10:49 am
Total newbie so if its obvious I apppologise now. Any help appreciated. The script is to add stuff to my database. The code is:
I get back from the browser when I try to see the page:
feyd switched [code.] to [php.] tag for readability
Code: Select all
<!DOCTYPE html PUBLIC
"-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>My Sql</title>
</head>
<body>
<?php
if (!empty ($_REQUEST['name'])&&
!empty ($_REQUEST['family'])&&
!empty ($_REQUEST['origin'])){
//check user input here!
$dberror="";
$ret=add_to_database($_REQUEST['name'],
$_REQUEST['family'],
$_REQUEST['origin'], $dberror);
if (! $ret) {
print "Error: $dberror<br/>\n";
}else{
print "Thankyou very much!<br/>\n";
}
}else {
write_form();
}
function add_to_database($name, $family, $origin, &$dberror){
$name=mysql_real_escape_string($name);
$family=mysql_real_escape_string($family);
$origin=mysql_real_escape_string($origin);
$link=mysql_pconnect("localhost", "garethna_fishacc", "<span style='color:blue' title='I'm naughty, are you naughty?'>smurf</span>");
if (! $link){
$dberror=mysqlerror();
return false;
}
if (! mysql_select_db("garethna_fishdatabase", $link)){
$dberror=mysqlerror();
return false;
}
$query="INSERT INTO fish (name, family, origin)
values('$name', '$family', '$origin')";
if (! mysql_query($query, $link)){
$dberror=mysql_error();
return false;
}
return true;
}
function write_form(){
print <<<EOF
<form method="post" action = "{$_SERVER['PHP_SELF']}">
<p><input type="text" name="name"/>
Name</p>
<p><input type="text" name="family"/>
Family</p>
<p><input type="text" name="origin"/>
Origin</p>
<p><input type="submit" value = "Sumbit it!"/></p>
</form>
FORM;
}
?>
</body>
</html>Thanks againParse error: parse error, unexpected $ in /usr/home/garethna/public_html/addmysql.php on line 68
feyd switched [code.] to [php.] tag for readability