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 [...]
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 [...]
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 [...]
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 [...]
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
Continue 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 [...]
