Right so I"ve built a flash file that pulls info out of a database (thanks to http://www.luxagraf.com/ ) which is working great. I’ve also bulit the backend php pages so that I can add/modify/delete the records that show up in the flash front end.
Now there are a couple of problems I’ve run into.
One) When I delete a record from my DB and then reload my flash front end and then click on a archive link that follows AFTER the record I have just deleted the story does not show in the main window…all I get is a - . I’m guessing this is to do with a none constant flow in the DB id’s. One way I can think of to remidy this is to update all of the ID’s after the deleted record so they all flow again… if so how would i do this? or are there any other ways?
Two) Pulling dates out in a readable format in flash. Currently I get: 2004-06-18 15:07:19. I would like something like 18/06/2004
Something more presentable anyway.
I’m using PHP and a mysql database.
This is the code in the flash file:
[color=#000000][color=#ff8000]
//function to load external data using the loadVars() object
//l=name of loadVars object
//n=name of text field
//t=trigger to decide whether to show all entries or just one.
//e= entry number to display (number)
//f=file to load from (string)
[/color][color=#007700]function [/color][color=#0000bb]lv[/color][color=#007700]([/color][color=#0000bb]l[/color][color=#007700], [/color][color=#0000bb]n[/color][color=#007700], [/color][color=#0000bb]t[/color][color=#007700], [/color][color=#0000bb]e[/color][color=#007700], [/color][color=#0000bb]f[/color][color=#007700]) {
[/color][color=#ff8000]//create a new loadVars object if one doesn't already exist if it does, use it
[/color][color=#007700]if ([/color][color=#0000bb]l [/color][color=#007700]== [/color][color=#0000bb]undefined[/color][color=#007700]) {
[/color][color=#0000bb]l [/color][color=#007700]= new [/color][color=#0000bb]LoadVars[/color][color=#007700]();
[/color][color=#0000bb]l[/color][color=#007700].[/color][color=#0000bb]onLoad [/color][color=#007700]= function() {
var [/color][color=#0000bb]i[/color][color=#007700];
[/color][color=#ff8000]//clear out any text that might already be there
[/color][color=#0000bb]n[/color][color=#007700].[/color][color=#0000bb]htmlText [/color][color=#007700]= [/color][color=#dd0000]""[/color][color=#007700];
[/color][color=#ff8000]//to show a single entry at a time we use the following code
[/color][color=#007700]if ([/color][color=#0000bb]t [/color][color=#007700]== [/color][color=#0000bb]undefined[/color][color=#007700]) {
[/color][color=#0000bb]n[/color][color=#007700].[/color][color=#0000bb]htmlText [/color][color=#007700]+= [/color][color=#dd0000]"<b>"[/color][color=#007700]+[/color][color=#0000bb]this[/color][color=#007700][[/color][color=#dd0000]"title"[/color][color=#007700]+[/color][color=#0000bb]e[/color][color=#007700]]+[/color][color=#dd0000]" - "[/color][color=#007700]+[/color][color=#0000bb]this[/color][color=#007700][[/color][color=#dd0000]"date"[/color][color=#007700]+[/color][color=#0000bb]e[/color][color=#007700]]+[/color][color=#dd0000]"</b><br><br>"[/color][color=#007700];
[/color][color=#0000bb]n[/color][color=#007700].[/color][color=#0000bb]htmlText [/color][color=#007700]+= [/color][color=#0000bb]this[/color][color=#007700][[/color][color=#dd0000]"entry"[/color][color=#007700]+[/color][color=#0000bb]e[/color][color=#007700]];
} else {
[/color][color=#ff8000]//cycle through and show all entries
[/color][color=#007700]for ([/color][color=#0000bb]i[/color][color=#007700]=[/color][color=#0000bb]0[/color][color=#007700]; [/color][color=#0000bb]i[/color][color=#007700]<[/color][color=#0000bb]this[/color][color=#007700].[/color][color=#0000bb]n[/color][color=#007700]; [/color][color=#0000bb]i[/color][color=#007700]++) {
[/color][color=#0000bb]n[/color][color=#007700].[/color][color=#0000bb]htmlText [/color][color=#007700]+= [/color][color=#dd0000]"<u><a href='asfunction:_root.loadArc,"[/color][color=#007700]+[/color][color=#0000bb]this[/color][color=#007700][[/color][color=#dd0000]"id"[/color][color=#007700]+[/color][color=#0000bb]i[/color][color=#007700]]+[/color][color=#dd0000]"'>"[/color][color=#007700]+[/color][color=#0000bb]this[/color][color=#007700][[/color][color=#dd0000]"title"[/color][color=#007700]+[/color][color=#0000bb]i[/color][color=#007700]]+[/color][color=#dd0000]"</a></u><br>"[/color][color=#007700];
}
}
[/color][color=#0000bb]sb[/color][color=#007700].[/color][color=#0000bb]update[/color][color=#007700]();
[/color][color=#0000bb]sb2[/color][color=#007700].[/color][color=#0000bb]update[/color][color=#007700]();
};
}
[/color][color=#0000bb]l[/color][color=#007700].[/color][color=#0000bb]load[/color][color=#007700]([/color][color=#0000bb]f[/color][color=#007700]);
}
function [/color][color=#0000bb]loadArc[/color][color=#007700]([/color][color=#0000bb]passed[/color][color=#007700]) {
[/color][color=#0000bb]arcNum [/color][color=#007700]= [/color][color=#0000bb]passed[/color][color=#007700]-[/color][color=#0000bb]1[/color][color=#007700];
[/color][color=#0000bb]lv[/color][color=#007700]([/color][color=#0000bb]blog_lv[/color][color=#007700], [/color][color=#0000bb]entries_txt[/color][color=#007700], [/color][color=#0000bb]undefined[/color][color=#007700], [/color][color=#0000bb]arcNum[/color][color=#007700], [/color][color=#dd0000]"archives.php"[/color][color=#007700]);
}
[/color][color=#ff8000]//for the large entry textfield
[/color][color=#0000bb]lv[/color][color=#007700]([/color][color=#0000bb]blog_lv[/color][color=#007700], [/color][color=#0000bb]entries_txt[/color][color=#007700], [/color][color=#0000bb]undefined[/color][color=#007700], [/color][color=#0000bb]0[/color][color=#007700], [/color][color=#dd0000]"getnews.php"[/color][color=#007700]);
[/color][color=#ff8000]//for the archives text field
[/color][color=#0000bb]lv[/color][color=#007700]([/color][color=#0000bb]archive_lv[/color][color=#007700], [/color][color=#0000bb]_root[/color][color=#007700].[/color][color=#0000bb]archives[/color][color=#007700].[/color][color=#0000bb]archive_txt[/color][color=#007700], [/color][color=#dd0000]"cycle"[/color][color=#007700], [/color][color=#0000bb]null[/color][color=#007700], [/color][color=#dd0000]"getnews.php"[/color][color=#007700]);
[/color][/color] The code for getnews.php:
<?php
mysql_connect ("localhost", "", "");
mysql_select_db ("blog_db");
$qResult = mysql_query ("SELECT * FROM blog_entries ORDER BY id DESC");
$nRows = mysql_num_rows($qResult);
$rString ="&n=".$nRows;
for ($i=0; $i< $nRows; $i++){
$row = mysql_fetch_array($qResult);
$rString .="&id".$i."=".$row['id']."&"."&title".$i."=".$row['title']."&"."&date".$i."=".$row['date ("F j, Y, g:i a")']."&"."&entry".$i."=".$row['entry']."&";
}
echo $rString."&";
?>
and the code for archives.php:
[color=#000000]
<?php
include ("connect.inc");
mysql_select_db ("blog_db");
$qResult = mysql_query ("SELECT * FROM blog_entries");
$nRows = mysql_num_rows($qResult);
$rString ="&n=".$nRows;
for ($i=0; $i< $nRows; $i++){
$row = mysql_fetch_array($qResult);
$rString .="&id".$i."=".$row['id']."&"."&title".$i."=".$row['title']."&"."&date".$i."=".$row['date']."&"."&entry".$i."=".$row['entry']."&";
}
echo $rString."&";
?>
[/color]
