[RESOLVED] Writing to a database

SpecialFX

I am trying to write to a database i created and for some reason Nothing happens I am just looking at a blank page, no echo, no anything.

Here is my script

<?php

$title = $POST['title'];
$blog = $POST['blog'];
$date = date('Y m d');

if (!$title || !$blog)
{
echo 'You have not entered all required details';
exit;
}

$title = addslashes($title);
$blog = addslashes($blog);
$date = doubleval($date);

require ('dbconnect.php');

$query = "insert into blognews values
('$title', '$blog', '$date')";
$result = $db->query($query);
if ($result){
echo 'Your blog entry $title, has been posted on $date';

}
$db->close();

bradgrafelman

Ok, so perhaps there is a DB error occuring.

Add an else statement into the if($result) statement and echo the errors reported by the DB.

SpecialFX

I added the else, but i dont know how to make it echo all errors

bradgrafelman

Well, I'm assuming you're using the [man]MySQLi[/man] extension, so perhaps the [man]mysqli_error/man function might shed some light on things.

ClarkF1

$query = "insert into blognews values
('$title', '$blog', '$date')";

You've left the column names out. Insert queries are of the form:

"insert into blognews field1, field2, field3 values ('$value1', '$value2', '$value3')";

This puts $value1 into field1 etc.........

SpecialFX

Hmm made the changes, still nothing

<?php
mysqli_error();

$title = $POST['title'];
$blog = $POST['blog'];
$date = date('Y m d');

if (!$title || !$blog)
{
echo 'You have not entered all required details';
exit;
}

$title = addslashes($title);
$blog = addslashes($blog);
$date = doubleval($date);

require ('dbconnect.php');

$query = "insert into blognews title, blog, date values('$title', '$blog', '$date')";
$result = $db->query($query);
else if ($result){
echo 'Your blog entry $title, has been posted on $date';

}
$db->close();
?>

scoppc

how about this:

<?php
$title = $_POST['title'];
$blog = $_POST['blog'];
$date = date('Y m d');

if (!$title || !$blog)
{
echo '<p>You have not entered all required details</p>';
exit;
}

$title = addslashes($title);
$blog = addslashes($blog);
$date = doubleval($date);

require ('dbconnect.php');

$query = "insert into blognews values ('$title', '$blog', '$date')";
$result = $db->query($query);
if ($result){
echo 'Your blog entry <b>$title</b>, has been posted on <i>$date</i>';
}else{
echo mysqli_error();
}
$db->close();
?>

laserlight

More like:

<?php
if (!empty($_POST['title']) && !empty($_POST['blog']))
{
	require 'dbconnect.php';

$date = date('Y m d');
$title = $db->real_escape_string($_POST['title']);
$blog = $db->real_escape_string($_POST['blog']);

$query = "INSERT INTO blognews (title, blog, `date`) VALUES ('$title', '$blog', '$date')";
if ($db->query($query))
{
	echo 'Your blog entry <b>' . $title . '</b>, has been posted on <i>' . $date . '</i>';
}
else
{
	echo $db->error();
}
$db->close();
}
else
{
	exit('<p>You have not entered all required details</p>');
}
?>

Note that I am guessing that backticks (`) should be used to escape identifiers. You may need to use the more standard double quotes or brackets, i.e.,

$query = "INSERT INTO blognews (title, blog, \"date\") VALUES ('$title', '$blog', '$date')";

$query = "INSERT INTO blognews (title, blog, [date]) VALUES ('$title', '$blog', '$date')";

SpecialFX

none of the three i can get to work, www.fallenskydesigns.com/blog/blogupdate.htm if you go there type in and hit submit it doesnt do anything it goes to the blank white php page.

ClarkF1

Could you post the code for dbconnect.php, the problem might be in there.

SpecialFX

dbconnect.php

<?
$host = "localhost";
$db = "Blog";
$dbuser = "user";
$dbpass = "pass";

////////// CONNECT TO THE DATABASE //////////////
$connect = mysql_connect($host, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($db, $connect) or die(mysql_error());
/////////////////////////////////////////////////
?>

Houdini

Could it be these short tags?

<?
$host = "localhost";
$db = "Blog";
$dbuser = "user";
$dbpass = "pass";

////////// CONNECT TO THE DATABASE //////////////
$connect = mysql_connect($host, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($db, $connect) or die(mysql_error());
/////////////////////////////////////////////////
?>

maybe try using <?php to start your PHP code instead of <?

SpecialFX

hmm even if i put <?php in still nothing happens.

ClarkF1

I think it's because you're referring to $db using the OOP class style functions, but it's not defined as a class in your db connection file.

You need to connect to the database using the following MySQL class function:

$db = new MySQL('hostname', 'user', 'password', 'dbname');

More info can be found here: http://www.sitepoint.com/article/object-oriented-php

SpecialFX

hmm well I think the problem maybe that PHP 4 is the edition that my host has and I believe Object Oriented things were added with 5? So anyother way I could do this?

ClarkF1

It's in PHP 4.........the manual page is dated 2003

SpecialFX

hmm I have no idea then what to do

Houdini

Like this;

require ('dbconnect.php');

$query = "insert into blognews title, blog, date values('$title', '$blog', '$date')";
$result = mysql_query($query);
else if ($result){
echo 'Your blog entry <b>$title</b>, has been posted on <i>$date</i>';

}
//and
mysql_close();

SpecialFX

Alright that doesn't work as well

SpecialFX

So I tried to write some code to retrieve the data and this is what i have

<?php
require ('dbconnect.php');
$row_count = 0; 
$query = "SELECT title, date, blog FROM blognews";  

$myresult = mysql_query($query) or die(mysql_error());
echo "<tr align='left' valign='top' bgcolor='$row_color'>
while($row = mysql_fetch_array($myresult)){
   $darkcolor = "#EEEEEE"; 
   $lightcolor = "#FFFFFF"; 
   $row_color = ($row_count % 2) ? $darkcolor : $lightcolor;
   $row_count++;   

	echo "<tr>"; 
	echo $row['title'];
	echo "</tr><tr>"; 
	echo $row['date'];
	echo "</tr><tr>"; 
	echo $row['blog'];
	echo "</tr>"; 
} 
echo "</table>";
?>

but it doesnt work anyone understand why?