|
|
This script is a real world application that shows how to use MySQL with PHP. You can learn from the step by step commented
php source code how to build a php program that uses MySQL to keep a database of your books. Program functions implemented include, saving a new record, listing of records for user selection, selection of a record and displaying its details, updating a record, deleting a record and searching for records. Once you have learned the techniques used in this program, you can build any php-mysql based programs.
If you are looking for a full example source codes for a complete PHP program that shows how to use PHP with MySQL, then this package is for you.
Here's what you'll learn from this package.
1. How to create and use functions in PHP
2. How to use html forms to send data to a PHP script
3. In a php script, how to properly retrieve data sent from a html form
4. How to separate php code from html and css files
5. How to display php generated data in html forms
6. How to use php include files to avoid unnecessary code duplication
7. In php functions, how to use variables defined outside the function
8. In php functions, how to pass variables into the function so that they can be used in the function
9. In php functions, how to return values of variables to the calling program.
10. In a php script, how to connect to a MySQL database, execute a query, get the query results and the number of rows returned in the query result.
11. How to dynamically fill a html form selection list with data returned from a mysql query.
12. How to use regular expressions to validate certain data inputs
13. In php script, how to redirect to another php script
14. How to avoid problems in query strings by using str_replace and addslashes
15. How to construct SQL queries that contain php variables.
16. How to use php to handle html form input errors and report them to the user.
|
|
|
Download link |
 |
|
Size |
670KB |
|
License |
Commercial |
|
Price |
24.95 |
|
Category |
Web Development / PHP |
|
Operating System |
Win98, WinME, WinNT 3.x, WinNT 4.x, Windows2000, WinXP, Windows2003, Unix, Linux |
|
Developer |
ICT eBooks by Yeoh HS |
|
|
|
Related tags: php, mysql, books, database,
|
|
|
| Top PHP / Web Development programs |
1)
2D/3D Line Graph for PHP 5.1
This PHP script provides a very easy way to embed dynamic line graphs to PHP apps and web pages. Very easy to use and it's perfectly possible to add professional quality real time graphing to web pages & apps within minutes. Try for free.
|
2)
ViArt Shop Free Shopping Cart 2.7.1
Free Ecommerce PHP shopping cart software coming with Content Management System and HelpDesk Support System. Multiple layouts support. This ecommerce solution supports MySQL and PostgreSQL databases as well as ODBC connected databases.
|
|
|
4)
Advanced Graph and Chart Collection for PHP 4.86
The PHP graphing scripts provide a very easy way to embed dynamically generated graphs and charts into PHP applications and HTML web pages.Very easy to use and add professional quality graphing to web pages / applications in minutes. Try for free.
|
![44 Scripts and Tools]()
5)
44 Scripts and Tools 1.0
Scripts with resell rights, built fabulous profit pulling websites
This package is full of many popular CGI, PHP scripts you can use to create fabulous website
Select from affiliate scripts, classified ad scripts and more. Automate your website.
|
6)
AccessForms2Web (PHP&MySQL Editon) 1.0.0
AccessForms2Web (PHP&MySQL Editon) allows you to convert mdb (Microsoft Access forms) to your WEB page. Now you can easily convert forms and their elements to Web page including elements' position, color pallet and fields type.
|
7)
2D/3D Vertical Bar Graph for PHP 5.1
This PHP script provides a very easy way to embed dynamic vertical bar graphs to PHP apps and web pages. Very easy to use and it's perfectly possible to add professional quality real time graphing to web pages & apps within minutes. Try for free.
|
![Dating Site Solution]()
8)
Dating Site Solution 3.1.12
Flexible solution for online dating business. Minimum costs - maximum profit. Free trial version and online demo for help in making a right choice. Multilingual interface and functional user mode. Create a place where users will make a perfect match.
|
9)
2D/3D Area Graph for PHP 4.64
This PHP script provides a very easy way to embed dynamic area graphs to PHP apps and web pages. Very easy to use and it's perfectly possible to add professional quality real time graphing to web pages & apps within minutes. Try for free.
|
10)
PHPWebQuiz 1.2.0
PHPWebQuiz is a program to solve quizzes online on the Internet or on a Intranet. It runs on a Internet server. PHPWebQuiz has been developed to be used together with QuizPro.
|
| New PHP / Web Development programs |
1)
Syndikut - Mail Me Commercial 1
Syndikut Mail Me Commercial is an easy to edit php contact form script packed with useful features. MMC allows your visitors to contact you using a simple easy to customize form. MMC is 100% flat file so no SQL database required!
|
2)
Syndikut - Mailing List Manager 2
Syndikut Mailing List Manager v2 is a PHP, subscribers/news letter script. Using a flat file database to store all subscribed email addresses so NO SQL needed! With MLM, you can easily start your own mailing list service for any purpose.
|
3)
Syndikut - Quick Download 3
Syndikut Quick Download v3 (QDL) is a hassle free, flat file, php script to aid quick, secure delivery of digital downloads. When your customer has purchased a product, you as admin create a unique download link through the admin CP..
|
4)
Syndikut - Visitors Online 3
Syndikut Visitors online is a flat file, PHP script that displays how many visitors are viewing your website. When 'VOL' displays users online you & your visitors can click the amount and be shown all the visitors online by counties with flags!
|
5)
Syndikut - 5 Five Star Rating 3
Syndikut 5 Five Star Rating php script is a unique multiple rating system using a flat file database so NO SQL required! FSR is very simple to use and, unlike most rating systems, extremely versatile.
|
6)
Ready Mortgage Site Solution OCT.2007
Establish a web presence and make your origination easier with Mortgage solution. Get a ready web site with calculators, application forms and manage everything with easy-to use administrative panel. Calyx and Fannie Mae compatible. Free support.
|
7)
DBForms from MSAccess to PHP+PostgreSQL 1.0.0
DBForms from MS Access to PHP+PostgreSQL allows you to convert mdb (Microsoft Access forms) to php + PostgreSQL driven WEB page using AJAX. Convert forms and their elements to Web page including elements' position, color pallet and fields type.
|
8)
Website Builder 1.6
The Website Builder script provides you with all the features you will need to set up your own website, using your own domain name. The script can be added to an already running website, or it can also run on its own.
|
9)
PHP 2D/3D Pie Chart 5.1
This PHP script provides a very easy way to embed dynamic pie charts to PHP apps and web pages. Very easy to use and it's perfectly possible to add professional quality real time graphing to web pages & apps within minutes. Try for free.
|
10)
2D/3D Vertical Bar Graph for PHP 5.1
This PHP script provides a very easy way to embed dynamic vertical bar graphs to PHP apps and web pages. Very easy to use and it's perfectly possible to add professional quality real time graphing to web pages & apps within minutes. Try for free.
|
|
|
|
|
|