PHP Read access DB instance code

PHP Read access DB instance code

 Open ($MM _conn_string);//link opens data source $query= "SELECT * from DM ORDER by ID ASC"; $RS->open ($query, $Conn, 1, 1);//EXECUTE statement, Returns the data set echo "Total:". $RS->recordcount. " Record results!
"//Record number for ($i =0; $i < $RS->fields->count; $i + +) echo $RS->fields[$i]->name." ";//Traverse field name echo"
"; $connect = mysql_connect (" 192.168.0.51 "," username "," password "), while (! $RS->eof) {$query =" INSERT INTO smsgames.nanjing_toponym values (' "; $query. = $RS->fields[" id "]->value." ', ' "; $query. = $RS->fields[" Name "- >value. "', '"; $query. = $RS->fields["symbol"]->value. "', '"; $query. = Str_replace ("\ r \ n", "", $RS->fields[ "Weizhi"]->value). "', '"; $query. = $RS->fields["" "" "" "]->value." ', ' "; $query. = $RS->fields[" Class "]-> Value. "', '"; $query. = Str_replace ("\ r \ n", "", $RS->fields["History"]->value). "', '"; $query. = Str_replace ("\ r \ n "," ", $RS->fields[" addr "]->value). $result = mysql_query ($query, $connect), if (! $result) print "Error:". Mysql_error (). "
Query: ". $query."
"; Elseprint $RS->fields[" id "]->value." "; $RS->movenext (); $i + +;} Release resources $conn->close (); $RS =null; $Conn =null;? >

