displaying arrays

aron

hi all.

just trying something.

i have a massive form that i have posted into an array.

now on a new page i want to print all the arrays with their values in a list.

how do i do this.

cheers aron

paulnaj

Hi aron,

If it's just for debugging purposes I use

echo '<pre>';
print_r($array);
echo '</pre>';

Paul.

aron

hi paul. thanks for reply.

no what i want to do is print all the arrays as a list (for now so i can see it). then ill build my sql statemnt for inserting into the datbase.

i wantto print the filed name and the value. but only for thoes fileds that are not empty.

cheers aron.

paulnaj

Just cycle through the $REQUEST array (which is the $POST and $GET arrays merged together) ...

foreach($_REQUEST as $key => $value){
	if($value != ''){
		echo $key.': '.$value.'<br>';
	}
}

Paul.

aron

why does it only print some stuff

property_id: Array
category: Array
development: Array
office_area: Array
stoor_room_area: Array
vehicle_parks: Array
vparks: Array
single_story: Array
multi_story: Array
facilities: Array
municipility: Array
sales_status: Array
price: Array
type: All
building_area: Array
land_area: Array
offices: Array
boadroom: Array
bathrooms: Array
toilets: Array
ensuit: Array
laundry_facilities: Array
accommodation_facilities: Array
additional_areas: loft
hot_water: Array
building_style: Array
title1: Array
Submit: Submit

for instance property_id is this in the form

its should print a number

and office_area is empty in the above case so it i dont want it to display at all.

cheers aron.

aron

ok got it working.

property_id: 418093
category: commercial
development: 1
vparks: covered
type: All
additional_areas: loft
hot_water: solar_electric
building_style: other

now what i want to do is build a insert sql query to insert thoes records into my datbase.

all the fields in the datbase are named the same as the form fileds.

eg..

property_id
category
development
vparks
type
additional_areas
hot_water
building_style

cheers aron.

paulnaj

Have a go at it yourself first. If you have problems, come back and show us what they are 😉

Paul.

aron

ok i got it pretty much there

property_id: 418093
category: commercial
development: 1
vparks: covered
type: All
additional_areas: loft
hot_water: solar_electric
building_style: other
Submit: Submit
INSERT into property (property_id, category, development, vparks, type, additional_areas, hot_water, building_style, Submit, )values(418093, commercial, 1, covered, All, loft, solar_electric, other, Submit, )

thats the output

here is the code

<?php
foreach($_REQUEST as $key => $value){ 
    if($value != ''){ 
        echo $key.': '.$value.'<br>';
		$sql_2 .= ($key.', '); 
    } 
}
$sql = "INSERT into property (".$sql_2.")".
"values(".$sql_2.")" or die("Invalid query: " . mysql_error());

echo $sql;
?>

all i need to do now is remove these things

trailing "," comma eg.. building_style, )

remove the Submit array totaly

and also i want to list a preselected list of fileds. eg.

hot_water
building_style

if any of the fileds = these i have to put '' around the values (due to them being INT fields in the database.

anyone able to help.

cheers aron

paulnaj

Hi again Aron.

First of all, what error-checking, if any, are you doing? You must consider the old rule that says: If there just one way to do it wrong, the user will choose it.

So, if a particular field in the db is numeric, then test the value before carrying on.

I've just tested for integer fields below, but you should add as many conditions as you need. Test every field.

I get around the ',' problem by building an array and then using the join() function on it.

<?php
$INTEGER_FIELDS = array('property_id', 'development'); // as many as you need
$insert = array();
foreach($_REQUEST as $key => $value){  

    if($value == '') continue;
	if($value == 'Submit') continue;

if(in_array($key, $INTEGER_FIELDS)){
	// Error checking
	if(!is_int($value)){
		die('Error ... ['.$key.'] field does not contain an integer.');
	}
	$insert[$key] = $value;
} else {
	$insert[$key] = "'".$value."'";
}
}

// Error checking - maybe someone just clicked the submit button.
if(count($insert)){
	$sql = "INSERT into property (".join(',', array_keys($insert)).") VALUES (".join(',', array_values($insert)).")"; 
	echo $sql; 
	//mysql_query($sql) or die("Invalid query: " . mysql_error());
}
?>

Paul.

aron

its not a debug script. its accualy building the insert into database script.

thanks for your help by the way.

everything seems to work good now

INSERT into property (property_id,category,development,office_area,vparks,sales_status,type,additional_areas,hot_water,building_style) VALUES ('201637','commercial','1','23','covered','sdasd','All','loft','solar_electric','other')

except for the interger bit. for starters the propery_id is an int but if i put it into the bit you said to it comes up with the error.

cheers aron

aron

never mind think i got it sorted. thank you very much for your help.

cheers aron.

aron

Hi all. this is associated with the code by paulnaj above.

if i run it from IE i get this output and no problems (post to database fine)

INSERT into property (property_id,category,development,vparks,type,additional_areas,hot_water,building_style,date) VALUES (551296,'commercial','1','covered','All','loft','solar_electric','other','2005-03-14')

if i run the same page (with out doing anything different) through firefox it dosent work. weird variables are coming up (CFTOKEN,CFID,CFMAGIC) where did it get them from..

INSERT into property (property_id,category,development,vparks,type,additional_areas,hot_water,building_style,CFTOKEN,CFID,CFMAGIC,date) VALUES (588324,'commercial','1','covered','All','loft','solar_electric','other','12446606','685388','685388:12446606','2005-03-14')Invalid query: Unknown column 'CFTOKEN' in 'field list'

cheers aron.

Coruba67

foreach($_REQUEST as $key => $value){ 
    if($value != ''){ 
        echo $key.': '.$value.'<br>'; 
}

Using this how did you end up getting it to show the values instead of the word "Array"