how to create and store in multiple database?

[zgkhoo]

how to create and store in multiple database?

 

eg..when detect the user's input is  male then store into a male's database

while if  female then store into a female's database

 

how to write a control of store different type of group into different db?

thanks..

[~n[EO]n~]

Create a variable for a database and check it in if..else condition

 

if ($male) 
{
$sLocalDatabaseName = "male_db";
} 
else 
{
$sLocalDatabaseName = "female_db";
}

 

and after that you need to define your connection

$conn = mysql_connect($sLocalHost,$sLocalUser,$sLocalPassword);
$db=mysql_select_db($sLocalDatabaseName);

 

 

By the way, you can do this using 2 tables. No need of multiple DB.

[thryb]

You dont really want to use multiple DB for that, juste use 2 different Table

Tbl_Male

Tbl_Female

store in there.

[thryb]

Or that but why would you want to use 2 DB ?

[zgkhoo]

cos the data that input will be huge..for this two group.

i afraid one db with two huge table will over the total limit

so i decided two or more db for different group ...

am i rite?

thanks..

 

[teng84]

its all about normalization again.....

if you dont know how to normalize then you need more than 2 DB joke!

[zgkhoo]

n~ link=topic=167981.msg740495#msg740495 date=1195227370]

Create a variable for a database and check it in if..else condition

 

if ($male) 
{
$sLocalDatabaseName = "male_db";
} 
else 
{
$sLocalDatabaseName = "female_db";
}

 

and after that you need to define your connection

$conn = mysql_connect($sLocalHost,$sLocalUser,$sLocalPassword);
$db=mysql_select_db($sLocalDatabaseName);

 

 

By the way, you can do this using 2 tables. No need of multiple DB.

 

then how to switch between two or more tables?

 

[~n[EO]n~]

Are you really using more that 1 database. It will be a headache later... Same thing can be achieved through 1 database with two tables for male and female.

[fenway]

n~ link=topic=167981.msg741358#msg741358 date=1195376146]

Are you really using more that 1 database. It will be a headache later... Same thing can be achieved through 1 database with two tables for male and female.

You're talking about vertical partitioning... that's an advanced technique.

[zgkhoo]

nope....changed to multiple table instead of multiple db. already...

 

how to list out all table name in my db?

i need compare with my record...if $gender==$tablename then...store....into $tablename

how?

thanks in advance

[fenway]

SHOW TABLES will get you the listing... the other question you have is a php issue.

[zgkhoo]

SHOW TABLE sample code pls..

thanks..

[fenway]

SHOW TABLE sample code pls..

thanks..

That is the sample code... and it's TABLES.  I suggest you take a closer look at the refmac.

[Hooker]

Can i ask one thing, how different are the structures for the "Male" and "Female" tables.

[zgkhoo]

no different..cos i wanna backup each male/female in different db/table

[fenway]

no different..cos i wanna backup each male/female in different db/table

I don't think you do.