FUDforum: comp.lang.php » take two - fetch items from a row.

Home » Imported messages » comp.lang.php » take two - fetch items from a row.

Show: Today's Messages :: Polls :: Message Navigator

Re: take two - fetch items from a row. [message #181298 is a reply to message #181297]

Fri, 03 May 2013 23:54

richard

Messages: 213
Registered: June 2013

Karma:

Senior Member

On Fri, 03 May 2013 16:32:59 -0700, Richard Yates wrote:

> On Fri, 3 May 2013 19:02:58 -0400, richard <noreply(at)example(dot)com>
> wrote:
>
>> This code may reside on a page in a line.
>> < a href="http:www.code.com/gettable.php?number=1">
>>
>>
>> Where I show id=$number, is that the way I want to show it or is there a
>> beter way?
>> I want to retrieve the row corresponding to the id number given in the
>> link.
>>
>> <?php
>>
>>
>> $number=$_GET["number"];
>> if (empty($number)) {$number=1;}
>> $number=(int)$number;
>>
>> // connections code left out intentionally //
>>
>>
>> $result = mysql_query("SELECT id,email FROM people WHERE id = $number");
>> if (!$result) {
>> echo 'Could not run query: ' . mysql_error();
>> exit;
>> }
>> $row = mysql_fetch_row($result);
>>
>> echo $row[0]; // 42
>> echo $row[1]; // the email value
>> ?>
>
> Your code does work. There are details about it that could be improved
> and others made suggestions about in response to your first post. I
> notice that in this post your id field in the database is assumed to
> be a number where the last time it seemed to be a string. Do yuou know
> which it is?
>
> Have you learned about validating and sanitizing user input yet?

I am assuming that "id" is an integer since that is how it is in the
database field.
the int() function changes the string to an integer so that's no big deal.

As with anything you do, you refine your output as time marches on.
After all, we all know YOU were born an expert in the field right?

Report message to a moderator

[Message index]

		take two - fetch items from a row. By: richard on Fri, 03 May 2013 23:02
		Re: take two - fetch items from a row. By: richard on Fri, 03 May 2013 23:13
		Re: take two - fetch items from a row. By: Denis McMahon on Sat, 04 May 2013 00:59
		Re: take two - fetch items from a row. By: Richard Yates on Fri, 03 May 2013 23:32
		Re: take two - fetch items from a row. By: richard on Fri, 03 May 2013 23:54
		Re: take two - fetch items from a row. By: Richard Yates on Sat, 04 May 2013 02:20
		Re: take two - fetch items from a row. By: Beauregard T. Shagnas on Sat, 04 May 2013 03:37
		Re: take two - fetch items from a row. By: SwissCheese on Sat, 04 May 2013 11:00

Previous Topic:	SoapServer constructor parameters: what is actor uri?
Next Topic:	replacing spaces with newline

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 07:37:21 GMT 2024

Total time taken to generate the page: 0.04501 seconds