PHP - Signature Capture With Php

I have a page (input.php) that will allow a user to upload a CSV file. This file has 5 columns (SKU, Product, Quantity, Retail Price, and Total Retail Price). The CSV upload will only have the SKU number and Quantity filled in.

When the user hit upload the (import.php) page is suppose to go to the site and pull the product up by searching the SKU number and pulling the price and product (brand and title).

I paid a freelancer to create this code. I watched it work on his machine. I cant seem to get it to work on mine (wont pull price or product) and he is non-responsive now. Any help would be greatly appreciated!!

I added some note in the code as I was troubleshooting.

 

<?php
ini_set('max_execution_time', 0);
error_reporting(0);
move_uploaded_file($_FILES["file"]["tmp_name"], "upload/". $_FILES["file"]["name"]);
$handle = fopen("upload/". $_FILES["file"]["name"], "r");
$file = '';
$line .= "SKU,Product,Quantity,Retail Price,Total Retail Price";
$file .=  $line . PHP_EOL;
for ($i = 0; $row = fgetcsv($handle ); ++$i) {
    // Do something will $row array
	if($row[0]!="" AND $i>0)
	{
		$line="";
		#echo "<pre>";
		#print_r($row);
		$SKU=$row[0];
		$quantity=$row[2];
		$loop=1;
		do{
			$url = "https://www.homedepot.com/s/".$SKU;
			$ch = curl_init();
			curl_setopt($ch, CURLOPT_URL, $url);
			curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
			curl_setopt($ch, CURLOPT_HEADER, 1);
			$response = curl_exec($ch);
			
			$header_size = curl_getinfo($ch, CURLINFO_HEADER_SIZE);
			$headers = substr($response, 0, $header_size);
			$body = substr($response, $header_size);
			curl_close($ch);
			
			header("Content-Type:text/plain; charset=UTF-8");
			$headers_arr = explode("\r\n", $headers);
			$str=$headers_arr[5];
			$arr=explode(":",$str);
			$check=trim($arr[0]);
			#echo $check; ### remove troubleshooting
			if($check=="location")  # made lowercase so it would get inside the If statement
			{
				#echo "Dustin"; ## remove troubleshooting
				$productPageLink=$headers_arr[5];
				$productPageLink=str_replace("Location:","",$productPageLink);
				#echo $productPageLink; ## troubleshooting -- seems to be getting the links
				$productPageLink=trim($productPageLink);
				$productPageLink=str_replace("http:","https:",$productPageLink);
				#echo $productPageLink; ## troubleshooting -- still seems to have links
				
				$ch = curl_init();	
				#echo $ch; ##troubleshooting -- prints out "resouce id"
				curl_setopt($ch, CURLOPT_URL, $productPageLink);
				#echo $ch; ##troubleshooting -- prints out "resouce id"
				curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
				curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'GET');		
				curl_setopt($ch, CURLOPT_ENCODING, 'gzip, deflate');		
				$headers = array(); 
				$headers[] = 'User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:70.0) Gecko/20100101 Firefox/70.0';
				$headers[] = 'Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8';
				$headers[] = 'Accept-Language: en-US,en;q=0.5';
				$headers[] = 'Upgrade-Insecure-Requests: 1';
				$headers[] = 'Connection: keep-alive';
				$headers[] = 'Te: Trailers';
				#echo $headers; ##troubleshooting -- ## Troubleshooting -- prints out "Array"
				curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
				
				$result = curl_exec($ch);
				#echo $result; ### troubleshooting - doesnt have any data
				if (curl_errno($ch)) {
					echo 'Error:' . curl_error($ch);  # it end inside this if statement, however no error is printed
				}
				curl_close($ch);
				preg_match_all('/<h2 class="product-title__brand" itemprop="brand" data-component="clickable brand link">(.*?)<\/h2>/s', $result, $output_array_brand);
				#echo "<pre>"; ###
				#print_r($output_array_brand);####
				
				$brand=trim(strip_tags($output_array_brand[1][0]));
				
				preg_match_all('/<h1 class="product-title__title">(.*)<\/h1>/', $result, $output_array);
				$productTitle=$output_array[1][0];
				$productTitle=$brand." ".$productTitle;
				
				preg_match_all('/<span class="price__dollars">(.*?)<\/span>/s', $result, $output_array_price);
				preg_match_all('/<span class="price__cents">(.*)<\/span>/', $result, $output_array_cent);
				#echo "<pre>";
				#print_r($output_array_price);
				$price=trim(strip_tags($output_array_price[1][0]));
				$cent=trim(strip_tags($output_array_cent[1][0]));
				if($cent!="" OR $cent!=0)
				{
					$price=$price.".".$cent;
				}
				$line.=$row[0].",";
				$line.='"'.$productTitle.'",';
				$line.=$row[2].",";
				$line.=$price.",";
				$totalPrice=$row[2]*$price;
				$line.=$totalPrice;
				$file .=  $line . PHP_EOL;   
			}
				
			# echo "<br>";
		 $loop=$loop+1;
		 #echo "<br>";
		 if($loop>4)
		 {
			 if($check!="Location")
			 {
				$line.=$row[0].",";
				$line.=',';
				$line.=$row[2].",";
				$line.=",";
				$line.="";
				$file .=  $line . PHP_EOL;   
				break;
			 }
		 }
		}
		while($check!="Location");
		
				
	}
}
fclose($handle);
header('Content-Type: application/csv'); 
$output=$_REQUEST['output'];
		header('Content-disposition: attachment; filename='.$output.'.csv');
		
		echo $file;
		#header('Content-disposition: attachment; filename='.$output.'1.csv');
		
		#echo $file1;
		exit;
