PHP - Retrieving Info

Hi,        I am currently working on a inventory page and a page which gets into the details of that particular product. Basically on one page i have a list of products and when i click on one of the products it takes me to another page when has more detail about the product (retrieved from the database). The problem which i am currently stuck on is when i click on say the first product (id=1) it will take me to the second page and show me product 2 (id=2) instead of the first product. here is what i have so far if anyone can assist it would be great.     this is in my first inventory page.--     <div id="viewdetails"><a href="<?php echo BASE_URL .'view/singleproda.php?id='. $info["id"];?>"> View Details</a></div>     this is how my second page looks--.:   include(ROOT_PATH ."controller/mainfunction.php");

There's many options available for downloading a URL - but I'm stuck.

I've looked through all the ones I know, but none seem to pay attention to partial content.

I'm trying to retrieve a URL that gives the following header:
HTTP/1.1 206 Partial Content
Content-Range:   bytes 0-100000/631723

As you can see it dishes out the file in 100,000 byte chunks.

Trouble is, when I use any method in PHP, ie file_get_contents, fopen, or even cURL, none of these continue on after retrieving the 100,000 bytes.

End result, I have a 100,000 byte file.

What I need is to get the PHP script to grab all the data, in the example above, all 631,723 bytes.

How can I do this?

Hi there

I am trying to use cURL to retrieve XML from a gateway. The code I am using works (ie. returns the HTTP response) for any URL that I use except the one that I need!  The URL is below, and when using that I get a blank response every time. I've tested and can telnet to that IP address on that port from my server.

I'm not sure if it is because of the format/structure of the URL? Could it have something to do with the port of the gateway? Any assistance would be much appreciated.

http://196.11.120.190:8080/mtnusa/client.jsp?command=<usareq NODE="tHTTP" USERNAME="HTTP" PASSWORD="1234" TRANSFORM="SMPP"><command><submit_sm><a_number>278200703520709</a_number><b_number>27824411926</b_number><service_type/><message>Test</message><registered_delivery/></submit_sm></command></usareq>

The function I am using (from http://davidwalsh.name) is:

/* gets the data from a URL */
function get_data($url)
{
   $ch = curl_init();
   $timeout = 5;
   curl_setopt($ch,CURLOPT_URL,$url);
   curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
   curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,$timeout);
   $data = curl_exec($ch);
   curl_close($ch);
   return $data;
}

$returned_content = get_data('http://196.11.120.190:8080/mtnusa/client.jsp?command=<usareq NODE="HTTP" USERNAME="HTTP" PASSWORD="1234" TRANSFORM="SMPP"><command><submit_sm><a_number>278200703520709</a_number><b_number>27824411926</b_number><service_type/><message>Test</message><registered_delivery/></submit_sm></command></usareq>');

Hi,
I need to get data from an XML file, like the format below:
Code: [Select]
<ISBNdb server_time="2011-05-31T19:19:42Z">
<BookList total_results="1" page_size="10" page_number="1" shown_results="1">
<BookData book_id="build_your_own_database_driven_web_site_using_php_mysql_4th_" isbn="0980576814" isbn13="9780980576818">
<Title>
Build Your Own Database Driven Web Site Using PHP & MySQL, 4th Edition
</Title>
<TitleLong/>
<AuthorsText>Kevin Yank, </AuthorsText>
<PublisherText publisher_id="sitepoint">SitePoint</PublisherText>
<Details change_time="2009-04-02T00:30:10Z" price_time="2011-05-31T17:46:10Z" edition_info="Paperback; 2009-06-15" language="" physical_description_text="360 pages" lcc_number="" dewey_decimal_normalized="5" dewey_decimal="005"/>
</BookData>
</BookList>
</ISBNdb>
I need to know how you get the details from <title>,<AuthorsText><PublisherText> and Bookdata. Tried using the example on W3C, using simplexml_load_file but it only returns:
Code: [Select]
ISBNdb
BookList:
Code I'm currently using is:
Code: [Select]
$xml = simplexml_load_file("http://isbndb.com/api/books.xml?access_key=----&results=details&index1=isbn&value1=".$isbn);
echo $xml->getName() . "<br />";

