Re: [PHP] Re: help with mysql

Tue, 27 Jan 2004 06:50:44 -0800

line 16: mysql_connect("tflood", "thomas91");

I think you mean: mysql_connect("localhost", "tflood", "thomas91");
otherwise mysql_connect takes "tflood" as Server and "thomas91" as
Username (if so, its better to replace passwords with ***** before
posting)
-> http://ch.php.net/mysql_connect

after connecting you need to choose a database, e.g.
line 17: mysql_select_db("databasename");

also make sure that the mysql-extension is installed and loaded.
to check this, create a textfile "phpinfo.php" with this content:
<?
phpinfo();
?>

check the output for information about mysql

g. tinu

Tue, 27 Jan 2004 08:51:52 -0500 Tom Flood <[EMAIL PROTECTED]>:

Thank you both, here is the entire code :

1<html>
2<head>
3<title>Untitled Document</title>
4<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
5</head>
6
7<body>
8<?php
9 $name = $_GET["name"];
10 $address = $_GET["address"];
11$city = $_GET["city"];
12print "Name is $name<br>\n";
13print "Address is $address<br>\n";
14print "City is $city<br>\n";
15
16mysql_connect("tflood", "thomas91");
17
18$result = mysql_query(
19 "insert into ephi.info
20 (name, address, city) values
21 ('$name', '$address', '$city')"
22);
23if ($result) {
24 print <<<EOT
25
26 <h1> Thank you. </h1>
27 Your signup is highly appreciated.  To show our appreciation, we will
send you something that you, in turn, will appreciate. <p>
28 Remember our motto: Once a Sinfonian, Always a Sinfonian, Long Live
Sinfonia!
29EOT;
30  }
31  else {
32   print "Something went wrong dunbass";
33  }
34  mysql_close();
35?>
36</body></html>




As far as mysql working on the machine, it is.  I am able to use the mysql
command to loginto the server and query my databases.  And I have the MySQL
Command Center installed and am able to see the databases on my computer
just fine.


Thank you for your help.

Tom

"Krit Kanrat" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi,

Are you sure that you already enable mysql function on your web server ?

Krit Kanrat

"Tom Flood" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello,
>
> I am just beginning my learning of php and its uses with mysql.  I wrote
a
> small program to add information into a mysql database. However my
script 
> returns the following error:
>
> Fatal error: Call to undefined function: mysql_connect() in
> /var/www/html/ephi/mysql.php on line 16
>
> what is the problem here? How can I fix it?
>
> I truly appreciate any help given.
>
> Tom Flood
> [EMAIL PROTECTED]


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to