Reply to Re: php/mysql syntax help

Your name:

Reply:


Posted by Rik on 02/15/07 01:35

On Thu, 15 Feb 2007 00:12:27 +0100, edward_sanders =

<edward_sanders@bellsouth.net> wrote:

> Hi,
> This is a newbie question. I am using a text for learning =

> php/mysql.
> I am using PHP 5.2.x and mysql 5.
> The example is that of a mysql
> database of jokes. Before we get to joins there is a
> simple table with 3 fields, ID field (primary key, integer),
> JokeText, and JokeDate. In the program for some
> reason the code is not retrieving the ID for each
> row from the db. It gets the JokeText field just fine.
> Let me include the snippets below.
>
> This is where each row (each joke) is to be displayed.
> Note that the ID is used to give the option of deleting a
> joke from the db. The link tag is supposed to get that
> ID passed to the link but that isn't happening. Please help.

Is the 'ID' not in the query result, or doesn't it get passed?

> // Display the text of each joke in the paragraph
> while ( $row =3D mysql_fetch_array($result)) {

What is teh query you're fetching the result from?
What does a print_r($row) tell you?

> echo("<p>$joketext " .
> "<A HREF=3D'$thispage?deletejoke=3D$jokeid'>" .
> "Delete this Joke</a></p>");

What's the resulting link in the HTML source?

> $deletejoke=3D$_GET['deletejoke'];


Please use an intval() on the GET variable here. Consider what will happ=
en =

if someone was to use '1 OR 1=3D1' as the GET variable to your page...
-- =

Rik Wasmus

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация