search data in table with user inputs in php with mysql

connection.inc.php :

<?php
$host='localhost';
$user_name='root';
$password='';
@$con = mysql_connect("$host","$user_name","$password");
if ($con)
 {}
else
  {
  die('Could not connect ');
  }
?>
=======================================================================

select_form.php :


<center><form action="select_table.php" method="POST">
<table border=0><tr><td>database name</td><td><input type="text" name="db_name" value="test"></td>
<td>table name</td><td><input type="text" name="table_name" value="test"></td></tr>
<tr><td>column1 name</td><td><input type="text" name="col1" value="sno"></td>
<td>column2 name</td><td><input type="text" name="col2" value="name"></td></tr>
<tr><td colspan=4 align="center"><input type="submit" value="submit"> </td></tr></table>
</form>

===================================================================

select_table.php :


<?php

require 'connection.inc.php';

if (@mysql_select_db($_POST['db_name']))
{
     if(isset($_POST['db_name'])&& isset($_POST['table_name'])&& isset($_POST['col1'])&& isset($_POST['col2']))
        {
         if(!empty($_POST['db_name'])&& !empty($_POST['table_name'])&& !empty($_POST['col1'])&& !empty($_POST['col2']))
             {
               $db=$_POST['db_name'];
               $tn=$_POST['table_name'];
               $snum=$_POST['col1'];
               $name=$_POST['col2'];
               $result=mysql_query("select * from $tn ",$con);

                          if(mysql_query("select * from $tn ",$con))
                          {
                              if(@mysql_num_rows($result))
                                {
                               echo ("<br><center><table><tr><th><b>$snum</td><th><b>$name</td></tr>");
                               if(mysql_query("select $snum from $tn") && mysql_query("select $name from $tn"))
                               {
                               while($data = mysql_fetch_array($result))
                                     {
                                      echo "<tr><td>".@$data[$snum] . "</td><td>" .@$data[$name]."</td></tr>";
                                     }
                                    }else {
                                            echo '<b>please verify column name(s)</b>';
                                          }

                         }   else echo '<center><b>empty table';
                  }  else echo ('<center><br><br><b>no table with that name<br><br>');
              }
           else echo '<center>please varify is all data entered ?';
  } else echo '<center>one of the input ont set';
}else echo '<center><br>wrong database selected<br>';

mysql_close($con);
?>

=======================================================================

run " select_form.php "

output :

fill every text box and click on submit button

where in php with mysql

connection.inc.php :

<?php
$host='localhost';
$user_name='root';
$password='';
@$con = mysql_connect("$host","$user_name","$password");
if ($con)
 {echo '<br>host coonected<br>';}
else
  {
  die('Could not connect ');
  }
?>

where_table.php :
<?php

require 'connection.inc.php';

if (mysql_select_db('test'))
if($result=mysql_query("select * from test where sno=2",$con))
  {
     echo "<br><table><tr><td>sno</td><td>name</td></tr>";
    while($data = mysql_fetch_array($result))
  {
  echo "<tr><td>".$data['sno'] . "</td><td>" .$data['name']."</td></tr>";
  }
  echo "</table><br>data selected<br>";
  }
else
  {
  echo '<br>data not selected :'.mysql_error().'<br>';
  }

mysql_close($con);
?>

run " where_table.php "


output :



host coonected

sno	name
2	human
2	human

data selected

update in php with mysql

connection.inc.php :

<?php
$host='localhost';
$user_name='root';
$password='';
@$con = mysql_connect("$host","$user_name","$password");
if ($con)
 {echo '<br>host coonected<br>';}
else
  {
  die('Could not connect ');
  }
?>

update_table.php :

<?php

require 'connection.inc.php';

if (mysql_select_db('test'))
if(mysql_query("update test set name='humans'where sno=1",$con))
  {
    $result=mysql_query("select * from test where name='humans'",$con);
     echo "<br><table><tr><td>sno</td><td>name</td></tr>";
    while($data = mysql_fetch_array($result))
  {
  echo "<tr><td>".$data['sno'] . "</td><td>" .$data['name']."</td></tr>";
  }
  echo "</table><br>data updated<br>";
  }
else
  {
  echo '<br>data not updated :'.mysql_error().'<br>';
  }

mysql_close($con);
?>

run " update_table.php "

output:


host coonected

sno

name

data updated

select in php with mysql

connection.inc.php :

<?php
$host='localhost';
$user_name='root';
$password='';
@$con = mysql_connect("$host","$user_name","$password");
if ($con)
 {echo '<br>host coonected<br>';}
else
  {
  die('Could not connect ');
  }
?>

select_table.php :
<?php

require 'connection.inc.php';

if (mysql_select_db('test'))
if($result=mysql_query("select * from test ",$con))
  {
     echo "<br><table><tr><td>sno</td><td>name</td></tr>";
    while($data = mysql_fetch_array($result))
  {
  echo "<tr><td>".$data['sno'] . "</td><td>" .$data['name']."</td></tr>";
  }
  echo "</table><br>data selected<br>";
  }
else
  {
  echo '<br>data not selected :'.mysql_error().'<br>';
  }

mysql_close($con);
?>

