PHP - Moved: Read Data From Array

I'm trying to send some POST data to a page and then get the contents of it. The page is not on my server, so I can't use Sessions or GET. Google hasn't provided me with a definite answer. How would I do this?

After searching postings on multiple forums, I am officially now "Freaking OUT" trying to understand something that is probably very simple, but cannot seem to grasp.

I simply want to read basic .csv data that is sent/uploaded directly to a PHP page, and to then append each record that shows up to a single .csv file on  the server.  

The incoming data is supposed incoming via $_POST['csv'] ... at least that's what I was told.

Each.csv  record line being sent/uploaded is very simple (either single or multiple records in one small file):

text1,text2,text3,text4,text5

For additional processing I know about 'explode', etc., but right now I am stuck even trying to do an 'echo' to display the simple incoming data "as is".

One option I tried was:

$postdata = file_get_contents("php://input");

echo $postdata;

In the Java App monitoring I get the following after 3 records are sent/uploaded to the PHP URL:

Server response status line: HTTP/1.1 200 OK

I find this strange since I did not include...  http_response_code(200); ... in the page code.

Obviously, I do NOT know what I am doing here {SIGH}.

Any assistance or guidance is appreciated.

Thank you !

- FreakingOUT

 

 

 

 

 

Hi,

I am trying to fetch a row in advance of the current one to find out if the next result is the same or not, and do something based on the outcome.

I know how to do this with the old mysql functions like mysql_data_seek.

What is the equivalent in PDO?

I want the below sample to return row number 2, but it returns nothing no matter what number I set the offset to be.


$readAhead = $resultParts->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_REL, 1) ;
echo $readAhead['partNumber'] ;


array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL) is set in my prepare statement.

hi guys, i want to retrieve data from database table using select query store the result into an array in database class and then in view class e.g in html i want to make an object of that database class and call the array and display the data into html table.
someone help would be appreciated.
                                                                                         Thanks in advance.

    $handle = fopen("/etc/rpt.fifo", "r") or die("Unable to open file!");
       $buffer = trim(fgets($handle));                
       $ary = explode (",", $buffer);  
       $x = $ary[2];
       print $x;
       flush();   
       pclose($handle);

        

When I run it, it reports:

Notice:  Undefined offset: 2 on line 4

This is the line in /etc/rpt.fifo that is being read (there are 4 indices)

20210721153256,1100,TXKEY,89790

The error makes no sense to me but I'm no expert <g>

Edited July 21 by KenHorse

This topic has been moved to Other Libraries and Frameworks.

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

Hi there...

This array thing seems little strange and I had to turn to phpfreaks

I have an array named:
$optionInfo

When we do:

print_r($optionInfo);

it displays all the values stored in the array i.e.

Array ( [4] => Array ( [optionId] => 5 [optionName] => Blue - Medium [optionListId] => 4 [dateCreated] => [enabled] => 1 ) ) 

And as we can clearly see, we have the optionId value as 5. So therefore, when I type:

Code: [Select]
print_r($optionInfo[optionId]);
It returns nothing. Even though there is a value 5 in the array but I just can't get the individual value of optionId.

Is there something I am missing here.

Kindly reply.

Thank you!

Cheers!

 

I'm creating a tool for building project proposals for clients, with pricing.

I have a database with two tables: services and clients.

The services table looks like this:

Code: [Select]
| code        | name        | cost |
+-------------+-------------+------+
| logo_design | Logo design | 10   |
| web_design  | Web design  | 20   |

The clients table looks like this:

Code: [Select]
| id | client  | logo_design | web_design |
+----+---------+-------------+------------+
| 1  | Walrus  | yes         | yes        |
| 2  | Narwhal | no      | yes        |

How would I link the results from these two tables so that I only pull out the services each person wants from the database?

Here is what I have so far:

Code: [Select]
<?
$sql = "SELECT * FROM services";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {

  echo $row{'name'} . ': $' . $row{'cost'} . '<br />';

} ?>

This, of course, displays all the services, with all the prices, like so:

Logo design: $10
Web design: $20

I want to add something here so that based on the selected client, we see only the services/prices they selected (ol' Narwhal's page would not show the "Logo Design" line). I've got the data from "clients" pulled in to this page as well, but don't know how to relate it to "services."

Thanks in advance! Let me know if I've left out any info that would help you to point me in the right direction.

This topic has been moved to Microsoft SQL - MSSQL.

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

Hello together,

I'm still relatively new with PHP and I'm encountering an error with the error code (Warning: Undefined array key "title" in I:\xampp\htdocs\test\Datenspeichern.php on line 13 to 17.).

