If I wanted to display my PHP content in Flash, how would I do it? Currently, my site is coded in XHTML/CSS/PHP and I want to convert it to Flash. However, I want to be able to easily input new information without having to go through the .fla file. Is there a way to do that?
And is there a way I’d be able to display my information in my PHP Database so that it resembles vaguely to the way it is displayed right now? Here’s the current code to what I’m using to access my database to display my content:
<?php
$user="----";
$host="----";
$database="----";
$table="----";
$pass="----";
$connection = mysql_connect($host,$user,$pass)
or die (“couldn’t connect to server”); $db = mysql_select_db($database,$connection)
or die (“Couldn’t select database”);
$query = "select * from Regular
order by ID desc ";
$result = mysql_query($query, $connection) or die
(“Could not execute query : $query .” . mysql_error());
$rows = mysql_num_rows($result);
if ($rows==“0”) { echo “No wallpapers found.”; }
$screen = $_GET[‘screen’];
$PHP_SELF = $_SERVER[‘PHP_SELF’];
$rows_per_page=5;
$total_records=mysql_num_rows($result);
$pages = ceil($total_records / $rows_per_page);
if (!isset($screen))
$screen=0;
$start = $screen * $rows_per_page;
$query .= “LIMIT $start, $rows_per_page”;
$result= mysql_query($query) or die
(“Could not execute query : $query .” . mysql_error());
while ($row=mysql_fetch_array($result))
{
$display=$row[“display”];
$series=$row[“series”];
$id=$row[“id”];
$date=$row[“date”];
$small=$row[“small”];
$big=$row[“big”];
echo "
<table class=“content”>
<tr>
<td align=“center”><img src="$display" /></td>
<td>
<b>Series:</b> $series<br />
<b>ID:</b> $id<br />
<b>Added on:</b> $date<br /><br />
<center>
<a href="$small" target=“new”>800x600</a> . <a href="$big" target=“new”>1024x768</a>
</center>
</td></tr>
</table>
";
}
?>
Thanks!
(I hope I posted this in the right place… I’m currently using Flash 8)