?>

 

Greetings,

Hi,

I am making login page with database and php. I need to be able when the person clicks theogin button to take photo of the person and add it to that same database based on the info entered.

 

I am doing this to know if that person that logged in is the person in reality.

 

Is it possible 

I need assistance with a few things with my coding.
1. where I grab the filename content...$filename = file_get_contents($_FILES['uploadedfile']['name']); will that work since I already moved the file to the /temp/files/? if not how would i say look in that folder?

2. two upload happen with my script one is for the .csv file and the other are the docx files. what I need help with is to capture the filenames from the flash part so i can upload them to /temp/files

3. as you can see i'm trying to use this as a php_self so how would i go about removing the upload.php in the upload_url for the flash? do I just put the name of the page or php_self code?

Code: [Select]
<?php
if(isset($_POST['submit'])) {

// check .csv file has been uploaded... and on the server proceed   
    if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], '../temp/files/')) {
     $filename = file_get_contents($_FILES['uploadedfile']['name']);
     
//*** process flash upload save files to /temp/files/ should go here

     $handle = fopen("$filename", "r");
     while (($data = fgetcsv($handle, 100000, ",")) !== FALSE) {
     if(file_exists('/temp/files/'. $data[0] .'.docx')) {
$import="INSERT into kmmb_member1(docx_id,no_ahli,no_pin,nama,no_ic_baru,no_ic_lama) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]')";
        mysql_query($import) or die(mysql_error());

//***  after insert move file
    rename('/temp/files/'. $data[0] .'.docx', '/docx_files/'. $data[0] .'.docx');

  }  
     }
     fclose($handle);
     print "Import done";
  
   } else {
      echo "There was an error uploading the *.csv file, please try again!";
}   
     
} else {
   
?>

<!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" xml:lang="en" lang="en">
<head>
<title></title>
<link href="swf_up/css/default.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="swf_up/swfupload/swfupload.js"></script>
<script type="text/javascript" src="swf_up/swfupload/swfupload.queue.js"></script>
<script type="text/javascript" src="swf_up/js/fileprogress.js"></script>
<script type="text/javascript" src="swf_up/js/handlers.js"></script>
<script type="text/javascript">
var swfu;

SWFUpload.onload = function () {
var settings = {
flash_url : "swf_up/swfupload/swfupload.swf",
flash9_url : "swf_up/swfupload/swfupload_fp9.swf",
upload_url: "swf_up/upload.php",
post_params: {
"PHPSESSID" : "NONE",
"HELLO-WORLD" : "Here I Am",
".what" : "OKAY"
},
file_size_limit : "100 MB",
file_types : "*.*",
file_types_description : "All Files",
file_upload_limit : 100,
file_queue_limit : 0,
custom_settings : {
progressTarget : "fsUploadProgress",
cancelButtonId : "btnCancel"
},
debug: false,

// Button Settings
button_image_url : "swf_up/XPButtonUploadText_61x22.png",
button_placeholder_id : "spanButtonPlaceholder",
button_width: 61,
button_height: 22,

// The event handler functions are defined in handlers.js
swfupload_preload_handler : swfUploadPreLoad,
swfupload_load_failed_handler : swfUploadLoadFailed,
swfupload_loaded_handler : swfUploadLoaded,
file_queued_handler : fileQueued,
file_queue_error_handler : fileQueueError,
file_dialog_complete_handler : fileDialogComplete,
upload_start_handler : uploadStart,
upload_progress_handler : uploadProgress,
upload_error_handler : uploadError,
upload_success_handler : uploadSuccess,
upload_complete_handler : uploadComplete,
queue_complete_handler : queueComplete // Queue plugin event

};

swfu = new SWFUpload(settings);
}

</script>
</head>
<body>


<div id="content">

<h2>Upload</h2>
<form id="form1" action="index.php" method="post" enctype="multipart/form-data">
<div id="divSWFUploadUI" style="margin-top: 20px;">
<span>Select .csv file:
<input name='uploadedfile' type='file' /><br />
</span>
<div class="fieldset  flash" id="fsUploadProgress">
<span class="legend">Upload Queue</span>
</div>
<p id="divStatus">0 Files Uploaded</p>
<p>
<span id="spanButtonPlaceholder"></span>
<input id="btnCancel" type="button" value="Cancel All Uploads" disabled="disabled" style="margin-left: 2px; height: 22px; font-size: 8pt;" />
<br />
</p>
</div>
<!-- -->

</form>
</div>
</body>
</html>


<?php
   }
