php &amp; MySQL

php & MySQL

Anon

I have php page named (welcome.php) it consist of the following code:

when I use my browser nothing displayed. (I typed: http:\localhost\welcome.php )

how can I test this code.

and where must I save this page .

thanks for your help.

rulian

first, make sure you have php correctly installed on your server, try this code to see if the php works;

<?php
phpinfo();
?>
you should have the page saved somewhere inside your web server's directory, anywhere else and your page will appear blank.

if php is correctly installed, it should give you a detailed information table of how php is running on your server. Also, this may have nothing to do with it, but arent addresses in foward slashes? http://localhost/welcome.php

Anon

I used php with Apache server it is work

but I want to try php with MySQL.

I tried what you send but it's solve my problem.

any Idiea?

rulian

Well, from what you wrote I got the idea you want to use mysql as a web server?
Apache and mysql are completely different animals, mysql is a database server, not a web, in order to make php work with mysql you also need a web server installed, and that's were you install php. If you install php on apache, and also install mysql, then you should be fine. All you need to do in php is connect to a mysql database and you can run queries from there. is that what you meant?

Anon

Yeah but how?

I installed php on Apache it is wrok.

and Istalled MySQL . now how can I work by using Php and MySQL?

thanks for you help

rulian

okay, now all you need to do is develop your scripts to use mysql. First, make a script that i will connect to your database:
<?php
$dbhost = "localhost";
$dbuser = "MYUSERNAME";
$dbpass= "MYPASSWORD";
$ddb="MYDATABASE";

$link_id = mysql_connect($dbhost, $dbuser, $dbpass);
if (!(mysql_select_db($ddb,$link_id))) die ("connection failed");
?>

once your connected, you can use regular mysql queries inside php to define stuff, for example if you want to get the name of a user nicknamed "tony" from your users table, you would to do:

$query=mysql_query("select name from users where nickname="tony");
$name=mssql_result($query, 0, 'name');

if you echo $name, it would real tony's real name: ROBERT.

There are alot of things you can do, go to php.net and look up mysql function and see how they work.

Anon

hi,....

I installed apache on :

c:\Program Files\Apache Group

and in apache group there are subdirectory,sub subdirectory,....

apache group\apache\htdocs

I must put any php file on that subdirectory "htdocs" else will not work .

for example:

If i have "standalone.php" file consist of the following code:

<?php
$dsn = "mydb";
$user = "st";
$password = "1";
$odbcid = odbc_connect ($dsn, $user, $password, "");
if($odbcid!=false)
print "connected";
$query_string="INSERT INTO users(Id,Name) VALUES('1','mmmm');";
$resultid = odbc_do($odbcid,$query_string);
echo $resultid;
?>

I have to save this file on c:\program files\apache group\apache\htdocs

so I can test it by Internet Explorer address " http:\localhost\standalone.php "
note: I used ODBC in the control pannel to use access2000 database and "mydb" is dsn name.
until now am talking about apache. ok?

you sent the following code:

I know it is different way to connect by using MySQL ( mysql_connect() )

<?php
$dbhost = "localhost";
$dbuser = "MYUSERNAME";
$dbpass= "MYPASSWORD";
$ddb="MYDATABASE";

$link_id = mysql_connect($dbhost, $dbuser, $dbpass);
if (!(mysql_select_db($ddb,$link_id))) die ("connection failed");
?>

so If I need to do all that things by using MySQL what must I do?

I meant:

the directory of MySQL that I have to save my "standalone.php" file
how can I configure my database on MySQL (my database is Access2000 database by using ODBC ? or another way?)
where must I save my database?
If I want to use my Internet Explorer should I put "http:\localhost\standalone.php" or what I have to write?

Thats all

I hope you send your Reply in details.

thanks for your help

rulian

okay, again MYSQL is not a web server, it's a database server:
You dont have to save anything within the MYSQL directory, the only directory you have to be aware of is your server's directory, because as you know it's the only place php will work. As for mysql, it saves all it's files in the mysql/data folder, but you dont really need that because you dont save mysql files, mysql does that automatically. open up the mysql/bin/ directory and launch mysql.exe
Okay, you should see a shell window open, that's how mysql works. Unlike access, mysql must be coded manually, and linking tables is not a point and click, but rather having the same fields in different tables. Get phpmyadmin, you'll see what I'm talking about, simply put in within your server's directory and you'll get a feel for how mysql works. Once you have your database up, you can have your php files anywhere on your computer, just as long as you connect to mysql and select a database, you can access that information.