Select multiple columns from a table and insert data into another table in a different database in PHP-MySQL -

-

i have select data table in database , insert them table in different database. below code returns $select_query ok, $insert_query not ok. please correct code , let me know response?

$host1 = "localhost"; $user1 = "jackpot"; $pass1 = "jackpot"; $db1 = "pinkapple"; $host2 = "localhost"; $user2 = "jackpot"; $pass2 = "jackpot"; $db2 = "blueberry";  $mysql_connection1 = mysql_connect($host1, $user1, $pass1); mysql_select_db($db1, $mysql_connection1) or die(mysql_error()); $select_query = mysql_query("select field1, field2, field3 tree date_entered > '2014-01-01 16:22:00'", $mysql_connection1); $number = mysql_num_rows($select_query);      if ($select_query) {         echo "select query ok <br>";         echo $number ."<br>";     } else {         echo "select query  not ok <br>";     }  $mysql_connection2 = mysql_connect($host2, $user2, $pass2, true);  mysql_select_db($db2, $mysql_connection2) or die(mysql_error());      while ($row = mysql_fetch_array($select_query)) {     $field1 = $row['field1'];     $field2 = $row['field2'];     $field3 = $row['field3'];     $insert_query = mysql_query("insert jungle (desk1, chair1, table1) values ('$field1', '$field2', '$field3')", $mysql_connection2);         if ($insert_query) {             echo "insert query ok <br>";         } else {             echo "insert query not ok <br>";         } } mysql_close($mysql_connection1); mysql_close($mysql_connection2);

below can see schematic image of tables.

enter image description here

you need establish values?

"insert jungle (desk1, chair1, table1) values (value1, value2, value3)"

you should collect data first select , can set pertinent values in insert statement

you can using mysql_fetch statement

$mysql_connection2 = mysql_connect($host2, $user2, $pass2, true); mysql_select_db($db2, $mysql_connection2) or die(mysql_error());  while($row = mysql_fetch_array($select_query)) {     $field1 = $row['field1'];     $field2 = $row['field2'];     $field3 = $row['field3'];     $insert_query = mysql_query("insert jungle (desk1, chair1, table1) values ('$field1', '$field2', '$field3')",$mysql_connection2);      if ($insert_query) {       echo "insert query ok <br>";     } else {       echo "insert query not ok <br>";     }  }

this statement loops through select statement , inserts row every returned result using insert statement

but should mysqli because mysql depreciated. basic logic behind doing


Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

android - How to disable Button if EditText is empty ? -

-
i have edittext , button in application. when button clicked,the text entered in edittext added listview. i want disable button if edittext empty.how ? this code button click imagebutton imb=(imagebutton)findviewbyid(r.id.btn_send); imb.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { edittext et = (edittext)findviewbyid(r.id.edittext1); string str = et.gettext().tostring(); web1.add(str); toast.maketext(shoutsingleprogram.this, "you entered...."+str, toast.length_short).show(); adapter1.notifydatasetchanged(); et.settext(""); } }); } how can ? edittext1.addtextchangedlistener(new textwatcher() { @override public void ontextchanged(charsequence s, int start, int before, in
Read more