PHP - [function.imagecreatefrompng] Connection Timed Out

Im making a site for my family to leave messages for everyone to see but every now and then the message wont load and i get theses errors,

Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/#####/public_html/#####.com/messages.php on line 17

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/#####/public_html/#####.com/messages.php on line 18

Warning: mysql_query() [function.mysql-query]: Access denied for user '#####'@'localhost' (using password: NO) in /home/#####/public_html/#####.com/messages.php on line 21

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/#####/public_html/#####.com/messages.php on line 21

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/#####/public_html/#####.com/messages.php on line 24

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/#####/public_html/#####.com/messages.php on line 25

Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home/#####/public_html/#####.com/messages.php on line 54


i also recieved this error once

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

The hosting support team have been no help at all.

can you run a query says every 60 seconds with out refreshing the entire page? at the moment im using <meta http-equiv="refresh" content="60;url=login_success.php">

Hi Ive made a database with the option to kick someone for a certain amount of time but seems like I'm doing something wrong somewhere can anybody please assist   My full script is    (Admin panel)

<?
include "./emoticon_replace1.php";


  if ($_POST["DeletePost"]) {
    $id = $_POST["id"];
    $query = "DELETE FROM ".$dbTable." WHERE id='".$id."'"; 
    mysql_query($query);
    echo "ID removed from system: ".$id;
  }
  if ($_POST["BanIP"]) {
    $IP_To_Add = $_POST["ip"];
    if(eregi("^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$", $IP_To_Add))
    {
      $sql = "INSERT INTO ".$IPBanTable." (ip) VALUES (\"$IP_To_Add\")";
      $result = mysql_query($sql);
    } else {
      echo "Error: Not a valid IP: ".$IP_To_Add;
    }
  }
  if ($_POST["purge"]) {
    $query = "TRUNCATE TABLE ".$dbTable; 
    mysql_query($query);
    echo "StringyChat purged";
  }
  if(!$_POST["update"] || !$_POST["StringyChat_name"] || !$_POST["StringyChat_message"]) {
  } else {
    $id = $_POST["id"];
    $name = $_POST["StringyChat_name"];
    $message = $_POST["StringyChat_message"];


    include("emoticon_replace.php");


    $query = "UPDATE ".$dbTable." SET StringyChat_name='$name', StringyChat_message='$message' WHERE id='".$id."'";
    $result = mysql_query($query, $db) or die("Invalid query: " . mysql_error());
  }
  if ($_POST["EditPost"]) {
    $id = $_POST["id"];
    $result = mysql_query("SELECT * FROM ".$dbTable." WHERE id='".$id."'", $db); 
    $myrow = mysql_fetch_array($result);
?>
    <form name="StringyChat_form" method="POST" action="?mode=postman">
      Name:<br>
      <input name="StringyChat_name" class="StringyChatFrm" type="text" size="20" maxlength="<? echo $name_size; ?>" value="<? echo $myrow["StringyChat_name"]?>">
      <br>
      Message:<br>
      <textarea name="StringyChat_message" class="StringyChatFrm" cols="20" rows="4"><? echo $myrow["StringyChat_message"]?></textarea>
      <br>
      <input type="hidden" name="id" value="<? echo $id ?>">
      <input name="update" class="StringyChatFrm" type="submit" value="Update">
    </form>


<?
  }
