displaying check box inside row query

[ddtpmyra]

Hi below is my script displaying all the information inside the table.

Pupose:
pupose of this php page is to display all the information on my table and have a check box at the last column that will allow the user to approved the member.

Problem:
I don't how to insert a checkbox on a loop condition.

<?php
# Connect to the database
$dbLink = mysql_connect("xxx.xxx.xx.x", "xxx", "xxx")
or die("Error! Failed to connect to the MySQL server!");
mysql_select_db("databasename", $dbLink)
or die("Error! Failed to select a database!");
 
# Query for a list of all existing files
$result = mysql_query("SELECT name, age, approved FROM table1");
 
# Check if it was successfull
if($result)
{
# Make sure there are some files in there
if(mysql_num_rows($result) == 0) {
    echo "<p>There are no files in the database</p>";
}
else
{
    # Print the top of a table or header
    echo "<table width='100%'><tr>";
    echo "<td><b>Name</b></td>";
    echo "<td><b>Age</b></td>";
    echo "<td><b>Click the box to approved</b></td>";        
 
    # Print each data
    while($row = mysql_fetch_assoc($result))
    {
        # Print file info
        echo "<tr border=10><td>". $row['name']. "</td>";
        echo "<td>". $row['age']. "</td>";
        #how could I add a check box here?
        echo "</tr>";
    }
 
    # Close table
    echo "</table>";
}
}
else
{
echo "Error! SQL query failed:";
echo "<pre>". mysql_error($dbLink) ."</pre>";
}
 
# Close the mysql connection
mysql_close($dbLink) ;
?>

[pbmods]

Heya, ddtpmyra.

Please use CODE tags when posting source code:

[CODE=php]
PHP code goes here.
[/CODE]

Thanks for your time.

pbmods

[ddtpmyra]

anybody can help?

All I need is to insert a text box inside the row

[maheswaran]

could you explain little bit brief.... Why u can't add the checkbox in to loop.....

[ddtpmyra]

Hi maheswaran,

Below again is the script I placed 'comment #' where i wanted to insert a check box. The code will be used for displaying the list of documents coming from mysql database.

Placing the checkbox inside the loop will allow the admin to approved it by checking the texbox and I'm having trouble of placing the check box inside the loop while displaying the records.

[PHP]{

# Print the top of a table LABELINGS
echo "<table width='100%'><tr>";
echo "<td><b>Created</b></td>";
echo "<td><b>File Name</b></td>";
echo "<td><b>Requestor</b></td>";
echo "<td><b>Author</b></td>";
echo "<td><b>Deadline Feedback</b></td>";
echo "<td><b>Approved</b></td>";
echo "<td><b>Category</b></td>";
echo "<td><b>Click the box to approved</b></td>"; echo "<td><b>&nbsp;</b></td>";
echo "</tr>";

# #Print each file
while($row = mysql_fetch_assoc($result))
{

# Print file info FROM THE MYSQL TABLE
echo "<td>". $row['Created']. "</td>";
echo "<tr border=10><td>". $row['FileName']. "</td>";
echo "<td>". $row['Created']. "</td>";
echo "<td>". $row['Requestor']. "</td>";
echo "<td>". $row['Author']. "</td>";
echo "<td>". $row['DeadLineFeedback']. "</td>";
echo "<td>". $row['approved']. "</td>";
echo "<td>". $row['category']. "</td>";

#THIS IS WHERE WHERE I WANTED TO PUT THE CHECK BOX echo "<td><input type="text"></td>";
#Print download link
echo "<td><a href='get_file.php?id=". $row['FileID'] ."'>Download";
echo "</tr>";
}[/PHP]

[maheswaran]

Hey could said where u can face the problems..?

Am not facing any problem in ur code (i changed some thing see)

<?
 
#
# Print the top of a table LABELINGS
#
                            echo "<table width='100%'><tr>";
#
                            echo "<td><b>Created</b></td>";
#
                            echo "<td><b>File Name</b></td>";
#
                            echo "<td><b>Requestor</b></td>";
#
                            echo "<td><b>Author</b></td>";
#
                            echo "<td><b>Deadline Feedback</b></td>";
#
                            echo "<td><b>Approved</b></td>";
#
                            echo "<td><b>Category</b></td>";                           
#
    echo "<td><b>Click the box to approved</b></td>";                           echo "<td><b>&nbsp;</b></td>";
#
                            echo "</tr>";
#
         $res="select * from app";
         $result=mysql_query($res);
#
                            # #Print each file
#                            
                            $i=0;
                            while($row = mysql_fetch_assoc($result))
#
                            {
#
                           $i++;
#
# Print file info FROM THE MYSQL TABLE
#
                                echo "<tr border=10><td>". $row['Created']. "</td>";
#
                                echo "<td>". $row['File Name']. "</td>";
#
 
#
                                echo "<td>". $row['Requestor']. "</td>";
#
                                echo "<td>". $row['Author']. "</td>";
#
                                echo "<td>". $row['Deadline Feedback']. "</td>";
#
                                echo "<td>". $row['Approved']. "</td>";
#
                                echo "<td>". $row['Category']. "</td>";
                                echo "<td><input type=\"checkbox\" name=\"chkid_$i\"></td>";
#
 
#
 #THIS IS WHERE WHERE I WANTED TO PUT THE CHECK BOX        echo "<td><input type="text"></td>";
#
                                #Print download link
#
                                echo "<td><a href='get_file.php?id=". $row['FileID'] ."'>Download";
#
                                echo "</tr>";
#
                            }
                            ?>
 

[ddtpmyra]

Hey Maheswaran it works thanks a ton... its the syntax all a long :)

