Search the Community
Showing results for tags 'datatransfer php mysqli'.
Found 1 result
-
Hello everybody! I'm here today with a mystery i can't solve... The problem i'm having is that i need to be able to transfer mysql data from one server to another one. Retrieving data from the one database is easy, but making it transfer to another server is not that easy for me. I have it printing out the data ATM This is how i retrieve data from one server: <?php $dbhost = ""; $dbname = "eg_xenforo"; $dbuser = ""; $dbpass = ""; $conn = mysqli_connect("$dbhost","$dbuser","$dbpass","$dbname") or die("Error " . mysqli_error($conn)); $sql= "SELECT username FROM xf_user WHERE FIND_IN_SET('9',secondary_group_ids) UNION SELECT username FROM xf_user WHERE FIND_IN_SET('10',secondary_group_ids) UNION SELECT username FROM xf_user WHERE FIND_IN_SET('12',secondary_group_ids)"; $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) > 0) { // output data of each row while($row = mysqli_fetch_assoc($result)) { $name = $row['username']; echo "$name <br>"; } } else { echo "0 results"; } ?> This is what i get as result: CosmonautBob ooglebrain JamieKG Quinnter16 Jordan Zoehamp skynet1123 misscupcake1306 Sir Crimson These are usernames that should be added onto another server in a database table. Any suggestions? Thanks in advance!
