Php search results are not assigning into values

Question

0.00/5 (No votes)

See more:

i want to search from database table and display on the HTMl form but those values are not assigning to php declared variables

What I have tried:

<?php
    
    
if(isset($_POST['search']))
{
    
    $connect= mysqli_connect("localhost","root","1234","latgsjason");
    if (mysqli_connect_error()){
    echo"Failed to Connect";
    }
//    $result=mysqli_query($connect,"SELECT * FROM customer WHERE veh_regno='$_POST[V_Regno]'");
    $Vregno = $_POST['V_Regno'];
    $query="SELECT 'nic','fullname','address','contact','color' FROM customer WHERE 'veh_regno'=$Vregno LIMIT 1"; 
    $result=mysqli_query($connect,$query);

    while ($row=mysqli_fetch_array($result))
        {
            $VReg=$row['veh_regno'];
            $Nic=$row['nic'];
            $FName=$row['fullname'];
            $Address=$row['address'];
            $Contact=$row['contact'];
            $Color=$row['color'];
        }
        
        mysqli_free_result($result);
        mysqli_close($connect);
}
else
{
    $VReg="";
    $Nic="";
    $FName="";
    $Address="";
    $Contact="";
    $Color="";
}

?>


<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Manage Account</title>
        <link rel="stylesheet" type="text/css" href="CSS/Style SheetGeneral.css">
    </head>
<body>
<br><br><br>

<table background="Images/Back Ground Images/BG1.jpg" border="2" align="center" width ="825" height="820">

    <th align=center valign=center>

        <form action="ManageAccount.php" method="POST"/>

        <div class="textcenter1">
            <h2>Manage An Account</h2>
        </div>
        <br><br>

        <table border="0"; align="center" width ="655" height="550" >
        <tr>
            <td>
                VEHICLE REGISTRATION NUMBER :
            </td>
            <td>
                <input type="text" name="V_Regno" size="40" value="<?php echo $VReg; ?>">
            </td>
        </tr>
        
        <tr>
            <td>
                NATIONAL ID :
            </td>
            <td>
                <input type="text" name="Nic"  size="40" value="<?php echo $Nic; ?>">
            </td>
        </tr>
        
        <tr>
            <td>
                FULL NAME :
            </td>
            <td>
                <input type="text" name="F_Name"  size="40" value="<?php echo $FName; ?>">
            </td>
        </tr>
        
        <tr>
            <td>
                ADDRESS :
            </td>
            <td>
                <input type="text" name="Address" size="40" value="<?php echo $Address; ?>">
            </td>
        </tr>
        
        <tr>
            <td>
                TELEPHONE NUMBER/MOBILE NUMBER :
            </td>
            <td>
                <input type="text" name="Contact" size="40" value="<?php echo $Contact; ?>">
            </td>
        </tr>
        
        <tr>
            <td>
                COLOR :
            </td>
            <td>
                <input type="text" name="Color" size="40" value="<?php echo $Color; ?>">
            </td>
        </tr>
        
<tr>
<td>
NIC Attachment :<select name="NicChk">
                <option selected="" value="">(New Document?)</option>
                <option value="yes">YES</option>
                <option value="no">NO</option>
                </select>
</td>
<td>
    <input type="file" name="Nic_Img" accept="image/*">
</td>
</tr>
<tr>
<td>
Registration Certificate :  <select name="RCcheck">
                            <option selected="" value="">(New Document?)</option>
                            <option value="yes">YES</option>
                            <option value="no">NO</option>
                            </select>
</td>
<td>
    <input type="file" name="Reg_Cer" accept="image/*">
</td>
</tr>

<tr>
<td></td>
<td>
    <input align="left" type="image" src="Images/Buttons/button_search.png" alt="button" name="search" value="Search" width="110" height="50"/>
</form> 
        
 <!--if submit button and reset button in same <form> will perform the formvalidation which leads the reset button also work as a submit button(wont reset anything)-->
 
 <form action="UpdateAccount.php" method="POST"/>
    <input align="center" type="image" src="Images/Buttons/button_update.png" alt="" name="reset" value="reset" width="110" height="50"/>
</td>
</tr>

</form>
 
</table>


</th>
</table>
<br><br>

</body>
</html>

Posted 15-Jul-17 22:49pm

Member 13049972

Updated 16-Jul-17 0:46am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Answer 1 · 2017-07-15T23:05:00

Solution 1

If nothing else you have some typo...

PHP

while ($row=mysqli_fetch_array($result)) // $row here

PHP

$Nic=$raw['nic'];
$FName=$raw['fullname'];
$Address=$raw['address'];
$Contact=$raw['contact'];
$Color=$raw['color']; // and $raw here

Posted 15-Jul-17 23:05pm

Kornfeld Eliyahu Peter

v2

Comments

Member 13049972 16-Jul-17 5:09am

i changed like this too still there are error messages

Kornfeld Eliyahu Peter 16-Jul-17 5:19am

Changed what? You still using $row and $raw!!!

Member 13049972 16-Jul-17 6:12am

<?php

if(isset($_POST['search']))
{

$connect= mysqli_connect("localhost","root","1234","latgsjason");
if (mysqli_connect_error()){
echo"Failed to Connect";
}
// $result=mysqli_query($connect,"SELECT * FROM customer WHERE veh_regno='$_POST[V_Regno]'");
$Vregno = $_POST['V_Regno'];
$query="SELECT 'nic','fullname','address','contact','color' FROM customer WHERE 'veh_regno'=$Vregno LIMIT 1";
$result=mysqli_query($connect,$query);
if (!$result) {
printf("Error: %s\n", mysqli_error($connect));
exit();
}
while ($row=mysqli_fetch_array($result))
{
$VReg=$row['veh_regno'];
$Nic=$row['nic'];
$FName=$row['fullname'];
$Address=$row['address'];
$Contact=$row['contact'];
$Color=$row['color'];
}

mysqli_free_result($result);
mysqli_close($connect);
}
else
{
$VReg="";
$Nic="";
$FName="";
$Address="";
$Contact="";
$Color="";
}

?>

Member 13049972 16-Jul-17 6:12am

but now there are no any error messages but the fields are fill with messages like this

Notice: Undefined variable: VReg in C:\xampp\htdocs\LATGS\ManageAccount.php on line 73