foreach($xml->children() as $child)
  {
  echo $child->getName() . ": " . $child . "<br />";
  }

Hi,

so i have a problem. I'm using a script to enable and disable checkboxes, and i'm id-ing them fetching values from a database:

while($data = mysqli_fetch_array($sql))
{
  if ($count % 5 == 0) {
    echo '</tr><tr>';
    $count = 0;
  }
  echo '<td><input name="subject_level[]" class="subject_a" disabled="disabled" type="checkbox" id="subject_level_'.$data['subject_level_id'].'" value="'.$data['subject_level_id'].'"/>';
  echo '<label for="subject_level_'.$data['subject_level_id'].'" class="subject_1">'.$data['subject_name'].'</label></td>';
  $count++; //Increment the count
}

The names of the checkboxes come out fine, just that, is there any way to retrieve the values of the checkboxes into an array of some sort so that i could build a search query later?

if($_POST(subject_level)) or if($_POST(subject_level[]))  doesn't return true. does it make sense? im new to php so please forgive my ignorance. Help appreciated. Thanks!

I have a basic table where I am trying to retrieve records that are filtered by a form request. Here is the code I have...

$ps = $pdo->prepare("SELECT * FROM `Products` Where `Vendor` LIKE concat('%',?,'%');
$ps->execute(array($_POST['Vendor']));;
echo "post=" . $_POST['vendor']; ////Displays correct data from form request
$count = $ps->rowCount();
echo "Count=" . $count; ////Count = 0 although I know for a fact that there is 1 record that should be in there

////Used for display of records
foreach ($ps as $row){
echo $row, PHP_EOL . "xxx<br>";
}

Where is the incorrect code? I am new to php and pdo. Thank you in advance

K

i have had a difficult time trying to work this out.I need to do some pattern matching for certain urls and retrieve information from it.
For example,
$url=http://www.test.com/showpic.php?do=showpic&u=89165&a=34933

if $url contains the value showpic.php,then i need to retrieve the following
{
  $u=value of u(i.e. 89165 in this case)
  $a=value of a(i.e. 34933 in this case)
}
else do nothin..

the format of the url will always be the same as above if it contains showpic.php

I'm making a game I have finished but have spent days and still can't figure out this part or how it should be done:

Gamer will type in keyword on the form box on my page then click submit

the page will connect to yahoo search then save/put the address bar URL search result of the keywords into a variable onto my page but the gamer will never have his page directed to yahoo but continue staying on my page while this all happens.


Any Help in the right direction or some code would be appreciated? 

i am trying to retrieve messages with some code.  It seems to be a bit more complicated that i thought it would be.  so here it goes:

Code: [Select]
$query = "SELECT * FROM memberMail WHERE userIDFrom='92' AND unread='1'"; 
$result = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result) or die(mysql_error());

$num_rows = mysql_num_rows($result);

echo "You have (" . $num_rows . ") unread message(s).";

$i = 0;
for($i; $i<$num_rows; ++$i) {
if($row[$i[unread]] == "1") {
echo $row[$i[message]] . "<p>";
}
}

}
what i am trying to do, is print out the messages from the records that are unread, and are from a certain user.  i don't think this for statement will pick up the record numbers that got matches though.  and i am not entirely sure about the $row statements in the for statement either.

$qID = '';
$question = 'Question not set';
$answerA = 'unchecked';
$answerB = 'unchecked';
$answerC = 'unchecked';
$answerD = 'unchecked';
$answerE = 'unchecked';



?>

<html>
<head>
<script type="text/javascript">
function show_alert()
{
alert("Please Click OK to proceed!");
                 
}
</script>
</head>
<form action="Process1.php" method="POST">
<table>
<tr>
<td>
<?php

