PHP - Trying To Read Simple Array Values...

<?php
ini_set('display_errors', 0);
function escapeArray($array)
{
        foreach ($array as $key => $val)
        {
			if(is_array($val)){
				$array[$key]=escapeArray($val);
			}
			else{
				$array[$key]=addslashes($val);
			}
        }

        return $array;
		
}





$request_type=$_SERVER['REQUEST_METHOD'];
$api_key=$_SERVER['HTTP_X_API_KEY'];
$res=array();
if($api_key!=="643256432"){
	$res['msg']="Failu Invalid API KEY";
	echo json_encode($res);
	die;
}
// Connects to the orcl service (i.e. database) on the "localhost" machine
//$conn = oci_connect('SCOTT', 'admin123', 'localhost/orcl');

$conn = oci_connect('test', 'test', '192.168.10.43/test.test.com');

if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

$request=file_get_contents("php://input");
$request=escapeArray(json_decode($request,true));

 print_r($request);
// die;
if($request_type=="POST"){//for creation of invoice


echo	$CONTACT_ID=isset($request['CONTACT_ID'])?$request['CONTACT_ID']:"";
	$INV_SERIAL_NO=isset($request['INV_SERIAL_NO'])?$request['INV_SERIAL_NO']:"";
	$NAME=isset($request['NAME'])?$request['NAME']:"";
	$INV_DATE=isset($request['INV_DATE'])?$request['INV_DATE']:"";
	$DUE_DATE=isset($request['DUE_DATE'])?$request['DUE_DATE']:"";
	$CURRENCY=isset($request['CURRENCY'])?$request['CURRENCY']:"";
	$SUBTOTAL=isset($request['SUBTOTAL'])?$request['SUBTOTAL']:"";
	$TAX_TOTAL=isset($request['TAX_TOTAL'])?$request['TAX_TOTAL']:"";

echo $SHIP_SERIAL_NO=isset($request['SHIP_SERIAL_NO'])?$request['SHIP_SERIAL_NO']:"";
	$MASTER_NO=isset($request['MASTER_NO'])?$request['MASTER_NO']:"";
	$HOUSE_NO=isset($request['HOUSE_NO'])?$request['HOUSE_NO']:"";
	$shipment_data=isset($request['shipment_data'])?$request['shipment_data']:"";

	if($CONTACT_ID==""){
		$res['msg']="CONTACT_ID is required";
	}
	else if($INV_SERIAL_NO==""){
		$res['msg']="INV_SERIAL_NO is required";
	}
	else if($NAME==""){
		$res['msg']="NAME is required";
	}
	else if($INV_DATE==""){
		$res['msg']="INV_DATE is required";
	}
	else if($DUE_DATE==""){
		$res['msg']="DUE_DATE is required";
	}
	else if($CURRENCY==""){
		$res['msg']="CURRENCY is required";
	}
	else if($SUBTOTAL==""){
		$res['msg']="SUBTOTAL is required";
	}
	else if($TAX_TOTAL==""){
		$res['msg']="TAX_TOTAL is required";
	}

	
	else if($MASTER_NO==""){
		$res['msg']="MASTER_NO is required";
	}
	else if($HOUSE_NO==""){
		$res['msg']="HOUSE_NO is required";
	}
	else if($SHIP_SERIAL_NO==""){
		$res['msg']="SHIP_SERIAL_NO is required";
	}



	

	else{
		$stid = oci_parse($conn, "Select * from FL_HDR_INVOICE where CONTACT_ID='$CONTACT_ID'");
		(oci_execute($stid));
		oci_fetch_all($stid, $out);
		
		

		if(count($out['CONTACT_ID'])==0){

			$stid = oci_parse($conn, "Insert into FL_HDR_INVOICE (CONTACT_ID,INV_SERIAL_NO,NAME,INV_DATE,DUE_DATE,CURRENCY,SUBTOTAL,TAX_TOTAL) Values ('$CONTACT_ID','$INV_SERIAL_NO','$NAME',TO_DATE('$INV_DATE','YYYY-MM-DD'),TO_DATE('$DUE_DATE','YYYY-MM-DD'),'$CURRENCY','$SUBTOTAL','$TAX_TOTAL')");
			oci_execute($stid);

			$stid_2 = oci_parse($conn, "Insert into FL_SHIPMENT_DATA (CONTACT_ID,INV_SERIAL_NO,SHIP_SERIAL_NO,MASTER_NO,HOUSE_NO) Values ('$CONTACT_ID','$INV_SERIAL_NO','$SHIP_SERIAL_NO','$MASTER_NO','$HOUSE_NO')");
			oci_execute($stid_2);



			if(oci_num_rows($stid)>0){
				$res['msg']="Invoice created successfully against this contact_id:".$CONTACT_ID;
			}
			else{
				$res['msg']="Something going wrong please try again later";
				
			}
		}
		else{
			$res['msg']="contact_id must be unique";
		}
	}
	echo json_encode($res);
	die;
}

