Featured Flash FLA 11336 Flash Movies | 2 New Flash Movies Added What's New | Top 100 Featured FLA » Author: Surjit Dhami » Title: Book » Description: Book » More by Surjit Dhami Random FLAs | Add Flash Movie Featured Flash Site 5848 Flash Sites | 0 New Flash Links What's New | Top 100 Flash Site Featured Site » Posted in the Flash Kit Links section » Title: All-American Rejects » Description: Get to know this great band by exploring their "practice room". Random Links | Add your own Flash Related Links

1277 Tutorials 7 New Tutorials Added! What's New | Top100 » Create xml slideshow with free template » How to Insert a Multilingual Subtitle Into Your Flash Video Studio » How to Create Cool Halloween Slideshow » Debugging flash using the Firebug console » Create Flash Slideshow on Blogger » FLASH TRICKS IN WEB ADVERTISING: FLASH BANNERS » HTML Photo Gallery Tutorial » Create your first flash site – PART 1 » How to Make a Flash Photo Gallery » Unknown Tag: Title10 Random Tutorial | Add Site

Sr Instructional Designer D2L-Moodle,Clearance WSI Nationwide, Inc. US-NJ-Fort Monmouth Post A Job | Post A Resume

Tutorials Home What's New Top Rated Submit myTutes Random!

Tutorials » Backend

mySQL and PHP - Login and Registration - Saving Movie Clip ('s) Position
Author: Jeffrey F. Hill | Website: http://www.snowvids.com |

Part II - Setting up the PHP 

The PHP scripts will be better explained by reading the comments in the attached files. Just open up the PHP script with notepad or any other text editor to make changes. 

The first thing we have to do is connect to the database.  You will need to know your database name, account username, and database password. In order to keep this as simple as possible use an include file to list these variables - They will be the same for each one of your scripts.  This is what is contained in the file Include.inc. One thing to note is that often times the $DBhost variable is slightly different then "localhost" - Sometimes it can be "localhost.yourHost.com".

<?
$DBhost = "localhost";
$DBuser = "UserName";
$DBpass = "DatabasePassword";
$DBName = "DatabaseName";
$table = "saveMovie";
?>

You will notice that at the top of each PHP script there is a line of code something like this: include ('Include.inc'); All this does is to include those variables in the script. It's just an easier way of keeping track of everything. 

Next you want to make a connection to the Database: 

mysql_connect($DBhost,$DBuser,$DBpass);
@mysql_select_db("$DBName");

 You can see how the variables in the Include File are used here. I'm only going to go over in detail the SQL query part of each script. The rest you should be able to figure out by reading through the comments in the File. Also note that for simplicity some basic sercurity precautions where left out. These are not necessary but you might want to include them if you have any type of sensitive data.

» Forums
	More help? Search our boards for quick answers!

Please rate this tutorial, 10 is the top rating, you can also click the comments link to read/write a review.

10 9 8 7 6 5 4 3 2 1