i'd like to modify this blog php mysql script , so that i could upload multi media
i'd like to modify this blog php mysql script ( in the uploaded .zip) , so that i can upload video files , image files & embedded YouTube vids. it currently only supports text. if anyone could point me in the right direction i'd greatly appreciate it.
Last edited by VictoryHawk; 05-23-2012 at 10:22 AM .
You would certainly get more response if you just paste the specific PHP code here. I would like to help but downloading files other than txt files make me nervous. Just a friendly suggestion.
homepage.php
Code:
<?php error_reporting (E_ALL ^ E_NOTICE); ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0014)about
Code:
<?php
require('connect.php');
$comment=$_POST['comment'];
$submit=$_POST['submit'];
if($submit)
{
if($comment)
{
$query=mysql_query("INSERT INTO comment (id,comment) VALUES ('','$comment')");
header("Location: success.php");
}
else
{
echo "Please fill out all the fields.";
}
}
?>
<html>
<head></head>
<body>
<form action="comment.php" method="POST">
<br /><br />
<label>Enter Data: </label><br /><textarea name="comment" cols="80" rows="1"></textarea><br/>
<input type="submit" name="submit" value="Post" />
</form>
</body>
<?php
require('connect.php');
$query=mysql_query("SELECT * FROM comment ORDER BY id DESC");
while($rows=mysql_fetch_assoc($query))
{
$id=$rows['id'];
$dcomment=$rows['comment'];
$linkdel="<a href=\"delete.php?id=" . $rows['id'] . "\">Delete Data</a>";
echo '<br />' . '<font color="#000099">Data:</font> ' . '<br />' . $dcomment . ' ' . ' ' .
' ' . ' ' . $linkdel ;
}
?>
</html>
connect.php
Code:
<?php
$connect=mysql_connect("localhost","root","") or die('mysql_error()');
$database=mysql_select_db("comment") or die('mysql_error()');
?>
Code:
<?php
require('connect.php');
$deleteid=$_GET['id'];
mysql_query("DELETE FROM comment WHERE id='$deleteid'");
header("location: success.php");
?>
Last edited by VictoryHawk; 05-24-2012 at 02:24 AM .
success.php
Code:
<?php
header("Location: homepage.php");
?>
comment.sql
Code:
CREATE TABLE IF NOT EXISTS `comment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `comment`
--
INSERT INTO `comment` (`id`, `name`, `comment`) VALUES
(1, 'hi'),
(2, 'bye');
Last edited by VictoryHawk; 05-24-2012 at 02:20 AM .
To be able to upload files via a web form you need to send the attribute enctype="multipart/form-data" in your form tag and add an <input type="file" name="myfile"> field in your form.
Last edited by holyhttp; 05-24-2012 at 02:33 AM .
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Reply With Quote
Bookmarks