[RESOLVED] Adding select all checkboxes

[newbtophp]

Im trying to manage my user submitted content by fetching the data from mysql, below is my current code, it works fine however im trying to adjust it so I can select all since it would make life much easier:

Current Code:

<?php

include("../config.inc.php");

if($_GET['cmd'] == 'delete')
{
    $id = mysql_real_escape_string($_GET['id']);
    $sql = "DELETE FROM stealth WHERE id = $id";
    $result = mysql_query($sql) or die(mysql_error());
    if($result)
   {   

      echo "<div align=center><a href=index.php>Link Deleted - Click to Proceed<BR><BR>";
   }
   else
   {
      echo "There was an error deleting."; 
   }
}


$data = mysql_query("SELECT * FROM stealth") or die(mysql_error());
Print "<table border='1' cellpadding='3'>";
Print "<th>Url</th><th>Link</th><th>Clicks</th><th>Delete</th>";
while($info = mysql_fetch_array( $data ))
{
   Print "<tr>";
   Print "<td>http://$siteurl/get.php?i=".$info['folder_name'] . " </td>";
   Print "<td>".$info['url'] . " </td>";
   Print "<td>".$info['visits'] . "</td>";
   if(!isset($cmd))
   {
      echo "<td><a href='index.php?cmd=delete&id={$info['id']}'>Delete</a></td>";
   }
   Print "</tr>";
}
Print "</table>";
?>

Preview (Current):

This is how I'd like it too look like:

Can anyone please help?, im new to to php.

[bpat1434]

That's relatively simple. If you break it down, you have 3 sections: Header, Content List, Footer.

Your code will have to change drastically however. Here's something quick I whipped up:

<?php
/* Include the config file that is one directory above this file */
include(dirname(dirname(__FILE__)).'/config.inc.php');
?>

<style type="text/css"><!--
div.message {
	display: block;
	margin: 10px 40px;
	padding: 5px 10px;
}

div#error.message {
	background-color: #fcc;
	border: 1px solid #f00;
	color: #f00;
	font-weight: bold;
}

form table.data-grid {
	border: 1px solid #d0e0ed;
	border-collapse: collapse;
	width: 100&#37;;
}

form table.data-grid thead tr {
	background-color:#77003c;
	border: none;
}

form table.data-grid thead tr th {
	color: #fff;
	text-align: center;
}

form table.data-grid tr .input-col {
	text-align: center;
	width: 10%;
}

form table.data-grid tr .url {
	width: 40%;
}

form table.data-grid tr .link {
	width: 40%;
}

form table.data-grid tr .visits {
	width: 10%;
}

form table.data-grid tr td input[type="submit"] {
	background-color: #3893b2;
	border: 1px solid #166687;
	color: #fff;
	font-weight: bold;
}
--></style>

<?php
/* If the user has posted the form to delete multiple items */
if(isset($_POST['cmd']) && strtolower($_POST['cmd']) == 'delete' && !empty($_POST['ids']))
{
	/* Iterate over the array "cleaning" the values */
	array_walk($_POST['ids'], create_function('&$item, $key', '$item = intval($item)'));

/* Delete all the rows that were selected */
$sql = "DELETE FROM `stealth` WHERE `id` IN (".implode(', ', $_POST['ids']).")";
$result = mysql_query($sql);
if(!$result)
{
	echo '<div class="message" id="error">
		There was an error deleting the selected rows.
	</div>';
}

echo '<div class="message">
	<a href="index.php">Link Deleted - Click to Proceed</a>
</div>';
}

