helpppp

[bigray]

ok i dont have mysql installed but my ftp supports it so do i really need mysql setup on my comp because i want to make a shoutbox and it wont work

that create table thing says error in browser n stuff so wut do i do

CREATE TABLE shoutbox (
id INT(11) NOT NULL AUTO_INCREMENT,
message TEXT NOT NULL,
author VARCHAR(80) NOT NULL,
email VARCHAR(50) NOT NULL,
date VARCHAR(50) NOT NULL,
ip VARCHAR(20) NOT NULL ,
PRIMARY KEY (id))

Now lets get on with the script !

<?php
// You just need to configure these 4 variables to match your server.
$db_host = "localhost"; // mySQL database host
$db_user = "username"; // mySQL database user
$db_password = "password"; // mySQL database password
$db_name = "database"; // the name of your mySQL database
// If a user has submitted a post, we want to :
// 1. Validate it
// 2. Strip unwanted html
// 3. Make sure messages and names aren't too long
// 4. Add it to our database.
if($POST['submit']) {
// 1. Validate it, by checking all the form inputs were filled in
if(!$POST['author']) {
echo 'Error ! : No name entered';
die;
}
if(!$POST['email']) {
echo 'Error ! : No email entered';
die;
}
if(!$POST['message']) {
echo 'Error ! : No message entered';
die;
}
// 2. Strip unwanted HTML
// Look up the strip_tags() function at
// http://www.php.net/manual/en/function.strip-tags.php for more info
$message = strip_tags($POST['message'], '');
$email = strip_tags($POST['email'], '');
$author = strip_tags($POST['author'], '');
// 3. Make sure messages and names aren't too long
// We will use the strlen() function to count the length.
$message_length = strlen($message);
$author_length = strlen($author);
if($message_length > 150) {
echo "Error ! : Your message was too long, messages must be less than 150 chars";
die;
}
if($author_length > 150) {
echo "Error ! : Your name was too long, names must be less than 150 chars";
die;
}
// 4. Add it to our database.
// If the script hasn't died yet due to an error in the inputted data
// we need to add the data to the database
// Lets connect to our database.
mysql_connect($db_host,$db_user,$db_password) or die(mysql_error());
// Select the database.
mysql_select_db($db_name) or die(mysql_error());
// Lets define the date format we want to enter to our database
// go here for more details
// http://www.php.net/manual/en/function.date.php
$date = date("h:i A dS M");
// This will produce 11:02 25th Aug
// Set the query as $query
$query = "INSERT INTO shoutbox (message, author, email, date, ip)
VALUES ('$message','$author','$email','$date','$SERVER[REMOTE_ADDR]')";
mysql_query($query);
mysql_close();
// Show thanks message and take them back to the main shoutbox
echo "Thanks for your post<BR>";
echo "<A HREF=\"shoutbox.php\">View the shoutbox</A>";
// If they haven't submitted a post, we want to :
// 1. Show the latest shouts
// 2. Show the shout post form
} else {
// 1. Show the latest shouts
// Lets connect to our database.
mysql_connect($db_host,$db_user,$db_password) or die(mysql_error());
// Select the database.
mysql_select_db($db_name) or die(mysql_error());
// Set the query as $query, and get the last 10 posts.
$query = "SELECT message, author, email, date, ip
FROM shoutbox order by id DESC LIMIT 10";
$result = mysql_query($query);
echo "<TABLE>";
while($r=mysql_fetch_array($result))

{
// To modify the appearance, edit this :
echo "<TR>
<TD><font size='1'>
Posted $r[date] by <A HREF=\"mailto:$r[email]\">
$r[author]</A></font></TD>
</TR>
<TR>
<TD><font size='1'>$r[message]</font></TD>
</TR>
<TR>
<TD><HR></TD>
</TR>";

}
echo "</TABLE>";

// 2. Show the shout post form
?>
<FORM METHOD=POST ACTION="shoutbox.php">
<TABLE>
<TR>
<TD>Name :</TD>
<TD><INPUT TYPE="text" NAME="author"></TD>
</TR>
<TR>
<TD>Email :</TD>
<TD><INPUT TYPE="text" NAME="email"></TD>
</TR>
<TR>
<TD>Message :</TD>
<TD><INPUT TYPE="text" NAME="message"></TD>
</TR>
<TR>
<TD>&nbsp;</TD>
<TD><INPUT TYPE="submit" name="submit" value="post"></TD>
</TR>
</TABLE>
</FORM>
<?php
}
?>

[wilzy]

One thing at a time 🙂

1 - What is it you are trying to make?

2 - What error did you get (ie: line # etc... show me that line and some around it)

[bigray]

CREATE TABLE shoutbox (
id int(11) NOT NULL auto_increment,
name text NOT NULL,
message longtext NOT NULL,
time text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

<?
mysql_pconnect("216.131.80.197","babesoncams","bastui8939");
mysql_select_db("news");

if($submit)
{
$time=date("h:ia d/j/y");
$result=MYSQL_QUERY("INSERT INTO shoutbox (id,name,message,time)"."VALUES ('NULL','$name', '$message','$time')");
}
?>
<?
$result = mysql_query("select * from shoutbox order by id desc limit 5");
while($r=mysql_fetch_array($result))

{
$time=$r["time"];
$id=$r["id"];
$message=$r["message"];
$name=$r["name"];
?>
<? echo $time ?><br>
<? echo $name ?><br>
<? echo $message ?><br><br>
<? } ?>
<form action="<? echo $php_self ?>" method="post">
<INPUT TYPE='TEXT' value='name' NAME='name' SIZE=30 maxlength='100'><br>
<INPUT TYPE='TEXT' value='message' NAME='message' SIZE=30 maxlength='100'>
<input type="submit" name="submit" value="submit">
</form>

and when i go to ie it says

CREATE TABLE shoutbox ( id int(11) NOT NULL auto_increment, name text NOT NULL, message longtext NOT NULL, time text NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM;
Warning: Access denied for user: 'babesoncams@216.131.80.197' (Using password: YES) in /home/httpd/babesoncams.com/html/shoutbox.php on line 10

Warning: MySQL Connection Failed: Access denied for user: 'nobody@localhost' (Using password: NO) in /home/httpd/babesoncams.com/html/shoutbox.php on line 11

Warning: MySQL: A link to the server could not be established in /home/httpd/babesoncams.com/html/shoutbox.php on line 11

Warning: MySQL Connection Failed: Access denied for user: 'nobody@localhost' (Using password: NO) in /home/httpd/babesoncams.com/html/shoutbox.php on line 20

Warning: MySQL: A link to the server could not be established in /home/httpd/babesoncams.com/html/shoutbox.php on line 20

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/babesoncams.com/html/shoutbox.php on line 21

[abda53]

a shoutbox like a tagboard?

[bigray]

yes same thing