select query

griffp

I have a input text box on an HTML page which calls a php page but I cannot get the input to pass to the php page.
Input page check it out.
PhP page code is below and works great for the select that is written in but I need it to get the input from the above page.
Thanks if you can help.
Paul

<?php
/ Connecting, selecting database /
$link = mysql_connect("localhost", "houseof", "password")
or die("Could not connect");
print "Your Item Status is Listed Below";
mysql_select_db("houseof_orders") or die("Could not select database");

/* Performing SQL query */
$query = "SELECT * FROM status where reference = 2075643247";
$result = mysql_query($query) or die("Query failed");

/* Printing results in HTML */
print "<table>

";
if (mysql_num_rows($result) == 0) {
echo "Please check your reference and try again, or try back later.";
exit;
}

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print " <tr bgcolor='black'>

";
foreach ($line as $col_value) {
print " <td><font color='white'><b>$col_value</td>
";
}
print " </font></tr>
";
}
print "</table>
";

/* Free resultset */
mysql_free_result($result);

/* Closing connection */
mysql_close($link);

cgraz

echo $_POST['db_search'];

Cgraz

griffp

Originally posted by cgraz
echo $_POST['db_search'];
Cgraz [/B]

Wow you must think I know what I am doing LOL.

Where would suggest I put this line. (ok, I set myself up for that one)

Which file and at what place.

Thanks
Paul
😕

cgraz

Well what do you want to do with the value they type into that form? It doesn't seem to do anything since your query isn't dependant on their input into that form.

Cgraz

torsoboy

on your html page the input field has the name of "db_search". Use it like this:

$query = "SELECT * FROM status where reference = '" . $_POST['db_search'] ."'";

instead of your handwritten number.

griffp

I would like the input on the page named transaction.html in the link above to trigger the query in the php page sqltest.php This is how my host said to do it but won't support the coding.

The way I understand it is that the input from one page is sent to the PHP page and triggers a select in mysql which then displays an html page with the results.

I got as far as to be able to make the mysql query in the php page to work by hard coding in the where statement and giving it a value that I know works.

Now I need to get that value to be inputted by the web page which is what I gave you a link to here it is again. web page

So I guess I need the code for both sides, 1. the page that the user inputs the reference # and 2. the code that receives that reference # and triggers the query.

I am getting in over my head but I spent two weeks now just getting the mysql database working from an Access conversion. Now it's PHP time and I am really tired, I took the tutorial for PHP and Mysql so I am really a beginner and need to see code that works to really learn it. Your help is great;

cgraz

If you change your query to what torsoboy suggested, it will search the database using the reference they type in. That's probably what you want. Then in the search box, you'd type in something like

2075643264

and by using a query like

$query = "SELECT * FROM status where reference = '" . $_POST['db_search'] ."'";

$_POST['db_search'] (the variable) is substituted for it's value, 2075643264

Cgraz

torsoboy

in other words, your html file is fine and the only thing you need to change in the PHP page is this section:

/ Performing SQL query /
$query = "SELECT * FROM status where reference = 2075643247";
$result = mysql_query($query) or die("Query failed");

to this:

/ Performing SQL query /
$query = "SELECT * FROM status where reference = '" . $_POST['db_search'] ."'";
$result = mysql_query($query) or die("Query failed");

that's all.

griffp

Ok everything is as you say it should be.

It all works but I am getting the default message that there is no data for input I know is in the mysql db.

This is the code for the input on the html page, the php page is not getting the data from this page.

<table>
<tr>
    <td>
        Reference Number 
    </td>
    <td>
        <input type="varchar" name="db_search" size="30" value="1" />

    </td>
</tr>

If you want to see it.
input 000095 should work.

Also would field lengths make a diff? "Reference" col in MySql is varchar(20), primary key, binary. Input field is 30. What about the leading 0's. The data in "reference" is sometimes 6 char and sometimes 10 char long. One is an Ebay auction # and the other is a Web order #.

cgraz

I think you're a little confused. Look at the following code with my comments