I need to read json data inside an array. Please help correct my code.. i am trying to do an API.

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 have mysql select query shown below retrieving data from a database:

$sql = "
SELECT 
	student, sum( test_score ) as score
FROM 
	test
INNER JOIN 
	level 
ON 
	test.level_id = level.level_id
GROUP BY 
	student"
$result = $mysqli->query($sql, MYSQLI_STORE_RESULT);
if($result)
{
      while ($row = $result->fetch_array(MYSQLI_ASSOC))
       {
	    var_dump($row);
       }
}

On inspection of the retrieved array with var_dump(), i have these result below:

array (size=2)
  'John' => string 'English' (length=2)
  'Score' => string '20' (length=3)

array (size=2)
  'Mary' => string 'Math' (length=3)
  'Score' => string '35' (length=3)

array (size=2)
  'Samuel' => string 'Physics' (length=3)
  'Score' => string '5' (length=3)

 How do I get at and print out the highest score from this set of array values within this context.
 I tried this echo max($row['count']) but i understandably got this feedback:
Warning: max(): When only one parameter is given, it must be an array   Thanks.

Hello all,

I have yet again trouble finding a logical solution to my problem.
I'm fetching an array which can hold 1 or more values.
The problem is, I want these values to ouput in my json_encode function, but this also needs to happen dynamically depending on the amount of values.

I can't explain it further, so here's the code so far:

Code: (php) [Select]
$files = mysql_fetch_array($get_files);

$a = count($files);

$i = 1;
while ($files) {
$variablename = 'fileName' . $i;
$$variablename = $files['fileName'];
$i++;
}

$output =  array( OTHER VALUES , 'fileName1' => $fileName1, 'fileName2' => $fileName2, 'fileName3' => $fileName3, ............); // How do I add the fileNames dynamically depending on how many there are?


This got me thinking, I also need to dynamically GET the values with jQuery. How would I do that, when the above eventually works?

Thank you.

Hi there,

Basic question, but I can't seem to find a page in the PHP docs that answers (though I'm sure such a one exists, I just can't seem to think up the right search terms - anyway)

My question is: is there a short-hand way to use a value from an associative array as the key in another associative array?

So for example, given this array:

$the_array = array(0 => array('name': 'the_name', 'value' : 'the_value'), 1 => etc....);

then this kind of foreach loop doesn't work

Code: [Select]
$new_data = array();
foreach($the_array as $element){
$new_data[$element['name']] = $element['value'];
}

Obviously I can just save out the values, like $name = $element['name'] --- but I was just wondering if there was a more efficient way to do it?

Cheers,

PS. I tried encapsulating with {} - i.e. $new_data[{$element['name']}] --- but that also fails.

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

I need to some how pull comma separated images $data[23] from this $data array and then put them into there own array so I can insert them into separate rows in a database.


    
This is the provided array:

$data[0] => VIN
$data[1] => StockNumber
    
...(all the other number here)
    
$data[23] => Image_URLs (comma seperated)
$data[24] => Equipment


// I need something like this (obviously doesn't work?!@#)

$delimiter = ",";
$img = explode($delimiter, $data[23]);

foreach($img as $pic){
$sqlPic = "insert into class_prodimages (pid image rank) values('".$LastId['id']."', '$pic', '".rand(1,20)."')"; 

}



Any help here?

I have the following  array structu
Code: [Select]

