Technical Developments Part 12

I think it's essential to put down the various PHP and MySQL addresses of sites I visited and tried to use code from.
My webography

http://www.w3schools.com/php/php_intro.asp
An introduction to PHP, explaining the basics.

http://www.phpbuilder.com/snippet/detail.php?type=snippet&id=42
This site allowed you to download the code files.


http://www.freewebmasterhelp.com/tutorials/phpmysql/2
This site assistance with understanding the data field types on the mySQL database.

http://www.wellho.net/solutions/
This site showed code about uploading and retrieving photos from the mySQL database.

http://www.flash-db.com
This website showed how to use flash, PHP and MySQL together to save and retrieve images.

http://www.weberdev.com/ViewArticle/Saving-Images-in-MySQL
Another site to save pictures to the database using PHP and mySQL.

http://www.web-source.net/html_redirect.htm
This page was about an HTML redirection. So that it automatic redirected the page after however many seconds you chose.

http://www.flashkit.com/movies/Scripting/Using_Databases
This is the site where my flash drawing interface came from.

Technical Developments Part 11

I've finally reached a point where I don't think I can go any further.

I have developed a mock up gallery area for the art works that represent the idea of someone going to the art area and completing a couple of games.

Here are some screen shots:-

Technical Developments Part 10

Here are a few web pages that I have been looking at to help me with the PHP and mySQL, I'm running out of time unfortunately and I'm not really getting anywhere.

I have looked at these websites to see if I can work out how to save and retrieve pictures from the database but it's not worked out.

http://php.about.com/od/phpbasics/ss/php_mysql.htm
http://www.php.net/

I though this was useful code for connecting to your database:-

// Connects to your Database
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error());
mysql_select_db("Database_Name") or die(mysql_error());
?>

I imagine need to substitute this in to the zapis.php file I have for saving to my databases, here's the zapis code:-

mysql_connect("localhost","root","");
mysql_select_db("flashkit");

I'm frustrated nothing's working.

Technical Developments Part 9

I have been working all day on trying to get the drawing interface to save to a database I've created.
I followed the instructions provided with the interface and I'm not sure whether it's not working because I removed the log in section. I didn't really need the log in part because I don't need the site to work in that way. I wanted it to be an open house for anyone to draw and save.

These are the instructions I followed for setting up the two databases

CREATE TABLE paint
No int(11) NOT NULL auto_increment,
Author varchar(20) NOT NULL default '',
Picture varchar(50) NOT NULL default '',
Country varchar(12) NOT NULL default '',
sloeve longtext NOT NULL,
aloeve longtext NOT NULL,
currentRis text NOT NULL,
frucS text NOT NULL,
frucA text NOT NULL,
PRIMARY KEY (No)
) TYPE=MyISAM;

CREATE TABLE users (
Uname varchar(20) NOT NULL default '',
Upass varchar(50) NOT NULL default '',
UNIQUE KEY UserName (Uname),
UNIQUE KEY Pass (Upass)
) TYPE=MyISAM;

I think I have managed to follow the instructions but as I said I don't really need the log in database which I guess is the User table.
There is another instruction that I don't really understand either:-

INSERT INTO users VALUES ('flashkit', 'flashkit');

I wonder if this is for the log in page in order to generically log on.


I have fiddled about with this and uploaded it to the web but when I now try and save it comes back with an error about my log in.

Technical Developments Part 8

I have put the drawing interface into Dreamweaver and upload to my website.
I appears to work fine I can save the drawings. I'm having trouble understanding where the PHP code is saving the files to as I don't have a database up and running.
I was trying to prioritise getting the flash interface working, which it is before I spent time working out the setting up of the mySQL.

There is a retrieval function with the drawing interface which I'm hoping I will be able to use to place the pictures in the gallery.

Technical Developments Part 7

I appear to have found a drawing interface which specifically works with mySQL and PHP there are folders for each with appropriate coding and I'm allowed to use it. It is a little busy for me and so I will amend it to suit my requirements more.

Here is a snapshot of the original and my adaptation:-

Technical Developments Part 6

I've looked through all the script and can't work out the file type that the drawing interface uses to save to the database. I'm going to look for another drawing interface to see if I can find one that specifically works with PHP and MySQL.