PHP Forum

**taj79** · 07-28-2004, 07:43 AM

i want to make a dynamic website using php & mysql database ..my website is hosted on apache server

http://www.websitepublisher.net/arti...p-mysql-intro/

i tried to follow this article

this is what i did:

1) made add.html as told in Adding Data and changed its permission to 666
2) then i put the next part of the article in added.php and made the table manually ... becoz i couldn't understand where to put the code given in Getting Started

when i fill the form in add.html it gives the error written in added.php ...

second problem is that even after adding manually in the table i m unable to Returning Data

what wrong have i done?

**Republikin** · 07-28-2004, 08:53 AM

Please post the error and add.html as well as added.php

**taj79** · 02:35 AM

add.html

<html> <head>
</head>
<body>
<h2>Add Data

<form method="post" action="added.php">
Name: <input type="text" name="xname"><br>
Author: <input type="text" name="xauthor"><br>
Description: <textarea name="xdescription"></text><br>
Body Text: <textarea name="xbody"></text><br>

<input type="submit" name="add" value="SUBMIT">
</form>
</body>
</html>

added.php

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

<body bgcolor="#FFFFFF">

<?php

$connect = mysql_connect("localhost", "user name", "pass");

mysql_select_db("guruofse_db1", $connect);

if($add == "SUBMIT"){
$sql = "INSERT INTO content SET
Name='$xname',
Author='$xauthor',
Body='$xbody',
Description='$xdescription'";

if(mysql_query($sql))
{
echo "The information has been added to the database.";
}
else
{
echo "There was an error submitting the information.";
}

} // closing bracket for original IF statement
?>

</body>

</html>

have put user name & passwd

error message There was an error submitting the information.

**Republikin** · 07-29-2004, 09:15 AM

Try putting or die(mysql_query()); after each mysql function and post that error. That will help narrow it down to which thing is causing the most trouble.

**taj79** · 01:17 AM

Hi,
i couldn't understand what you suggested. Could you please explain?

also i have made a table called test inside the database ... Does added.php mention it also?

i have hosted my website in apache server with cpanel ..

**taj79** · 08-02-2004, 05:09 AM

i tried using the help of another tutorial:

http://webmonkey.wired.com/webmonkey...tw=programming

i m trying to make a php page which will use the mysql database .. and following the instructions given in this webpage ..

i have created a database and a table named employees inside it ..
i m using Cpanel.

Code:

SQL-query : [Edit] [Create PHP Code] 
CREATE TABLE `employees` ( 
`id` TINYINT( 4 ) DEFAULT '0' NOT NULL AUTO_INCREMENT , 
`first` VARCHAR( 25 ) NOT NULL , 
`last` VARCHAR( 25 ) NOT NULL , 
`address` VARCHAR( 255 ) NOT NULL , 
`position` VARCHAR( 50 ) NOT NULL , 
PRIMARY KEY ( `id` ) 
);

and inserted data manually in the table ..

Code:

Inserted rows: 1 
Inserted row id: 2 
  
SQL-query : [Edit] [Create PHP Code] 
INSERT INTO `employees` ( `id` , `first` , `last` , `address` , `position` ) 
VALUES ( 
'2', 'vxvsv ', 'ghjhk ', 'y  5u5uj tj tjtj', 'tthj' 
);

then i put the code given in webmonkey webpage in a file testemployees.php

http://www.guruofseo.com/testemployees.php

but its not showing ...

what's the mistake i have done ..? and how to correct it ..