Inserting data into two databases

[PseudAnon]

$sql_=_" INSERT INTO users_table_of_2nd_Database (username,user_password,user_email) 

SELECT  $signup_username,password('$PW'),$signup_email
FROM users_table_of_1st_Database "; 

$result_=_mysql_query_($sql);

What I'm trying to do is, insert values from one table in database_1 into a table in database_2...

is this even possible? is this anywhere near close to working?
what would i replace: users_table_of_2nd_Database with?

[snoopy13]

you first have to read out the information from the first database, store it somewhere and then put it into the second database

[PseudAnon]

ummm... how?

[snoopy13]

first you make a connection to the first database

//then you make the query:
$sql=mysql_query("SELECT * FROM user");
while ($array=mysql_fetch_array($sql)){

//connection to second db

....
//insert the values you've just read out of the first one
$sql=myql_query("INSERT INTO table (user, x,..) VALUES ( '$array[user]', '$array[x]', ....")
}

I haven't tried this, but hope it works. else come back

[PseudAnon]

//connection to first database
$db = mysql_pconnect('localhost', username, password){
	mysql_select_db(firstdbname, $db);}


//reading the information
$sql=mysql_query("SELECT * FROM user"); 
while ($array=mysql_fetch_array($sql)){ 

//connecting to second database
$db = mysql_pconnect('localhost', username, password){
	mysql_select_db(seconddbname, $db);}

//inserting the values
$sql=myql_query("INSERT INTO table (user, x,..) VALUES ( '$array[user]', '$array[x]', ....") 
} 

Questions:

How does that look?

$sql=mysql_query("SELECT * FROM user");

what exactly is 'user' ?

Thanks for your help,
Andy

[snoopy13]

I think it looks quite nice. does it work?
user?? I just took that word as an example..:-)
instead of SELECT * FROM user I should have written SELECT 3 FROM tablename
tell me if it works

[PseudAnon]

awesome, thanks for your help dude...

//connection to first database
$db = mysql_pconnect('localhost', 'pseud', 'password'){
	mysql_select_db(pseud_pictures, $db);}


//reading the information
$sql=mysql_query("SELECT * FROM users"); 
while ($array=mysql_fetch_array($sql)){ 

//connecting to second database
$db = mysql_pconnect('localhost', 'pseud', 'password'){
	mysql_select_db(pseud_xmb5, $db);}

//inserting the values
$sql=myql_query("INSERT INTO phpbb_users ('username', 'user_password') VALUES ( '$array[username]', '$array[password]'") 
} 

Is that looking ok? I haven't tried it yet! Too scared to...

Should I run it as a seperate script, or can I put it into an existing script? Possibly the signup.php script?

[snoopy13]

is your first table called users? so that SELECT * FROM users is ok.
then there are two little mistakes:
inserting the values you misspelt mysql_query
and then
INSERT INTO phpbb_users (username, userpassword) without ' (don't know what they are called in english)

the rest looks ok - I'd love to know if it works, as I haven't tried:-)

you of course can run it in an existing script, but also in an other one. I just don't really understand what it's for? why don't u initially write the username and password in the right table?

[PseudAnon]

basically, I own a site which has an image rating section on it using a php script and a phpbb forum... The section with the heaviest traffic is the image rating section. I want visitors who register at the image rating section to automatically be registered in the forum....

gonna implement it now and see what happens.. i'll be back to tell you which errors occur 😉

[PseudAnon]

Error:

Parse error: parse error in /home/pseud/public_html/session.php on line 3

<?php
//connection to first database
$db = mysql_pconnect('localhost', 'pseud', 'password'){
	mysql_select_db(pseud_pictures, $db);}


//reading the information
$sql=mysql_query("SELECT * FROM users"); 
while ($array=mysql_fetch_array($sql)){ 

//connecting to second database
$db = mysql_pconnect('localhost', 'pseud', 'password'){
	mysql_select_db(pseud_xmb5, $db);}

//inserting the values
$sql=mysql_query("INSERT INTO phpbb_users (username, user_password) VALUES ( '$array[username]', '$array[password]'") 
}
?>

What's a Parse Error?

[snoopy13]

I think it's when there's something spelt wrong. what's the code on line 3?

[snoopy13]

I do the connection like that:

$db = mysql_connect("localhost","dbname","password") or die ("no connection possible");    

