先贴上代码:
$dbServer = "GWRD-WIN2003";$dbName = "voddb"; $dbUser = "vod"; $dbPass = "vod"; $table = "jqdistribute";$path = "ftp://" + $host;$connect=mysql_connect($dbServer,$dbUser,$dbPass); echo $connect;
mysql_select_db($dbName); $queryInsert="insert into " + $table + "values ('".$pid."', '".$sid."', '".$path."')";
mysql_query($queryInsert,$connect);
$err=mysql_error; 再写出测试结果。(服务器名,用户名,密码保证正确。)
SWF DEBUG: Event: uploadProgress: File ID: SWFUpload_0_0. Bytes: 0. Total: 195523
SWF DEBUG: Event: uploadProgress: File ID: SWFUpload_0_0. Bytes: 98304. Total: 195523
SWF DEBUG: Event: uploadProgress: File ID: SWFUpload_0_0. Bytes: 195523. Total: 195523
SWF DEBUG: Event: uploadSuccess: File ID: SWFUpload_0_0 Data: Cannot initiate connection to host
$dbServer = "GWRD-WIN2003";$dbName = "voddb"; $dbUser = "vod"; $dbPass = "vod"; $table = "jqdistribute";$path = "ftp://" + $host;$connect=mysql_connect($dbServer,$dbUser,$dbPass); echo $connect;
mysql_select_db($dbName); $queryInsert="insert into " + $table + "values ('".$pid."', '".$sid."', '".$path."')";
mysql_query($queryInsert,$connect);
$err=mysql_error; 再写出测试结果。(服务器名,用户名,密码保证正确。)
SWF DEBUG: Event: uploadProgress: File ID: SWFUpload_0_0. Bytes: 0. Total: 195523
SWF DEBUG: Event: uploadProgress: File ID: SWFUpload_0_0. Bytes: 98304. Total: 195523
SWF DEBUG: Event: uploadProgress: File ID: SWFUpload_0_0. Bytes: 195523. Total: 195523
SWF DEBUG: Event: uploadSuccess: File ID: SWFUpload_0_0 Data: Cannot initiate connection to host
老郁闷了~~
这个是数据库服务器,如果是本机用localhost
如果是远程机器,那么要ip地址一个很简单的例子:
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);马虎聚搜
我连接的是局域网的一台电脑。SWF DEBUG: <b>Warning</b>: mysql_connect(): Can't connect to MySQL server on '10.10.10.13' (10061) in <b>c:\inetpub\wwwroot\sfvod\manager\upload.php</b> on line <b>78</b><br />
SWF DEBUG: <br />
SWF DEBUG: <b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL-Link resource in <b>c:\inetpub\wwwroot\sfvod\manager\upload.php</b> on line <b>84</b><br />
SWF DEBUG: <br />
SWF DEBUG: 网上找了一圈也不太明白。
$dbServer = "localhost";//Ip地址 or localhost$dbName = "dbname";$dbUser = "mailasp";$dbPass = "mailasp";$table = "table";$pid = "aa";
$sid = "bb";
$host = "cc";
$path = "ftp://" + $host;$connect=mysql_connect($dbServer,$dbUser,$dbPass); if($connect)
{
echo success;
}
else
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db($dbName); $queryInsert="insert into ".$table." values ('".$pid."', '".$sid."', '".$path."')";
var_dump($queryInsert);//die;//打印queryIsert
mysql_query($queryInsert,$connect);
?>
SWF DEBUG: <b>Warning</b>: mysql_connect(): Can't connect to MySQL server on '10.10.10.13' (10061) in <b>c:\inetpub\wwwroot\sfvod\manager\upload.php</b> on line <b>79</b><br />
SWF DEBUG: Could not connect: Can't connect to MySQL server on '10.10.10.13' (10061)