Pradeepkumar.org

The following script tries to connect the database and if it is failed it will display relevant message. The server is localhost and username/password combination is root/abc123. it is necessary to create a database ‘dummy’ before executing the script. Click here to set password for mysql and phpmyadmin
<?php
$con=mysql_connect(”localhost”,”root”,”abc123″) or die(”Couldnt Connect to database”);
$a=mysql_select_db(”dummy”,$con);
if($a)
echo “Database Selection [...]

Continue reading Connect to MySQL Database using PHP

If a user visits a website, where he is asked for validating his username and password and will be validated with the MySQL Database. the following scripts demonstrate this.Step 1: create a database called dummy by executing “create database dummy” in mysql command window or shell windowStep 2: Create a table called usertable with two [...]

Continue reading User Validation/Authentication in PHP

Username/password Creation in PHP and MySQL. a Simple form is designed to get the username and two passwords the objectives are
1. Both the username and password should contain atleast 6 characters
2. both the passwords should be same
3. upon submitting to the database, the existence of username is checked with the database, if the username already [...]

Continue reading User Creation using PHP/MySQL

The following PHP scripts shows how to maintain a mailing list. the users are asked to subscribe/unsubscribe to a mailing list and the entire mails are stored in the database.
The user has to type his email id and his/her name and select the radio button subscribe/unsubscribe. Since one email ids are unique, the email id [...]

Continue reading Subscribe/Unsubscribe to a Mailing List