Normally I wanted that when I enter the data in the fields from the CD_Website page, that it is inserted in my created database and displayed in the table on the page. 

Does anyone know where my error is? 

Thanks a lot

 

main Code=

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Unbenanntes Dokument</title>
<style type="text/css">
table {
        border-collaps: collapse;
        width: 100%;
        font-family: serif;
        font-size: 35px;
        text-align: center;
        
    
}

td {
        font-size: 25px;
        text-align: center;
        font-family: serif;
}


</style>
</head>
<body>
<table>
    <tr>
        <th>CD-Titel</th>
        <th>Artist</th>
        <th>Songtitel</th>
        <th>Musiklänge</th>
        <th>Lied Nummer</th>
        </tr>
        
    
        
<?php                                                             

    $host = "localhost";
    $user = "root";
    $password = "";
    $db_name = "cdaufgabe";

    $con = mysqli_connect($host, $user, $password, $db_name);
    if(mysqli_connect_error()) {
        die("Verbindungsabbruch mit der Datenbank: ". mysqli_connect_error());
      };

    $check = "SELECT * FROM `cd-titel`";
    $result = mysqli_query($con, $check);
    
    if ($result > null) {
    while ($row = $result->fetch_assoc()){
    echo "<tr><td>" . $row['CD-Titel'] . "</td> <td>" . $row['Artist'] . "</td> <td>" . $row['Songtitel'] . "</td> <td>" . $row['Musiklänge'] . "</td> <td>" . $row['Lied-Nummer'] . "</td></tr>";
    };        
    };
    
    
    
    /*if (isset($_POST['submitted'])) {
            
    
    $titel = $_POST['titel'];
    $artist = $_POST['artist'];
    $songtitel = $_POST['songtitel'];
    $musicle = $_POST['musicle'];
    $liednr = $_POST['liednr'];
    $data_add =  "INSERT INTO cd-titel (CD-Titel, Artist, Songtitel, Musiklänge, Lied-Nummer) VALUES ('$titel', '$artist', '$songtitel', '$musicle', '$liednr')";
    
    if (!mysqli_query($db_name, $data_add)) {
        die('Fehler beim einfügen von Daten');
    }
        

}
*/
// $data_add =  "INSERT INTO `cd-titel` (`CD-Titel`, `Artist`, `Songtitel`, `Musiklänge`, `Lied-Nummer`) VALUES ('$titel', '$artist', '$songtitel', '$musicle', '$liednr')";
// mysqli_query($con, $data_add);    
    
    
    /*mysqli_query($con, $data_add);*/
    

?>

<form methode="post" action="Datenspeichern.php"> 
            <input type="text" name="titel" placeholder="CD-Titel"/>
            <input type="text" name="artist" placeholder="Artist"/>
            <input type="text" name="songtitel" placeholder="Songtitel"/>
            <input type="text" name="musicle" placeholder="Musiklänge"/>
            <input type="text" name="liednr" placeholder="Lied-Nummer"/> 
             <input type="submit" name="submitted" value="speichern"/>
    </form>
    </br></br></br>
    </table>

</body>
</html>

second code(Datenspeichern.php)=

<?php                                                             
$con = mysqli_connect('localhost', 'root', '');
 if (!$con) {
     echo'Nicht verfügbar';
 }
 
 if (!mysqli_select_db($con, 'cdaufgabe')){
 
        echo 'Datenbank nicht ausgewählt';
        
 };
 
    $titel = $_POST['titel'];
    $artist = $_POST['artist'];
    $songtitel = $_POST['songtitel'];
    $musicle = $_POST['musicle'];
    $liednr = $_POST['liednr'];
 
 
    $data_add =  "INSERT INTO cd-titel (CD-Titel, Artist, Songtitel, Musiklänge, Lied-Nummer) VALUES ('$titel', '$artist', '$songtitel', '$musicle', '$liednr')";
    
 if (!mysqli_query($con, $data_add)){
     echo 'Fehler';
     
 }
 
 else {
     echo'Eingefügt';
 };
 
 
 
 header("url=CD_Webseite.php");
 
?>

Does anyone knows the mistake i keep doing?

I want to create a singleton class that read multidimensional array from txt file and flatten the array retrieved.

This topic has been moved to Third Party PHP Scripts.

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

Hi, after banging my head against the wall for a while thinking this would be a simple task, I'm discovering that this is more complicated than I thought.

Basically what I have is a link table linking together source_id and subject_id.   For each subject there are multiple sources associated with each.

