Import Data from Excel into a MySQL Table
Export Data from a MySQL Table to Excel
Your client needs a PHP and MySQL application built in two days. They want a Student Information Management System (SIMS) to organize their student information.
You will get credit for each fully functional working script. Please work together to gain access to the resources and problem solve issues.
Maintain a work flow journal to document [...]
To create a simple search form and php script examine the following examples. The HTML form and PHP script are all in one document. You can download it below. Also remember to change the variables to your specific database and HTML form needs.
The HTML and PHP Form
Download
search.php (zipped)
The Tutorials
You should subscribe to rrphillips’ channel at [...]
You need an HTML and PHP file to delete material from your database table from a web browser. Below are screenshots of two samples. Linked in the Download are more examples from the Head First PHP and MySQL Book Web Site.
HTML File
PHP File
Download
Remove_Files (zipped)
You will find a sample similar to the .php pictured above at [...]
Sample Page Titled: authorize.php
Include the file pictured below in the same folder as the page you are trying to protect, like any page that allows someone to enter or delete data. You can download this file at the end of this blog entry.
Script Included on Protected Page
You must include this script above all of the [...]
The PHP Code Embedded in HTML
The screenshots and zipped file for download, linked below, are based on the Chapter 3 addmail.html and .php scripts from the Head First PHP and MySQL Book with some fun CSS modifications. It has these fields; First Name, Last Name, Gender, Graduation Year and Comments. You need to be change [...]
Watch the tutorial videos part 1 and part 2 to see how to use the files from chapter 2 of the Head First Series PHP and MySQL Book with the hulk.osd.wednet.edu web server.
Click on the download link below each video to see a larger version of the screencast
Part 1 [10:21m]: Play Now | Play in Popup | Download Part 2 [7:32m]: Play Now | Play in Popup | DownloadContinue reading about PHP & MySQL Connection Basics Tutorial
Resources
Web server address hulk.osd.wednet.edu
Your database is titled your OSD username and password
Accessing the Hulk Web Server on the Internet
Putty - Free SSH (Secure Shell) Clientto Access the Web Server
Tunnelier - Free SCP (Secure Copy Protocol) Program to Upload Files to the Web Server
WinSCP - Another SCP (Secure Copy Protocol) Program to Upload Files to the Web Server
Tutorials
http://www.w3schools.com/sql/default.asp
Learn and [...]
