PHP - Connection Failed: Could Not Find Driver

I am trying to figure how to code around this. I have a DOM scraper function that pulls urls from my database, opens the page, scrapes the data, and then moves onto the next URL to scrape. my issue is that if the page fails to load the script bombs and I have to restart it again. Trying to figure out how if the Code: [Select]
$html->find('div[class="itemHeader address"]') as $div fails to open the page it just skips the DOM inspection.

Here is my error...

Failed to open stream: HTTP Request failed.

Here is where I am at with my script....

Code: [Select]
mysql_select_db("scraped") or die(mysql_error());
$result = mysql_query("SELECT PKEY, URL, HASSCRAPED, SHOULDSCRAPE FROM CRAWLED WHERE SHOULDSCRAPE ='1' AND HASSCRAPED = '0'") or die(mysql_error()); 

while($row = mysql_fetch_array( $result )) {
mysql_query("UPDATE CRAWLED SET CRAWLED.HASSCRAPED =  '1' WHERE CRAWLED.URL = '" . $row['URL'] . "'");
$html = file_get_html($row['URL']);
foreach($html->find('div[class="itemHeader address"]') as $div) {
foreach($div->find('a') as $element){
$CleanData = CleanData($element->innertext);
if (strlen($CleanData[0]) > 5){
    mysql_query("INSERT INTO SCRAPED (ADDR1, CITY, STATE, ZIP, URL, DATE) VALUES ('" . $CleanData[0] . "','" . $CleanData[1] . "','" . $CleanData[2] . "','" . $CleanData[3] . "','". $row['URL'] . "','". date( 'Y-m-d H:i:s ' ) ."')");
        }
}
}

$html->clear();
unset($html);
unset($CleanData);
}

function CleanData($data) {
  $NewData = trim($data);
  $NewData = str_replace("<em>", "", $NewData);
  $AddrCityStateZip = explode("</em>",$NewData);
  $CityStateZip = explode(",",$AddrCityStateZip[1]);
  $StateZip = explode(' ',$CityStateZip[1]);
  $NewDataArray = array ($AddrCityStateZip[0], $CityStateZip[0], $StateZip[1], $StateZip[2]);
  return $NewDataArray;
  unset($NewData);
  unset($AddrCityStateZip);
  unset($CityStateZip);
  unset($StateZip);
}
mysql_close($link);
echo 'Scraping has compleated without error';

Hi all,

this is driving me crazy - I must be doing something obviously wrong.  I want to load the Microsoft PHP PDO drivers.  I have checked my phpinfo and found the following:-

PHP Version 5.3.8
Loaded Configuration File    C:\Program Files (x86)\PHP\php.ini
extension_dir                           C:\Program Files (x86)\PHP\ext

So I put the file 'php_pdo_sqlsrv_53_ts_vc9.dll' in the extension dir.

I then added the following line the correct php.ini file:-

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
extension=php_pdo_sqlsrv_53_ts_vc9.dll

But when I check php info the sqlsrv driver does not appear to be loaded, not even after a reboot.  All I see is:

PDO drivers    mysql, odbc, sqlite

Not sure what I have missed.  How can I tell if PHP has tried to load the sqlsrv drivers?

Thanks

Kev

This topic has been moved to PHP Installation & Configuration.

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

This topic has been moved to Installation in Windows.

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

$body = <<<EMAIL
Hello <[fname]>,

You've registered and need to activate your account. Click the link below or paste it into the URL bar of your web browser

http://blahblah.com/activate.php?id=<[id]>&code=< Code: [Select]
>

Thanks!

Team
EMAIL;

The <[id]> isn't working. It literally sends out <[id]> in the email.

Can someone help me with my problem
i'm trying to make and thing to update my database
so i can update first name last name and login
but i get a "query failed"

update-exec.php


<?php
//Start session
session_start();

//Include database connection details
require_once('config.php');

//Array to store validation errors
$errmsg_arr = array();

//Validation error flag
$errflag = false;

