select and insert

pneudralics

I'm new and need a little help. I've been reading php.net but still kind of lost. This is what I want to do..I have two database (maindb and seconddb). I want to transfer the username from maindb to seconddb. How would I do that? I understand it's just selecting the maindb and insert it in the seconddb. I just don't understand how to write the syntax. Do I have to do a mysql connect also? What goes into: mysql_query("INSERT INTO mytable (product) values ('kossu')");?
I'm trying to do a phpbb integrate with my site. If my site's password is not encrypted, will that cause any issues transfering it to phpbb's password since phpbb is encrypted.

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
mysql_select_db('maindb');

mysql_query("INSERT INTO mytable (product) values ('kossu')");
printf("Last inserted record has id %d\n", mysql_insert_id());
?>

jmrouleau

You should have two different database connections and select the values from one and insert into the other.

You will have a problem with passwords for sure...since the current ones aren't encrypted and phpbb does encrypt you will have to figure out what method of encryption it uses (I think it is md5) and apply it to the old password after you select it from the database. Then insert the encrypted value into the new database.

I hope this is clear.

MarkR

You should not use more than one database if you can possibly avoid it. It just complicates things without any actual gain.

Bear in mind that a single database can have as many tables as you like. Although if you need to integrate two apps which use the same table names, you may have to use separate DBs.

If your MySQL user has appropriate permissions, you can access tables from several different databases in the same connection, or even the same queries (e.g. with a join).

Mark

pneudralics

Thanks for the help.

Houdini

phpBB uses md5 e.g.

$sql = "UPDATE " . USERS_TABLE . "
SET user_newpasswd = '" . md5($user_password) . "', user_actkey = '$user_actkey'

WHERE user_id = " . $row['user_id'];