[ddtpmyra]

maheswaran,

How can I update mysql table when the box are checked?

thanks!

[maheswaran]

for that am incresed the checkbox name with $i

<input type=\"checkbox\" name=\"chkid_$i\">
 

Just you make the loop for number of rows or count. We knew the total number of records, so pass the this count and do it like

(for xample i=5)

for($j=0;$j<$i;$j++)
{
$chkid=$_POST['$chkid'_$j'];
$qry="update qry";
$res=mysql($qry,$db);
}

[ddtpmyra]

maheswaran
please tell me what's wrong with my update it's not working

[PHP]
<?php

# Connect to the database
$dbLink = mysql_connect("localhost", "xxx", "xxx")
or die("Error! Failed to connect to the MySQL server!");
mysql_select_db("cmr", $dbLink)
or die("Error! Failed to select a database!");



# Gather all required data
$i=5;
for($j=0;$j<$i;$j++)
{
$chkid=$_POST['$chkid'_$j'];
$qry="update filestorage set Approved='Y'";
$res=mysql($qry,$db);
}

?>
[/PHP]


and what if I don't know exactly how many the $i is since the user will add data and delete data daily?

thanks!

[maheswaran]

Hey myra,

Just for an example am giving $i=5; just you count the number of rows in ur table and place that one (.i.e $i=$count_rows)..and sorry i mistakenly added $_POST['$chkid'_$j'] instead of $_POST['chkid'_$j'] and change the mysql connection string.. see below... may its help...

                     $i=$count_rows;
                        for($j=0;$j<$i;$j++)
                        {
                        $chkid=$_POST['chkid'_$j'];
                        $qry="update filestorage set Approved='Y'";
                        $res=mysql_query($qry);
                        }  
 

[ddtpmyra]

Hi maheswaran... i'ts still not updating my table please help if I missing a link here.

Step 1 Displaying the row data
[PHP]
<form action='approvals_file3.php' method='post'>
<?php


# Connect to the database
$dbLink = mysql_connect("localhost", "xxx", "xxx")
or die("Error! Failed to connect to the MySQL server!");
mysql_select_db("cmr", $dbLink)
or die("Error! Failed to select a database!");

# Query
$result = mysql_query("SELECT filebaname, approved from filestorage");


# Print the top of a table
echo "<td><b>filename</b></td>";
echo "<td><b>aproved</b></td>";


# Print each file
while($row = mysql_fetch_assoc($result))
{
# Print file info
echo "<tr border=10><td>". $row['filename']. "</td>";
echo "<td><input type=\"checkbox\" name=\"chkid_$i\"></td>";
}


# Close the mysql connection
mysql_close($dbLink);

?>
<input type='submit' value='Submit'>
</form>
[/PHP]

Step 2 Updating the row data

[PHP]
<?php

# Connect to the database
$dbLink = mysql_connect("localhost", "xxx", "xxx")
or die("Error! Failed to connect to the MySQL server!");
mysql_select_db("cmr", $dbLink)
or die("Error! Failed to select a database!");

$i=$count_rows;
for($j=0;$j<$i;$j++)
{
$chkid=$_POST['chkid'_$j'];
$qry="update filestorage set Approved='Y'";
$res=mysql_query($qry);
}

# Close the mysql connection
mysql_close($dbLink);
?>
[/PHP]

[ddtpmyra]

This update my table but it updates all the records.
Little more help on this.. how can I update the only checked ones?

[PHP] $i=10;
for($j=0;$j<$i;$j++)
{
$chkid=$_POST['chkid_$j'];
$qry="update filestorage set Approved='Y'";
$res=mysql_query($qry);
}


[/PHP]

[maheswaran]

just add where conditions in that

[johndavid19]

Try this

 while($row = mysql_fetch_assoc($result))
    {
        # Print file info
        echo "<tr border=10><td>". $row['name']. "</td>";
        echo "<td>". $row['age']. "</td>";
        echo"<input type='checkbox' name='check' name='value' id='check'>";
        echo "</tr>";
    }