PHP help plz

WrathOfAchilles · 7 Mar 2006 at 20:54

Hi all,

I'm getting this error:

Fatal error: Call to undefined function escape_data() in C:\wamp\www\registerfe.php on line 8

From this code:

<?php # Script 7.7 - register.php (3rd version after Scripts 7.3 & 7.5)

include ('./projectincludes/header.html');

require_once ('../mysql_connect.php'); // Connect to the db.

$t = escape_data($_POST['Title']); :mad:

< Line 8
$s = escape_data($_POST['Surname']);
$f = escape_data($_POST['Forename']);
$i = escape_data($_POST['Initials']);

// Make query
$query = "INSERT INTO forensic_entomologist (Fe_ID, Title, Surname, Forename, Initials) VALUES (NULL, $t, $s, $f, $i)";

$result = @mysql_query ($query); // Run the query.

?>

<h2>Register Forensic Entomologist</h2>

<form action="registerfe.php" method="post">

<p>Title: <input type="text" name="Title" size="15" maxlength="10" value="<?php if (isset($_POST['Title'])) echo $_POST['Title']; ?>" /></p>
<p>Surname: <input type="text" name="Surname" size="20" maxlength="25" value="<?php if (isset($_POST['Surname'])) echo $_POST['Surname']; ?>" /></p>
<p>Forename: <input type="text" name="Forename" size="20" maxlength="25" value="<?php if (isset($_POST['Forename'])) echo $_POST['Forename']; ?>" /> </p>
<p>Initials: <input type="text" name="Initials" size="10" maxlength="5" value="<?php if (isset($_POST['Initials'])) echo $_POST['Initials']; ?>" /> </p>
<p><input type="submit" name="submit" value="Register" /></p><input type="hidden" name="submitted" value="TRUE" />
</form>

Any help would be great, i been stuck for hours.

Cheers,

Marty

Carrot · 7 Mar 2006 at 21:00

Where is escape_data() defined? It's not a standard PHP function, is it?

Beansprout · 7 Mar 2006 at 21:06

Nope

WrathOfAchilles · 7 Mar 2006 at 22:58

Ok, i got it working... kind of.

It works with this code:

<?php # Script 7.7 - register.php (3rd version after Scripts 7.3 & 7.5)

include ('./projectincludes/header.html');

require_once ('../mysql_connect.php'); // Connect to the db.

if (isset($_POST['Title'])) {

$t = $_POST['Title'];
$s = $_POST['Surname'];
$f = $_POST['Forename'];
$i = $_POST['Initials'];

echo $t; :confused:

// Make query
$query = "INSERT INTO forensic_entomologist (Fe_ID, Title, Surname, Forename, Initials) VALUES (NULL, $t, $s, $f, $i)";

$result = @mysql_query ($query); // Run the query.

}
?>

<h2>Register Forensic Entomologist</h2>

<form action="registerfe.php" method="post">

<p>Title: <input type="text" name="Title" size="15" maxlength="10" value="" /></p>
<p>Surname: <input type="text" name="Surname" size="20" maxlength="25" value="" /></p>
<p>Forename: <input type="text" name="Forename" size="20" maxlength="25" value="" /> </p>
<p>Initials: <input type="text" name="Initials" size="10" maxlength="5" value="" /> </p>
<p><input type="submit" name="submit" value="Register" /></p><input type="hidden" name="submitted" value="TRUE" />
</form>

But when i remove the highlighed echo, nothing goes into the database!

How could an echo effect anyting??

Damn php

Marty

Beansprout · 7 Mar 2006 at 22:59

Er, it's not. Compare the 4 lines above that echo

WrathOfAchilles · 7 Mar 2006 at 23:03

looks ok 2 me or am i missin summin because i been starin at it for so long?!!!

Beansprout · 7 Mar 2006 at 23:06

$t = $_POST['Title'];
$s = $_POST['Surname'];
$f = $_POST['Forename'];
$i = $_POST['Initials'];

Now look in the first one - escape_data() is in the first one. escape_data() is not a standard PHP function.

WrathOfAchilles · 7 Mar 2006 at 23:10

So confused!!

The first code i posted had loads of errors, the escape_dats function was me trying to copy a code snippet from a book and not knowing what it ment!

I deleted it and made alterations, and thats what i have posted for the second code. For some reason, it works fine when i have the echo in ( whole code works fine, data goes from form into database fine) but doesn't do anything when i take it out?!!!

Weird?

Marty

Beansprout · 7 Mar 2006 at 23:14

Comment out the echo line with "//" at the start of the line, just incase you're accidentally messing about with anything else

WrathOfAchilles · 7 Mar 2006 at 23:17

now it works with the commented line in! but when i take line out completly it stops working!!??

WrathOfAchilles · 7 Mar 2006 at 23:18

now its working with the line out..

Something is amiss

NightmareXX · 7 Mar 2006 at 23:20

When you say 'it works' with the echo in, is that simply because you can see something happening?

Check the database after running it without the echo. You should find that the values are in there anyway. You just have no comformation of that

WrathOfAchilles · 7 Mar 2006 at 23:27

na, the records dont go into the database

For some reason, they are only going in then i enter numbers rather than letters! The database is setup as varchars for those fields going in.

echo is irrelivent now, i was just not consistant with my test data!

Ok, so:

It only works now if i enter data in ALL the fields and if all the fields contain numeric data!

Carrot · 7 Mar 2006 at 23:33

You need to put quotes around your strings' variable names in your query string, I think.

NightmareXX · 7 Mar 2006 at 23:36

YOUR A GENIUS!!!

I remember now. On the key next to the 1 and above the tab, put those funny quotes around the database fields (This one ` )

Also put quotes around the $t, $i etc.

WrathOfAchilles · 7 Mar 2006 at 23:39

That got it!!!

Cheers

Carrot · 7 Mar 2006 at 23:41

NightmareXX said:
Also put quotes around the $t, $i etc.

Those are the ones that matter.

If you hadn't had the @ on this line: $result = @mysql_query ($query); You would have had a much easier time figuring out where the problem was, too.