$SQL = "SELECT stu_satisfaction_tblquestions.question_id, stu_satisfaction_tblquestions.question, answer_type.answer1, answer_type.answer2, answer_type.answer3, answer_type.answer4, answer_type.answer5 FROM stu_satisfaction_tblquestions INNER JOIN answer_type ON stu_satisfaction_tblquestions.answers_id=answer_type.answers_id
";
$result = mysql_query($SQL);
while($db_field = mysql_fetch_assoc($result)){

   $qID = $db_field['question_id'];
   $question = $db_field['question'];
   $A = $db_field['answer1'];
   $B = $db_field['answer2'];
   $C = $db_field['answer3'];
   $D = $db_field['answer4'];
   $E = $db_field['answer5'];
   print $question;
?>
</td>
</tr>
<tr>
<td>
<INPUT TYPE = 'Radio' Name ='q'  value= 'A' <?PHP echo $answerA; ?>><?PHP echo $A; ?>
<INPUT TYPE = "Hidden" Name = "h"  VALUE = <?PHP print $qID; ?>>
<?php echo $qID;?>
</td>
</tr>
<tr>
<td>
<INPUT TYPE = 'Radio' Name ='q'  value= 'B' <?PHP echo $answerB; ?>><?PHP echo $B; ?>
<?php echo $qID;?>
</tr>
</td>
<tr>
<td>
<INPUT TYPE = 'Radio' Name ='q'  value= 'C' <?PHP echo $answerC; ?>><?PHP echo $C; ?>
</tr>
</td>
<tr>
<td>
<INPUT TYPE = 'Radio' Name ='q'  value= 'D' <?PHP echo $answerD; ?>><?PHP echo $D; ?>
</tr>
</td>
<tr>
<td>
<INPUT TYPE = 'Radio' Name ='q'  value= 'E' <?PHP echo $answerE; ?>><?PHP echo $E; ?>
<br>
<?php }  mysql_close(); ?>
</tr>
</td>
<tr>
<td>


Please add any comments you may have:</br>
 <textarea rows="3" cols="60" name="comments" id="comments">
 </textarea>

</td>
</tr>


</table>

<input type="submit" onclick="show_alert()" value="Submit" />
</form>

</html>

I ran to some problems here. After filling every question up with the answers. When i process the form, i only managed to get QID of 20 and the answer of 1st question as my database have only 20questions. How do i go about in solving, so that i'm able to retrieve all result and update my database correctly

      $selected_radio = $_POST['q'];
      
      
      $qID = $_POST['h'];

      echo $selected_radio;
      
      echo $qID;
         
         $SQL = "UPDATE answers SET $selected_radio = $selected_radio + 1 WHERE question_id='$qID'";
         $result = mysql_query($SQL);
         mysql_close();
         print "Thanks for voting!";


?>
THis is my process page, and i echo out the answer to be B and qid as 20.

i have this script called view.php
Code: [Select]
<?php
  include 'db.inc';

  $file = clean($file, 4);

  if (empty($file))
     exit;

  if (!($connection = @ mysql_pconnect($hostName,
                                       $username,
                                       $password)))
     showerror();

  if (!mysql_select_db("Php_test", $connection))
     showerror();

  $query = "SELECT mime, data FROM file 
            WHERE id = $file";

  if (!($result = @ mysql_query ($query,$connection)))
     showerror();  

  $data = @ mysql_fetch_array($result);

  if (!empty($data["data"]))
  {
    // Output the MIME header
     header("Content-Type: {$data["mime"]}");
    // Output the image
     echo $data["data"];
   }
?>after i have db.inc
Code: [Select]
<?php

// These are the DBMS credentials
$hostName = "localhost";
$username = "root";
$password = "oxioxi";

// Show an error and stop the script
function showerror()
{
   if (mysql_error())
      die("Error " . mysql_errno() . " : " . mysql_error());
   else
      die("Could not connect to the DBMS");
}

// Secure the user data by escaping characters 
// and shortening the input string
function clean($input, $maxlength)
{
  $input = substr($input, 0, $maxlength);
  $input = EscapeShellCmd($input);
  return ($input);
}

