31 Mar 2014

mysql_fetch_array in php and mysql

Mysql_fetch_array() returns row as an associative, numeric array or both based on parameters passed in it. Three types of parameters can be passed in mysql_fetch_array function.

1. MYSQL_BOTH - return both associative and numeric array
2. MYSQL_ASSOC - return associative array
3. MYSQL_NUM - return numeric array

Retrieve data from table using mysql_fetch_array() in php:

Consider following example:

mysql_fetch_array in php and mysql at phponwebsites

Mysql_fetch_array() with MYSQL_BOTH in php:

It returns result as both associative and numeric array. You can retrieve data using both associative and numeric indices in php.

<html>
<body>
<table>
<th>Game_ID</th><th>Category</th><th>Title</th>
<?php
mysql_connect('localhost','root','')  or die(mysql_error());
mysql_select_db('new')  or die(mysql_error());
$query=mysql_query('select * from table1')  or die(mysql_error());
while($res=mysql_fetch_array($query, MYSQL_BOTH))
{
echo'<tr><td>'.$res['game_ID'].'</td><td>'.$res[1].'</td><td>'.$res['game_Title'].'</td></tr>';
}
echo'<table>';
?>
</body>
</html>

Now you'll get output like this:

mysql_fetch_array with MYSQL_BOTH in php

Where,
the array should be like this:

Array(
[game_ID] => 1
[category_Name] => Adventures
[game_Title] => Achilles
)

Array(
[0] => 1
[1] => Adventures
[2] => Achilles
)

mysql_fetch_array() with MYSQL_NUM in php:

It returns result as numeric array. ie, indices are numeric like 0,1,2...

<html>
<body>
<table>
<th>Game_ID</th><th>Category</th><th>Title</th>
<?php
mysql_connect('localhost','root','')  or die(mysql_error());
mysql_select_db('new')  or die(mysql_error());
$query=mysql_query('select * from table1')  or die(mysql_error());
while($res=mysql_fetch_array($query, MYSQL_NUM))
{
echo'<tr><td>'.$res[0].'</td><td>'.$res[1].'</td><td>'.$res[2].'</td></tr>';
}
echo'<table>';
?>
</body>
</html>

Now you'll get output like this:

In this type, the array of result should be like below:

Array(
[0] => 1
[1] => Adventures
[2] => Achilles
)

Suppose you'll use
echo'<tr><td>'.$res[0].'</td><td>'.$res[1].'</td><td>'.$res['game_Title'].'</td></tr>';

That means you use associative index instead numerical, then you will get undefined index error like as follows as:

mysql_fetch_array() with MYSQL_ASSOC in php:

It returns result as an associative array.

<html>
<body>
<table>
<th>Game_ID</th><th>Category</th><th>Title</th>
<?php
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('new') or die(mysql_error());
$query=mysql_query('select * from table1') or die(mysql_error());
while($res=mysql_fetch_array($query,MYSQL_ASSOC))
{
echo'<tr><td>'.$res['game_ID'].'</td><td>'.$res['category_Name'].'</td><td>'.$res['game_Title'].'</td></tr>';
}
echo'<table>';
?>
</body>
</html>

Now you'll get output like this:

mysql_fetch_array with MYSQL_ASSOC in php

Where,
the array should be like this:
Array(
[game_ID] => 1
[category_Name] => Adventures
[game_Title] => Achilles
)

Suppose you'll use

echo'<tr><td>'.$res[0].'</td><td>'.$res['category_Name'].'</td><td>'.$res['game_Title'].'</td></tr>';

That means you use numeric index instead associative, then you will get undefined offset error like as follows as:

mysql_fetch_assoc,php, mysql at phponwebsites

Note:

mysql_fetch_array() without array_type means return row as an associative, numeric array or both

Related Post:

Retrieve data from mysql database using mysql_fetch_row in php
Retrieve data from mysql table using mysql_fetch_assoc in php

26 Mar 2014

mysql_fetch_row in php and mysql

Mysql_fetch_row() return row as numeric array. We can't use associative indices to retrieve data from mysql table using php.

Consider following example:

Retrieve data from table using mysql_fetch_row() in php:

You can retrieve data from mysql table using mysql_fetch_assoc() in php. The following php script is used for retrieve data.

<html>
<body>
<table>
<th>Game_ID</th><th>Category</th><th>Title</th>
<?php
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('new') or die(mysql_error());
$query=mysql_query('select * from table1') or die(mysql_error());
while($res=mysql_fetch_row($query))
{
echo'<tr><td>'.$res[0].'</td><td>'.$res[1].'</td><td>'.$res[2].'</td></tr>';
}
echo'<table>';
?>
</body>
</html>

Now you'll get output like this:

Where,
the result of array should be like this:
Array(
[0] => 1
[1] => Adventures
[2] => Achilles
)

Suppose you'll use following php script,
echo'<tr><td>'.$res[0].'</td><td>'.$res[1].'</td><td>'.$res['game_Title'].'</td></tr>';

That means you use associative index instead numerical, then you will get undefined index error like as follows as:

Where,
'game_Title' is the field name of column. You can't use $res['game_title'] here. Because you retrieved data from table using mysql_fetch_row().

Related Post:

Retrieve data from mysql database using mysql_fetch_assoc in php
Retrieve data from mysql database using mysql_fetch_array() in php

24 Mar 2014

mysql_fetch_assoc in php and mysql

Mysql_fetch_assoc() return row as an associative array. Here, we can use numeric indices to get values from mysql data using php.

Consider following example:

Retrieve data from table using mysql_fetch_assoc() in php:

You can retrieve data from mysql table using mysql_fetch_assoc() in php. The following php script is used for retrieve data.

<html>
<body>
<table>
<th>Game_ID</th><th>Category</th><th>Title</th>
<?
php mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('new') or die(mysql_error());
$query=mysql_query('select * from table1') or die(mysql_error());
while($res=mysql_fetch_assoc($query))
{
echo'<tr><td>'.$res['game_ID'].'</td><td>'.$res['category_Name'].'</td><td>'.$res['game_Title'].'</td></tr>';
}
echo'<table>';
?>
</body>
</html>

Now you'll get output like this:

Where,
the result of array should be like this:
Array(
[game_ID] => 1
[category_Name] => Adventures
[game_Title] => Achilles
)

Suppose you'll use

echo'<tr><td>'.$res[0].'</td><td>'.$res['category_Name'].'</td><td>'.$res['game_Title'].'</td></tr>';

That means you use numeric index instead associative, then you will get undefined offset error like as follows as:

Where,
$res[0] represents the first column of mysql table. But you can't use this to retrieve data from table. Because you used mysql_fetch_assoc() mysql function to retrieve data.

Related Post:

Retrieve data from mysql database using mysql_fetch_row in php
Retrieve data from mysql database using mysql_fetch_array() in php

19 Mar 2014

Avoid duplicate values storing in table using php and mysql

We can avoid duplicate values storing in table when we insert data to table. Because the duplicate entry is one of the main problem, while insert data into mysql table . We removed duplicate values using 'DISTINCT' key in mysql query, if it is present in table. We can check whether the value is present in table or not using PHP and Mysql before add data to table.

We can also avoid duplicate values storing in mysql table while inserting by primary key.

Consider following example. You've a database named with 'new' and table named with 'user'. You try to add names in user table. Now you've to check the values is present or not while you inserting. The table look like this:

Avoid duplicat values sotring in table using PHP at phponwebsites

Now you try to add name 'guru' again. You can check whether the name 'guru' is present in table or not using below PHP script.

<?php
if(isset($_POST['submit']))
{
mysql_connect('localhost','root','');
mysql_select_db('new');
$name=$_POST['name'];
$query=mysql_query("select * from user where name='".$name."' ") or die(mysql_error());
$duplicate=mysql_num_rows($query);
if($duplicate==0)
{
$query1=mysql_query("insert into user values('".$name."')") or die(mysql_error());
}
else
{
echo'The name '.$name.' is already present in the user table';
}
}
?>
<html>
<body>
<form method='post' action='#'>
name: <input type='text' name='name'>
<input type='submit' name='submit' value='Submit'>
</form>
</body>
</html>

Where,
mysql_query() - execute the query and select if any similar values are present in table. mysql_num_rows() - returns numeric value of selected rows. If its value is 0, then there is no similar values present in table. Otherwise the value is already present in table.
Where,
you can also use mysql_fetch_row() instead of mysql_num_rows().
If the value is present in table, it could not be stored in table. Now you can avoid duplicate entries in table using PHP and Mysql.

Related Post:

How to store values into mysql table using php

13 Mar 2014

Insert data into mysql table using php

You can insert values to mysql table using php. The following mysql query is used for insert data into table.
INSERT INTO table_name VALUES(values datatype(length))

Store values into mysql table using php:

The following php script is used to store values into mysql table.

<?php
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('new') or die(mysql_error());
$query=mysql_query("insert into table1 values(1,'sample1', 'sample1.jpg')") or die(mysql_error());
if($query)
{
echo 'Vaules are inserted into table';
}
else
{
echo'Vaules are not inserted';
}
?>

Note:
If you declared field name as varchar, then you must insert values between single quotation marks ( 'sample1').

Now the values are inserted into table. You can see it in your mysql table at phpmyadmin. Your mysql table look like this:

You inserted values to your table using php.

Get values from user and insert into mysql table using php:

Suppose you want to get values from user. First you have to know how to get values from text boxes.

How to get values from textbox using php:

$name=$_POST['name']; if(method is post)
or
$name=$_GET['name']; if(method is get)
or
$name=S_REQUEST['name']; if(method is either post or get)

where,
S_POST[] is used to get values from textbox, If you use POST method.
S_GET[] is used to get values from textbox, If you use GET method.
S_REQUEST[] is used to get values from textbox, If you use either GET or POST method.

Then the following php code is used to insert values into table.

Where,
the values will get from users using post method like as below:
$_POST['textbox_name']

Now you run this file. Your display look like this:

Then you can get values, if user type anything in textbox. Now i added values as like this:

Get values from user and stored into mysql table using php

Now you'll get output like this:

Your mysql table have user inserted values.

Related Post:

How to avoid duplicate values storing in mysql table 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

Pages

31 Mar 2014

mysql_fetch_array in php and mysql

Retrieve data from table using mysql_fetch_array() in php:

Mysql_fetch_array() with MYSQL_BOTH in php:

mysql_fetch_array() with MYSQL_NUM in php:

mysql_fetch_array() with MYSQL_ASSOC in php:

26 Mar 2014

mysql_fetch_row in php and mysql

Retrieve data from table using mysql_fetch_row() in php:

24 Mar 2014

mysql_fetch_assoc in php and mysql

Retrieve data from table using mysql_fetch_assoc() in php:

19 Mar 2014

Avoid duplicate values storing in table using php and mysql

13 Mar 2014

Insert data into mysql table using php

Store values into mysql table using php:

Get values from user and insert into mysql table using php:

How to get values from textbox using php:

6 Mar 2014

Create mysql table using php