PHP to mysql news system with image Content management system

debugyeh · March 21, 2007

hi everyone, really hope you can help me out,

im new to php, and mysql, however, im struggling to get this working, im trying to make the news articles appear with images, however my first problem was getting an image uploaded, i'll worry about getting it to display later. here is my cms-addarticle.php

thanks very much in advance

<html>

<head>

<title>Add An Article</title>

<!--

.box {

font-family: Arial, Helvetica, sans-serif;

font-size: 12px;

border: 1px solid #000000;

}

-->

</style>

</head>

<body>

<?php

if(isset($_POST['save']))

{

$title = $_POST['title'];

$content = $_POST['content'];

$fileName = $_FILES['userfile']['name'];

$tmpName = $_FILES['userfile']['tmp_name'];

$fileSize = $_FILES['userfile']['size'];

$fileType = $_FILES['userfile']['type'];

$fp = fopen($tmpName, 'r');

$content1 = fread($fp, $fileSize);

$content1 = addslashes($content);

fclose($fp);

if(!get_magic_quotes_gpc())

{

$title = addslashes($title);

$content = addslashes($content);

$fileName = addslashes($fileName);

}

include 'library/config.php';

include 'library/opendb.php';

$query = "INSERT INTO news (title, content, name, size, type, content1 ) VALUES ('$title', '$content' '$fileName', '$fileSize', '$fileType', '$content1')";

mysql_query($query) or die('Error ,query failed');

include 'library/closedb.php';

echo "Article '$title' added";

}

?>

<tr>

<td width="100">Title</td>

</tr>

<tr>

<td width="100">Content</td>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

<tr>

</td>

</tr>

</table>

</form>

</body>

</html>

i keep getting an error, "error, query failed", which is because the data wont go in the database, but i cant see why. thanks

Alan Hamlyn

Sign In

PHP to mysql news system with image Content management system

Recommended Posts

debugyeh

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information