?>and i have my page witch part of it is  this
Code: [Select]
   <?php
  include 'db.inc';
  
  $query = "SELECT id, name, mime FROM file";

  if (!($connection = @ mysql_pconnect($hostName, 
                                    $username,
                                    $password)))
     showerror();

  if (!mysql_select_db("php_test", $connection))
     showerror();
        
  if (!($result = @ mysql_query ($query, $connection)))
     showerror();
?>
    <h1>Image database</h1>


<?php 


  if ($row = @ mysql_fetch_array($result))
  {
?>

    <table>
    <col span="1" align="right">
    <tr>
       <th>Short description</th>
       <th>File type</th>
       <th>Image</th>

    </tr>
<?php
   do 
   {
?>
    <tr>
       <td><?php echo "{$row["name"]}";?></td>         
       <td><?php echo "{$row["mime"]}";?></td>
       <td><?php echo "<img src=\"view.php?file={$row["id"]}\">";?></td>
    </tr>
<?php
   } while ($row = @ mysql_fetch_array($result));
?>
    </table>
<?php
  } // if mysql_fetch_array()
  else
     echo "<h3>There are no images to display</h3>\n";
?>i have do it right but for some reason it doesnt displays the pictures the type and the name are displayed normally but not the picture!! instead of them there are small icons of not existing pictures.. please i want help i really need to do it

Code: [Select]
$query = mysql_query("SELECT a.*, b.*
         FROM friendlist a
INNER JOIN friendlist b
ON (a.friendemail=b.friendemail)
INNER JOIN users c
ON (b.friendemail = c.EmailAddress)
WHERE a.email = 'asdf@gmail.com'
AND c.Username LIKE '%carol%'
GROUP BY a.id
ORDER BY count(*) DESC");
Code: [Select]
while ($showfriends = mysql_fetch_array($query)) {
     echo $showfriends['Username'];
}
and I would get nothing. It produces the correct number of <div> so i know it's getting through, but it's having trouble displaying the entries?

I use Popshops Datafeed API and cant figure out an issue im having with an array. I'm trying to retrieve a category name from an array for the current page.

Here is the array code which is in the index.php file.

 $categories = array();
  $categories[] = array( 'name' => 'page name', 
                         'search_options' => array( 'keywords' => 'page keyword' ) );
  $categories[] = array( 'name' => 'page name', 
                         'search_options' => array( 'keywords' => 'page keyword' ) );
  $categories[] = array( 'name' => 'page name', 
                         'search_options' => array( 'keywords' => 'page keyword' ) );


This is how the script calls the current page keyword.
<?php echo ucwords($_REQUEST[$popshops->nameSpace.'keywords']) ?> 

The code above works fine, so I thought all I had to do was change the 'keywords' to 'name' to get what I was looking for. But that does not seem to work?
<?php echo ucwords($_REQUEST[$popshops->nameSpace.'name']) ?> 

I've tried as much as my limited php knowledge can take me, so now I need some advice.

Here is the function in the popshops.php file they use to pull the page name out for the links in the navigation, but I just want to know how to retrieve just the category name for the current page, nothing else.

function customCategoryLink($category) {
    $url = $this->baseURL($this->params);
    
    if (isset($category['search_options']) && sizeOf($category['search_options']) > 0) {
      foreach($category['search_options'] as $key => $value) {
        $url = $this->addParameter($url,$key,$value);
      }      
    } else {
      $url = $this->addParameter($url,'keywords',$category['name']);
    }
    $url = str_replace('?&','?',$url);
    return '<a href="'.$url.'">'.$category['name'].'</a>';
  }

Thanks in advanced!
 

I would like to display weather conditions on my website and store them in mysql database.
I wonder if it is possible to load web page into php for parsing so the required info could be found and used?
Is it doable with php and what functions could you recommend for this functionality?
How can I have program running in the background on the server which would be triggered every so often to perform this task?
Another question is if I want to trigger some action once a week like Tuesday at noon, is there function in php which could be used to check what day of the week and time it is ?
I am new to website design so any help will be greatly appreciated.

I've searched all over and have found some scripts but none of them work anymore.

Is there a way to fetch Google images using PHP? There's no Google Image API (only the regular Google API)