?>


  <a href="<? echo $_SERVER['REQUEST_URI']; ?>&m=purge">Purge StringyChat</a><br>
    <br>


  <?
  // Load up the last few posts.  The number to load is defined by the "ShowPostNum" variable.
  $result = mysql_query("SELECT * FROM ".$dbTable." ORDER BY StringyChat_time DESC",$db);


  while ($myrow = mysql_fetch_array($result)) {
    $msg = $myrow["StringyChat_message"];


    $msg = strip_tags($msg);
    $msg = eregi_replace("im#([a-z]{3})", "<img src=\"/stringychat/images/\\1.gif\" alt=\"emoticon\">",$msg);


printf("<div class=\"StringyChatItem\"><h4>%s<br>\n", $myrow["StringyChat_name"]);
printf("%s<p>\n",$myrow["StringyChat_ip"],"%s</p>\n");
    printf("%s</h4>\n", date("H:i - d/m/y", $myrow["StringyChat_time"]));
    printf("%s</div>\n", $msg);




if ($_POST["1h"]) {
    $mxitid1= $_POST["1h"];
    if(eregi("^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$", $IP_To_Add))
    {
      $sql1 = "UPDATE ".$dbTable." SET unban_time = DATE_ADD(NOW(), INTERVAL 1 DAY) WHERE mxit_id = $mxitid1)";
      $result1 = mysql_query($sq1l);
    } else {
      echo "Error: Cannot Kick: ".$IP_To_Add;
    }
  }
function checkban($mxitid) 
    { 
        // querys database 
        $q = mysql_query("SELECT 1 FROM ".$dbTable." WHERE unban_time > NOW() AND mxit_id = '$mxitid'",$db); 
        $get = mysql_num_rows($q); 
        // if found 
        if ($get == "1") 
            {  
                // deny user access 
                $r=mysql_fetch_array($q); 
                die("You have been banned from this website until $r[legnth]. If you feel this is in error, please contact the webmaster at ."); 
            } 
    }








?>
    <form name="form<? echo $myrow["id"];?>" method="post" action="?mode=postman">
      <input name="id" type="hidden" value="<? echo $myrow["id"];?>">
      <input name="ip" type="hidden" value="<? echo $myrow["StringyChat_ip"];?>">
      <input name="EditPost" type="submit" id="EditPost" value="Edit">
      <input name="DeletePost" type="submit" id="DeletePost" value="Delete">
      <input name="BanIP" type="submit" id="BanIP" value="Ban <? echo $myrow["StringyChat_ip"];?>">
<input name="1h" type="submit" id="1" value="Kick <? echo $myrow["mxit_id"];?>">
<input name="1d" type="submit" id="1d" value="Kick <? echo $myrow["StringyChat_ip"];?> for 24 hours ">
<input name="7d" type="submit" id="7d" value="Kick <? echo $myrow["StringyChat_ip"];?> for 7 days ">
    </form>
  <?
  }   
?>

The part I added to the above script which is giving me pain is   

if ($_POST["1h"]) {
    $mxitid1= $_POST["1h"];
    if(eregi("^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$", $IP_To_Add))
    {
      $sql1 = "UPDATE ".$dbTable." SET unban_time = DATE_ADD(NOW(), INTERVAL 1 DAY) WHERE mxit_id = $mxitid1)";
      $result1 = mysql_query($sq1l);
    } else {
      echo "Error: Cannot Kick: ".$IP_To_Add;
    }
  }
function checkban($mxitid) 
    { 
        // querys database 
        $q = mysql_query("SELECT 1 FROM ".$dbTable." WHERE unban_time > NOW() AND mxit_id = '$mxitid'",$db); 
        $get = mysql_num_rows($q); 
        // if found 
        if ($get == "1") 
            {  
                // deny user access 
                $r=mysql_fetch_array($q); 
                die("You have been banned from this website until $r[legnth]. If you feel this is in error, please contact the webmaster at ."); 
            } 
    }

What I'm trying to do is to ban the person for 1 day. And by banning the person I want them to be blocked from my Index page from submitting a form (sending a message) which is stored as tik.php on my index page     index.php

<?php
require_once('common.php');


include "ip-ban-time-limit.php";
checkban($_SERVER['HTTP_X_MXIT_USERID_R']);






checkUser();
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
<html>
<head>
   <title>Galaxy Universe Chat</title>
   <link href="style/style.css" rel="stylesheet" type="text/css" />
</head>
<body><br>
    <div id="main">
      <div class="caption">Galaxy Universe Chat</div>
      <div id="icon">&nbsp;</div>
      <div id="result">
