checkbox frontpage

n_baswa

Hello,

I've a form that adds data to the mysql database. It is working perfect. Now i want to add a checkbox in that....so that if it is checked then the record will be displayed in the homepage otherwise it shouldn't be displayed in the home page. I don't know how to do it. Pls help.

Here is the code:

<?php
include('dbconn.php');

?>

<html>
<head>
</head>
<body>

<script language="Javascript">
function checkForm(form1)
{

if(form1.headline.value=="")
{
alert("Please enter Headline!!");
form1.headline.focus();
return(false);
}
if(form1.date.value=="")
{
alert("Please enter Date!!");
form1.date.focus();
return(false);
}
}
</script>

<form name="form1" action="adddb.php" method="POST" onSubmit="return checkForm(this)">

<table border='0'>
<tr>
<td>
Headline* : <br>
<input type="text" name="headline" value="<?php print($headline);?>" />
</td>
</tr>

<tr>
<td>
Date: <br>
<input type="text" name="date" value="<?php print($date);?>" />
</td>
</tr>

<tr>
<td>
Content: <br>
<TEXTAREA name="body" class="body"><?php print($body);?></TEXTAREA></td>
</td>
</tr>

</table>

<input type="checkbox" name="frontpage" value="1" checked/>Display on Front Page
<br>
<br>
<input type="submit" value="Add" id="submit" name="submit" />

</form>

</body>
</html>

<?php
include('dbconn.php');

function es($val) {
    return mysql_real_escape_string($val);
}

$sql = sprintf("INSERT INTO newsevents(headline,date,body)
VALUES
('$_POST[headline]','$_POST[date]','$_POST[body]')");
if (!mysql_query($sql,$con))
		{
			 die('Error: ' . mysql_error());
		}
?>

<?php
include('dbconn.php');

$sql = "SELECT * FROM newsevents";

if (!mysql_query($sql,$con))
{
 die('Error: ' . mysql_error());
}

echo "Click on the titles below to update News/Event details.";
echo "<br/>";
echo "<br/>";

$result = mysql_query("SELECT * FROM newsevents");

$num=mysql_num_rows($result);

mysql_close();

$i=0;
while ($i < $num) {

$news_id=mysql_result($result,$i,"news_id");
$headline=mysql_result($result,$i,"headline");
$date=mysql_result($result,$i,"date");
$body=mysql_result($result,$i,"body");

echo "<b><a href=\"edit.php?news_id=$news_id\">$headline</a> $date<br><br>";


$i++;
}

echo "Total No. of News Items = $num";

if(!$result)
{
	echo "No data.";
}
mysql_free_result($result);

echo "<br>";
echo "<br>";

echo "<a href=\"add.php\">Add News Item";

?>

abc123

You will need a column in your mysql table that will record whether the check box was ticked or not. Could give it a value of 1 for ticked and 0 if not.

Then when you run the select query on the homepage you simple include a WHERE clause that only selects the rows where it has a 1 for being selected.

n_baswa

Hi abc123,

I understood the method u told me, but i'm not able to write the code for the checkbox and put the if condition for value=1 or 0.

How will it automatically take the value as 1 if it checked....pls let me know...

n_baswa

can anyone pls explain this to me....

thanks

tams

ok so to create a check box

echo "<input type='checkbox'
                    name='checked[1]' value='1'>1\n";

]

and then when you select you write,

$query="SELECT * FROM table WHERE checked='1' ";

I hope that helps

n_baswa

i've added the code here....

<input type="checkbox" name="frontpage[]" value="1" />Display on Front Page
<br>
<br>
<input type="submit" value="Add" id="submit" name="submit" />

</form>

and....

echo "Click on the titles below to update News/Event details.";
echo "<br/>";
echo "<br/>";
echo "$frontpage";

$result = mysql_query("SELECT * FROM newsevents where frontpage=1");

$num=mysql_num_rows($result);

mysql_close();

$i=0;
while ($i < $num) {

$news_id=mysql_result($result,$i,"news_id");
$headline=mysql_result($result,$i,"headline");
$date=mysql_result($result,$i,"date");
$body=mysql_result($result,$i,"body");
//$frontpage=mysql_result($result,$i,"frontpage");

echo "<b><a href=\"news_edit.php?news_id=$news_id\">$headline</a> $date<br><br>";

$i++;
}

These codes r adding the records into the database, but they r not displayed if frontpage=1 on the home page.....they do not display any records in the frontpage....

abc123

Try this:

$result = mysql_query("SELECT * FROM newsevents where frontpage LIKE '1'") or die(mysql_error());

Failing that check out the mysql manual for the proper syntax for a where clause.

If there is a problem with the query then you should at least get an error with it.

n_baswa

even this is not wrkng. and thr is no error. the data is inserted into the database, but it doesn't show up in the frontpage.

Do we need to have a field in the database for frontpage? I tried using that also, but it doesn't work.

n_baswa

Hello.....anyone thr to help me with this issue?