?>

1-    Write a PHP program that goes through all integers between 1 and 100 (excluding 1 and 0) and displays each even number on a separate line.

2-   Re-write the program in question 1 but this time use a function to go through the numbers and display them.

I have the following.  How can I do the other one?   

<?php

for ($i = 2; $i <= 100; $i++)
{
if ($i % 2 == 0){
print $i . " <Br>
";
}
}

?>

How do i capture and get the xml data send by other page to my php page?

Let say my page is mypage.php. I send some parameters to otherpage.php. otherpage.php send xml data (eg. delivery status) to mypage.php. On the browser itself i still on mypage.php. otherpage.php does not send data in parameter value.. that where i feel lost.

Please help.. 

I wrote a VB6 app that uses a web browser control to create an inbuilt instance of IE.
I then used that to navigate to a LOC web page, do a search and collect MARC tag data.

I was wondering how you could do this in PHP.?
I put up some attachments that show this working in VB6.

The searchable web page that returns results is here
http://www.loc.gov/cgi-bin/zgate?ACTION=INIT&FORM_HOST_PORT=/prod/www/data/z3950/locils2.html,z3950.loc.gov,7090

So you do a search for something.
LOC gives you a list.
You click on an item in the list where it says 'more on this record'
then you click 'tagged display'
And that is the data you want to have collected into your variable.
I created a Download Icon on the web browser control that turns green when the data is displayed.

Do you somehow create your own web browser instance?
or? I am new to PHP and have figured out a few things.
I created this here in PHP
http://www.sdowney717.byethost16.com/mysearch2first.php

Hi there,

I am trying to edit my shopping cart page so that i can use a different shipping rate for each country that i ship to. At the minute this is the code i use:


*/
if(isset($_GET['eushipping'])||(isset($_POST['rec_country'])&&$_POST['rec_country']!='uk')){
$shipping = ceil($total/30.00)*20.00;
   }
   
I though it if i just changed the value 'eushipping' to the country option value it would work but it doesn't.



Can anyone point me in the write direction of what i need to change? 


Many thanks.

Hash

Hello PHPers,

One more help I think may be wrong.  I currently have code as $_GET['width'] . "x" . $_GET['height'];.  This provides continually with 640 * 480. 

 believe this to be incorrect as I do not think that everyones screen is set to this.  Neither is my screen resolution and is still capturing these figures.

Is there something wrong with the variable that should be changed so that it can pick up the visitors screen resolution.
Thank you kindly,
HJ

I currently have Wordpress 3.1 running in network mode so that I could have 1 site but in 2 languages.

the url's are as follows:

http://mysite.com/ - English
http://mysite.com/fr - French

I want to have a link embedded in the template that will say either French or English and when clicked take the user to the same page they are viewing but in the other language. All my pages and articles on both sites will have the same permalinks, so what I want to have is a link that will grab the current url or page being viewed and add the fr into the link automatically, so that I never have to manually update these links.