[0] => Array
        (
            [id] => Array
                (
                    [$t] => http://www.google.com/mate/
                )

            [updated] => Array
                (
                    [$t] => 2011-08-31T11:43:05.942Z
                )

            [category] => Array
                (
                    [0] => Array
                        (
                            [scheme] => http://schemas.google.com/g/
                            [term] => http://schemas.google.com/contact/
                        )

                )

            [title] => Array
                (
                    [type] => text
                    [$t] => Name
                )

            [link] => Array
                (
                    [0] => Array
                        (
                            [rel] => http://schemas.google.com/contacts/2008/rel#edit-photo
                            [type] => image/*
                            [href] => https://www.google.com/mate/feeds/photos/media/
                        )

                    [1] => Array
                        (
                            [rel] => self
                            [type] => application/atom+xml
                            [href] => https://www.google.com/mate/feeds/contacts
                        )

                    [2] => Array
                        (
                            [rel] => edit
                            [type] => application/atom+xml
                            [href] => https://www.google.com/mate/feeds/
                        )

                )

            [gd$email] => Array
                (
                    [0] => Array
                        (
                            [rel] => http://schemas.google.com/g/2005#other
                            [address] => email_address@gmail.com
                            [primary] => true
                        )

                )

        )



I am tried to display name and email address.
I am using following method, can anyone tell me is there any better way? Thank u 4u help.
NAME
$name=( $emp_det[0]['title'][t]);
EMAIL
$email =( $emp_det[0]['gdemail'][0][address]);

I have an array created to control the down states of the my buttons in my navigation. Which is working well. This array will have quite a few strings in it before I'm done.

I then want to conditionally load a CSS file for all the files in that array with the exception of two, is this possible?

In plain in english I want to say If in array apart from these values then load my css file.

My array (will have more values when complete)

Code: [Select]
$otherTitles = array('Product Selector', 'Avon Range', 'Knightsbridge Range', 'Kingston Range' );

My code to load a css file

Code: [Select]
<?php if (in_array($title, $otherTitles)) { ?>
<link rel="stylesheet" type="text/css" href="homepage.css"/>
<?php } ?>

I want all titles in the otherTitles array to get this CSS file apart from two Product Selector and Avon Range.

Thanks

Richard

I am attempting to flush values from a URL query with a pagation script.

This line of code will replace one value:
$page_name2 = preg_replace('/&?start=\d+/','',$page_name);

This line of code will replace the second value:
$page_name3 = preg_replace('/&?limit=\d+/','',$page_name);

Can I combine them to replace both values in replace?

This obviously isn't it:
$page_name3 = preg_replace(('/&?limit=\d+/','',)&&('/&?start=\d+/','',)$page_name);

Thank you.

Hello there again!   I have the following construct of array now (schematics):

array[0]
	array[id] = "1"
	array[title] = "title"
array[1]
	array[id] = "3"
	array[title] = "another title"

Now what i want to do, is to assign the parent-array keys to the IDs of it's contents.   This is what it should look like:

array[1]
	array[id] = "1"
	array[title] = "title"
array[3]
	array[id] = "3"
	array[title] = "another title"

How do I do that again? I know I did this some years ago, but I can not remember how.

I'm working on a way to let parents in my son's cub scout pack volunteer for specific spots in a duty roster via an AJAX page and MySQL db.

The duty roster is saved as an array in the db.  My intent is to pull out the array, parse it into XML to send back to the jQuery which asked for it.
The end result right now is that it just displays a bunch of "available" strings in a row, which is the default value for a job slot which hasn't been filled yet. 

The xml should look something like:
Code: [Select]
<data>
<DAY val="DAYVALUE">
<TIMEBLOCK val ="TIMEVALUE">
<JOB title="titlevalue">
<slot num="x">AVAILABLE or NAME</slot>
<slot num="x">AVAILABLE or NAME</slot>
{...}
</JOB>
</timeblock>
</DAY>
<data>
Where the attribute changes to reflect the different days for the campout, and the TIMEBLOCK val attribute changes for the different timeblocks which have job slots (Breakfast, Lunch, etc).

Here is the snippet of code.  The page starts with Header('Content-type: text/xml');  before making the call to the db (I've left that section out for security).  The part where it gets retrieves and traverses the array are working as expected.  It's where the XML gets built that everything goes wonky.  (But if someone can show me a more recursive, efficient way of getting the same effect, I'm all ears)

The output of this page shows up at:http://www.pack238.net/campingregistration/retrievedutyroster.php
You'll see at the bottom where it just says "available available available available available available available available...."
The code is:
Code: [Select]
//start the xml
$xml = new SimpleXMLElement('<data></data>');

//  get the duty roster array from the database
$query = "select dutyroster from ".$eventsTable." where eventID = 1";
$result = mysql_query($query);
if(!$result)
{
}
else{
//put the returned result into a usable array
$returnedRows = mysql_fetch_array($result);
$day = unserialize($returnedRows[0]);
foreach($day as $key => $value) //this gives us each day
{
echo "<Br/> Key is: $key && the value is $value";
$day1 = $xml->addChild('DAY');
$dayValue = $day1->addAttribute('val',$key);
//Here, we know we're at the top level, so parse out the sub arrays
foreach($value as $key1 => $value1)//this gives us each time block
{
$timeblock = "";
$timeblockValue = "";
$timeblock = $day1->addChild('TIMEBLOCK');
$timeblockValue = $timeblock->addAttribute('val',$key1);
echo "<br/>&nbsp;&nbsp;Let's see the time blocks for each day:  $key1   $value1";
//check to see if there's a JOBS sub array yet again or if it's a standalone
if(is_array($value1))
{
foreach($value1 as $key2 => $value2)
{
$job = "";
$title = "";
$job = $timeblock->addChild('JOB');
// $title = $timeblock->addAttribute('title',$key2); //this is the line throwing the attribute error
echo "<br/>&nbsp;&nbsp;&nbsp;&nbsp; We're in a sub array, and the values a   $key2   $value2";
if(is_array($value2))
{
foreach($value2 as $key3 => $value3)
{
//for each slot:
$slot = $job ->addChild('slot',$value3);
$slotnum = $slot ->addAttribute('num',$key3);
echo "<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The jobs a $key3   $value3";
}
}
else //we need to account for individual jobs that don't have a subarray
{
$slot = $job ->addChild('slot',$value3);
$slotnum = $slot -> addAttribute('num','0');
}
}
}
}
// echo "<br/><br/>The array returned is: ".$usableArray."<br/>";
// $usableArray = unserialize($usableArray);
// print_r($usableArray);
}//end of the main foreach
//we got the duty roster array....now just parse out the days, time periods, and jobs then create the xml


$dom = dom_import_simplexml($xml)->ownerDocument;
$dom->formatOutput = true;
echo $dom->saveXML();

echo "<hr/>";
//print_r($xml);

}//end of else to if(!result)

Hello, I try to get website speed of some website, but i can read only ''domain.com'' i can't read website files like css , js ... why ? i use proxies for this job. here is the php code:

$options = array(
'useragent' => "Firefox (+http://www.firefox.org)", // who am i
'connecttimeout' => 120, // timeout on connect
'timeout' => 120, // timeout on response
'redirect' => 10, // stop after 10 redirects
'referer' => "http://www.google.com",
'proxyhost' =>'85.25.8.14:80'
);
$response = http_get("http://solve-ict.com/wp-content/themes/ict%20theme/js/jquery-1.7.1.min.js", $options , $info);

but it works fine with http://domain.com/ , but with files css or js it gives 404, using some free proxy servers available ? Thanks.

Hi there,

I am working on a PHP web form and I have a very simple situation I guess, I have a variable named: $MyVal

When I do

print_r($MyVal);
To see whats inside, I get:

SimpleXMLElement Object ( [0] => 8.23 )
Now I am assigning this variable into a session variable so that I can do calculations with it.

So I assign:

$_SESSION['MySesVal'] = $MyVal;
But after assigning to session variable, when I do my calculations:

$finalValue = $_SESSION['MySesVal'] * 4;

I get 0. So is it because the actual $MyVal variable has some XML stuff as:

SimpleXMLElement Object ( [0] => 8.23 )

So what is the right way to properly assign $MyVal variable to a session variable to do calculations.

Please reply.

All comments and feedbacks are always welcome.

Thank you!

Hi there,

I am having a PHP form with simple combo box. Here is the code:

<form name="form1" method="get" action="">
  <select name="select" onChange="form1.submit()">
    <option value='value1'>My Value1</option>
    <option value='value2'>My Value2</option>
    <option value='value3'>My Value3</option>
  </select>
</form>

Now the form is successfully being submitted upon 'onChange' event. The only thing I am trying to do is to retain the value of the new option. As every time I select the value from the combo, it goes back and displays the 'value 1' even when I select value 3 or 2.

How do I make the combo box retain the value as 3 (when I select option 3) after the form is submitted.

Please reply.

Thank you!