PDA

View Full Version : can someone tell me wahts wrong with this code

sytodave88
08-10-2005, 11:35 AM
<?
require ("config.php");
?>

<html>
<head>
<title>vNews Content Administration</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#eaeaea" text="#000000">

<?
$connection = mysql_connect($dbhost, $dbusername, $dbpassword);
?>

<form name="News" method="post" action="">

<?
// Add / Edit news
if ($Submit == "Add")
{
$news = nl2br($news);

// Time offsetting
$adjusted = $hrdiff * 60 * 60;

if ($ahead=="+")
{
$Add = mysql_db_query ($dbname, "INSERT INTO newscontent VALUES ('',trim('$news'),DATE_ADD(NOW(), INTERVAL '$adjusted' SECOND))");
}
else
{
$Add = mysql_db_query ($dbname, "INSERT INTO newscontent VALUES ('',trim('$news'),DATE_SUB(NOW(), INTERVAL '$adjusted' SECOND))");
}

$action="";
}
elseif ($Submit == "Modify")
{
$news = nl2br($news);
$Update = mysql_db_query ($dbname, "UPDATE newscontent SET news=trim('$news') WHERE id='$id'");
$action = "";
}

// Delete News
if ($action=="delete")
{
$Delete = mysql_db_query($dbname, "DELETE FROM newscontent WHERE id='$id'");
}

// Show specific news
if ($id != "")
{
// Show selected news
$Show = mysql_db_query($dbname, "SELECT * FROM newscontent WHERE id='$id'");
$ShowRow = mysql_fetch_array($Show);
$ShowNews = strip_tags($ShowRow["news"]);
mysql_free_result($Show);
}

// Show all news
$result = mysql_db_query($dbname, "SELECT * FROM newscontent ORDER BY id DESC");
$row = mysql_fetch_array($result);
?>

<table width="97%" border="1" cellspacing="2" cellpadding="0" align="center" bordercolor="#000000">
<tr bgcolor="#eaeaea">
<td colspan="2">
<div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="4" color="#000000">News
Content Administration</font></div> </td>
</tr>
<tr valign="middle">
<td width="11%" bgcolor="#eaeaea"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">News</font></td>
<td width="89%">
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<?
print "<textarea name=\"news\" cols=\"45\" rows=\"12\" wrap=\"VIRTUAL\">";
if ($action=="edit")
{
print trim($ShowNews);
}
print "</textarea>";
?>
</font>
</td>
</tr>
<tr valign="middle">
<td colspan="2">
<div align="center">
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">

<?
if ($action!="edit")
{
print "<input type=\"submit\" name=\"Submit\" value=\"Add\">";
}
else
{
print "<input type=\"submit\" name=\"Submit\" value=\"Modify\">";
}
?>

<input type="reset" name="Reset" value="Reset">
</font></div>
</td>
</tr>
</table>
</form>
<table width="97%" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#000000">
<tr bgcolor="#999999" valign="top">
<td width="5%" bgcolor="#eaeaea">
<div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><b>ID</b></font></div> </td>
<td width="60%" bgcolor="#eaeaea">
<div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><b>News</b></font></div> </td>
<td width="26%" bgcolor="#eaeaea">
<div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><b>Date/Time</b></font></div> </td>
<td width="9%" bgcolor="#eaeaea">
<div align="center"><font face="Verdana, Arial, Helvetica, sans-serif"><b><font color="#000000" size="2">Action</font></b></font></div> </td>
</tr>
<?
while ($id=$row["id"])
{
$id = $row["id"];
$news = $row["news"];
$date = date("n-j-Y g:i A", strtotime($row["event"]));


print "<tr valign=\"middle\">";
print " <td width=\"5%\">";
print " <div align=\"center\"><font size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\">";
print " $id</font></div>";
print " </td>";
print " <td width=\"60%\"><font size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\">";
print " $news</font></td>";
print " <td width=\"26%\">";
print " <div align=\"center\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">";
print " $date</font></div>";
print " </td>";
print " <td width=\"9%\">";
print " <div align=\"center\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\">";
print " <a href=\"newscontent.php?id=$id&action=edit\"><img border=\"0\" src=\"edit.gif\" width=\"15\" height=\"15\" alt=\"Modify news\"></a>&nbsp;";
print " <a href=\"newscontent.php?id=$id&action=delete\"><img border=\"0\" src=\"delete.gif\" width=\"15\" height=\"15\" alt=\"Delete news\"></a></font></div>";
print " </td>";
print "</tr>";

$row = mysql_fetch_array($result);

}
mysql_free_result ($result);
?>

</table>
<p>&nbsp;</p>
<table width="97%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<div align="right"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><a href="newsadmin.php">Home</a>
| <a href="newsdesign.php">Design Administration</a></font></div>
</td>
</tr>
</table>
<p>&nbsp;</p>
</body>
</html>
Acid
08-10-2005, 11:40 AM
Not read through it all yet but spotted this straight away:

mysql_db_queryThat function is deprecated as of php version 4.0.6, so use this instead:

mysql_query
NancyJ
08-10-2005, 01:07 PM
it might help if you tell us what we're looking for ;)

IE. what it should do, what it does do and any error messages you get.
donsipe
08-10-2005, 01:20 PM
I believe you are missing: mysql_select_db()It looks like you've connected to the MySQL server but have yet to tell MySQL which database on the server you want to query.