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.

Technical Developments Part 5

I changed the password on my Dreamweaver settings and it's still not working. This is so frustrating!

I thought maybe I'd check the firewall advanced settings on the remote server tab in the Manage sites section. It appears to be timing out the connection after about 8 seconds which may mean that it's not connecting to zappa before the time out happens.
I've changed the settings to 300secs just to see what happens.

I'm connected, brilliant!

I need to check the script in the flash interface and see which part of the code saves to the database and what file type. Then I need to set up the MySQL database to accommodate my images.

Technical Developments Part 4

I went into university today and found that I had to update my passwords on the log in. The connection was working fine on the Dreamweaver at university so I've definitely got the correct settings for the remote and the testing server.
I will need to change my password on my Dreamweaver at home and hopefully this will solve the problem.

I set the database information up and managed to connect to the MySQL database. I tried to set up a new database. There is lots of information to fill in and I don't really know what field type I need to accommodate the pictures as I don't know how the flash recorder that I'm using saves the file and in what file type, jpeg, gif, bmp?

I'll go home and do some research.

Technical Developments Part 3

I've been having all sorts of problems connecting to the Zappa server from home.
I'm finding it really frustrating, it connected on a previous occasion and now it won't connect. I don't understand I haven't changed any of the settings in the Manage Sites part of Dreamweaver, I can't see any reason why it won't work.

My firewall might be blocking communications, but I have grant Dreamweaver access to the web in all the settings I can find.

I went online to Zappa.tvu.ac.uk to make sure it's up and running, I know they sometimes take it down for maintenance, this isn't the problem.

I will go into university and try there and then if it doesn't work I can ask the technical guys for assistance.

I'm having trouble getting anything done because of this!

Technical Developments Part 2

I had a flash drawing interface that was sent to me by Ian Grant last time I did a drawing project. Whilst it wasn't suitable for that project it maybe suitable for this one. Below is the original drawing interface and my adapted one:-





The snapshots above don't show the save buttons clearly even though they are there.

I'm hoping that I can apply some PHP code that will save and retrieve the drawings from the database that I will set up.

Technical Developments Part 1

My art project will require various PHP scripts, a MySQL database and html coding.

This is a broken down list of the requirements that I think I will need to enable my web art idea to work:-

My web experience must have an upload function. The flash drawing mechanism with save the file once the participant is happy with the outcome therefore I will need some PHP script to save the image file to the MySQL database.

The next requirement will be the recall of the image. When the second participant joins the art experience they will be need to view the previous art piece. Therefore the PHP script must recall the last MySQL database entry.

The third script will need to limit the viewing time of the art piece. I wanted to allow the participant 10-15 seconds to see the art piece before they can draw anything themselves. I think an automatic re-direct script to the drawing screen will be required. I guess this will probably be an HTML command script of some kind.

Then finally the art pieces must be laid out in the gallery space once 6 drawings have been complete, therefore the PHP script must recognise when the database has this many entries saved and allow participants to view the area. The participants with be able to view old games and therefore the PHP script must limit the art displayed in the gallery area to the last complete game.

These are the points I must work towards, I think once I have set my PHP to work and my MySQL database I can crack on with searching for the coding.