2 questions, quite simple

buddysal

ok question 1...

I have 2 databases, 1 form, i need to post the form results into each db like... one db is website signup, the other is safelist signups...

but they have different table names... i have my form working with the website signup.. but i still need to get my form working with my safelist d/b... alittle stuck there..

questions 2...

where can i find a script to a simple login script? all i need is a simple login and one page members area on the same page....

hope someone can hep, been looking through some php books and havnt had any luck yet...

Thanks,
Buddy

fazer75

..two tables, one form...
i dunno, try something like this?

<?php
if (isset ($submit))
{
$query1 = "insert into table1";
$query2 = "insert into table2";
mysqlquery etc...
mysqlquery etc...
}
?>

buddysal

This is my query coding....

$query = "INSERT INTO USERS ( userid, firstname, lastname, username, password,
auth_cookie, SP )
values
( '$userid', '$firstname', '$lastname', '$username', '$password', '$auth_cookie', '$SP' )";
if ( ! mysql_query( $query, $link ) ) {
$dberror = mysql_error();
return false;
}
return true;

}

Do i need to do this?

mysql_db_select( Website )
$query = "INSERT INTO USERS ( userid, firstname, lastname, username, password,
auth_cookie, SP )
values
( '$userid', '$firstname', '$lastname', '$username', '$password', '$auth_cookie', '$SP' )";
if ( ! mysql_query( $query, $link ) ) {
$dberror = mysql_error();
return false;
}
return true;
}

Mysql_db_select( Safelist )
$query2 = "INSERT INTO ACCOUNT ( username, password, contactemail, listemail )
values
( '$username', '$password', '$auth_cookie', '$userid' )";
if ( ! mysql_query( $query, $link ) ) {
$dberror = mysql_error();
return false;
}
return true;

}

$auth_cookie = contact email
$userid = list email

i accidently messed up in my db and never changed the table names, only reason its like that...

oh and sense its on different d/b do i need sep db connects and selects? or just 2 db select with the same connection?

buddysal

i tried using 2 connects... but i have a problem with the function add_to_database(), it says it cant re declare itself? how can i have 2 add_to_database functions? the coding is below...

function add_to_database( $userid, $firstname, $lastname, $username, $password,
 $auth_cookie, $SP, $subscribe, &$dberror ) {
$user = "buddysal_admin";
$pass = "3585835";
$db = "buddysal_rtr";
$link = mysql_connect( "localhost", $user, $pass );
if ( ! $link ) {
$dberror = "Couldn't connect to mysql server";
return false;
}
if ( ! mysql_select_db( $db, $link ) ) {
$dberror = mysql_error();
return false;
}
$query = "INSERT INTO USERS ( userid, firstname, lastname, username, password,
 auth_cookie, SP, subscribe )
values
( '$userid', '$firstname', '$lastname', '$username', '$password', '$auth_cookie', '$SP', '$subscribe' )";
if ( ! mysql_query( $query, $link ) ) {
$dberror = mysql_error();
return false;
}
return true;
}

function add_to_database( $username, $subscribe, $password, $userid, &$dberror ) {
$user = "buddysal_admin";
$pass = "3585835";
$dbS = "buddysal_safelist";
$linkS = mysql_connect( "localhost", $user, $pass );
if ( ! $linkS ) {
$dberror = "Couldn't connect to mysql server";
return false;
}
if ( ! mysql_select_db( $dbS, $linkS ) ) {
$dberror = mysql_error();
return false;
}
$queryS = "INSERT INTO SAFELIST ( Username, Subscribe, Password, Contact )
values
( '$username', '$subscribe', '$password', '$userid' )";
if ( ! mysql_query( $queryS, $linkS ) ) {
$dberror = mysql_error();
return false;
}
return true;
}

buddysal

ok.. im getting desperate... if you can help me ill give you free for life membership onto my site... if you want it that is... ($150.00 value)

buddysal

ok... no-one is still helping me... if no-one can help me can you tell me where i can find it in a php book? or somewhere online?

xblue

Hi, it just seemed fairly hard to understand where your problem is at first glance. and you didn't use the [php] [/php] tags around your code, which makes it easier to read.

okay, you store similar information in indentically named tables in 2 different databases, do I get this right?
that actually smells like redundancy, you might want to check on this, there's an article about database design here on phpbuilder, too.

but back to your problem:
if you want to use 2 separate functions, you need to name them differently, e.g. function add_to_admin and function add_to_safelist.

however, since they are almost identical except for the database it may make sense to have only one function, pass the database name as argument and use that in your mysql_select_db call.

buddysal

Thank you,

also my tables and forums have different names... on both d/b's the only fields that match are username and password

ill try renaming the add_to_database and see if it works..

buddysal

ok.. i changed it and the only way it posts to my d/b is if it has add_to_database, i have it posting to my first db but i cant get it to post to my second

xblue

a function's name doesn't mean much at all ("what's in a name? ..."), it is just a unique identifier so php knows what to do when you call a self-defined function (which is why 2 functions which identical name are invalid).

so, if you change the name, you'd need to change any calls to that function to use that modified name, okay?

and would you perhaps edit your initial post to insert the [php] [/php] tags?

buddysal

ok i changed it to php coding above... and i will try renaming again... maybe i forgot to change my unction calls later in the script...

thanks