Member Avatar for tqmd1

Dear Sir, I have following codes

<?php
    require_once("connect.php");

if(isset($_POST['button1']))
    {
        // Get values from form 
        $sno =$_POST['txtsno']; 

        $record_check ="SELECT * FROM test WHERE sno = " . $sno;
        $result=mysqli_query($record_check);
        $row = mysqli_fetch_array($result) ;

        if(!$row)
                    die ('No record Found'); 
    }
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Display data in textboxes</title>
<style type="text/css">

html {
overflow:auto;
}

body {
background-color:#FFFFFF;
margin:0 auto;
}

#mypopup
{
float: left;
width: 250px; height: 350px;
background: #90bade; 
border: 1px solid #069;
text-align:center;
padding:2px;
margin-top:150px;
margin-left:100px;
overflow:auto;
}

#header
{
background-color:#3399FF;
background-position:left center;
line-height:25px;
font-size:22px;
color:#FFFF33;
font-weight:600;
border-bottom:1px solid #6699CC;
padding:10px;
}
</style>


</head>
<body>
<center>
  <div id="mypopup">
    <div id="header">Search Data</div>
    <div style="margin-top:80px;">

     <form name="form1" action="data_find_in_textbox2.php" method="post">
        <table border=0; cellpadding="1" cellspacing="1" bgcolor="#CCFFFF" align="center" >
          <tr>
            <td>Code</td>
            <td width="50px"><input type="text" name="txtsno" value="" title="Enter product code" onkeypress="validate(event)" ;  onfocus="this.select()" /></td>
          </tr>
          <tr>
            <td>Product</td>
            <td><input type="text" name="txtpro" value="<? echo $row['packing'] ?>" title="Enter product name" ></td>
          </tr>
          <tr>
            <td>Weight</td>
            <td><input type="text" name="txtwet" value="<? echo $row['weight'] ?>" title="Enter product weight" onfocus="this.select()" ></td>
          </tr>
        </table>
        <div style=text-align:center;margin-top:20px;>
          <input type="submit" name="button1" value="Display" >
          <input type="submit" name="button2" value="Clear" >
        </div>
      </form>
    </div>
  </div>
</center>
<?php 
        mysqli_close($con);
?>
</body>
</html>

I want to search data as

[IMG]http://i40.tinypic.com/w6xjb8.jpg[/IMG]

If I enter sno and press Dispaly button, then text2 and text3 must display relevant data from table.

Now when enter sno=1 and press Display button then it shows this error message

Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\wamp\www\db\data_find_in_textbox2.php on line 10

Test table has more than 3 recores including sno=1

Please help

  • 2 Contributors
  • 2 Replies
  • 252 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by tqmd1
Member Avatar for Bachu

Do the following changes

<?php
global $con;
require_once("connect.php");
$productValue="";
$productWeight="";
$productCode = "";

if(isset($_POST['button1']))
    {
        // Get values from form 
        $sno =$_POST['txtsno']; 

        $record_check ="SELECT * FROM test WHERE sno = '$sno' ";
        $result=mysqli_query($con, $record_check);
        $row = mysqli_fetch_array($result); 
        if(!$row)
                    die ('No record Found');
        else {
            $productValue = $row['packing'];
            $productWeight = $row['weight'];
            $productCode = $sno;
        }                    
    }
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Display data in textboxes</title>
<style type="text/css">

html {
overflow:auto;
}

body {
background-color:#FFFFFF;
margin:0 auto;
}

#mypopup
{
float: left;
width: 250px; height: 350px;
background: #90bade; 
border: 1px solid #069;
text-align:center;
padding:2px;
margin-top:150px;
margin-left:100px;
overflow:auto;
}

#header
{
background-color:#3399FF;
background-position:left center;
line-height:25px;
font-size:22px;
color:#FFFF33;
font-weight:600;
border-bottom:1px solid #6699CC;
padding:10px;
}
</style>


</head>
<body>
<center>
  <div id="mypopup">
    <div id="header">Search Data</div>
    <div style="margin-top:80px;">

     <form name="form1" action="#" method="post">
        <table border=0; cellpadding="1" cellspacing="1" bgcolor="#CCFFFF" align="center" >
          <tr>
            <td>Code</td>
            <td width="50px"><input type="text" name="txtsno" id="txtsno" value="<?php  echo $productCode ; ?>" title="Enter product code" onkeypress="validate(event)" ;  onfocus="this.select()" /></td>
          </tr>
          <tr>
            <td>Product</td>
            <td><input type="text" name="txtpro" value="<?php echo $productValue; ?>" title="Enter product name" ></td>
          </tr>
          <tr>
            <td>Weight</td>
            <td><input type="text" name="txtwet" value="<?php echo $productWeight; ?>" title="Enter product weight" onfocus="this.select()" ></td>
          </tr>
        </table>
        <div style=text-align:center;margin-top:20px;>
          <input type="submit" name="button1" value="Display" >
          <input type="reset" name="button2" value="Clear" >
        </div>
      </form>
    </div>
  </div>
</center>
<?php 
        mysqli_close($con);
?>
</body>
</html>

And also made changes in connect.php

<?php
// Connection variables
$host="localhost";
$username="root";
$password="";
$db_name="DatabaseName"; 


// Connect to database
$con=mysqli_connect("$host", "$username", "$password", "$db_name");

// Connect result
if(!$con){
die('Error Connecting to Database: ' . mysqli_error());
}
else
{
//echo "Connected" . mysqli_error($con);
}
//close the connection
//mysql_close($con);
?>
Edited by Bachu because: text correction
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.