Having trouble with first script..help please

Tom_LR

Here are my two php files. When I execute search2.php (which asks for an account number to search for), my results page comes up blank. I would really appreciate if someone could let me know what I'm doing wrong. Thanks.

(Search Page Code)

(Result Page Code)

(I changed the names to generic for security reasons)
<?
$hostname = "host"; // Usually localhost.
$username = "user"; // If you have no username, leave this space empty.
$password = "password"; // The same applies here.
$usertable = "crossroads10"; // This is the table you made.
$dbName = "dbname"; // This is the main database you connect to.

$cliacct=$_Post['ClientNum']

MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
$query="SELECT*FROM crossroads10" WHERE CLIREF='$cliacct'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i<$num){

$dcs=mysql_result($result,$i,"DCS#");
$guarantor=mysql_result($result,$i,"GUAR");
$patient=mysql_result($result,$i,"PAT");
$address1=mysql_result($result,$i,"ADDR1#");
$address2=mysql_result($result,$i,"ADDR2");
$city=mysql_result($result,$i,"CITY");
$state=mysql_result($result,$i,"ST");
$zip=mysql_result($result,$i,"ZIP");
$social=mysql_result($result,$i,"SS#");
$dob=mysql_result($result,$i,"DOB");
$phone=mysql_result($result,$i,"PHONE");
$ticketbal=mysql_result($result,$i,"DBAL");
$totalbal=mysql_result($result,$i,"TBAL");
$paid=mysql_result($result,$i,"PAID");

echo "<b>Results for Client Account Number: $cliacct<p>
Responsible Party: $guarantor<br>
Patient: $patient<br>
Address: $address1<br>
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp$address2<br>
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspCity, ST, Zip: $city, $state $zip<br>
Social Security Number: $social<br>
Date of Birth: $dob<br>
Phone: $phone<br>
Encounter Balance: $ticketbal<br>
Total Due: $totalbal<br>
Total Paid: $paid<br>";

$i++;
}

Roger_Ramjet

Learn to use the php tags as it makes life easier for everyone

(Search Page Code)

<form method="post" action="result2.php">
<input type="varchar" name="ClientNum" size="25" value="Client Account Number">
<input type="Submit">
</form>

(Result Page Code)

(I changed the names to generic for security reasons)

<?
$hostname = "host"; // Usually localhost.
$username = "user"; // If you have no username, leave this space empty.
$password = "password"; // The same applies here.
$usertable = "crossroads10"; // This is the table you made.
$dbName = "dbname"; // This is the main database you connect to.

$cliacct=$_Post['ClientNum']

MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
$query="SELECT*FROM crossroads10" WHERE CLIREF='$cliacct'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i<$num){

$dcs=mysql_result($result,$i,"DCS#");
$guarantor=mysql_result($result,$i,"GUAR");
$patient=mysql_result($result,$i,"PAT");
$address1=mysql_result($result,$i,"ADDR1#");
$address2=mysql_result($result,$i,"ADDR2");
$city=mysql_result($result,$i,"CITY");
$state=mysql_result($result,$i,"ST");
$zip=mysql_result($result,$i,"ZIP");
$social=mysql_result($result,$i,"SS#");
$dob=mysql_result($result,$i,"DOB");
$phone=mysql_result($result,$i,"PHONE");
$ticketbal=mysql_result($result,$i,"DBAL");
$totalbal=mysql_result($result,$i,"TBAL");
$paid=mysql_result($result,$i,"PAID");

echo "<b>Results for Client Account Number: $cliacct<p>
Responsible Party: $guarantor<br>
Patient: $patient<br>
Address: $address1<br>
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp$address2<br>
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspCity, ST, Zip: $city, $state $zip<br>
Social Security Number: $social<br>
Date of Birth: $dob<br>
Phone: $phone<br>
Encounter Balance: $ticketbal<br>
Total Due: $totalbal<br>
Total Paid: $paid<br>";


$i++;
}

?>

Roger_Ramjet

And the problem becomes immediately obvious - just look at the colours in your first query.

Tom_LR

I've already fixed that problem, I caught it after I had posted. The double quotes should have only been at the end of the line instead of an extra one in the middle. I'm still having the same problem, the results page comes back blank.

Roger_Ramjet

That is because you are closing the database connection before you process the results. Understand, when you close the connection you destroy all resources associated with it.

There is usually no advantage from using mysql_close in any case as "Using mysql_close() isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution."

Only if your script is going to do a lot of processing after you have finished with the db will it make an appreciable difference.

Tom_LR

I'm still having problems after the corrections that were suggested. When I hit submit, it just brings up a blank page. I can't see what I'm doing wrong. Here is the corrected code so far.

<b>Search Page Code</b>


<form method="post" action="result2.php"> 
<input type="varchar" name="ClientNum" size="25" value="Client Account Number">
<input type="Submit">
</form>

<b>Result Page Code</b>



<? 
$hostname = "host";         // Usually localhost. 
$username = "username";     // If you have no username, leave this space empty. 
$password = "password";         // The same applies here. 
$usertable = "table";         // This is the table you made. 
$dbName = "database";         // This is the main database you connect to. 

$cliacct=$_Post['ClientNum']

MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database"); 
@mysql_select_db( "$dbName") or die( "Unable to select database"); 
$query="SELECT * FROM crossroads10 WHERE CLIREF='$cliacct'";
$result=mysql_query($query);

$num=mysql_numrows($result);


 $i=0;
while ($i<$num){

$dcs=mysql_result($result,$i,"DCS#");
$guarantor=mysql_result($result,$i,"GUAR");
$patient=mysql_result($result,$i,"PAT");
$address1=mysql_result($result,$i,"ADDR1#");
$address2=mysql_result($result,$i,"ADDR2");
$city=mysql_result($result,$i,"CITY");
$state=mysql_result($result,$i,"ST");
$zip=mysql_result($result,$i,"ZIP");
$social=mysql_result($result,$i,"SS#");
$dob=mysql_result($result,$i,"DOB");
$phone=mysql_result($result,$i,"PHONE");
$ticketbal=mysql_result($result,$i,"DBAL");
$totalbal=mysql_result($result,$i,"TBAL");
$paid=mysql_result($result,$i,"PAID");

echo "<b>Results for Client Account Number: $cliacct<p>
Responsible Party: $guarantor<br>
Patient: $patient<br>
Address: $address1<br>
$address2<br>
City, ST, Zip: $city, $state $zip<br>
Social Security Number: $social<br>
Date of Birth: $dob<br>
Phone: $phone<br>
Encounter Balance: $ticketbal<br>
Total Due: $totalbal<br>
Total Paid: $paid<br>";


$i++;
}

?>

Roger_Ramjet

NOTHING?? Not even the html plain text?

Tom_LR

I did make a simple plain text page and tested it. The form worked fine and the results page came up when it just contained the plain text. But when I put the code back in, nothing came up. I even put html plain text above the code and tried that and the result page still came up blank. By the way, I appreciate your help.

Tom_LR

ttt