3v4l.org

run code in 300+ PHP versions simultaneously
<?php $dbname = 'RPGDugEAOoSvpJcerHpc'; /*填入数据库连接信息*/ $host = 'sqld.duapp.com'; $port = 4050; $user = 'ISDddvTQAsC00NmHsOrCcqIL';//用户名(api key) $pwd = 'GMEWfs0973mqDGlgfsz7zVSnEQxqAePM';//密码(secret key) /*以上信息都可以在数据库详情页查找到*/ /*接着调用mysql_connect()连接服务器*/ $link = @mysql_connect("{$host}:{$port}",$user,$pwd,true); if(!$link) { die("Connect Server Failed: " . mysql_error()); } /*连接成功后立即调用mysql_select_db()选中需要连接的数据库*/ if(!mysql_select_db($dbname,$link)) { die("Select Database Failed: " . mysql_error($link)); } /*至此连接已完全建立,就可对当前数据库进行相应的操作了*/ mysql_select_db('mydb'); /* Update records */ mysql_query("UPDATE mytable SET used=1 WHERE id < 10"); printf ("Updated records: %d ", mysql_affected_rows()); mysql_query("COMMIT"); ?>

preferences:
32.69 ms | 402 KiB | 5 Q