simple form

[-LEVI-]

Hey,

I have a simple form that I'd like to get working. I have the form.php where I have the <form> and than the action.php where I have all the php script that it should do after submitting the form. The error I'm getting is "The query string is empty"

I'm guessing that for some reason the action.php is not receiving the variables. Is there any script that I need to place in action.php so it's waiting for that certain variable?

thanks,
Levi

[limke]

It is a bit difficult to answer your question in this way.

Basically, the form that you are going to submit, does not require any php codes, normal html page with <form> tag will do. But remember to put in
action="the php file that you are passing to"
&
method=post

then in the file which is the file that you submited to

just out in

<?
echo $text1; //this is the text field name that u created inside your previous html page.
?>

but for new version of php, you need to edit php.ini, and look for the "register_globals", then chance the off value to on, then only you can use above code.

otherwise you will need to do this
<?
echo $_POST['text1']; //this is the text field name that u created inside your previous html page.
?>

[-LEVI-]

What I'm trying to create is a mini search engine kinda thing. The user enters a word and when "search" is pressed, the php script lookds through a MySQL database looking for text containing that word.

I uploaded the two files if you have time please look at them.

in the action.php I have something like this:

$searchin = $_POST['searching'];

"searching" is the name of the text field in the form.php . And than it goes on with the sql commands and and getting the results.

Thanks,
Levi

[limke]

🙂 so, do you get the result what you are looking for?

[-LEVI-]

heh no it tells me the query is empty. I have this line in action.php:

$result = mysql_query($search_result) or die("Error in query: " .mysql_error());

and this is what I'm getting when I submit the form:

"Error in query: Query was empty"

any ideas?

[limke]

I believe the query statement is incorrect.

It is better that you check first for the variable $_POST['searching'], whether that is it empty.

You can use this
echo $_POST['searching']; to see whether that it is empty

then the query should format in this way
$search_result = @("SELECT * FROM jokes WHERE title LIKE '%".$searching."%' OR language LIKE '%".$searching."%' OR author LIKE '%".$searching."%' ORDER BY id DESC");

then make another echo to check whether that the query is correct.

just remember that " is use to open and close a string in php, and you use . to combine two string. then I believe that you need a ' to enclose a string for the database to search base on a string.

or you also can do in this way

$query = "SELECT * FROM jokes WHERE title LIKE '%".$searching."%' OR language LIKE '%".$searching."%' OR author LIKE '%".$searching."%' ORDER BY id DESC";

//if your $query got a syntax error, the page will load error.

echo $query;

$search_result = @($query);

[-LEVI-]

thanks a lot, it seems to be running now. I'm getting some sql syntax error but ill struggle with that for a while before asking any questions.. 🙂

Levi

[limke]

welcome

if you have any problem on the sql syntax, you mighy also can share it also. I will see whether that I can help.

All the best to you,

kekeke, debugging is always the headache one.🙂 😃 😉 :p

[-LEVI-]

thanks, i got it figured. these quotes are confusing. when to use " and ' :/

so cool though, just making my first working scripts🙂 ..