Retrieving Data from the Database

Aybabtu

Hey guys. I cant remember how to pull info from that database. I can put it in but how do I pull it out to a web page. I have the following code but it does not reconize my veriables.

<HTML>
<BODY>
<?
$set = "0";
// set up some variables

// server name
$server = "localhost";

// username
$user1 = "aybabtu";

// password
$pass = "some_pass";

// database to query
$db = "laptop";

// open a connection to the database
$connection = mysql_connect($server, $user1, $pass);

// formulate the SQL query - same as above
$query = "select * from loan where user = $cdsid";

// run the query on the database

$result = mysql_db_query($db,$query,$connection);

echo "Girs Ticket: $girs &nbsp &nbsp &nbsp User Name: $user 
The user had checled out the following items make sure they are being returned. 
------------------ "

?>

It reconizes my Connection veriables but it does not find $user or $girs. What is the problem?

paulnaj

From your code ...

// formulate the SQL query - same as above 
$query = "select * from loan where user = $cdsid"; 


// run the query on the database 
$result = mysql_db_query($db,$query,$connection); 

// NEW CODE (assuming your table has fields called [girs] and [user])
while($obj = mysql_fetch_obj($result)){
    echo "Girs Ticket: ".$obj->girs."       User Name: ".$obj->user." <BR><BR>";
}

Natty_Dreadlock

u gotta use $data = mysql_fetch_array($result); then u can retrieve the values of the db fields girs and user:
$girs = $data["girs"]; $user = $data["user"];
hth & check out the docu at www.php.net/mysql

Aybabtu

This is all good pointers but what do I do when there are several entries for this data. I have like 7 rows of data under these collumns.

paulnaj

That's why you use a while() loop. (See previous reply)

Aybabtu

Sorry I missed the while statement. but now I get the error

Fatal error: Call to undefined function: mysql_fetch_obj() in c:\inetpub\wwwroot\lreturns.php on line 30.

I have tried making sure my query produces resulty in a MySQL GUI I have. I do get the results I want but when the PHP runs it dosent work, I dont get it.

Here is my current code

<?
$set = "0";
// set up some variables

// server name
$server = "localhost";

// username
$user1 = "aybabtu";

// password
$pass = "some_pass";

// database to query
$db = "laptop";

// open a connection to the database
$connection = mysql_connect($server, $user1, $pass);

// formulate the SQL query - same as above
$query = "select * from loan where user = '$cdsid'";

// run the query on the database
$result = mysql_db_query($db,$query,$connection);

// NEW CODE (assuming your table has fields called [girs] and [user])
while($obj = mysql_fetch_obj($result)){
echo "Girs Ticket: ".$obj->girs." User Name: ".$obj->user." ";
}

?>

Thanks for the helpd so far paulnaj

paulnaj

Oops,

should be mysql_fetch_object()

sorry 'bout that!

Aybabtu

Thank you soooo much. It is working now. The only question is why you use the period before the obj-> statements. They produce unwanted periods in my HTML. Just wondering if they serve another purpose.

paulnaj

OK.

The dots are string-concatenation operators ... they join strings together.

//Suppose you have a variable 
$var = "Fred";

// Then this is perfectly valid
echo "Hello, $var, how are you!";

// But this is clearer to me
echo "Hello, ".$var.", how are you!";

// Note that it is easier to see color-coding in text-editors and there are no efficiency issues.

Aybabtu

ok thanks.