run "select_table.php "

output :


host coonected

sno	name
2	human
2	human

data selected

order by in php with mysql

connection.inc.php :

<?php
$host='localhost';
$user_name='root';
$password='';
@$con = mysql_connect("$host","$user_name","$password");
if ($con)
 {echo '<br>host coonected<br>';}
else
  {
  die('Could not connect ');
  }
?>

order_by_table.php :

<?php

require 'connection.inc.php';

if (mysql_select_db('test'))
if($result=mysql_query("select * from test order by name",$con))
  {
     echo "<br><table><tr><td>sno</td><td>name</td></tr>";
    while($data = mysql_fetch_array($result))
  {
  echo "<tr><td>".$data['sno'] . "</td><td>" .$data['name']."</td></tr>";
  }
  echo "</table><br>data selected<br>";
  }
else
  {
  echo '<br>data not selected :'.mysql_error().'<br>';
  }

mysql_close($con);
?>

run " order_by_table.php "

output :


host coonected

sno	name
2	human
2	human

data selected

insert data into table in php with mysql

connection.inc.php :
<?php
$host='localhost';
$user_name='root';
$password='';
@$con = mysql_connect("$host","$user_name","$password");
if ($con)
 {echo '<br>host coonected<br>';}
else
  {
  die('Could not connect ');
  }
?>



insert_table.php :
<?php

require 'connection.inc.php';

if (mysql_select_db('test'))
echo '<br>database selected<br>';
if(mysql_query("insert into test(sno,name)values (2,'human')",$con))
  {
  echo "<br>data inserted<br>";
  }
else
  {
  echo '<br>data not inserted :'.mysql_error().'<br>';
  }

mysql_close($con);
?>

run " insert_table.php "

output :


host coonected

database selected

data inserted

delete table in php with mysql

connection.inc.php :

<?php
$host='localhost';
$user_name='root';
$password='';
@$con = mysql_connect("$host","$user_name","$password");
if ($con)
 {echo '<br>host coonected<br>';}
else
  {
  die('Could not connect ');
  }
?>

del_table.php :

<?php

require 'connection.inc.php';

if (mysql_select_db('test'))
if(mysql_query("delete from test where sno = 1",$con))
  {  $result=mysql_query("select * from test where sno = 1",$con);
     echo "<br><table><tr><td>sno</td><td>name</td></tr>";
     while($data = mysql_fetch_array($result))
  {
  echo "<tr><td>".$data['sno'] . "</td><td>" .$data['name']."</td></tr>";
  }
  echo "</table><br>data deleted<br>";
  }
else
  {
  echo '<br>data not selected :'.mysql_error().'<br>';
  }

mysql_close($con);
?>



run " del_table.php "

output :


host coonected

sno

name

data deleted

database create in php with mysql

connection.inc.php :

<?php
$host='localhost';
$user_name='root';
$password='';
@$con = mysql_connect("$host","$user_name","$password");
if ($con)
 {echo '<br>host coonected<br>';}
else
  {
  die('Could not connect ');
  }
?>
=========================================================
 database_creation.php :

<?php

require 'connection.inc.php';
if(isset($_POST['db'])&&!empty($_POST['db']))
{
$db1=$_POST['db'];
if (mysql_query("create database $db1",$con))
  {
  echo "<br>Database created<br>";
  }
else
  {
  echo '<br>database not created<br> :'.mysql_error().'<br>';
  }
}
else
{ echo '<br>please write database name below<br><br>' ; }
mysql_close($con);
?>

<form action="database_creation.php" method="POST">
<input type="text" name="db">
<input type="submit" name="submit">
</form>

===============================================================
run " database_creation.php "

output :


host coonected

please write database name below

host coonected

please write database name below

   "here button is there"

create table in php with mysql

connection.inc.php :

<?php
$host='localhost';
$user_name='root';
$password='';
@$con = mysql_connect("$host","$user_name","$password");
if ($con)
 {echo '<br>host coonected<br>';}
else
  {
  die('Could not connect ');
  }
?>

creation_table.php :
<?php

require 'connection.inc.php';

if (mysql_select_db('test'))
echo '<br>database selected<br>';
if(mysql_query("create table test(sno varchar(3),name varchar(15))",$con))
  {
  echo "<br>table created<br>";
  }
else
  {
  echo '<br><br>table not created :'.mysql_error();
  }

mysql_close($con);
?>

run " creation_table.php"

output :

host coonected

database selected


table created

connect with database in php with mysql

connection.inc.php :

<?php
$host='localhost';
$user_name='rootgf';
$password='';
@$con = mysql_connect("$host","$user_name","$password");
if ($con)
 {echo '<br>host coonected<br>';}
else
  {
  die('Could not connect ');
  }
?>

connection.php :

<?php

require 'connection.inc.php';



mysql_close($con);
?>

run  " connection.php"
output :
host coonected



array
arrays display
associative arrays in php
multi dimensional arrays in php
for each statements with arrays in php
add one arry to another array or append
array reduce with array_splice() in php
array to string in php
change array size using array_pad() in php
delete array elements with unset() in php
check array index or key with user inputs in php
checking if an element is in array or not using in php