MySQL Problems With Insertinf PHP Code

leprechaun13 · May 10 '07, 12:18 PM (#1)

Ive wrote a small articles script here To view the link you have to Register and would like to know how i can put php in the database so it gives the correct output.

Im trying with this PHP

PHP Code:


			
<?php
srand(time());
$max=13; // This is the number of photo you have in your directory (eg. numbered 1-50)
$arr = array();
while ( count($arr) < $max ) {
$x = mt_rand(1,$max);
if ( !in_array($x,$arr) ) { $arr[] = $x; }
} 
$p1 = "photo_".$arr[0].".jpg";
?>
<div style="text-align:center; padding-top:30px;">
<img src="/images/random/<?php echo $p1 ?>" />

<br /><br />


You Are Viewing Picture <?php echo $arr[0] ?><br />
How About Another? Just Hit F5

</div>

**mlseim** · May 10 '07, 03:23 PM (#2)

I don't see the connection between the MySQL articles and
the random .jpeg image. Are you trying to do a random article?

**filburt1** · May 10 '07, 06:11 PM (#3)

If you're doing what I think you're doing in that loop, this is much more efficient: To view the link you have to Register

Your code gets exponentially more inefficient the more elements there are because the probability of in_array() returning true increases.

leprechaun13 · May 11 '07, 02:11 AM (#4)

I just wanted to run my entire site from a simple artciles/cms script but cant get it to output the correct data when using a php script.. it doesnt matter what the script is it still cleans the data ad converts all of the data into its html entities.

filb i got the php script in the tutorials section so dont really know how it works i just know it works

**mlseim** · May 11 '07, 09:02 AM (#5)

Phil ...

This is probably too late to mention now,
but I think Joomla is the answer for you.

Before you dig in deeper, you might want
to check it out.

leprechaun13 · May 13 '07, 01:57 PM (#6)

used joomla and mambo before, I found too many restrictions as far as templating and didnt like the fact that they werent semantic so I wrote my own solution.