//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
die("Unable to select database");
}

//Function to sanitize values received from the form. Prevents SQL injection
function clean($str) {
$str = @trim($str);
if(get_magic_quotes_gpc()) {
$str = stripslashes($str);
}
return mysql_real_escape_string($str);
}

//Sanitize the POST values
$fname = clean($_POST['fname']);
$lname = clean($_POST['lname']);
$login = clean($_POST['login']);

//Input Validations
if($fname == '') {
$errmsg_arr[] = 'First name missing';
$errflag = true;
}
if($lname == '') {
$errmsg_arr[] = 'Last name missing';
$errflag = true;
}
if($login == '') {
$errmsg_arr[] = 'login missing';
$errflag = true;
}




//Create INSERT query
$qry = "INSERT INTO members(firstname, lastname, login,) VALUES('$fname','$lname','$login')";
$result = @mysql_query($qry);

//Check whether the query was successful or not
if($result) {
header("location: member-index.php");
exit();
}else {
die("Query failed");
}
?>

<form id="loginForm" name="loginForm" method="post" action="update-exec.php">
First Name<input name="fname" type="text" value="<?php echo $_SESSION['SESS_FIRST_NAME'];?>" class="textfield" id="fname" />
Last Name<input name="lname" type="text" value="<?php echo $_SESSION['SESS_LAST_NAME'];?>" class="textfield" id="lname" />
Login<input name="login" type="text" value="<?php echo $_SESSION['SESS_USERNAME'];?>" class="textfield" id="login" />
<input type="submit" name="Submit" value="Update" />
</form>

Hi for the following product.php page.

<?php

error_reporting(E_ALL);
ini_set('display_errors', '1');
?>





<?php

if (isset($_GET['id'])) {
    // Connect to the MySQL database  

    include "storescripts/connect_to_mysql.php";


    $id = preg_replace('#[^0-9]#i', '', $_GET['id']);

    //$id = $_GET['id'];
    
    $sql = mysql_query("SELECT * FROM products WHERE id='$id' LIMIT 1");
    $productCount = mysql_num_rows($sql); // count the output amount
    if ($productCount > 0)

 {
        // get all the product details
        while($row = mysql_fetch_array($sql)){
             $product_name = $row["product_name"];
             $price = $row["price"];
             $details = $row["details"];
             $category = $row["category"];
             $subcategory = $row["subcategory"];
             $date_added = strftime("%b %d, %Y", strtotime($row["date_added"]));
         }
        
    } else
 {
        echo "That item does not exist.";
        exit();
    }
        
} else {
    echo "Data to render this page is missing.";
    exit();
}
mysql_close();
?>





<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title><?php echo $product_name; ?></title>

<link rel="stylesheet" href="style/style.css" type="text/css" media="screen" />
</head>
<body>
<div align="center" id="mainWrapper">
  <?php include_once("template_header.php");?>
  <div id="pageContent">
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <table width="100%" border="0" cellspacing="0" cellpadding="15">
  <tr>
    <td width="19%" valign="bottom"><p><img src="inventory_images/<?php echo $id; ?>.jpg" width="104" height="132" alt="<?php echo $product_name; ?>" /></p>
      <p><br />
        <a href="inventory_images/<?php echo $id; ?>.jpg">View Full Size Image</a></p></td>
    <td width="81%" valign="top"><h3><?php echo $product_name; ?></h3>
      <p><?php echo "$".$price; ?><br />
        <br />
        <?php echo "$subcategory $category"; ?> <br />
<br />
        <?php echo $details; ?>
<br />
        </p>
      <form id="form1" name="form1" method="post" action="cart.php">
        <input type="hidden" name="pid" id="pid" value="<?php echo $id; ?>" />
        <input type="submit" name="button" id="button" value="Add to Shopping Cart" />
      </form>
      </td>
    </tr>
</table>
  </div>
  <?php include_once("template_footer.php");?>
</div>
</body>
</html>

