I'm facing this problem where the scraper gets stuck and when I refresh the page it resets the scraping from the beginning. Is their a way to make the scraper go straight to where it left off from then start at the begging. The scraper is php build and it uses simplehtmldom to get the content.

Note: I have limited knowledge in scraping in general.

function get_web_page( $url )
{
    $user_agent='Mozilla/5.0 (Windows NT 6.1; rv:8.0) Gecko/20100101 Firefox/8.0';

$options = array(

    CURLOPT_CUSTOMREQUEST  =>"GET",        //set request type post or get
    CURLOPT_POST           =>false,        //set to GET
    CURLOPT_USERAGENT      => $user_agent, //set user agent
    CURLOPT_COOKIEFILE     =>"cookie.txt", //set cookie file
    CURLOPT_COOKIEJAR      =>"cookie.txt", //set cookie jar
    CURLOPT_RETURNTRANSFER => true,     // return web page
    CURLOPT_HEADER         => false,    // don't return headers
    CURLOPT_FOLLOWLOCATION => true,     // follow redirects
    CURLOPT_ENCODING       => "",       // handle all encodings
    CURLOPT_AUTOREFERER    => true,     // set referer on redirect
    CURLOPT_CONNECTTIMEOUT => 120,      // timeout on connect
    CURLOPT_TIMEOUT        => 120,      // timeout on response
    CURLOPT_MAXREDIRS      => 10,       // stop after 10 redirects
);

$ch      = curl_init( $url );
curl_setopt_array( $ch, $options );
$content = curl_exec( $ch );
$err     = curl_errno( $ch );
$errmsg  = curl_error( $ch );
$header  = curl_getinfo( 

Select all Open in new window

…

I am refactoring an older system written in Php/Mysql.  In this code I am seeing several instances of 'return -1' and I'm not clear why this could be.

function mysql_connection($database){
      if(!isset($database)){
            return -1;
        }

        more code ...
}

I'm a novice and have not found an answer in any of my research.

Can someone help me understand why this would be used?

I have inherited a program where the date field in a MySQL table is really a VARCHAR field.  The date looks like this string:  1260777185.  I can't change the format of the field because of various reasons.  How can I change/convert this field to a date format in my query?  It needs to be done at the query level.  The field is called timestamp.  

I'm using this query, but the field is blank once the query has been run.

SELECT amount, description, STR_TO_DATE('timestamp', '%m/%d/%Y') AS transdate FROM transactions

Thank you.

I'm using this little function in order to "see" the results of a prepared SELECT statement:

<?php

function interpolateQuery($query, $params) {
    $keys = array();

    # build a regular expression for each parameter
    foreach ($params as $key => $value) {
        if (is_string($key)) {
            $keys[] = '/:'.$key.'/';
        } else {
            $keys[] = '/[?]/';
        }
    }

    $query = preg_replace($keys, $params, $query, 1, $count);

    #trigger_error('replaced '.$count.' keys');

    return $query;
}

function select() {

$query="SELECT usrID ,E.empID ,usrEEID ,usrFN ,usrLN ,usrDOB ,usrCity ,usrState ,usrZip ,usrUsername ,usrPassword FROM hraUsers U INNER JOIN Employers E on U.empID = E.empID INNER JOIN ChannelPartners CP on E.cpID = CP.cpID WHERE usrDOB = ? AND usrEEID LIKE ? AND E.empPID = ?";

$params=array();
$params=array("08/26/1963", "12345", "8975");

$test=interpolateQuery($query, $params);
echo $test;

}

$view=select();

?>

Select all Open in new window

You can see it in action at http://brucegust.com/adm/applied/pdo_sql_test.php

The page that I'm trying to troubleshoot is a little more complicated.

Here's the SQL:

SELECT usrID ,E.empID ,usrEEID ,usrFN ,usrLN ,usrDOB ,usrCity ,usrState ,usrZip ,usrUsername ,usrPassword FROM hraUsers U INNER JOIN Employers E on U.empID = E.empID INNER JOIN ChannelPartners CP on E.cpID = CP.cpID WHERE usrDOB = ? AND usrEEID LIKE ? AND E.empPID = ?

The $params, when I do a var_dump, look like this:

array(3) { ["usrDOB"]=> string(10) "11/28/1990" ["usrEEID"]=> string(7) "12345sp" ["E.empPID"]=> int(7542) }

Consequently, when I run everything through the interpolateQuery, I don't get the values, I get the keys.

When I do a var_dump on the first example, I get three string values:

array(3) { [0]=> string(10) "08/26/1963" [1]=> string(5) "12345" [2]=> string(4) "8975" }

So, I'm thinking I need to run my $params through some kind of loop to eliminate the keys so I'm left with just the values.

How would I do that?

i am finding it difficult to get radio button value in php using jquery ajax. every thing work fine if i comment the radio button variable in the php file  below, but if i remove the comment , nothing works. i have been on this for more then a day now. thanks for the help!!!

here is the html and jquery file :

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width">
    <title>Form Validation</title>
	<style>
		.error{
			color:red;
		}
		
		.emai{
			border: solid 2px green;
		}
		
		.error2{
			color: green;
		}
		.textBoxError{
			border: solid 2px red;
	       color: red;
		
		}
	</style>
</head>
<body>



<form method="POST" id="form" name="form" action="">
    <label for="email" >Enter your email</label>
    <input id="email" class="emai" name="email">
	<p id="result"></p>
	<label for="email">Enter your first name</label>
	<input id="firstname" name="firstname">
	<label for="address">address</label>
	<input id="address" name="address">
	 Yes: <input type="radio" name="opt" value="yes">
    No: <input type="radio"  name="opt" value="No" checked="checked">
	<p id="result2"></p>
    <button id="submitform">Submit</button>
	<p id="result3"></p>
</form>

<script src="https://code.jquery.com/jquery-3.1.0.js"></script>
<script>
$( document ).ready(function() {
    $(function(){
        $('#submitform').on('click',function(e){
            e.preventDefault();  // do not allow the default form action
            var 

Select all Open in new window

…

Hello Experts,

I created a 19 question PHP survey program using HTML text areas. It is hosted on my employer's network and can only be accessed via a work computer. The results are anonymous, to some extent. Although I do not collect the survey taker's information, I work in a small department and my boss would know that it came from someone currently working at the moment. My department is open 24/7, 365. So, instead, my boss wants me to dynamically generate a PDF, upon the user's submission, which is not a huge ordeal...but...

How would I accommodate various users' responses, i.e., shorter responses versus longer responses? It'd be nice if each pdf was restricted to X pages, but I don't want to restrict the end user's answer.

Also, if the data extends beyond one page, how do I create additional pages? Would I just use another instance of $pdf->AddPage();?

Hello, Experts,

I built a PHP script that queries a database and outputs the results in JS/HTML form. If you could review the code below, I need help how to make the result field URL clickable.

Example:

Name: John Doe
URL: http://google.com

When results display for John, he is able to see the result set for his name and click on http://google.com

Let me know if you need further clarification.

<?php
//fetch.php
$connect = stuff
$output = '';
if(isset($_POST["query"]))
{
 $search = mysqli_real_escape_string($connect, $_POST["query"]);
 $query = "
  SELECT * FROM emp_details 
  WHERE dept LIKE '%".$search."%'
  OR fname LIKE '%".$search."%' 
  OR lname LIKE '%".$search."%' 
  OR pkid LIKE '%".$search."%' 
  OR url LIKE '%".$search."%'
 ";
}
else
{
 $query = "
  SELECT * FROM emp_details;
 ";
}
$result = mysqli_query($connect, $query);
if(mysqli_num_rows($result) > 0)
{
 $output .= '
  <div class="table-responsive">
   <table class="table table bordered">
    <tr>
     <th>pkid</th>
     <th>fname</th>
     <th>lname</th>
     <th>department Code</th>
     <th>url</th>
    </tr>
 ';
 while($row = mysqli_fetch_array($result))
 {
  $output .= '
   <tr>
    <td>'.$row["pkid"].'</td>
    <td>'.$row["fname"].'</td>
    <td>'.$row["lname"].'</td>
    <td>'.$row["DEPT"].'</td>
    <td>'.$row["url"].'</td>
   </tr>
  ';
 }
 echo $output;
}
else
{
 echo 'Data Not Found';
}

?>

Select all Open in new window

Thank you for looking at my question,

I have a user input form (php) that has some javascript validation which should, if the conditions are met, assign a value to a hidden form element but it isn't working and I can't see why.

	<form name="Form1" action="Forms/Section1.php" method="GET" onSubmit="return jsValidate()">
		<input type="hidden" name="StockItem" />

Select all Open in new window

The javascript validation looks like this

if (z.length == 23){
	if (z.slice(0,2) == "VE" || z.slice(0,2) == "SE"){
		
		//alert("So Far So Good");
		
		document.getElementById("StockItem").value = 1; //Full Build
		alert (document.getElementById("StockItem").value);
	} else {
		errorcount++;
		document.getElementById('VECO').style.color='#FF0000';
	}
} else if (checknum==1){
	
	//alert("So Far So Good");
	
	document.getElementById("StockItem").value = 0; //Component
	alert ("Assembly Stock Item: " + document.getElementById("StockItem").value);
} else {
	errorcount++;
	document.getElementById('VECO').style.color='#FF0000';
}

Select all Open in new window

If either of the conditions are met (z == 23 characters starting VE or SE, or checknum == 1)  then, when it's not commented out, the "So Far So Good" alert appears on the screen but the following

alert(document.getElementById("StockItem").value);

Select all Open in new window

doesn't
and no value is assigned to the StockItem element - as can be seen in the address of the php page the data should pass to

http://xx.xx.xx.xx/ed1/Forms/Section1.php?StockItem=&Meter=1000&ProdnOrder=553456789&SalesOrder=9999&SerialNo=&VECode=VE884S05E0G0T01D0004000

Select all Open in new window

What am I missing?

I had this question after viewing Need If Logic Help That Assigns Different Unique Values.

On the earlier question

// simulate your post
$post = array('illness','fruits');

Select all Open in new window

 these questions are selected manually but I need them to be dynamic based on the users form input.

I have read that if a checkbox isn't selected no values are transmitted but it seems I have something miscoded in my code.  

I thought this line for the immune column

// simulate your post
$post = array('illness','difficulty','odor','antibiotics');

Select all Open in new window

would only produce the value of 3 if I checked the illness question.  Instead it gives a value of 7.  3 for illness + 3 for antibiotics and 1 for difficulty.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
 "http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
<title>Count Checks</title>
</head>
<body>
<h1>Count Checks</h1>
<form method="post">
General Health & Vitality<br />
Please check all that apply<br />
Illness More Than Twice A Year:<input type="checkbox" name="illness[]" value=""><br />
Monthly Female Concerns:<input type="checkbox" name="female[]" value=0><br />
Difficulty Digesting Certain Foods:<input type="checkbox" name="difficulty[]" value=""><br />
Body Odor and/or Bad Breath:<input type="checkbox" name="odor[]" value=""><br />
Recent Or Frequent Use Of 

Select all Open in new window

…

This is my first foray into JSON and I'm trying to develop an autocomplete field with JSON, php and sql.  I've got it working on a single field (employee Name) but would like to add a second field that gets populated by the employee title when the employee name is selected.  

So far, my test page looks like:

<!DOCTYPE html>
<html>
<head>
    <title>Autocomplete Textbox Demo | PHP | jQuery</title>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script>
    <link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/themes/smoothness/jquery-ui.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script>

    <script type="text/javascript">
        $(function() {
            var availableTags = <?php include('fetchEmpName.php'); ?>;
            $("#empName").autocomplete({
                source: availableTags,
                autoFocus:true
            });
        });
    </script>
</head>
<body>
<label>Department Name</label></br>
<input id="empName" type="text" size="50" />
<input id="empTitle" type="text" size="50" />
</body>
</html>

Select all Open in new window

And the fetchEmpName.php file is like:

<?php
require('i_PDOConnection.php');
$query = "SELECT empFName + ' ' + empLName as [empName], empTitle FROM tbl_CouncilStaff WHERE active = 1 AND display = 1 AND (empFName LIKE '%".$search."%' OR empLName LIKE '%".$search."%') ORDER BY empLName";
$stmt = $dbh->prepare($query);
$stmt->execute();
$data = $stmt->fetchAll();
foreach ($data as $row) {
    $empName[] = $row['empName'];
    $empTitle[] = $row['empTitle'];
}
 $arrData = array($empName,$empTitle);
 echo json_encode( $arrData );
?>

Select all Open in new window

The code is working if I only use the $empName or $empTitle array and encode that ($data = $empTitle or $data=$empName.  

However making an array of both arrays causes the empName box to return two blank lines instead of any names or titles when I type.  I get that, but I don't know what to do about it to access the underlying data and have the names list in text box one and populate the employee title to text box two upon a selection.

As always, thanks in advance for any help offered.