Virtual Airlines Using Export Flight

[Iberiaorbit]

READ THIS
How can I access my database through PHP?You can create any custom PHP scripts to access your database. Below are a few lines of
PHP code that show you how to access your database:

<?php
$link = mysql_connect("mysql", "USERNAME", "PASSWORD");
mysql_select_db("DATABASE");

$query = "SELECT * FROM TABLE";
$result = mysql_query($query);

while ($line = mysql_fetch_array($result))
{
foreach ($line as $value)
{
print "$value\n";
}
}

mysql_close($link);
?>



Please note that you must replace USERNAME and PASSWORD with the user name and password that you have created for your
database. You must also replace TABLE and DATABASE with the valid table and database names from your database. The address of
the MySQL database server is just "mysql" -- a port number is not necessary.

SO I SHOULD use mysql instead of localhost?

[eazy]

Iberiaorbit wrote:
#database
$cfg['mysql_server']='localhost';
$cfg['database']='IberiaOrbitAirSpace';
$cfg['user']='bossorwhatever';
$cfg['passwordbase']='keywordsuchnsuch';

I have got the message:
Not connected
to localhost server
Database:

mySql error:
Access denied for user: 'IberiaOrbitAirSpace@localhost' (Using password: YES)

Are you sure, your settings.php looks like the one above?!? Because then the error message should look like this:
Not connected
to localhost server
Database: IberiaOrbitAirSpace

mySql error:
Access denied for user: 'bossorwhatever@localhost' (Using password: YES)

So it seems you didn't enter a database name at all and "IberiaOrbitAirSpace" as user name...

Iberiaorbit wrote: SO I SHOULD use mysql instead of localhost?

NO, it's just an example. "localhost" seems to be ok with your server, otherwise the error message would probably be:

mySql error:
Can't connect to MySQL server on 'localhost' (10061)

or

mySql error:
Unknown MySQL server host 'localhost' (11001)

Note: "localhost" is only a placeholder for the server's IP address if (and ONLY then) the database is installed on the same machine as the
webserver+php. There's no such placeholder as "mysql".

[DanSteph]

perhaps you may have a look to some php tutorial ?

Dan

[Iberiaorbit]

Yes, eazy, my setting.php is this
#general
$cfg['DebugTestonLocalHost']=true;
$cfg['databaselocalhostl']='IberiaOrbitAirSpace';

#database
$cfg['mysql_server']='localhost';
$cfg['database']='IberiaOrbitAirSpace';
$cfg['user']='blablabla';
$cfg['passwordbase']='suchsuchsuch';

#administration
if(defined("FSP_ADMIN"))
{
$cfg['admin_user']='blablbabla';
$cfg['admin_pass']='suchsuchsuch';
And I am sorry I had a mistake in common.php, I put the table name instead the user name, that's why the message 'mySql error:
Access denied for user: 'IberiaOrbitAirSpace@localhost' (Using password: YES)'

Now all I get is:
Not connected
to localhost server
Database:

mySql error:
No Database Selected
Hah, even though you see above this lines I am using IberiaOrbitAirSpace as database.
I really feel I am pushing too much on your patience, and I am sorry, so don't feel bad if you decide to ignore me, I will understand, I am
just trying to make it work here, for I love this program. But why now it says no db selected is beyond me... Cheers eazy, cheers Dan.

[eazy]

But why now it says no db selected is beyond me...

... and me! You're sure there IS a database running? (just a silly question)

Try this:
Make a file called "test.php" or whatever with the following content

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('no connection: ' . mysql_error());
} else {
echo 'connection ok';
$db_selected = mysql_select_db('database_name', $link);
if (!$db_selected) {
die ('database error: ' . mysql_error());
}
}
mysql_close($link);
?>

and run it on your server. (Make sure to replace "mysql_user", "mysql_password" and "database_name" with your own values).
If you get an error message, post it here.

BTW: you won't be ignored - as long as I have any idea, I'll try to

[Iberiaorbit]

ok, one question, probably a stupid one, where I put it? anywhere in my server? and what do you mean by run it? just openit?

[Iberiaorbit]

http://iberiaorbitvirtualairlines.com/db/test.php=no connection: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)



Post Edited ( 08-10-05 23:37 )

[eazy]

At least something. Seems to be a socket problem with localhost (which, as far as I know, happens on some Linux systems). You could
still try to put the server's IP (if you know it) instead of "localhost". If that doesn't work either it's time to call your ISP, I think.

[Iberiaorbit]

I just added PHPNUKE to my site. Also I will try to figure out about their IP, thanks eazy, you have really tried, consider yourself an Iberia
Orbit friend and member of honor of our airline (whenever we start working). Free tickets for ya to all destinations .

[pegase]

Hello,

I just could do this job today
http://www.nedap.fr/pegase/FsPlistflight.php

Seems to work so far.


About the server name, localhost works ONLY if your PHP server and MySQL database are ON THE SAME COMPUTER. If they are on different machines
you must either use the IP adress or the machine name. If all is hosted by your ISP., they should be able to give you the machine name/IP address.

Second thing to sort out will be the database name.

Either they give you the right to create a database or just use a predefined database (usually having your name)

let us know about this.

[DanSteph]

pegase wrote:
About the server name, localhost works ONLY if your PHP server and MySQL database are ON THE SAME COMPUTER. If they are on
different machines

Ther is no rules in this domain many provider give also localhost as server..
the only valid tips : ASK YOUR PROVIDER FOR THOSE DATA....

Iberiaorbit Give me admin access and the DB data as provided by you provider by mail
and I can help you (I have *some* spare time) (well some hours)

Dan

[Iberiaorbit]

I think mysql is the database that manages all the others. So I shouldn't mess with that one and I am able to create my own databases
with tables and all what it takes up to a limit I gues of 4 Gigas, or 4kMb, something like that. Not sure. But yes I can create my own
databases, that is for sure.
Also there is several places where I read to use mysql as server name no IP necesary, and localhost wouldn't work. I think Dan got a
back plan that right now is my main hope.
And Pegase, good job, you are able to do it, something so easy for you and so desired and unreacheable for me.

[DanSteph]

Sorry, I tried but yahoo just suck... change host and all will work.

Dan

[Iberiaorbit]

So you blame it on my host? and everything else I have done it's ok? Good Heavens I am paying 40 bucks a month!!!

[Iberiaorbit]

And, please advise me a good host.