when i click on image link.. i get   ReadResponse() failed: The server did not return a response for this request.     pl help asap
Edited by mac_gyver, 25 September 2014 - 08:21 AM.
code tags please

Hi guys,

I'm getting the following error when i try to upload an image:

Code: [Select]
Warning: copy() [function.copy]: open_basedir restriction in effect. File(C:\Windows\Temp\phpAF5B.tmp) is not within the allowed path(s): (C:\Inetpub\vhosts\truvibefm.com\httpdocs\) in C:\Inetpub\vhosts\truvibefm.com\httpdocs\testarea\imageupload\upload.php on line 25
Out of commonsense i check the open_basedir in php.ini and it is set too: C:\Inetpub\vhosts\truvibefm.com\httpdocs

Thanks for you time!
J

My php script is:
Code: [Select]
<?php
$SafeFile = $HTTP_POST_FILES['ufile']['name'];
$SafeFile = str_replace("#", "No.", $SafeFile);
$SafeFile = str_replace("$", "Dollar", $SafeFile);
$SafeFile = str_replace("%", "Percent", $SafeFile);
$SafeFile = str_replace("^", "", $SafeFile);
$SafeFile = str_replace("&", "and", $SafeFile);
$SafeFile = str_replace("*", "", $SafeFile);
$SafeFile = str_replace("?", "", $SafeFile);

$uploaddir = "uploads/";
$path = $uploaddir.$SafeFile;

if($ufile != none){ //AS LONG AS A FILE WAS SELECTED...

    if(copy($HTTP_POST_FILES['ufile']['tmp_name'], $path)){ //IF IT HAS BEEN COPIED...

        //GET FILE NAME
        $theFileName = $HTTP_POST_FILES['ufile']['name'];

        //GET FILE SIZE
        $theFileSize = $HTTP_POST_FILES['ufile']['size'];

        if ($theFileSize>999999){ //IF GREATER THAN 999KB, DISPLAY AS MB
            $theDiv = $theFileSize / 1000000;
            $theFileSize = round($theDiv, 1)." MB"; //round($WhatToRound, $DecimalPlaces)
        } else { //OTHERWISE DISPLAY AS KB
            $theDiv = $theFileSize / 1000;
            $theFileSize = round($theDiv, 1)." KB"; //round($WhatToRound, $DecimalPlaces)
        }

echo <<<UPLS
<table cellpadding="5" width="300">
<tr>
    <td align="Center" colspan="2"><font color="#009900"><b>Upload Successful</b></font></td>
</tr>
<tr>
    <td align="right"><b>File Name: </b></td>
    <td align="left">$theFileName</td>
</tr>
<tr>
    <td align="right"><b>File Size: </b></td>
    <td align="left">$theFileSize</td>
</tr>
<tr>
    <td align="right"><b>Directory: </b></td>
    <td align="left">$uploaddir</td>
</tr>
</table>

UPLS;

    } else {

//PRINT AN ERROR IF THE FILE COULD NOT BE COPIED
echo <<<UPLF
<table cellpadding="5" width="80%">
<tr>
<td align="Center" colspan="2"><font color=\"#C80000\"><b>File could not be 

uploaded</b></font></td>
</tr>

</table>

UPLF;
    }
}

?>

How can I check to see if a query has failed, be it INSERT, UPDATE, DELETE or SELECT?

I want to return one value if the query fails, but a different one if it works.

For example, if I have a query to delete a row, but somehow this query fails because the row doesn't exist, then I want to check that it's failed and then output a result

Ok, I'm having some trouble with file_get_contents failing & am trying to make a loop that will sleep & then retry a maximum of 3 times before giving up & moving to the next item. I tried using a while loop but I'm getting unexpected T_WHILE, which I assume is because it's already in a while loop?

I found this:

Code: [Select]
$maxTries = "3";
for ($try=1; $try<=$maxTries; $try++) {

but could use some clarification. Will that only trigger if it failes or do I need to include another if statement like

Code: [Select]
$myfile = file_get_contents("http://example.com");
if ($myfile === FALSE) {
$maxTries = "3";
for ($try=1; $try<=$maxTries; $try++) {
sleep(3);
$myfile = file_get_contents("http://example.com");
}
else {
//continue with script

I hope that makes sense...trying to explain it as best I can without having to post my actual source code as I've had it stolen off forums before & now I have a clone to compete with. I'm not great at putting this into words so if I need to clarify, please feel free to ask. I appreciate any & all help given. Thanks!

I'm having a rough time getting an AS3 application working with a PHP script.

The PHP script takes POST variables and then sends an email using SMTP.

When running it through a standard HTML form, the PHP side works perfectly.

However, when I send the exact same POST variables through AS3 to the script, I get this error.

Failed to set sender: phpemailtesting@gmail.com [SMTP: Failed to write to socket: not connected (code: -1, response: )]

So, I'm not really sure what the issue is here... Here's some code that might help.

//print_r($_POST);
require_once('Mail-1.2.0/Mail.php');

$from = isset($_POST['emailfrom']) ? $_POST['emailfrom'] : '';
$to = isset($_POST['emailsubject']) ? $_POST['emailto'] : '';
$bcc = isset($_POST['bcc'])? $_POST['bcc'] : '';
$subject = isset($_POST['emailsubject']) ? $_POST['emailsubject'] : '';
$body = isset($_POST['emailbody']) ? $_POST['emailbody'] : '';
$ssl = isset($_POST['ssl']) ? $_POST['ssl'].'://' : '';
$smtp_server = isset($_POST['smtpserver']) ? $_POST['smtpserver'] : '';
$password = isset($_POST['emailpassword']) ? $_POST['emailpassword'] : '';
$port = isset($_POST['port']) ? $_POST['port'] : '';
$success_counter = 0;
$fail_counter = 0;
$bigerror;

if($from!='' && $to!='' && $subject!='' && $body!='' && $smtp_server!='' && $password!='' && $port!='') {
if($bcc!='') {
$bcc_array = explode(',',$bcc);
}
$host = $ssl . $smtp_server;
$smtp = Mail::factory('smtp', array('host'=>$host, 'port'=>$port, 'auth'=>true, 'username'=>$from, 'password'=>$password));

$header = array('From'=>$from, 'To'=>$to, 'Subject'=>$subject);
$mail = $smtp->send($to, $header, $body);

        if (PEAR::isError($mail)) {
$bigerror = $mail->getMessage();
$fail_counter++;
           //echo("<p>Message failed".$to." :<br />" . $mail->getMessage() . "</p>");
        } else {
$success_counter++;
         //echo("<p>Message successfully sent to <b>". $to ."</b>!</p>");
        }

for($counter=0; $counter<count($bcc_array) && $counter<=99; $counter++) {
$header = array('From'=>$from, 'To'=>$bcc_array[$counter], 'Subject'=>$subject);
$mail = $smtp->send($bcc_array[$counter], $header, $body);

if (PEAR::isError($mail)) {
$bigerror = $mail->getMessage();
//echo("<p>Message failed".$bcc_array[$counter]." :<br />" . $mail->getMessage() . "</p>");
$fail_counter++;
} else {
         //echo("<p>Message successfully sent to <b>". $bcc_array[$counter] ."</b>!</p>");
$success_counter++;
}
}
//echo "<br /><br />Successful emails: " . $success_counter;
//echo "<br />Failed emails: " . $fail_counter;
echo $success_counter.",".$fail_counter.",".$bigerror;
} else {
echo "error";
//echo '<p>Some information is missing, please try again!</p>';
}


Then, the AS if anybody's interested in seeing it.

Code: [Select]
//Create loader to load emailer.php
var loader:URLLoader = new URLLoader(); 
var request:URLRequest = new URLRequest("http://tendollartools.com/testmail/emailer.php"); 

//Create POST variables
var variables:URLVariables = new URLVariables(); 
variables.emailfrom = preferences["smtpLogin"];
variables.emailto = preferences["smtpLogin"];
variables.smtpserver = preferences["smtpServer"];
variables.emailpassword = preferences["smtpPassword"];
variables.ssl = preferences["smtpSSL"];
variables.port = preferences["smtpPort"];
variables.bcc = emails;
variables.emailsubject = preferences["emailSubject"];
variables.emailbody = preferences["emailBody"];

//Set method to POST and set variables as the vars to send to emailer.php
request.method = URLRequestMethod.POST;
request.data = variables; 

//Load emailer.php and run the onEmailComplete function when finished loading
loader.dataFormat = URLLoaderDataFormat.TEXT;
loader.addEventListener(Event.COMPLETE, onEmailComplete); 
loader.load(request);
The preferences object has all the correct information in it... so this is where I'm confused. Why will the exact same POST information work from an HTML form, but not when sent through AS?

I am trying to use the google maps to geocode a location but I get this error:

Warning: file_get_contents(http://maps.google.com/maps/api/geocode/json?address=New London,+Connecticut,+United States&sensor=false): failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request

Code: [Select]
$location_request = "http://maps.google.com/maps/api/geocode/json?address={$city},+{$real_state},+{$real_country}&sensor=false";
$geocode         = file_get_contents($location_request);

What am I doing wrong?  I tried URL encoding the location request but that also didn't work.

This topic has been moved to mod_rewrite.

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

Hi guys,

I have a bit of trouble as I am trying to extact the data from mysql database when I enter the url as something like this:

Code: [Select]
http://www.mysite.com/login.php?user=test&pass=test

<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myuser');
    define('DB_PASSWORD', 'mypass');
    define('DB_DATABASE', 'mydbname');
       
    $errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {

die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
    $user = clean($_GET['user']);
    $pass = clean($_GET['pass']);
    $login = clean($_GET['login']);


if($user == '' && $pass == ''){
   // both are empty
   $errmsg_arr[] = 'Both name and email are missing. You must enter one or the other.';
   $errflag = true;
}

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
$insert = array();
if(isset($_GET['user'])) {
    $insert[] = 'user = \'' . clean($_GET['user']) .'\'';
}
if(isset($_GET['pass'])) {
    $insert[] = 'pass = \'' . clean($_GET['pass']) . '\'';
}
if(isset($_GET['login'])) {
    $insert[] = 'login = \'' . clean($_GET['login']) . '\'';
}

if (count($insert)>0) {
   $names = implode(',',$insert);


if(isset($user) && isset($pass)) {
   $query  = "SELECT username, LoggedUser FROM Login WHERE username='$user'";
   $result=mysql_query($query) or die('Error:<br />' . $qry . '<br />' . mysql_error());
   echo "<p id='LoggedUser'>";
   echo $row['LoggedUser'] . "</p>";
} elseif(isset($user) && isset($login)) {
   $sql="UPDATE Login SET {$login} where username='{$user}'";
   echo "<p id='LoggedUser'>";
   echo $row['LoggedUser1'] . "</p>";
 }
}
}
?>

when I entered the url, there are empty array which it did not filled on the webpage.

I want to extact the data from the database when I enter the url like on above.

Please can you help?

Thanks,
Mark

Hey folks,   is there some particular reason not able to use / bind ipv6 address as pasrt of a default interface and address in mysql?   For examle, no such thing as a problem when using a loopback ipv6 addr:   /etc/my.cnf

bind-address=::1 // works fine

// but 

bind-address=fe80::216:3eff:fe97:9f35 // failed

eth0      Link encap:Ethernet  HWaddr 00:16:3E:97:9F:35  
          inet addr:192.168.122.2  Bcast:192.168.122.255  Mask:255.255.255.0
          inet6 addr: fe80::216:3eff:fe97:9f35/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:897358 errors:0 dropped:0 overruns:0 frame:0
          TX packets:166433 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:84292777 (80.3 MiB)  TX bytes:177566584 (169.3 MiB)