$data = mysql_query("SELECT * FROM `stealth`");
if(!$data)
{
	echo '<div style="background-color: #fcc; border: 1px solid #f00; color: #f00; font-weight: bold; padding: 5px 10px;">
		No data returned.
	</div>';

if(!empty(mysql_error()))
{
		echo '<div style="background-color: #fcc; border: 1px solid #f00; color: #f00; font-weight: bold; padding: 5px 10px;">
			MySQL Error (#'.mysql_errno().'): '.mysql_error().'
		</div>';
}
exit;
}

?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" id="data-grid-form">
	<table class="data-grid" cellspacing="0" cellpadding="0">
		<thead>
			<tr>
				<th class="input-col">
					<input type="checkbox" onclick="toggleAll(this);" id="checkAllBox" />
				</th>
				<th class="url">Url</th>
				<th class="link">Link</th>
				<th class="visits">Clicks</th>
			</tr>
		</thead>
		<tbody>
			<?php while($row = mysql_fetch_assoc($result): ?>
			<tr>
				<td class="input-col">
					<input type="checkbox" name="ids[]" value="<?php echo $row['id']; ?>" />
				</td>
				<td class="url">http://<?php echo $siteurl; ?>/get.php?i=<?php echo $row['folder_name']; ?></td>
				<td class="link"><?php echo $row['url']; ?></td>
				<td class="visits"><?php echo $row['visits']; ?></td>
			</tr>
			<?php endwhile; ?>
			<tr>
				<td colspan="4" style="text-align: center;">
					<input type="submit" name="cmd" value="Delete" />
				</td>
			</tr>
		</tbody>
	</table>
</form>

<script type="text/javascript"><!-- // --><![CDATA[
function toggleAll(input)
{
	// Will the inputs be checked or not?
	var checked = input.checked;

var form = document.getElementById('data-grid-form');
if(form.elements.length)
{
	for(var i=0; i<form.elements.length; i++)
	{
		var input = form.elements[i];

		if(input.type == 'checkbox')
		{
			input.checked = checked;
		}
	}
}
}
// ]]></script>

Hope that helps.

[newbtophp]

bpat1434;10918384 wrote:

That's relatively simple. If you break it down, you have 3 sections: Header, Content List, Footer.

Your code will have to change drastically however. Here's something quick I whipped up:

<?php
/* Include the config file that is one directory above this file */
include(dirname(dirname(__FILE__)).'/config.inc.php');
?>

<style type="text/css"><!--
div.message {
	display: block;
	margin: 10px 40px;
	padding: 5px 10px;
}

div#error.message {
	background-color: #fcc;
	border: 1px solid #f00;
	color: #f00;
	font-weight: bold;
}

form table.data-grid {
	border: 1px solid #d0e0ed;
	border-collapse: collapse;
	width: 100%;
}

form table.data-grid thead tr {
	background-color:#77003c;
	border: none;
}

form table.data-grid thead tr th {
	color: #fff;
	text-align: center;
}

form table.data-grid tr .input-col {
	text-align: center;
	width: 10%;
}

form table.data-grid tr .url {
	width: 40%;
}

form table.data-grid tr .link {
	width: 40%;
}

form table.data-grid tr .visits {
	width: 10%;
}

form table.data-grid tr td input[type="submit"] {
	background-color: #3893b2;
	border: 1px solid #166687;
	color: #fff;
	font-weight: bold;
}
--></style>

<?php
/* If the user has posted the form to delete multiple items */
if(isset($_POST['cmd']) && strtolower($_POST['cmd']) == 'delete' && !empty($_POST['ids']))
{
	/* Iterate over the array "cleaning" the values */
	array_walk($_POST['ids'], create_function('&$item, $key', '$item = intval($item)'));

/* Delete all the rows that were selected */
$sql = "DELETE FROM `stealth` WHERE `id` IN (".implode(', ', $_POST['ids']).")";
$result = mysql_query($sql);
if(!$result)
{
	echo '<div class="message" id="error">
		There was an error deleting the selected rows.
	</div>';
}

echo '<div class="message">
	<a href="index.php">Link Deleted - Click to Proceed</a>
</div>';
}

$data = mysql_query("SELECT * FROM `stealth`");
if(!$data)
{
	echo '<div style="background-color: #fcc; border: 1px solid #f00; color: #f00; font-weight: bold; padding: 5px 10px;">
		No data returned.
	</div>';

if(!empty(mysql_error()))
{
		echo '<div style="background-color: #fcc; border: 1px solid #f00; color: #f00; font-weight: bold; padding: 5px 10px;">
			MySQL Error (#'.mysql_errno().'): '.mysql_error().'
		</div>';
}
exit;
}

?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" id="data-grid-form">
	<table class="data-grid" cellspacing="0" cellpadding="0">
		<thead>
			<tr>
				<th class="input-col">
					<input type="checkbox" onclick="toggleAll(this);" id="checkAllBox" />
				</th>
				<th class="url">Url</th>
				<th class="link">Link</th>
				<th class="visits">Clicks</th>
			</tr>
		</thead>
		<tbody>
			<?php while($row = mysql_fetch_assoc($result): ?>
			<tr>
				<td class="input-col">
					<input type="checkbox" name="ids[]" value="<?php echo $row['id']; ?>" />
				</td>
				<td class="url">http://<?php echo $siteurl; ?>/get.php?i=<?php echo $row['folder_name']; ?></td>
				<td class="link"><?php echo $row['url']; ?></td>
				<td class="visits"><?php echo $row['visits']; ?></td>
			</tr>
			<?php endwhile; ?>
			<tr>
				<td colspan="4" style="text-align: center;">
					<input type="submit" name="cmd" value="Delete" />
				</td>
			</tr>
		</tbody>
	</table>
</form>

<script type="text/javascript"><!-- // --><![CDATA[
function toggleAll(input)
{
	// Will the inputs be checked or not?
	var checked = input.checked;

var form = document.getElementById('data-grid-form');
if(form.elements.length)
{
	for(var i=0; i<form.elements.length; i++)
	{
		var input = form.elements[i];

		if(input.type == 'checkbox')
		{
			input.checked = checked;
		}
	}
}
}
// ]]></script>

Hope that helps.

Thanks for the code but i tested it and it shows and error:

Fatal error: Can't use function return value in write context in /home/linknew/public_html/admin2/edit.php on line 90[code]

[Weedpacket]

That's this line:

    if(!empty(mysql_error())) 

As you'll find by looking at the page for [man]empty[/man] it only works on variables. The test isn't needed though.

if(mysql_error())

would be enough. mysql_errno() would be more appropriate, though.

[newbtophp]

Thanks, this is the updated code, it gives an error:

"Parse error: syntax error, unexpected ':' in /home/linknew/public_html/admin2/edit.php on line 113"

<?php
/* Include the config file that is one directory above this file */
include(dirname(dirname(__FILE__)).'/config.inc.php');
?>

<style type="text/css"><!--
div.message {
    display: block;
    margin: 10px 40px;
    padding: 5px 10px;
}

div#error.message {
    background-color: #fcc;
    border: 1px solid #f00;
    color: #f00;
    font-weight: bold;
}

form table.data-grid {
    border: 1px solid #d0e0ed;
    border-collapse: collapse;
    width: 100%;
}

form table.data-grid thead tr {
    background-color:#77003c;
    border: none;
}

form table.data-grid thead tr th {
    color: #fff;
    text-align: center;
}

form table.data-grid tr .input-col {
    text-align: center;
    width: 10%;
}

form table.data-grid tr .url {
    width: 40%;
}

form table.data-grid tr .link {
    width: 40%;
}

form table.data-grid tr .visits {
    width: 10%;
}

form table.data-grid tr td input[type="submit"] {
    background-color: #3893b2;
    border: 1px solid #166687;
    color: #fff;
    font-weight: bold;
}
--></style>

<?php
/* If the user has posted the form to delete multiple items */
if(isset($_POST['cmd']) && strtolower($_POST['cmd']) == 'delete' && !empty($_POST['ids']))
{
    /* Iterate over the array "cleaning" the values */
    array_walk($_POST['ids'], create_function('&$item, $key', '$item = intval($item)'));

/* Delete all the rows that were selected */
$sql = "DELETE FROM `stealth` WHERE `id` IN (".implode(', ', $_POST['ids']).")";
$result = mysql_query($sql);
if(!$result)
{
    echo '<div class="message" id="error">
        There was an error deleting the selected rows.
    </div>';
}

echo '<div class="message">
    <a href="index.php">Link Deleted - Click to Proceed</a>
</div>';
}

$data = mysql_query("SELECT * FROM `stealth`");
if(!$data)
{
    echo '<div style="background-color: #fcc; border: 1px solid #f00; color: #f00; font-weight: bold; padding: 5px 10px;">
        No data returned.
    </div>';

if(mysql_error())
{ 
            echo '<div style="background-color: #fcc; border: 1px solid #f00; color: #f00; font-weight: bold; padding: 5px 10px;">
                MySQL Error (#'.mysql_errno().'): '.mysql_error().'
            </div>';
    }
    exit;
}

?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" id="data-grid-form">
    <table class="data-grid" cellspacing="0" cellpadding="0">
        <thead>
            <tr>
                <th class="input-col">
                    <input type="checkbox" onclick="toggleAll(this);" id="checkAllBox" />
                </th>
                <th class="url">Url</th>
                <th class="link">Link</th>
                <th class="visits">Clicks</th>
            </tr>
        </thead>
        <tbody>
            <?php while($row = mysql_fetch_assoc($result): ?>
            <tr>
                <td class="input-col">
                    <input type="checkbox" name="ids[]" value="<?php echo $row['id']; ?>" />
                </td>
                <td class="url">http://<?php echo $siteurl; ?>/get.php?i=<?php echo $row['folder_name']; ?></td>
                <td class="link"><?php echo $row['url']; ?></td>
                <td class="visits"><?php echo $row['visits']; ?></td>
            </tr>
            <?php endwhile; ?>
            <tr>
                <td colspan="4" style="text-align: center;">
                    <input type="submit" name="cmd" value="Delete" />
                </td>
            </tr>
        </tbody>
    </table>
</form>

<script type="text/javascript"><!-- // --><![CDATA[
function toggleAll(input)
{
    // Will the inputs be checked or not?
    var checked = input.checked;

var form = document.getElementById('data-grid-form');
if(form.elements.length)
{
    for(var i=0; i<form.elements.length; i++)
    {
        var input = form.elements[i];

        if(input.type == 'checkbox')
        {
            input.checked = checked;
        }
    }
}
}
// ]]></script>

[bpat1434]

Missing a closing parenthesis on this line:

<?php while($row = mysql_fetch_assoc($result): ?>

It should be:

<?php while($row = mysql_fetch_assoc($result)): ?>

[newbtophp]

Thanks I added that, and the table displays but without the data within the sql it also returns with an error saying:

"Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/linknew/public_html/admin2/edit.php on line 113"

Heres a screenshot: http://i39.tinypic.com/35lvryq.jpg

I tried removing the error myself by replacing line 113 with:

<?php 
if($result and !is_bool($result)) {
$row = mysql_fetch_assoc($result);
}
?> 

The error removed but the content from the sql still didnt display. (so I left the code back to the original which you provided.)

Can you please tell me how to fix this

[bradgrafelman]

You're using $result in your while() loop, but the variable you stored the MySQL resource in was called $data from above.

[newbtophp]

Thanks, everything works great except, when i delete a link.

It shows two errors:

"Parse error: syntax error, unexpected '}' in /home/linknew/public_html/admin2/edit.php(66) : runtime-created function on line 1

Warning: array_walk() [function.array-walk]: Wrong syntax for function name in /home/linknew/public_html/admin2/edit.php on line 66 "

[bradgrafelman]

Try adding a semicolon after the intval() statement inside the second parameter of the create_function() function call.

[newbtophp]

That returns with:

"Parse error: syntax error, unexpected '(' in /home/linknew/public_html/admin2/edit.php on line 66"

[bradgrafelman]

Copy and paste line 66 so we can see what it looks like now.

[newbtophp]

The original was this (which displayed and functioned fine, accept when i deleted a link it whould show 2 errors refering to line 66):

    array_walk($_POST['ids'], create_function('&$item, $key', '$item = intval($item)'));

"Parse error: syntax error, unexpected '}' in /home/linknew/public_html/admin2/edit.php(66) : runtime-created function on line 1

Warning: array_walk() [function.array-walk]: Wrong syntax for function name in /home/linknew/public_html/admin2/edit.php on line 66 "

---

Now, it looks like this (i added a semicolon as you suggested, but now the whole thing dont display it gives a syntax error):

    array_walk($_POST['ids'], create_function('&$item, $key', '$item = intval'($item)'));

"Parse error: syntax error, unexpected '(' in /home/linknew/public_html/admin2/edit.php on line 66"

[bradgrafelman]

Er, you didn't add a semicolon... you added a single quote. And it's in the wrong spot, too.

This parameter:

'$item = intval($item)'

gets evaluated as regular PHP code. As such, you need to end the intval() statement with a semicolon, just like you would anywhere else in the PHP script.

[newbtophp]

lol sorry, fixed, dont know what i was thinking.

'$item = intval($item);'));

Thanks for the help!.