[PHP/mySQL] Question

[Trigs]

When selecting a database using mysql_select_db(), can you use the function more than once and still retain the previous database selection? For example, can I do:

mysql_select_db('abc');
mysql_select_db('def');

Would that select both databases or would it select abc then select def?

[Protege]

I believe you would need two instances of a mysql connection active in order to connect to two databases simultaneously.

[Fehm]

Ya know what i'd do, have 2 config files and have

include ('config.php');
include ('config2.php');

Lol
Dunn of it would work though

[Agnostic Bear]

When selecting a database using mysql_select_db(), can you use the function more than once and still retain the previous database selection? For example, can I do:

mysql_select_db('abc');
mysql_select_db('def');

Would that select both databases or would it select abc then select def?

abc then def, if you wanted only 1 mysql connection, you could do it with a bit of overhead, you have 2 functions, i.e "mysql_select_2" "mysql_select_1" and you put this in each:



mysql_query('USE `databasename`');
then run the query.

[Trigs]

So wouldn't I just be better off doing something like:

mysql_query('USE db1 SELECT * blah blah blah');
and
mysql_query('USE db2 SELECT * blah blah blah');

[Agnostic Bear]

So wouldn't I just be better off doing something like:

mysql_query('USE db1 SELECT * blah blah blah');
and
mysql_query('USE db2 SELECT * blah blah blah');

No, however you can simply omit the mysql_select_db and do this:

SELECT * FROM `databasename`.`tablename`

[Trigs]

Thats much better. Thanks.

[Trigs]

Also, 2 more questions.

1. I created a function. Heres the code:


function clean($str) {
if(!get_magic_quotes_gpc()){
$str = addslashes($str);
}
$str = strip_tags(htmlspecialchars($str));
return $str;
}

Thats in config.php. If I include index.php and call that function I get an error saying that I can't redeclare it. I've never gotten that error before and all the other functions I created work.

And lets say I have these files

-MainFolder
--config.php
-SecondaryFolder
--index.php

How should I include config.php into index.php? Should I spell out the whole url?

[Trinity]

And lets say I have these files

-MainFolder
--config.php
-SecondaryFolder
--index.php

How should I include config.php into index.php? Should I spell out the whole url?



include '../config.php';

[Trigs]

tried that already. didnt work. maybe theres something in php.ini or apache's settings?

[Excellent2]

tried that already. didnt work. maybe theres something in php.ini or apache's settings?You tried just 1 dot?

[Trigs]

You posted 2 dots?

[Excellent2]

You posted 2 dots?That was Trinity :P

[Trigs]

Oh lol. So is it 1 or 2 dots?

[Excellent2]

Oh lol. So is it 1 or 2 dots?Try include './config.php'; to see if it works :)

[GeekSRV]

Maybe Try:



<?php
define('DOCUMENT_ROOT', '/path/to/directory');
include(DOCUMENT_ROOT."/config.php");
?>


Remember to edit path to directory :)

[Trigs]

BTW, I'm actually using require();

and thanks guys, ill see

[Blinger1]

Can't you just use include

[GeekSRV]

BTW, I'm actually using require();

and thanks guys, ill see

Just change include to require - and if using require use require_once() - Unless you require it more than once :)

[Agnostic Bear]

You are all very silly and should learn to read:



require_once '../MainFolderName/config.php';

[Sameer!]

Lol Jewish Bear got you there! He's the one that posted the correcdt code for it.

[Trigs]

Jewish Bear's code worked. Thanks once again.

Is there anyways to resend header info? I need a way to set cookie info if a user has checked a remember me box but I can't because I can't find a way to do it without getting the headers already sent error.

[Trinity]

Jewish Bear's code worked. Thanks once again.

Is there anyways to resend header info? I need a way to set cookie info if a user has checked a remember me box but I can't because I can't find a way to do it without getting the headers already sent error.

Make sure there's no output before you attempt to send headers.

[Dentafrice]

Jewish Bear's code worked. Thanks once again.

Is there anyways to resend header info? I need a way to set cookie info if a user has checked a remember me box but I can't because I can't find a way to do it without getting the headers already sent error.
Headers don't work like that.
Post your entire code, that gives you the headers already sent error.

[Trigs]

It's pretty much something like:

<?php

session_start();

if($_POST['rememberme']) {
setcookie(blah blah blah)
}

?>

[Dentafrice]

Well there has to be output before that, or it wouldn't give you that error.

[Trigs]

Yeah there is.

[Dentafrice]

Well that's what I want to see.. you can't have that outputting before you set it..

[Trigs]

Well then how would I set the cookie? How do other sites use a remember me feature?

[Dentafrice]

Well then how would I set the cookie? How do other sites use a remember me feature?
They don't output before they set it maybe?

[Trigs]

Nevermind. It's pretty unsafe anyways.

[Dentafrice]

No it's not.. not if you do it correctly.

What makes you think it is "unsafe"?

[Trigs]

I've never used cookies before. If I do it, it will be unsafe because I don't know how to make it secure. I was planning on storing the username and password in the cookie because that's the only way I knew how to do it.

[Protege]

I've never used cookies before. If I do it, it will be unsafe because I don't know how to make it secure. I was planning on storing the username and password in the cookie because that's the only way I knew how to do it.
*slaps*