+- 2DWorlds Forums (http://2dworlds.buildism.net/forum)
+-- Forum: Off Topic (http://2dworlds.buildism.net/forum/forumdisplay.php?fid=5)
+--- Forum: Programming (http://2dworlds.buildism.net/forum/forumdisplay.php?fid=30)
+--- Thread: **** PHP (/showthread.php?tid=8255)
**** PHP - Dignity - 09-06-2011
Code:
function load_ad()
{
mysql_connect("69.175.121.66","roperson_a","pass123");
mysql_select_db("roperson_wp");
$ad_query=mysql_query("SELECT * FROM Stats2");
while ($row=mysql_fetch_array($ad_query))
{
$ad_num=$row["ad_num"];
}
$ad_query=mysql_query("SELECT * FROM Ads2 WHERE ID='".rand(17,$ad_num)."'");
while ($row=mysql_fetch_array($ad_query))
{
echo "<div align='center'><a href='$row[link]'><img id='round' src='".$row["src"]."' alt='[Ad]' width='728' height='90'/></a></div>";
}
}
load_ad();**** PHP Wrote:Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 110 in /home/vnetwork/public_html/api.php on line 124
Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'vnetwork'@'localhost' (using password: NO) in /home/vnetwork/public_html/api.php on line 125
Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/vnetwork/public_html/api.php on line 125
Warning: mysql_query() [function.mysql-query]: Access denied for user 'vnetwork'@'localhost' (using password: NO) in /home/vnetwork/public_html/api.php on line 126
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/vnetwork/public_html/api.php on line 126
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/vnetwork/public_html/api.php on line 127
Warning: mysql_query() [function.mysql-query]: Access denied for user 'vnetwork'@'localhost' (using password: NO) in /home/vnetwork/public_html/api.php on line 131
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/vnetwork/public_html/api.php on line 131
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/vnetwork/public_html/api.php on line 132
RE: **** PHP - Jacob__mybb_import1 - 09-07-2011
(09-06-2011, 07:39 PM)roperson Wrote: Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 110 in /home/vnetwork/public_html/api.php on line 124
Sounds like your MySQL server is down/configured wrong, or you put in the wrong IP address. That should not normally happen.
RE: **** PHP - Dignity - 09-07-2011
It's all correct.
The access in Remote MySQl reads '%' which should allow everything.
The host is definitely correct.
RE: **** PHP - RickAstley - 09-07-2011
Jacob_ is correct. Instead of your IP put locahost.
RE: **** PHP - Dignity - 09-07-2011
NO YOU FOOL!
I'm testing an ad system I' making, and it requires Remote MySQL!
THINK!!!!
RE: **** PHP - Jacob__mybb_import1 - 09-07-2011
Why do you need remote MySQL? It's usually not a good idea to do that unless the MySQL server is on the same LAN as the web server.
RE: **** PHP - Dignity - 09-07-2011
Because I'm trying to make an advertizing system, like googles.
All that user can do is select data, nothing else.