Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Tablet DB Connection Infos
- $servername = "host1";
- $username = "user1";
- $password = "pw1";
- $dbname = "db1";
- //Intra DB Connection Infos
- $servername2 = "host2";
- $username2 = "user2";
- $password2 = "pw2";
- $dbname2 = "db2";
- // Create connection
- $conn = mysqli_connect($servername, $username, $password, $dbname);
- // Check connection
- if (!$conn) {
- die("Connection to DB1 failed: " . mysqli_connect_error());
- }
- $sql = "SELECT * FROM form WHERE exists = 0";
- $result = mysqli_query($conn, $sql);
- //INSERT
- if (mysqli_num_rows($result) > 0) {
- //connect to DB2
- $conn2 = mysqli_connect($servername2, $username2, $password2, $dbname2);
- if (!$conn2) {
- die("Connection to DB2 failed: " . mysqli_connect_error());
- }
- while($row = mysqli_fetch_assoc($result)) {
- $sqlInsert = "INSERT INTO `formulario` (`ID_FORM`,`ID_PICTURE`, `PICTURE`
- VALUES ($row[ID_FORM],$row[ID_PICTURE].$row[PICTURE]);";
- }
- mysqli_close($conn2);
- } else {
- echo "0 records! <br />";
- }
- mysqli_close($conn);
Add Comment
Please, Sign In to add comment