Flash formating of PHP data?

9

This is the best guestbook that I found, it took me about 1 minute to have it up and running and it easy to change around.

http://www.flash-db.com/Tutorials/guestbook/

This is the most advanced one that I found, so advanced I wouldn’t even want to touch it.

http://script.digichina.net/guestbook/guestbook.htm

Basicly I want the first one, but instead of output that looks like notepad, I want it to look more like these forums. I want to have it look like it is in tables and have icons next to peoples names etc…

But I can’t find one single examle…

10

I have seen the first one, I wanted to use that for my site but when I set it up I kept getting three errors in the script and when I asked about it on their forums the best they could come up with was “ignore them”. Apparently there is a variable and the point at which it happens is undifined, so my server reports it. Never did get that sorted out…

[edit] that second one is pretty cool :):?)

11

You can only send text into the flash directly from the php,

Thats all I need…

Ie: I had planed to have Sex: Male/Female
Once it was loaded into the movie I was going to have it check the sex, and set the background colour of the post to reflect it. Ie: light blue for Male posts, and light pink for girls.

And other stuff like that… but I need to get it in there before I can…

12

kept getting three errors in the script and when I asked about it on their forums the best they could come up with was “ignore them”.

Do you remember exactly what the problem was ?

Did it start and have errors ?
Not load the messages ?
Give error on sumbmitting ?

13

It loaded up the entries but then there were three errors that came up when you submitted each entry. Give me 5 mins I’ll set it up again and show you what I mean.

14

Here it is. Its fine now, but then you sign it… try for yourself.

15

No worries…
I have spent my whole weekend looking for an example of anything, even a shopping cart or something with tables… I will be looking for a couple more hours before I go to bed…

Maybe we will get lucky and sort out your errors.

16

I wish someone could sort them out :expressionless: Did you get anything like that when you installed it?

17

Notice: Undefined variable: i in c:\domains\vapour-music.co.uk\wwwroot ests\GuestBook.php on line 48

Notice: Undefined variable: i in c:\domains\vapour-music.co.uk\wwwroot ests\GuestBook.php on line 49

Notice: Undefined variable: i in c:\domains\vapour-music.co.uk\wwwroot ests\GuestBook.php on line 50

Notice: Undefined variable: i in c:\domains\vapour-music.co.uk\wwwroot ests\GuestBook.php on line 51
Name: The_Vulcan
Email: [email protected]
Comments: Testing
Date: 2004-07-18 16:24:24

Notice: Undefined variable: i in c:\domains\vapour-music.co.uk\wwwroot ests\GuestBook.php on line 54

Wow that is funny…

Have you changed anything in the files would be my first question ?

If you want .Zip and Post your .php file and .swf and I will upload it to my server and see if it works.

If it works it is a error on your server.
If it dont work there is a error in your files.

$DBhost = “localhost”; // Database Server
$DBuser = “"; // Database User
$DBpass = "”; // Database Pass
$DBName = “***********”;// Database Name
$table = “guestbook”; // Database Table
$numComments = 10; // Number of Comments per page

Just change your info in the .php file before you send it.

18

Everything is straight out of the zip file, thats what I don’t get. I was told I might need to adjust table widths in MySQL or something but I don’t know squat about MySQL so… shrugs… give me two minutes and I’ll post the zip for you

19

Nah I didn’t have a problem at all…

The only thing I had to do was look up my database name…

Here is one that I was playing with…
I was experimenting/farting around with password protection so its not functional…

Just select Cathy from the drop down menu and hit submit.
http://www.cathyschultz.com/boylen/Girls%20of%20Boylen.html

20

Sweet, I was thinking of doing something like that because we kept getting a load of a-holes just spamming our old book. The zip file is attached.

21

http://www.cathyschultz.com/fiery/gbv2.swf

didn’t put it in a html so give it a sec…

It worked fine so it is not your files…

CREATE TABLE guestbook (
ID int(5) NOT NULL auto_increment,
name text NOT NULL,
email text NOT NULL,
comments text NOT NULL,
time datetime NOT NULL default ‘0000-00-00 00:00:00’,
PRIMARY KEY (ID)
)

I would delete your table and remake it just to be sure there are no errors in that.

Is your mysql on the same server as your php and .swf
I know there are errors when you try to connect to mysql on a different server.

I will look at the line errors you posted above…

22

The MySQL and the files are all on the same server :expressionless: I think I’m maybe not creating the table right. Did you set column widths or something in MySQLCC? Someone told me something about that…

23

if($numallComments == 0) {
print “No entries in the guestbook, as yet…”;
} else {
while ($array = mysql_fetch_array($fewComments)) {
$name = mysql_result($fewComments, $i, ‘name’);
$email = mysql_result($fewComments, $i, ‘email’);
$comments = mysql_result($fewComments, $i, ‘comments’);
$time = mysql_result($fewComments, $i, ‘time’);

		   print '<b>Name: </b>' . $name . '<br><b>Email: </b>' . $email . '<br><b>Comments: </b>' . $comments . '<br><i>Date: ' . $time . '</i><br><br>';
		   $i++;
	    }
	}

well its obviouslt the $i var that is causing the problem so they question is why?

If it was java you would have to give it a value before you use it… But PHP i dont know about… perhaps your server is running a older version of PHP that needs its var declared before they are used.

24

It is running version 4.3.3. I know its not the newest but its fairly up to date… I dun o I really don’t know squat about php :frowning:

25

The only thing I can think of is declare the var $i = 0; before the

if($numallComments == 0) {

26

I just recreated the MySQL table… I’m still getting the same errors :expressionless:

27

I used php admin and pasted the code into the query window and that was it…

28

The only thing I can think of is declare the var $i = 0; before the

if($numallComments == 0) {

So what exactly would I change the code to? Just so i don’t mess this up and waste yet more time…