Archive

Posts Tagged ‘mysql’

Installing MySQL on Windows

May 12th, 2009 Gertjan No comments

As Web sites and Web-based applications become more important to commercial firms and other organizations, so too does the methods used for storing data online, such as customer contact information, system login details, product data, and much more. Rewritable flat files may be sufficient for extremely limited data for which security is not an issue. But for most Web sites and applications, a robust database is called for.

There are several relational database management systems (RDBMSs) from which you the developer can choose, ranging from expensive systems that can prove quite difficult to administer, to free and open source alternatives that may not have as many features as the proprietary RDBMSs, but can be much faster to set up and work with. Of these, MySQL is the hands-down favorite.
Read more…

Categories: Windows Tags: , , ,

Creating a MySQL Database Class Using the Singleton Design Pattern

March 27th, 2009 Gertjan No comments

When creating a database class using mysql, we would create a class, and call it’s constructor in the script.

One potential problem with this approach is that each time we create a new database object, we allocate more and more memory to those operations. In some cases, it might make sense to do it that way, but a lot of times we only need one instance. This will help keep things organized and save memory.
Read more…

Categories: PHP Tags: , , , , ,

ASP vs PHP

July 29th, 2008 Gertjan 2 comments

By Halstatt Pires

When building web sites, ASP and PHP are very popular languages. Here’s my opinion on whether ASP or PHP is best.
Read more…

Complete advanced login member system – PHP tutorial

January 11th, 2008 Gertjan 256 comments

In this advanced tutorial i will teach you the steps required to create a custom build login/member system with PHP.

The system itself ofcourse has alot of room for improvements, also, it’s very easily expandable, i’ve chosen to work in a modular way, so that if you change something you only have to change it in 1 file. I’ve done this by using functions, this script is a good example of the real power of PHP.

Features:

  • Registration
  • Lost password
  • Various checks on passwords and usernames
  • users can change their password
  • Passwords are stored in a database with a seed added to it and they have sha1 encryption
  • Easy to adjust & use

Requirements:

  • Mysql database
  • a php & mysql enabled host
  • php mail() enabled host
  • ftp access to your website

Overview

Steps:

  1. Creating the mysql table
  2. Creating a db_connect.inc.php file
  3. Creating the header.php file
  4. Creating the footer.php file
  5. Creating the index.php file
  6. Creating the login.php file
  7. Creating the logout.php file
  8. Creating a function.inc.php file
  9. Creating the mail.functions.inc.php file
  10. Creating the display.functions.inc.php file
  11. Creating the login.functions.inc.php file
  12. Creating the user.functions.inc.php file
  13. Creating the validation.functions.inc.php file
  14. Creating the lostpassword.php file
  15. Creating the changepassword.php file
  16. Creating the register.php file
  17. Creating the activate.php file

Read more…

Export Mysql data to CSV – PHP tutorial

December 16th, 2007 Gertjan 102 comments

Want to export your Mysql data to a CSV(comma seperated value) file? In this tutorial i will show you how to export your data from Mysql into a CSV file.

Read more…

cutenews export to mysql – php tutorial

December 8th, 2007 Gertjan 30 comments

Want to export your cutenews posts to a mysql database? In this tutorial i will show you how to export your posts from cutenews into a mysql table.
Read more…

Categories: PHP Tags: , , , , ,

Creating a simple login script with php and mysql

December 6th, 2007 Gertjan 81 comments

Learn to create a simple login system with php and mysql in 7 simple steps:

Requirements:

  • Mysql database
  • a php & mysql enabled host
  • ftp access to your website

Overview

Steps:

  1. Creating the mysql table
  2. Creating a db_connect.inc.php file
  3. Creating the html login form
  4. Creating the login.php file
  5. Creating the logout.php file
  6. Creating a function.inc.php file
  7. Adding the script to index.php

Read more…

Categories: PHP Tags: , , , , , ,
Data Recovery