At 11:12 AM 1/22/2002 +1100, Justin French wrote:
>Hi all,
>
>I've got into the habbit of pulling data out of a table something like this:
[...]
> $id = $sql_myrow["id"];
> $date = $sql_myrow["date"];
[...]
>Now, I reckon there must be a way of automating the task of making the
>$title var out of $sql_myrow["title"] etc etc for starters, which would
>really help on tables with lots of columns.
Personally I find it much easier to work with mysql_fetch_object(). In
your scenario you are most likely setting $id = $sql_myrow["id"] because
the former is easier to type and you're probably going to be referencing it
more than once. But if you use mysql_fetch_object() you may decide that
you don't need to do that anymore. For example:
while ($row = mysql_fetch_object($result)) {
echo "$row->artist - $row->title<br>";
}
Much easier than
echo $row["artist"]." - ".$row["title"]."<br>";
>Then, it'd be great if I could automate this further to automaticaly to
>a stripslashes() on each var, then possibly nl2br() etc.
Just curious, but why are you having to stripslashes() on the data coming
out of the database? Do you have magic_quotes_runtime enabled on your server?
>In psuedo-code I guess it looks something like:
>
>while($sql_myrow = mysql_fetch_array($sql_result))
> {
>
> // we have an array of one row
>
> <use a foreach loop to stripslashes() on each element of the array>
>
> <use a foreach loop to nl2br() on each element of the array>
>
> <use a foreach loop to take each element (eg $sql_myrow["id"]) and
>create a var ($id)>
>
> }
This is untested, but should work:
while($sql_myrow = mysql_fetch_array($sql_result)) {
foreach($sql_myrow as $key => $value) {
$$key=nl2br(stripslashes($value));
}
}
Basically the foreach loop goes through each index of $sql_myrow and
creates a variable by that name, setting it equal to the value of the index
after it's had it's slashes stripped and it's br's newlined. :-)
>Ultimately, I'd like to put this all into a function which I call that
>does it all in one hit, but I'll take that in a smaller step :)
The function Mr. Stancescu posted looks like it'll do the trick, with some
modifications to perform the nl2br() and the stripslashes()...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