<a name="db_search"></a> 
<form method="post" action="db_search.php"> // added .php
<input type="hidden" name="lang" value="en-iso-8859-1" /> 
<input type="hidden" name="convcharset" value="iso-8859-1" /> 
<input type="hidden" name="server" value="1"> 
<input type="hidden" name="db" value="houseof_orders.status" /> 

<table> 
<tr> 
<td> 
Reference Number 
</td> 
<td> 
// input type has to be text. What is varchar in html?
// also, why are you setting a default value of1
<input type="text" name="db_search" size="30"> 

</td> 
</tr> 
</table>

-- on db_search.php -- 

// all your code here

// on the part where your query is

$query = "SELECT * FROM status where reference = '" . $_POST['db_search'] ."'"; 
$result = mysql_query($query) or die("Query failed"); 

// display your results here

while ($a_row = mysql_fetch_array($query)) {

// replace field1, field2, field3, and field4 with the field names in your mysql db
// this will print out the results for your fields
// you can add more or delete them
    print "Field 1: " . $a_row["field1"] . "<br>\n";
    print "Field 2: " . $a_row["field2"] . "<br>\n";
    print "Field 3: " . $a_row["field3"] . "<br>\n";
    print "Field 4: " . $a_row["field4"] . "<br>\n";

}


-- end of db_search.php --

Cgraz

griffp

It worked the data came through you are great.

This is the page that displayed.

Some problems I fooled aroung with it but could not get it to go in the right format.

Your Item Status is Listed Below
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/houseof/public_html/db_search.php on line 13
000095 9.12 0.00 0.88 10.00 TRUE TRUE TRUE 2002-12-02

The code that produced this is:

<?php
/ Connecting, selecting database /
$link = mysql_connect("localhost", "houseof", "*****")
or die("Could not connect");
print "Your Item Status is Listed Below";
mysql_select_db("houseof_orders") or die("Could not select database");

/* Performing SQL query */

$query = "SELECT * FROM status where reference = '" . $_POST['db_search'] ."'";
$result = mysql_query($query) or die("Query failed");

while ($a_row = mysql_fetch_array($query)) {

print "reference: " . $a_row["reference"] . "<br>\n";
print "end_bid: " . $a_row["end_bid"] . "<br>\n";
print "s_h: " . $a_row["s_h"] . "<br>\n";
print "salestaxin: " . $a_row["salestaxin"] . "<br>\n";
print "total: " . $a_row["total"] . "<br>\n";
print "confirmation: " . $a_row["confirmation"] . "<br>\n";
print "pay: " . $a_row["pay"] . "<br>\n";
print "shipped: " . $a_row["shipped"] . "<br>\n";
print "ship_date: " . $a_row["ship_date"] . "<br>\n";

}

 /* Printing results in HTML */
print "<table>

";
if (mysql_num_rows($result) == 0) {
echo "Please check your reference and try again, or try back later.";
exit;
}

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print " <tr bgcolor='black'>

";
foreach ($line as $col_value) {
print " <td><font color='white'><b>$col_value</td>
";
}
print " </font></tr>
";
}
print "</table>
";

/* Free resultset */
mysql_free_result($result);

/* Closing connection */
mysql_close($link);

Any suggestions would be great.

I noticed that you are in WA state.
Me too in Kirkland.

Thanks

cgraz

Ahh sorry,

while ($a_row = mysql_fetch_array($query)) {

should be

while ($a_row = mysql_fetch_array($result)) {

Yeah I'm in Woodinville, just a couple minutes away.

Cgraz

griffp

It works great, thank you for your help you have made this whole thing easy. You have given me a real jumpstart with PHP and MySql.

If you want to see the final product try this reference #
2076824152

Search Page.

Thanks again.
My email is p.griff@verizon.net
Maybe sometime we can get together and have a beer or whatever.

Paul

cgraz

Maybe in 3 years; I'm 18 😉

Cgraz

griffp

Wow I have a son your age.
And a daughter older.

Well I owe you a burger at Red Robin so just let me know when you want to go.

Thanks
Paul