Jump to content

ShoutBox Editing Help!!


FortMyersDrew

Recommended Posts

haha you are pure genius lol dude you have made my shoutbox look so website customized  ;D however i only have a few questions left

 

1. is there anyway to autofill the Name, E-mail... like it saves the ip or w/e but when they return to the page there Nickname and Email are already filled in?

Link to comment
Share on other sites

  • Replies 54
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Np that I have lol.. Another thing i wanted was like when you click the box name and you click something else the Name text that was there is gone is there and if you click all 3 the pre included text is gone is there a way to fill it back in until they type something? Also is there a way to change those boxes from plain white

Link to comment
Share on other sites

yes but first things first

 

run this Query in your PHPmyadmin and give me the name of the database you are using

 

CREATE TABLE `shout_user_log` (
`id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`username` VARCHAR( 255 ) NOT NULL ,
`email` VARCHAR( 255 ) NOT NULL ,
`ip` VARCHAR( 255 ) NOT NULL
) ENGINE = innodb;

Link to comment
Share on other sites

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/d/r/e/drewsmedia/html/doit.php on line 28

 

Warning: Cannot modify header information - headers already sent by (output started at /home/content/d/r/e/drewsmedia/html/doit.php:28) in /home/content/d/r/e/drewsmedia/html/doit.php on line 41

 

 

I got this error!

Link to comment
Share on other sites

change your doit.php with this

 

<?php
//including the database connection
include('config.php');
//getting everything that has been submitted
$name=mysql_real_escape_string(strip_tags($_POST['name']));
$mail=mysql_real_escape_string(strip_tags($_POST['mail']));
$message=mysql_real_escape_string(strip_tags($_POST['message']));
$submit=$_POST['submit'];
//get the current time with php date() function
//note that the server time will be recorded
//more info about all functions - http://php.net
$time=date("m/d/y - g:i a");
//get the ip. Note that this wont see through proxies
$ip=$_SERVER['REMOTE_ADDR'];


//just some basic error checking which
//checks if name,e-mail and message 
//hasnt been left blank or with default text
if (($name!=="") || ($name!=="Name") || ($mail!=="") || ($mail!=="E-mail") || ($message!=="") || ($message!=="Your text"))
{
//inserts data into the database
$sql = "INSERT INTO shoutbox (id, name, mail, message, time, ip) VALUES ('NULL', '$name', '$mail', '$message', '$time', '$ip')";
mysql_query($sql) or die(mysql_error());

$query = "SELECT * FROM `shout_user_log` WHERE `ip` = '$ip'";
$result = mysql_query ($query);
$num_rows = mysql_num_rows ($result);

if ($num_rows > 0) {

$query = "DELETE * FROM `shout_user_log` WHERE `ip` = '$ip'";
mysql_query ($query);

}

$query = "INSERT INTO `shout_user_log` (`id`, `username`, `email`, `ip`) VALUES ";
mysql_query ($query);

//sends the user back to the form
header("Location:".$_SERVER['HTTP_REFERER']);
}
else{
header("Location:".$_SERVER['HTTP_REFERER']);
}
?>

 

Updated version

 

Now give me your current version of "SHOUT.PHP"

Link to comment
Share on other sites

Shout.php

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<style type="text/css">
<!--
a:link {color: #CCCCCC;}
a:visited {color: #CCCCCC;}
a:active {color: #CCCCCC;}
.shout{
padding-bottom:4px;
border-bottom:1px solid #000;
width:180px;
text-align:left;
font-family: Arial, Helvetica, sans-serif;
font-size: 11px;
background-color:#262727
color:#525757;
font-weight: bold
}
-->
</style>
<title>Shoutbox</title>
</head>
<body>
<?php
include('config.php');
$result = mysql_query("select * from shoutbox order by id desc limit 10");

//the while loop
while($r=mysql_fetch_array($result))
{      
  //getting each variable from the table
  $time=$r["time"];
  $id=$r["id"];
  $message=$r["message"];
  $name=$r["name"];
    $mail=$r['mail'];

echo "<div class='shout'>
   <font color=#525757>Shouted on: <i>".$time."</i><br>
   <font color=#CCCCCC>By: <b><a href='mailto:".$mail."'>".$name."</b></a><br><font color=#525757>
   ".$message."<br>
  </div><br>";
} ?>
</body>
</html>

Link to comment
Share on other sites

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>Shoutbox</title>
</head>
<body>
<?php 

include 'shouts.php'; 

$query = "SELECT * FROM `shout_user_log` WHERE `ip` = '$ip'";
$result = mysql_query ($query);

$user_info = mysql_fetch_array ($result);

if (!$user_info[id]){

$name = "Name";
$email = "E-mail";

} else {

$name = $user_info['username'];
$email = $user_info['email'];

}

?>
<form method="post" action="doit.php">
<input type='text' name='name' value='<?php echo $name; ?>' onfocus='this.value=""'><br>
<input type='text' name='mail' value='<?php echo $email; ?>' onfocus='this.value=""'><br>
<textarea name='message' onfocus='this.value=""' rows='3' cols='20'>Your Text Here</textarea>
<br>
<input type='submit' value='submit' name='submit'>
</form>
</body>
</html>

 

Change your Form.php to this

Link to comment
Share on other sites

Don't have either

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>Shoutbox</title>
</head>
<body>
<?php 

include 'shouts.php'; 

$query = "SELECT * FROM `shout_user_log` WHERE `ip` = '$ip'";
$result = mysql_query ($query);

$user_info = mysql_fetch_array ($result);

if (!$user_info['id']){

$name = "Name";
$email = "E-mail";

} else {

$name = $user_info['username'];
$email = $user_info['email'];

}

?>
<form method="post" action="doit.php">
<input type='text' name='name' value='<?php echo $name; ?>' onfocus='this.value=""'><br>
<input type='text' name='mail' value='<?php echo $email; ?>' onfocus='this.value=""'><br>
<textarea name='message' onfocus='this.value=""' rows='3' cols='20'>Your Text Here</textarea>
<br>
<input type='submit' value='submit' name='submit'>
</form>
</body>
</html>

 

try altering it to that

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.