pls solve myproblemo

jinchiruki · #1 (**permalink**) 02-12-2008, 11:22 PM

Index.php

<table width="1000" height="95" border="1">
<tr>
<td bgcolor="#0000FF"> </td>
</tr>
</table>
<p>

<center><a href="register.html">Click here for register</a><br>
<br>

<p>
<b> <html> Attend List; </b><p>
<?php

include("connect.php");

$query="SELECT * FROM rsvp ";
$result=mysql_query($query);
$num = mysql_num_rows ($result);
mysql_close();

if ($num > 0 )

{
$i=0;
while ($i < $num)

{
$name = mysql_result($result,$i,"name");
$email = mysql_result($result,$i,"email");
$contact = mysql_result($result,$i,"contact");
$person_attend = mysql_result($result,$i,"person_attend");
$comment = mysql_result($result,$i,"comment");
$id = mysql_result($result,$i,"id");

echo "<b>Name:</b> $name<br>";
echo "<b>Email:</b> $email<br>";
echo "<b>Contact:</b> $contact<br>";
echo "<b>Person attend:</b> $person_attend<br>";
echo "<b>Comment:</b> $comment<br>";

echo "<br><br>";

++$i; }

} else { echo "No one yet register"; }
?>
</center>

register.html

<table width="1000" height="95" border="1">
<tr>
<td bgcolor="#0000FF"> </td>
</tr>
</table>

<html>
<center>
<head>
<title></title>

</head>
<body>
<form id="FormName" action="added.php" method="post" name="FormName">

<table width="416" height="386" border="0" cellpadding="2" cellspacing="2">
<tr>
<td width="145" height="26" align="right">Name</td>

<td width="257"><input id="name" name="name" type="text" size="25" value="" maxlength="50" /></td>
</tr>
<tr></tr>
<tr>
<td align="right">Email</td>
<td><input id="email" name="email" type="text" size="25" value="" maxlength="50"></td>
</tr>

<tr>
<td align="right">Phone</td>
<td><input id="contact" name="contact" type="int" size="25" value="" maxlength="10"></td>
</tr>
<tr>
<td align="right">Person attend</td>
<td><textarea id="person_attend" name="person_attend" rows="4" cols="40"></textarea></td>
</tr>
<tr>
<td align="right">Comment</td>
<td><textarea id="comment" name="comment" rows="4" cols="40">
</textarea></td>
</tr>
<tr>

<td> </td>
</tr>
<tr>
<td align="right"></td>
<td><p>
<input type="submit" value="Submit">
<INPUT name="RESET" TYPE="RESET" VALUE="Reset">

</tr>
</table>
</form>

<P> </P>
</body>
</center>
</html>

added.php

<table width="1000" height="95" border="1">
<tr>
<td bgcolor="#0000FF"> </td>
</tr>
</table>

<?
include("connect.php");

//this is your validation in the form,put it here....

if (empty($_POST['name']))

{

$errors[] = 'Please enter a name';

}

if (empty($_POST['email']))

{

$errors[] = 'Please enter an e-mail';

}

else if (!eregi("^[_a-z0-9-]+(.[_a-z0-9-]+)*@[a-z0-9-]+(.[a-z0-9-]+)*(.[a-z]{2,3})$", $_POST['email']))

{

$errors[] = 'Please enter a valid e-mail address';

}

if (empty($_POST['contact']))

{

$errors[] = 'Please enter a contact';

}

else if (!is_numeric($_POST['contact']))

{

$errors[] = 'Please enter a valid contact with a numeric value';

}

if (empty($_POST['person_attend']))

{

$errors[] = 'Please enter some word';

}

else if (strlen ($_POST['person_attend']) > 255)

{

$errors[] = '';

if (empty($_POST['comment']))

{

$errors[] = 'Please enter some comment';

}

else if (strlen ($_POST['comment']) > 255)

{

$errors[] = ' ';

if (count($errors) > 0)

{

die(echo $errors[0];

}

else

{

//process form

//this is your add query....

$name = $_POST['name'];

$email = $_POST['email'];

$contact = $_POST['contact'];

$person_attend = $_POST['person_attend'];

$comment = $_POST['comment'];

$query = "INSERT INTO rsvp (id, name, email, contact, person_attend, comment)

VALUES ('', '$name', '$email', '$contact', '$person_attend', '$comment')";

$results = mysql_query($query) or die

("Could not execute query : $query." . mysql_error());

{

echo "thanks you ";

}

mysql_close();

}

?>

<br>
<a href="Index.php">View list attend</a>

connect.php

<?php
define('DB_HOST' , 'localhost');
define('DB_NAME' , 'rsvp');
define('DB_USERNAME' , 'root');
define('DB_PASSWORD' , '');

$conn = mysql_connect(DB_HOST, DB_USERNAME )
or die(mysql_error());mysql_select_db(DB_NAME);
?>
can somebody help me fix this?

DaveSawers · #2 (**permalink**) 02-13-2008, 09:31 AM

Fix what exactly? I don't see any specific question in there.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to solve this (Include) issue in PHP	WomenXtra	Web Programming Discussion Forum	13	10-12-2006 11:37 AM
A Problem I can't solve yet	texxs	Web Programming Discussion Forum	4	01-10-2006 08:04 AM
Please Review - Help me solve my problem	jnarowski	Submit Your Site For Review	2	03-12-2005 01:14 AM
Please help to solve my Google's google	lganimys	Google Discussion Forum	5	12-19-2004 10:56 PM
www.deepblueutila.com will this solve my problem	foxy	Submit Your Site For Review	1	06-01-2004 01:27 PM