0

Hello,

I have two databases on my website lebphoto.com with the same tables. One with a 1665 members and the other with 33 members, I want to merge them together. is there a way other than typing each records by myself or ask the members to register again?

Thank you

3
Contributors
2
Replies
3
Views
10 Years
Discussion Span
Last Post by arty56
0

Create 2 db connection scripts
connect.php and dbconnect.php
Create 1 script called
create-new.php
Below is the connect.php

<?php
// this is connect.php
// connect to the 33 member database

        $host = "localhost";               // Database server
        $user = "Database username";          // Database username
        $pass = "Database password";                // Database password
        $db = "Database name";       // Database name
    $db1=mysql_connect("$host","$user","$pass");
    mysql_select_db("$db");
    $ok = mysql_select_db("$db");
    if (!ok)
{
    die("<br>" . mysql_errno().":".mysql_errno()."<br>");
}
?>

Below is the dbconnect.php

<?php
// this is dbconnect.php
// connect to the 1665 member database
        $host = "localhost";               // Database server
        $user = "Database username";          // Database username
        $pass = "Database password";                // Database password
        $db = "Database name";       // Database name
    $db1=mysql_connect("$host","$user","$pass");
    mysql_select_db("$db");
    $ok = mysql_select_db("$db");
    if (!ok)
{
    die("<br>" . mysql_errno().":".mysql_errno()."<br>");
}
?>

Below is the create-new.php

<?php
// 33 members database
include("connect.php); 
// for this demo we'll use customer as the table name
// replace the field names with the correct fields from your database table

$sql = "SELECT * FROM customer"; 
    $sql1=mysql_query($sql) or die("Couldn't select customer!");
while($row = mysql_fetch_array($sql1))
     {
    $ID = stripslashes($row['ID']);         // replace the field names only
    $MembersID = stripslashes($row['MembersID']);    // replace the field names only
    $fname = stripslashes($row['fname']);        // replace the field names only
    $lname = stripslashes($row['lname']);        // replace the field names only
    $email = stripslashes($row['email']);        // replace the field names only
// 1665 members database
include("dbconnect.php);  
$insertmember="insert into customer (ID, MembersID, fname, lname, email) values ('$ID', '$MembersID', '$fname', '$lname', '$email')";  
//registering member in database
$insertmember2=mysql_query($insertmember) or die("<br><br>Could not insert customer");
// do not uncomment code below.
//$ID = mysql_insert_id();
echo "Insert $fname $lname Completed Successfully";
    }// Closes While statement
?>

Basically you are connecting to the database with the 33 members and as long as the table and field structure is identical you can then just open a connection to the database containing the 1665 members and append the 33 members to that db.

When completed you will have 1 db with 1698 members.

Have fun.
Arty.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.