Example:
When viewing Page 1 English, the href would automatically provide a link to Page 1 in French, and update itself dynamically as you viewed different pages..

mysite.com/page1 turns into mysite.com/fr/page1

Is this possible?

Thanks for everyones help.

Hi All   I am hoping someone can help.   I am trying to create a session based on when the users first enters the page. This will capture the timestamp and retain that as the starting point for the countdown so even if the user goes away from the page and comes back, the timestamp does not reinstantiate itself.   Can anyone give me some guidance please?      

I'd like to capture the text of a PHP warning.

This is an internal process, no one will ever visit these php pages, so I want to send myself an email if the process fails.  Right now, as part of debugging this, I am forcing failures and echoing the content of my email to the page.  The first test is to use the wrong password. The following message is put on the page (broken into 3 sections for discussion purposes).

A) Warning: mysql_connect() [function.mysql-connect]:
B) Access denied for user 'xxx'@'localhost' (using password: YES)
C) in E:\php\www\folder\DatabaseConnectionInfo.php on line 8

mysql_error() gives me part B. 
Access denied for user 'xxx'@'localhost' (using password: YES)

How can I get parts A and C ?

As part of my User Profile, I have a series of open-ended questions that Members can answer, e.g...
Quote

1.) Why did you start your own business?
2.) If you could offer one piece of advice to other entrepreneurs, what would it be?
:
10.) How do you compete against large corporations?



I was leaning towards creating a many-to-many relationship like this...

member -||---------0<- answer ->0---------||- question


From a database standpoint this works great, HOWEVER, I just realized a big problem...

If run this query...

Code: [Select]
SELECT response
FROM answer
WHERE member_id = 1;
...then I would get TEN RECORDS back and I don't know of any way to maps those to the 10 Text Boxes on the "My Thoughts" page?!

(It would be a real PITA to have to create 10 separate Prepared Queries in PHP - one for each Field - to fill out my page?!)

So, is there a way to keep my table structure, but push the 10 records from above into 10 separate variables so I would have something like $response1, $response2,... $response10 ??

Thanks,


Debbie

Need some help to define the php logic to echo back a selection if/when chosen from the drop down menu.
Note: I'm using just a small subset of the USA states to show setup and what I'm trying to accomplish - it will be the same for all the other drop down menus as well....

Here's the example code:

Code: [Select]

<form name="form1" method="post" action="<?php $_SERVER[PHP_SELF]; ?>">
<select name="address_state" id="address_state" tabindex="25">
<option value="" selected> - Select State -</option>
<option value="AK">Alaska</option>
<option value="AL">Alabama</option>
<option value="AR">Arkansas</option>
<option value="AZ">Arizona</option>
<option value="CA">California</option>
<option value="CO">Colorado</option>
<option value="CT">Connecticut</option>
<option value="DC">District of Columbia</option>
</select>

<input name="submit" type="submit" value="submit" tabindex="900" id="submit" />
</form>

Issue: I have validation (logic) define to check all the (other) text, radio, and check boxes of the form and that all works great! However, any time one of those particular fields fail validation, any selected "drop down" item is lost - it defaults back to no selection and the user has to make all drop down menu selections again.

Can someone provide method to echo back - in php being the page reloads to itself - the drop down selection as in the example above?
Thanks!

Hi guys,

I have an intention to allow user to select multiple district, however even though when they select more than 2 options in the district, it turns out my database is only able to capture the last value.

For instance, I chose ID=1 ID=2, however the return value to my database will be only ID=2.

Is there something which I have missed out? Your advice is greatly appreciated. Thank you

<?php
$district = $_POST['district'];

if (isset($_POST['submit'])) { 
$dbc = mysqli_connect('localhost', '***', '***', '***')
    or die(mysqli_error());

$query2 = "INSERT INTO tutor_preferred_dlocation (district_id) VALUES ('$district')";

$result2 = mysqli_query($dbc, $query2)
or die(mysqli_error());
}


<input name="district" type="checkbox" id="1" value="1">
<label for="yishun">Yishun</label>
    
<input name="district" type="checkbox" id="2" value="2">
<label for="angMoKio">Ang Mo Kio</label>
    
<input name="district" type="checkbox" id="3" value="3">
<label for="yioChuKang">Yio Chu Kang</label>

?>