I had created a basic listing of sources by subject... no problem.   I now need a way of having a form to create an ordered list in a user-specified way.  In other words, I can currently order by id or alphabetically (subject name lives on a different table), but I need the option of choosing the order in which they display.  I added another row to this table called order_by.  No problem again, and I can manage all of this in the database, however I want to create a basic form where I can view sources by subject and then enter a number that I can use for sorting.

I started off looping through each of the entries and the database (with a where), and creating a foreach like so (with the subject_id being grabbed via GET from the URL on a previous script)
Code: [Select]
while($row = mysqli_fetch_array($rs)) {


//update row order
if (isset($_POST['submit']))  {

//get variables, and assign order

$subject_id = $_GET['subject_id'];
$order_by = $_POST['order_by'];
$source_id = $row['source_id'];


//echo 'Order by entered as ' . $order_by . '<br />';

foreach ($_POST['order_by'] as $order_by) {

$qorder = "UPDATE source_subject set order_by = '$order_by'
WHERE source_id = '$source_id'
AND subject_id = '$subject_id'";

mysqli_query($dbc, $qorder)
or die ('could not insert order');

// echo $subject_id . ', ' . $order_by . ', ' . $source_id;
// echo '<br />';
} 
}
else {
$subject_id = $_GET['subject_id'];
$order_by = $row['order_by'];
$source_id = $row['source_id'];

}

And have the line in the form like so:
Code: [Select]
echo '<input type="text" id="order_by" name="order_by[]" size="1" value="'. $order_by .'"/>

(yes I know I didn't escape the input field... it's all stored in an htaccess protected directory;  I will clean it up later once I get it to work)

This, of course, results in every source_id getting the same "order_by" no matter what I put into each field.

I'm thinking that I need to do some sort of foreach where I go through foreach source_id and have it update the "order_by" field for each one, but I must admit I'm not sure how to go about this (the flaws of being self-taught I suppose;  I don't have anyone to go to on this).

I'm hoping someone here can help?

Thanks a ton in advance

hi i am trying to make a payroll calculator script that takes employee info, calculates pay, displays submitted info in a table, stores info in an array, and updates the array when new info is submitted. i have most of these accomplished, i am having trouble with the "store into an array, and update the array when new info is submitted" parts of the project. i am still not very fluent in php so there may be easier ways to achieve what i have so far. any pointers would be a great help, this part has got me stumped.

Using curl_multi, I have loaded up 3 url's and then printed the array.

1) How can I also set a timestamp on output to let me know when each url was run?

2) How can I explode the array to only display the data and timestamp, excluding the text "Array ( =>", "[1] =>", "[2] =>" and " )"? Code

<?php

function multiRequest($data, $options = array()) {

  // array of curl handles
  $curly = array();
  // data to be returned
  $result = array();

  // multi handle
  $mh = curl_multi_init();

  // loop through $data and create curl handles
  // then add them to the multi-handle
  foreach ($data as $id => $d) {

    $curly[$id] = curl_init();

    $url = (is_array($d) && !empty($d['url'])) ? $d['url'] : $d;
    curl_setopt($curly[$id], CURLOPT_URL,            $url);
    curl_setopt($curly[$id], CURLOPT_HEADER,         0);
    curl_setopt($curly[$id], CURLOPT_RETURNTRANSFER, 1);

    // post?
    if (is_array($d)) {
      if (!empty($d['post'])) {
        curl_setopt($curly[$id], CURLOPT_POST,       1);
        curl_setopt($curly[$id], CURLOPT_POSTFIELDS, $d['post']);
      }
    }

    // extra options?
    if (!empty($options)) {
      curl_setopt_array($curly[$id], $options);
    }

    curl_multi_add_handle($mh, $curly[$id]);
  }

  // execute the handles
  $running = null;
  do {
    curl_multi_exec($mh, $running);
  } while($running > 0);

  // get content and remove handles
  foreach($curly as $id => $c) {
    $result[$id] = curl_multi_getcontent($c);
    curl_multi_remove_handle($mh, $c);
  }

  // all done
  curl_multi_close($mh);

  return $result;
}



$data = array(array(),array());

$data[0]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Pearl+Jam&output=json';
$data[1]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Black+Eyed+Peas&output=json';
$data[2]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Nirvana&output=json';

$r = multiRequest($data);

print_r($r);

?>

Output

Array ( => Pearl Jam [1] => Black Eyed Peas
        [2] => Nirvana )

Preferred Output

01:00:01 Pearl Jam
01:00:02 Black Eyed Peas
01:00:03 Nirvana