create - phponwebsites.com

Showing posts with label create. Show all posts

6 Jul 2014

Login validation using php and mysql

Everybody should see the login pages in most of websites. You should have doubt about this login form, how they validate username and password. There is nothing, just only 2 steps as follows as for login validation using php.
1. You enter username and password already registered which is stored in mysql database.
2. After you submit a button to login, it check the database values whether the username and password is correct or not using php and mysql query. The mysql query for select a values from mysql database as like this:

ie, SELECT * FROM table_name WHERE name='username' and password='password'

If it return values correctly, then you can login. Otherwise it give error message.

Simple login validation using php and mysql:

Lets see how to validate the username and password using php.

1. First you create table using mysql query like this:

CREATE TABLE login(name varchar(30), password varchar(30), PRIMARY KEY(name))

Now the table 'login' is created. The field 'name' is primary key. Because the username must be unique.

2. Then insert values into table using mysql query like this:

INSERT INTO login VALUES('guru','guru')

Now the table look like this:

3. The php script for login validation as follows as:
login.php:

<html>
<head>
<style type="text/css">
input{
border:1px solid olive;
border-radius:5px;
}
h1{
color:darkgreen;
font-size:22px;
text-align:center;
}
</style>
</head>
<body>
<h1>Login<h1>
<form action='#' method='post'>
<table cellspacing='5' align='center'>
<tr><td>User name:</td><td><input type='text' name='name'/></td></tr>
<tr><td>Password:</td><td><input type='password' name='pwd'/></td></tr>
<tr><td></td><td><input type='submit' name='submit' value='Submit'/></td></tr>
</table>

</form>
<?php
session_start();
if(isset($_POST['submit']))
{
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('new') or die(mysql_error());
$name=$_POST['name'];
$pwd=$_POST['pwd'];
if($name!=''&&$pwd!='')
{
$query=mysql_query("select * from login where name='".$name."' and password='".$pwd."'") or die(mysql_error());
$res=mysql_fetch_row($query);
if($res)
{
$_SESSION['name']=$name;
header('location:welcome.php');
}
else
{
echo'You entered username or password is incorrect';
}
}
else
{
echo'Enter both username and password';
}
}
?>
</body>
</html>

