php连接mysql
<div><?php</div><div>$ver = '2011090989';</div><div><br></div><div>$db_host = "192.168.1.4";</div><div>$db_port = 8808;</div><div>$db_name = "fivetrees_manage";</div><div>$db_user = "root";</div><div>$db_pass = '123456';</div><div><br></div><div>$db = new mysqli($db_host, $db_user, $db_pass, $db_name, $db_port);</div><div><br></div><div>if (mysqli_connect_errno()) {</div><div> printf("Connect failed: %s\n", mysqli_connect_error());</div><div> exit();</div><div>}</div><div><br></div><div>$sql = "</div><div>SELECT</div><div> `name` AS `id`,</div><div> `api_server` AS `node`,</div><div> `db_server` AS `db`</div><div>FROM</div><div> `servers`</div><div>WHERE</div><div> `cid` != 2 AND</div><div> `open` = 1 AND</div><div> `server_ver` != '$ver'</div><div>ORDER BY</div><div> `db_server`, `sid` ASC</div><div>";</div><div><br></div><div>$plan = '';</div><div>$plan_id = 0;</div><div>$last_db = '';</div><div>$counts = array();</div><div><br></div><div>if ($result = $db->query($sql)) {</div><div> while($row = $result->fetch_array(MYSQLI_ASSOC)) {</div><div> $server = substr($row['node'], 0, 5);</div><div> $code = "./shell-update {$row['id']} $server $ver\n";</div><div><br></div><div> if ($last_db != $row['db']) {</div><div> $plan_id= 1;</div><div> $last_db = $row['db'];</div><div> $counts[$plan_id] = 0;</div><div> file_put_contents("update_plan_$plan_id.sh", "");</div><div> }</div><div><br></div><div> $counts[$plan_id]= 1;</div><div><br></div><div> file_put_contents("update_plan_$plan_id.sh", $code, FILE_APPEND);</div><div> }</div><div><br></div><div> $result->close();</div><div>}</div><div><br></div><div>$db->close();</div><div><br></div><div>print_r($counts);</div><div>?></div><div><br></div>
页:
[1]