Hello <?php echo $_SESSION['userName']; ?> ! <br/>
<div style="color:red"><b><p>Please keep it clean and in English or you will be banned!</p></b></div>
<br>
<?PHP


include "./stringychat.inc.php";
require_once ( 'tik.php' );


?>


<br>




<p><a href="index1.php">Refresh</a> | <a href="logout.php">Log Out</a></p>
 </div> 
 <div id="source">Galaxy Wars chat @ cobusbo</div>
    </div>
</body>   

Seems like I've been doing something wrong with my queries...

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=320284.0

Hi guys im having trouble implementing functions into some buttons. I got a kicking script from the internet that looks as follow    

I'm trying to post to a (SMF) simplemachines 2.0 forum using curl.

I have logged in and I have tried sending all the fields, but when I try to post, I receive this message:

"The following error or errors occurred while posting this message:
Your session timed out while posting. Please try to re-submit your message."

Do any of you know why this happens? Is the problem that when I visit the posting url, they give me a cookie that expires if I leave the posting url?

I don't think the form is invalid, it looks like it has to do with the session. People at the simplemachines forum can have this problem when they try to post the ordinary way, but that is because of an inactivity period. Can my problem be because of a cookie?

HI fellow programmers,

Can i connect a textbox to a field in the MySql using the id of the text box? If yes, can u show me a small example.


Thanks
RAM

Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\connect\index.php on line 10
Hallo I am beginner  and starting to learn php I got this message when I want to connect with server. Can I get some suggestion what to do? Thanks

Hi! I got the following problem...
I have a SQL 2005 Server in a VPN. For security reasons,internet access to the database server is only possible for VPN members.

Now i want to connect to the openvpn Server from my webserver in order to connect to the database for some webreports. How can i achieve this using php?

thanks

Hi Guys,

need a little help and drawn a blank. The code that is not working is below

$result = $conn->query("SELECT * FROM MK_migration_details WHERE mig_bid='".$_SESSION['bid']."'");

I can confirm the $_SESSION['bid'] is working as echo's out on another part of the page. and the above $result works when i manually type the search criteria like below.

$result = $conn->query("SELECT * FROM MK_migration_details WHERE mig_bid='300101'");

Basically no result turn up on the page. Any ideas or advise how I can diagnose?

Hi All,

I have a landing page that I use, but often my sql database is too busy or gets overwhelmed and then the landing page just stalls and traffic is lost.  Here it is:

Code: [Select]
<?php
//ini_set("display_errors",1);
if(!$src) $src = $q;
define("__EXEC_", 1);
include("config.php");
include("custom.php");
function lsp_visit_find($__val, &$__uid) {
global $u;
global $db;
$l_campaign = array("campaign_id"=>"", "url"=>"", "cost"=>"0.00", "name"=>"-", "ad_keyword"=>"", "mapped_keyword"=>"");
$l_visit = array();
$q = $_GET['q'];
$src = $_GET['src'];
// for STAGE #1 (visit definition): get cost, ad keyword, mapped keyword.
$l_campaign['name'] = "info";
$l_campaign['mapped_keyword'] = "$q";
  $l_campaign['ad_keyword'] = "$src";
  $l_campaign['cost'] = ".02";

// get referer (campaign URL). if no campaign found, - create it!
if (!empty($l_campaign['name'])) {
$r = mysql_query("select campaign_id,name from campaign where name='$l_campaign[name]'");
if (!mysql_affected_rows($db)) {
$r = mysql_query("insert into campaign(name,cost, creation_date,last_update_date) values('$l_campaign[name]',$l_campaign[cost], unix_timestamp(),unix_timestamp())");
$l_campaign['campaign_id'] = mysql_insert_id($db);
}
else {

$w = mysql_fetch_assoc($r);
$l_campaign = array_merge($l_campaign,$w);
}
}
// check, whether we had visits from this IP for this keywords within 2 minutes.
// if we have one, get its ID, otherwise - create new!
$visit_id="";
if (!empty($l_campaign['ad_keyword']) && !empty($l_campaign['mapped_keyword']) ) {
$ip = get_real_ip();
$r = mysql_query("select visit_id,uid,campaign_id,ad_keyword,mapped_keyword from visit where ip='$ip' and ad_keyword='$l_campaign[ad_keyword]' and mapped_keyword='$l_campaign[mapped_keyword]' and currtime>=from_unixtime(".(time()-120).") limit 1");
if (!mysql_affected_rows()) {
$__uid = md5($ip.time().$l_campaign['campaign_id']);
$x = mysql_query("insert into visit(ip,uid,cost,currtime,campaign_id,ad_keyword,mapped_keyword)
values('$ip','$__uid',$l_campaign[cost],now(),$l_campaign[campaign_id],'$l_campaign[ad_keyword]','$l_campaign[mapped_keyword]')");
$visit_id = mysql_insert_id($db);
}
else {
$l_visit = mysql_fetch_assoc($r);
$visit_id = $l_visit['visit_id'];
$__uid = $l_visit['uid'];
}
return $visit_id;
}
}
$db = mysql_connect(__CFG_HOSTNAME, __CFG_USERNAME, __CFG_PASSWORD);
mysql_select_db(__CFG_DATABASE, $db);
$u = isset($_GET['u'])? $_GET['u'] : 2;

$uid = "";
$visit_id = lsp_visit_find($_REQUEST['l'], $uid);
if (!empty($visit_id)) {
setcookie("x_uid", base64_encode($visit_id."QQ".$uid), time() + 3600);
}
global $q;
mysql_close($db);
$q = $_GET['q'];
$src = $_GET['src'];
header("Location: http://www.mydomain.com/search/?q=$q");
exit();
?>
My question is how do I code it so that if after 5 seconds or so, or the connection can't be made, it just terminates the connection and auto loads the header redirect at the bottom of the page?

Thanks!

Hi,

I'm trying to write my first MVC framework for my college project and faced this problem: i have main framework class, and have this loader class, that loads view files and libraries. Now, how can I do that when I load library, I could reach it from my main class? For example: in main class goes this code:
Code: [Select]
public $load;

function __construct ( )
{ $this->load = new Loader; }

function someFunction ( )
{
    $this->load->library('someLibrary');
    // and now reach the library like this
    $this->someLibrary->functionInLibrary();
}
The idea is from codeigniter, so if anyone has used this framework will understand my question.

Is there a way to instantiate a PDO object using an already existing database connection? Or does PDO detect an already opened connection and use it? The existing connection is a persistant connection.

Hi all!

   I'm trying to retreive my own status updates from LinkedIn, but without success uptill now.

I did setup an oAuth communication which resulted in requesting the user for permission for the application to access his profile and I retrieved an access token succefully which I saved in the database.

However, when I try the following after that, using the access token:
Code: [Select]
$options = array(
  'consumerKey' => '[key here]',
  'consumerSecret' => '[secret here]',
);

// This is where I get the token, not really interesting :p
$dbSocialAccount = new SocialAccount();
$oSocialAccount = $dbSocialAccount->fetchRow('id = "3"');

$token = unserialize($oSocialAccount->token);
$client = $token->getHttpClient($options);

$client->setUri('https://api.linkedin.com/v1/people/~');
$client->setMethod(Zend_Http_Client::GET);
$response = $client->request();
$content = $response->getBody();

echo 'content:<br /><br />';
echo $content;
exit();
It works fine! I get some profile information of the user/my own linkedin account.
Now I want to retrieve the last, say 5, updates from my own account, so I change the request URL to:

http://api.linkedin.com/v1/people/~/network/updates?scope=self

Which should get me all my own updates... however now I get an error:

401 1303487627487 0 [unauthorized]

I don't understand why I'm not authorized now? I do have access I guess, when the first example works?
What am I doing wrong here?

Thank you for your answer! If you need more information, please ask!

Hello,

Does anyone know how may i detect the Connection type by user IP?

Broadband etc.