mysql_select_db("dbname",$db);

Probably the error is because you said mysql_pconnect

[PseudAnon]

Thanks again 🙂

<?php
//connection to first database
$db = mysql_connect('localhost', 'pseud_', 'password') or die ("no connection possible");{
	mysql_select_db('pseud_pictures', $db);}


//reading the information
$sql=mysql_query("SELECT * FROM users"); 
while ($array=mysql_fetch_array($sql))

//connecting to second database
$db = mysql_connect('localhost', 'pseud_xmb5', 'password') or die ("no connection possible");{
	mysql_select_db(pseud_xmb5, $db);}

//inserting the values
$sql=mysql_query("INSERT INTO phpbb_users (username, user_password) VALUES ( '$array[username]', '$array[password]'") 
?>

It's running without any errors, but it's not doing anything.

Ok, since it's selecting * from the users table, that means everything? Should it be inserting all the values into appropiate places? Or can it select all, insert a couple and just ignore that it even read out the other values?

[waltherjt]

I know I am replying to this kind of late.

The reason your last script may not be working is you didn't close one of the parantheses in the insert statement.

Here's my version. You are obviously inserting into the users table when they register for the picture site right? Why don't you insert a code like this below the code where you insert them in the user table. I will assume you are getting all your users info from a form.

//connect to phpbb database
$db = mysql_connect('localhost', 'pseud_xmb5', 'password') or die ("no connection possible");{
mysql_select_db(pseud_xmb5, $db);}

//insert same info from your form into phpbb database. Only use the columns that you need.

$sql=mysql_query("INSERT INTO phpbb_users (username, user_password) VALUES ( '$POST[username]', '$POST[password]')")
?>

You can update two databases in 1 script, it's no problem. Also, I don't know if it matters, but I try not to use the same variable names twice in the same script for different values.

[snoopy13]

hy PseudAnon

When you told me what the data is copied for, I thougt the same as waltherjt - why don't u insert the information right away into two databases??
If you stay with "our" script:

The wile statement needs { and close them after you've inserted the information}

did the script work when you closed the )?

[PseudAnon]

Walther, when i put that code into the script where users use to form to signup (signup.php) then it gives me an error on line 74 of the script, which is before where i put that piece of code.. I think it was a parse error.. not sure though.. that would be an ideal way to do it though....... any suggestions?

Snoopy, I closed the parenthesis like you suggested:

<?php 
//connection to first database 
$db = mysql_connect('localhost', 'pseud_', 'password') or die ("no connection possible");{ 
    mysql_select_db('pseud_pictures', $db);} 


//reading the information 
$sql=mysql_query("SELECT * FROM users");  

while {($array=mysql_fetch_array($sql))

//connecting to second database 
$db = mysql_connect('localhost', 'pseud_xmb5', 'password') or die ("no connection possible");{ 
    mysql_select_db(pseud_xmb5, $db);} 

//inserting the values 
$sql=mysql_query("INSERT INTO phpbb_users (username, user_password) VALUES ( '$array[username]', '$array[password]'")}
?> 

I think that's right, but it gives me an error:

Parse error: parse error, expecting `'('' in /home/pseud/public_html/session.php on line 9

Thanks for your help guys, it's really appreciated...

[snoopy13]

The { comes after the while statement...
while($array=mysql_fetch_array($sql)) {
....
}
still errors?

the other way of doing it would still be easier - where is the error exactly and what does it tell you?

[PseudAnon]

ok, i fixed the parenthesis problem (I had put the { immediately after the word while ) and i put the closed parenthesis right after the 'connection to second database' code.... no errors anymore but it's still not working....

as for using the error i get with the other bit of code, well, i put the code right at the end of the signup.php script, would that be correct?

Error i get is:

Parse error: parse error in /home/pseud/public_html/pictures/irater/include/signup.php on line 74

(line 74 of the script is:

$username_html = "<br />The username "" . $signup_username . "" already exists, please choose a different one."; 

[snoopy13]

to many "" I think. and where is the echo?

Try like this:

$username_html = echo "<br />The username " . $signup_username . " already exists, please choose a different one.";

[neon]

snoopy13 get your facts straight,
By using:
$val = echo "foobar";
You'd output foobar and try to assign $val with the value which echo returns (void).
When assigning variable simply use
$val = "foobar";
and output:
echo $val;