Need Help with HTML, PHP, and MySQL creating a web-base database!

babak_khoramdin

I am new and trying to learn HTML, PHP, and MySQL to develop my own interactive database website. I am using the Intranet on my own computer to put my codes into the test. I am experiencing a problem when I try my HTML page to insert some data into the MySQL database serve. When I click on the “submit” I get a window saying that I am starting to save my PHP file rather than executing the PHP file which is used to send the data to the MySQL. I should also mention that my entire codes are in C:\Inetpub\wwwroot\MyWeb folder.

Here are the codes:

HTML Code

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



<head>
<title>Add a Phonebook Entry</title>
</head>
<body>
<h1>Add a Phonebook Entry</h1>
<form method="POST" action="example.8-2.php">
<table>
<tr>
<td>Surname:
<td><input type="text" name="surname" size=50>
</tr>
<tr>
<td>First name:
<td><input type="text" name="firstname" size=50>
</tr>
<tr>
<td>Phone number:
<td><input type="text" name="phone" size=20>
</tr>
</table>
<br><input type="submit">
</form>
</body>
</html>

PHP Code (example.8-2.php)

<?
// Assign database server information to variables.

$username="XXXX";
$password="XXXXXXX";
$database="telephone";

$surname=$POST['surname'];
$firstname=$POST['firstname'];
$phone=$_POST['phone'];

mysql_connect('localhost',$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO phonebook VALUES
(
'NULL',
'$surname',
'$firstname',
'$phone',
)";

mysql_query($query);

mysql_close();

babak_khoramdin

Here are the codes:

HTML Code

PHP Code (example.8-2.php)

<?
// Assign database server information to variables.

$username="XXXX";
$password="XXXXXXX";
$database="telephone";

$surname=$POST['surname'];
$firstname=$POST['firstname'];
$phone=$_POST['phone'];

mysql_connect('localhost',$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO phonebook VALUES
(
'NULL',
'$surname',
'$firstname',
'$phone',
)";

mysql_query($query);

mysql_close();

halojoy

hello,
babak_K

forget about MxSQL or any other complicated outside php, external programs
it is yesterdays stuff

today more and more people find php internal database and file storing functions
are the ways to go

PHP do not need MxSQL
PHP can do without MxSQL
but
can
MxSQL do without PHP ???

that is the question

halojoy does quite alright using Flat File Data Storage methods
trusting in PHP Functions
completely!

🙂
not that many is smart enough and knows whats going on enough
to follow a good advice
I think
🙂

halojoy - free of SQL problems - you can bet on it ........

thorpe

forget about MxSQL or any other complicated outside php, external programs
it is yesterdays stuff

you may like the idea of not using a database for whatever reason, but you seem completely misguided. dont try and push your opinions onto other people, especially people new to the concepts. databases are made for storing data, its that simple.

now, babak_khoramdin, i assume you have installed php?

halojoy

I am not pushing more
than anybody else

even beginners needs to know there are very good alternatives
WITHIN PHP and php is what this site is about

halojoy - doesnt get pushed by the MySQL promotion people from mysql.com
he walks the pure PHP way

🙂

Kudose

If you want to be successful outside of your own projects, learn and use a form of SQL. The rest of the world does. It is a good thing to learn internal storage methods, but if you want to work for or with a team you should know SQL.

bastien

is the webserver you have on your machine configured to use php? doesn't sound like it...

what is the machine OS? webserver?

babak_khoramdin

Dear Halojoy,

I am sure there are many other ways that this can be achieved and I am grateful for your information. But my question stays the same since I am just using my free time to learn something and in time when I have a better knowledge I am sure that I will make the right decision about choosing the database management. Right now I am stuck with problem and your help would be appreciated immensely.

Hello Thorpe,

I have installed PHP5 and MySQL and I have tested both of them and they run perfectly and smoothly. I have noticed when I change the extension of my HTML file (the first file in my posting) from HTML to PHP there is no problem and the file that I have my Form Tag in, sends the parameters (surename, firstname, phone) to the PHP file (the second file called example.8-2.php in my posting). The PHP file (example.8-2.php) establishes the connection and inserts the data into the MySQL with no problem. The problem arises when the extension of the first file is HTML.

I am under impression that my HTML file has be with HTML extension since that is going to be my welcoming page! On the other hand, it has no PHP script in it and I don’t see why it should be saved with a PHP extension file.

Thank you for your time,

thorpe

you should be able to use the html extension for your form page, as you stated there is no php in it. it could also be a php extension without any problems though. this is an odd problem and is normally caused by people trying to run php code without php installed, but as youve said, it is installed and working.

how are you accessing this page? via a browser? something like...

http://localhost/form.html

babak_khoramdin

Hello Thorpe,

Base on your question “how are you accessing this page?” I noticed something interesting. These are my finding base on different way of accessing the the file with extensions of HTML and PHP.

Accessing the file with HTML extension:

If I access the HTML file (index1.html) using the browser; the browser cannot display the page and the message I am getting is: The page cannot be displayed.

http://localhost/MyWeb/index1.html (The page cannot be displayed)

But if I simply double click on the HTML file that is going to open the file using the browser with no problem. Although the address that I am getting in the address field of the browser is different!

C:\Inetpub\wwwroot\MyWeb\index1.html (The page is displayed with no problem)

Accessing the file with PHP extension:

If I access the PHP file (index2.php) using the browser; the browser opens and displays my page but it is unable to show the images in the page and they are left out.

http://localhost/MyWeb/index2.php (page is opened with missing images)

Double clicking of the PHP file (index2.php) opens the notepad with the codes init (This is the only thing which makes sense! :o)...)

I should also let you know that my entire files THML, PHP, and Images are in the same folder.

C:\Inetpub\wwwroot\MyWeb

Thank you for you time

babak_khoramdin

Hello bastien,

Base on the question “how are you accessing this page?” I noticed something interesting. These are my finding base on different way of accessing the file with extensions of HTML and PHP.

Accessing the file with HTML extension:

If I access the HTML file (index1.html) using the browser; the browser cannot display the page and the message I am getting is: The page cannot be displayed.

http://localhost/MyWeb/index1.html (The page cannot be displayed)

C:\Inetpub\wwwroot\MyWeb\index1.html (The page is displayed with no problem)

Accessing the file with PHP extension:

If I access the PHP file (index2.php) using the browser; the browser opens and displays my page but it is unable to show the images in the page and they are left out.

http://localhost/MyWeb/index2.php (page is opened with missing images)

Double clicking of the PHP file (index2.php) opens the notepad with the codes init (This is the only thing which makes sense! 😃)

I should also let you know that my entire files THML, PHP, and Images are in the same folder.

C:\Inetpub\wwwroot\MyWeb

Thank you for you time