Where,
  if(isset($_POST['submit']){}   means run after submit a results.
  if($name!=''&&$pwd!=''){} means if either username or password is empty, it give message like as 'Enter both username and password'.
  mysql_query("select * from login where name='".$name."' and password='".$pwd."' ") select the values if the username and password is present.
$res=mysql_fetch_row($query) return row as numeric array.
You don't know about mysql_fetch_row, then visit mysql-fetch-row in mysql.
if($res){} validate the result. If it is correct, then your name is stored in session variable and also you'll navigate to 'welcome.php' page. Otherwise you'll get 'You entered username or password is incorrect' message. You want to visit Session in php.
    When you run the above file, it should be like this:

The php script for welcome page:

welcome.php:

<?php
session_start();
$name=$_SESSION['name'];
echo'welcome :'. $name.'<br>';
echo'<a href="signout.php">Signout</a>';
?>

Now you enter username and password 'guru' and 'guru', you will navigate to 'welcome.php' page and get output like this:

welcome: guru
Signout

If it is wrong, then you can't login.

Signout in php:

When you click the signout.php, it destroy the session and return back to login page. The php script for signout page:
signout.php:

<?php
session_start();
session_destroy();
header('location:login.php');
?>

session_destroy is used to destroy the session variable in php.

Related Post:
Create Registration form using PHP and MySQL
Login form validation with remember function using php and mysql
Forgot password to mail in login form validation using PHP and Mysql

6 Mar 2014

Create mysql table using php

You can create mysql table using php. The following mysql query is used to create mysql table.
CREATE TABLE table_name(field_name datatype(length))

The php script as follows as:

<?php
mysql_connect('localhost','root','');
mysql_select_db('new');
$query=mysql_query("create table table1(id int(5),name varchar(40),img varchar(30))") or die(mysql_error());
if($query)
{
echo 'Table is created';
}
else
{
echo'Table is not created';
}
?>

Where,
- mysql_connect() is used to connect the database.
- 'localhost' is server name.
- 'root' is user name of database.
- '' represent the password of database.
- mysql_select_db() is used to select the database for use.
- 'new' is the database new.
- mysql_query() is used for execute the mysql query.
- mysql_error() gives error message when the mysql query is not running successfully.

Now the mysql table 'table1' is created. You can see it in your mysql database at phpmyadmin.
Your mysql database should be like this:

Create mysql table using CREATE TABLE mysql command in php

Now you created your mysql table.

Related Post:

How to connect mysql database using php
How to create mysql database using php

21 Feb 2014

Create mysql database using php

All of you know, create mysql database in phpmyadmin. Now we are going to know how to create database using php.

The mysql query is:
CREATE DATABASE db_name

Then you use the particular database. The mysql query is:
USE db_name

The php coding as follows as:

<?php
mysql_connect('localhost','root','');
$query=mysql_query('create database new') or (mysql_error());
$qu=mysql_query('use new') or (mysql_error());
if($query)
{
echo'Database is created';
}
else
{
echo'Database is not created';
}
?>

Where,
- mysql_connect() is used to connect the database.
- 'localhost' is server name.
- 'root' is user name of database.
- '' represent the password of database.
- mysql_query() is used for execute the mysql query.
- 'new' is the database new.
- mysql_error() give error message while the mysql query is execute.
- die() terminate the excution.

Now you'll get output as " Database is created ". Then you can see the new database in your phpmyadmin.

create database in mysql using php at phponwebsites

The database 'new' is created and ready for use.

Related Post:

How to connect mysql database using php
How to create mysql table using php

12 Feb 2014

Primary key in mysql

The primary key in mysql is used to identify the unique values in table. It don't allow duplicate entries in mysql table. The primary key column should be NOT NULL. It don't allow null values in mysql table. The mysql table can have only one primary key.

How to create primary key in mysql:

The mysql query for create primary key is:

Create table table_name (column_name datatype(length), primary key(column_name))

For example,
create table table1(name varchar(30), address varchar(100), primary key(name))

Where the column 'name' is primary key.

How to add primary key to existing table in mysql:

You created table without primary like this:

create table table1(name varchar(30),address varchar(100))

But you need to add primary key in order to remove duplicate entries in mysql. At the time you can add primary key to existing table in mysql. Following mysq query is used for add primary key.

Alter table table_name add primary key(column_name)

For example,

Alter table table1 add primary key(num)

How to remove primary key in mysql:

You created table with primary. But you need not primary key for particular table. Then how can remove primary key from table in mysql. The following mysql query is used to drop the primary key from table in mysql.

alter table table_name drop primary key

For example,

alter table table1 drop primary key

where,

The primary key is removed from table 'table1'. Now you can add duplicate values to your mysql table.

Related Post:

distinct in mysql
Order by in mysql
Group by multiple columns in mysql
How to use order by together with group by in mysql
Difference between delete truncate drop in mysql
how to use order by before group by in mysql
How to reset auto increment initial value in mysql

23 Jan 2014

Add primary key to existing column in mysql

Primary key is used to avoid duplicate entries in mysql table. A mysql table can have only one primary key.

Create table with primary key in mysql:

The mysql query for create table with primary key is:

CREATE TABLE table_name(column_name datatype(length),
PRIMARY KEY(column_name))

For example,
CREATE TABLE table1(No int(5) datatype(length), ,Game_name varchar(15), Image varchar(15), PRIMARY KEY(No))

Now the table column 'No' is primary key in this table.

How to add primary key to existing column in mysql:

You can add primary while creating new table. But can you add primary key to existing column in mysql? Yes, you can add primary key to existing column in mysql. The mysql query is:

Alter table table_name add PRIMARY KEY(column_name)

Consider the example:
table1 is name of this table.

changing column size in mysql at phponwebsites

When you click the structure of table in your database, it is look like this:

There is no index defined. Suppose you've to add primary key to column 'Game_name'. On that time you can add the primary key. The mysql query is:

Alter table table1 add PRIMARY KEY(Game_name)

Now you click the structure of table in mysql database, the index is defined as below:

add primary key existing column in mysql

Now your Game_name column is changed from NULL into NOT NULL with primary key. Because the primary key should not be null. Only one primary key in a mysql table. A mysql table haven't more than one primary key.

Related Post:
Change column name in mysql
Change column size in mysql table
Delete column in mysql table
Add column after specific field in mysql table
Move columns in mysql table

change column datatype in mysql
Change table name in mysql
Add primary key to existing column in mysql
how to add auto increment to existing column in mysql
How to reset auto increment initial value in mysql

Pages