PHP - Capture Xml String In Php Page

Greetings experts,

Please forgive me for this cheap question.

I have got a calendar of events and displays events for  7 departments.

For each department, we would like the calendar to display events specific to that department.

The way I am thinking about doing this is to grab the department from the url and compare it with the department on the db for which events is inserted into the db with.

If there is a match, then display the events for that department.

Something like:

    $tquery = "select * from ".$EVENTS_TB." where ".$EVENTS_TB.".month='".$smmonth."' and ".$EVENTS_TB.".year='".$smyear."' and ".$EVENTS_TB.".deptid='deptFromQueryString' " ;

The problem that I have is that I don't in php, how to capture the querystring from url.

For instance, assume this  is the url:

http://www.domain.com/departName.

DeparmentName represents the department value.

How do I capture the query above?

Thanks so much.

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 

Greetings,

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>
";
}
}

?>

Ok, I'm trying to play with custom error handeling, and not getting anywhere. 
I have some code I made up just to mess about and get a feel for this, but no matter what I try I get nothing thrown out and no error caught. 
I did have it all in the one class, but got strongly advised that was a bad bad bad thing to do, so in an effort to keep the focus on the actual problem I've moved it off into it's own class.

Here's the code, it's self contained (as I said its only a play around) but I would really appreciate it if someone could explain why the errors arn't being caught:
<?php
//------------------------------------------------
class dbc {
public $server;
public $host;
public $db;
public $user;
public $pass;

public function set($var, $val=0){
 try{
  if(is_array($var)){
   foreach ($var as $k => $v) {
    if(!$this->$k = $v){
     throw new Exception('Error Setting Database Information :');
    }     
   }  
  }
  else{
   if(!$this->$var = $val){
    throw new Exception('Error Setting Database Information :');
   }
  }
 }
 catch(Exception $e){
  $setError = array('1', 'set', $e->getMessage());
  $error->ErrorHandle($setError);
 }
}
}
//------------------------------------------------    
class errorCatch{
public $severity;
public $methodCall;
public $message;

public function ErrorHandle($error){
 $this->severity = $error['0'];
 $this->methodCalled = $error['1'];
 $this->message = $error['2'];
 if ($this->severity == 1){
  die ("Critical error in call to dbo-&gt;$methodCall: $message");
 }
 die("Warning Call to $methodCall resulted in a non fatal error: $message");
}
}
//------------------------------------------------
$error = new errorCatch;
$con = new dbc;
$set = array('hst'=>'localhost', 'svr'=>'mysql');
$con -> set($set);
var_dump($error);
?>

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
   }
?>

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;
?>

 

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.

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'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 ?

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

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 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?      

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

Hi Folks,

This is my first post here and I was wondering if anyone could help me out at all please.

I would basically like to change the logo on the home page based on whether a query string from a referring URL has a specific value. It's an affiliate URL for an online store, so essentially I need to get the referrer, check if the query string adnetwork = as and then replace the logo if it does, if not leave it as it is. Does that make sense? Any help would very much appreciated.

I was thinking along the lines of:

<?php

if ($_GET('adnetwork') == 'as') {
changeLogo();
}
else
{
leaveLogo();
}

?>

Am I along the right lines folks?