PHP :: Create Array From 2 Database Fields

Best Way To Create Object From A Form With Lots Of Fields
I have multiple forms that will create an object. Basically a energy
efficiency measure object. The measure object will have a couple of
required properties set but after that it can have 10-20 different fields
that are optional per measure.

How do I account for the different fields that will be
posted from the different forms when I create the measure object? Should
I create a constructor method with just the required fields as the
parameters and then create some sort of setter method for the optional
fields? Or do I create a different concrete measure object from an an
abstract measure base class? I have about 10 different measure objects
that I can think of but really the only difference between them are what
optional fields are posted.

Going forward the other issue is I need these measures to persist across
the pages of the application (sort of like a shopping cart app) and I see
that I can serialize an object in a $_SESSION object but do the fields
that I would set in the setter method also get serialized or do only the
actual properties of the object get set.

I then need to retrieve all these measure objects and send them to a
stored procedure to enter into a database so unfortunately I can't save
the fields as serialized because each field has to be separate to be sent
as the parameters to the stored procedure.

Basically my question is how do people deal with huge forms and fields
easily from a html post?

Create Radio Button Group WHERE Other Fields Can Disappear?
I'm trying to create radio buttons on my form where if one radio button is selected, then other fields disappear. Here is classic example:

Do you have a passport?

o NO

o YES, if so Date issued: [date pull down menu]

See what i mean? If the user clicks NO, then the "yes" selection as well as the Date pull down menu will turn grey so that the user cannot select it anymore.
Is it possible doing this without reloading the page?

PHP Script To Sort Data/create Pages According To Fields?
Someone fills out 3 fields. (There will be more but this is just to
give you an idea)

1. Country
2. State
3. City

I want this script to generate a web page and list the people by
information submitted.

eg. Everyone that put in USA will be listed on a page.

or

Choose California and everyone that typed in California will be listed
on a page.

I can also create links with criteria at the end. eg.
mysite/search.php?=montana

This script will also accept data from people. So people will visit,
type of the form and if the information is valid (not spam) then
they'll be in a database and able to be sorted.

Looking For A PHP Script To Sort Data/create Pages According To Fields.
eg.

Someone fills out 3 fields. (There will be more but this is just to
give you an idea)

1. Country?
2. State?
3. City

I want this script to generate a web page and list the people by
information submitted.

eg. Everyone that put in USA will be listed on a page.

or

Choose California and everyone that typed in California will be listed
on a page.

I could also create a link with the search term at the end. eg.
mysite/phpsearch=?montana

This script will also accept data from people. So people will visit,
type on the form and if the information is valid (not spam) then
they'll be in a database and able to be sorted.

Searching 2 Database Fields At Once....
How can i search two database fields at once. PHP Code:

Create Array From Members Of An Array Of Objects
I have the following situation:

$list[] is an array of MyElement objects.

MyElement has two members: MyElement->member1; MyElement->member2;

What I want is to get the following:

$newlist[] so that:

$newlist[0]=$list[0]->member2;
$newlist[1]=$list[1]->member2;
$newlist[2]=$list[2]->member2;
....

I need to do this using A SINGLE LINE OF CODE.
Is it possible? How to do this?

I tried with:

array_walk($list,create_function('$a,$b,$result',' $result[] =
$a->member2;'), &$result);

but I get the following error:

Warning: Call-time pass-by-reference has been deprecated - argument
passed by value; If you would like to pass it by reference, modify the
declaration of array_walk(). If you would like to enable call-time
pass-by-reference, you can set allow_call_time_pass_reference to true in
your INI file. However, future versions may not support this any longer.

Want To Autopopulate Form Fields From Database
I have a working form that submits info into a database.

I want to take a few fields about the poster (name, email) and hide them and have them filled out from my user table, which is the same database but different table then where the form data is being sumbitted.

I must be searching for thr wrong thing cause i am not finding any information on it.

How Could I Get The Form Fields Filled From A Database?
One idea I have is to do a redirect, but it doesn't quite
work because it ends to an infinite loop cause the page
is redirecting to itself:

header("Location: " . $_SERVER['PHP_SELF'] .
"?field1=something&field2=something else");

That would bee neet. I just would create a string from the contents
I receive from the db and just redirect, but as I said, it doesn't
work easily. You have to use the apache rewrite, but I didn't quite
get it.

Another solution is to check if the request is not empty for the
particular field.

Slideshow Pulling Database Fields
I used a javascript slideshow tutorial and changed it to insert my php database fields homephoto1 - homephoto6. Works perfectly. However, if all 6 database fields were not filled by the user, the screen shows a blank missing image for that particular field. Doesn't exactly look good when a user only has 2 pics and 4 blanks. Is there a way to change this so the empty fields will not show up in the array?

<!--
var interval = 4000;
var random_display = 0;
var imageDir = "homes/photo/";

var imageNum = 0;
imageArray = new Array();

imageArray[imageNum++] = new imageItem(imageDir + "<?php echo $home['homephoto1'];?>");
imageArray[imageNum++] = new imageItem(imageDir + "<?php echo $home['homephoto2'];?>");
imageArray[imageNum++] = new imageItem(imageDir + "<?php echo $home['homephoto3'];?>");
imageArray[imageNum++] = new imageItem(imageDir + "<?php echo $home['homephoto4'];?>");
imageArray[imageNum++] = new imageItem(imageDir + "<?php echo $home['homephoto5'];?>");
imageArray[imageNum++] = new imageItem(imageDir + "<?php echo $home['homephoto6'];?>");

var totalImages = imageArray.length;

Searching My Database For Multiple Fields
I have a number of different tables containing a number of different fields and i want to give people on my site an advanced search. The easiest way to explain this is for you to think of it as an estate agent's website. People visit the site and search for houses based on a number of different criteria, for example they would have a number of diffent boxes they could narrow a search down such as 'number of rooms', 'type of property', 'price' etc... Now this is similar to my site, I want people to b able to choose to narrow there search down but not be forced to enter information into all boxes.

So i want a search where a user would be able to select the number of rooms they want a property to have but if they choose not to enter that information then the intial value of '0' (or null) would be submitted to the search query. A user should be able to enter number of rooms AND/OR property type AND/OR price. IF they dont enter that information then a value of '0' (or null) would be submitted for each of the options to the query however if they do select a value then this would form the query.

This is where im struggling. After racking my small brains and trying to think logically about how i would do this, my logic tells me (and correct me if im wrong) that if i choose too insert each variable 1 at a time into a search query such as

$search_result = mysql_query("SELECT * FROM tablename WHERE rooms='$rooms' AND type='$type' AND price='$price'",$database);

...then if a user hadnt entered how many rooms but had entered 'flat' as the property type they wanted then the sql would be searching the 'rooms' field for 0 (which it obviously WONT find) AND 'type' for 'flat' and will return no result even if a 'flat' did exist in the database

What I have considered is building up the query as i go, so for example. Code:

Using Variable Names Stored In Database Fields.
I'm working on a project where I need to store a CGI query in a
database field. The query contains variables which will be substitued
at runtime (e.g., today's date, key to select upon, etc), and may be
pointed to different URLs depending upon the table key.

The variable substitution works fine when hardcoding into the script,
e.g.:

$var1='data1'
$var2='data2'
$a="http://www.webserver.com/query.cgi?a=$var1&b=$var2";
$fd=fopen($a,"r");
...

However, the substitution fails when the query is pulled from a database
record, e.g.

//Only one record returned for testing purposes.
//
//location field (varchar) is:
//"http://www.webserver.com/query.cgi?a=$var1&b=$var2"

$var1='data1'
$var2='data2'
$dbconn=yadda yada;
$dbquery=pg_query($dbconn,"select key,location from schema.table");
$row=pg_fetch_assoc($dbquery);
$fd=fopen($row['location'],"r");
...

In this case, the variable substitution doesn't occur in the query (i.e.,
$var1 remains the string $var1, instead of changing into the value of say,
༿-23-2004'). I've tried different variations, and treating as a
variable variable (with $$row['url'] and ${$row['url']}.

$_POST Identical Text Fields Into Database
I have a list which is pulled and displayed from my MS Access database. Next to each row, is a text field which appears evertime a new row is displayed and that is called 'code'.

I want any text field filled in by the user to be sent into my database, into one field all separated by commas. I have made an attempt at this in the second example script but it needs tweaking.

I have here my script which pulls the list from my database: Code:

Throwing Empty Fields Out Of An Array
what is the best way to throw out empty fields from an array i mean, if i have an array looking like:

array[0] = house
array[1] = NULL
array[2] = car

i whant the array[1] to be taken out, so it looks like:

array[0] = house
array[1] = car

Sorting And Cleaning Array From 4 DB Fields
I have 4 fields in my database that I am trying to combine and present as a unified dropdown. I've gotten the basic sort and display of the info to work, but don't quite know how to remove spaces caused by empty field nor how to make the dropdown unified. Code:

Create Database
I have basically an install script that creates a database and all the tables and fields.
This works great on the local IIS I have on this machine, but that's because I have 1 password for all databases. THe database cannot be created when I run this on the server that hosts my websites (which is a remote server that I rent space on, it's not in my control).

I'm trying to figure out if what I want to do is possible. I want to have a script that creates a database on any server via a web page.

Sorting An Multidimentional Array By Multiple Fields
If the multidimentional array was a mysql TABLE, what i'm trying to do would look like this:

SELECT * from array WHERE 1 ORDER BY field1 ASC, field2 DESC, field3 ASC
and so on.

I already constructed a function do to so, but this function, or should i say these 2 functions, sort only the first field properly, and then any other field is sorted improperly. PHP Code:

Sorting An Array Based On One Of Many Form Fields?
I think the root of my problem, aside from mental, is array based...but I'm not even sure what I want to do is even possible. So if I can get far enough to know that one way or the other, then I can try to figure out how to do it.

But here's the situation:

Page 1 I have a form with many item rows pulled from a database query. Among other fields, each row contains a checkbox to select the item and a text field which contains an item_description.

On submit, I have it so that every checked item goes onto the next page where more stuff happens to each item, and the select items end up in an HTML table as well as a CSV spreadsheet.

Now, because the selected items are pulled from an array based on the checkbox, the sort order is based on the item's unique ID number. WHat I'm being asked is if I can have the final results sorted by that item_description field I mentioned before. Which can occurr at the end of the 2nd page's processing, sure.

Well, here's what I have to select the items: .....

Create Mysql Database?
How do I make PHP create a database for mysql please?

I can see how to make tables and I have read all the documents
I can find but I don't understand how to make the database itself.

All the tutorials I can find seem to bypass the issue by ignoring it?

Create Value On The Fly, Or Store If SQL Database?
I have a value in a database of a car sale which could be $1,000.00 then I have another value in a database of a number of payments, then I create *on the fly* a value of amount per month. Should I store that in the database, or keep that *on the fly*..

What I mean by on the fly is. PHP Code:

Create A Survey By Using Database.
I want to create a survey by using data from database. And then i want display the result by clicking 'View Result'. How could i do that?

Unable To Create A Database
I am unable to create a table in SQL using PHP. I think it might jsut be a code, because it won't even show the page. It just gives me an internal error.

<?php

$connection = @mysql_connect("localhost","jcruz","abc2000")
or die(mysql_error());
$new_db = "testDB2";

$result = @mysql_create_db($new_db, $connection) or die(mysql_error());

?>

Submitting Multiple Form Fields In An Array / Loop
I have the following form

<FORM NAME="form1" METHOD="POST">
<?php do { ?>
<input name="approve[]" type="checkbox" id="approve[]" value="<?php echo
$row_rs['ID']; ?>">
<select name="select">
<option value="1">option 1</option>
<option value="2">option 2</option>
<option value="3">option 3</option>
</select>

<?php } while ($row_rs = mysql_fetch_assoc($rs)); ?>
</FORM>

I want to acheive a loop that inserts a record into a database that enters
the id and the value they have selected (if the approve input box was
ticked)

so far I have this:
<?
foreach($approve as $aID) {
$insertSQL = "INSERT INTO TABLE('refID','optionSelected') VALUES
('$aID','')";

}

?>

How do I enter the select value within this loop?
I assumed that it would be just
$insertSQL = "INSERT INTO TABLE('refID','optionSelected') VALUES
('$aID','$select')";

I Have A Weird Database Problem: It Is Returning Spurious Rows Withall The Fields Concatenated Into One
I have a PHP program that almost works. I'm running it from the command
line and simulating a form using a GET method. That part is working,
but I get spurious records with all of the fields concatenated into a
single field.

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="content-type">
<title>eqdb_read.php - Read the Equipment Database</title>
</head>
<body>
<small>This document last modified
<script>document.writeln(document.lastModified)</script>.</small>

<?php
$_GET['hostname'] = $argv[1]; // grab [1] because [0] holds the script
name FOR DEVELOPMENT ON THE COMMAND LINE ONLY

$hostname = $_GET['hostname'];
if ( is_null($hostname) ) {
?>

<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="GET">
Host Name:
<input type="text" name="hostname" /> <br />
<input type="submit" name="Lookup by hostname" />
</form>

Re:which Tool To Use To Create Form For A Database?how To Bu
You may want to check Achievo ATK (http://www.achievo.org/atk). It's a
framework for building data management applications with minimal
coding.

Create Rollover Buttons From Database
I've just finished an online php course and now fighting with a site I'm trying to create (of course ) I am trying to create a table with rollover buttons. The buttons details are sitting in a table, but everything I try doesn't work. Here are some things I tried: Code:

Create Checkboxes From Database Data
I'm trying to create checkboxes from a database table header row and then pass that to another page.

The checkboxes are gotten from the "header" row of the mysql table.
I check which of these checkboxes are selected and if it is selected, I display the data for the rest of the rows under that same column which is selected as a checkbox. Here's the code to generate the checkboxes:

How To Create An Array?
how to create an array that contains cat01, cat02,cat03..., cat17 and the cat01 has a value equal to 1, cat02 has a value = 2, cat17 has a value =17 ??? (means every cat01-cat17 has a value assigned to).

Help? How To Create Next Buttons When Using A Flat Text Database
Ok, I know the code below does not work but I am wondering about the logic...

1 How do I just print 10 rows.
2 How do I get the buttons.

You get the Idea. Anyway, I would like to know if anyone has done this with text files. I always see mysql as examples but nothing using a flat text database.

<?
$maxResults = 10;
$datafile = "sometextfile.txt";

$rows = @file($datafile);
for($size=0;$size<count($rows);$size++) {
$rows[$size] = chop($rows[$size]);
$coll = split("|",$rows[$size]);

// print something

}
if ($size > 0) {
$currPage = $size / $maxResults;
if ($currPage > 1)
print("<A HREF="test.php" >['prev']</A>");
for ($i = 0; $i < $size / $maxResults; $i++) {
if ($currPage == $i + 1)
printf("<A HREF="test.php"> </A> ",$i + 1);
else
printf("<A HREF="test.php"> </A> ",$i + 1);
}
if ($currPage < size / $maxResults)
print("<A HREF="test.php">['next']</A>);
}
?>

MYSQLDUMP, Create New Database, Before Restoring SQL Data.
I can use mysqldump to create a .sql file backup of my data.

For importing how can I test to see if the DB exists, if it does
import the .sql

If not create the DB then import the .sql!

Cannot Create Mysql Database And Tables From Php Script
'm trying to build a php script that will build a database in MySQL, create tables, and then populate those tables.

1. I'm not sure how I need to execute the php, from the browser or from the command line?

2. I'm not sure what is wrong with my code, but when I use php -v createdatabase.php, I get output that says my php function to create the database is incorrect. I've looked at other examples on google, and they seem to be almost the same...? Here is the code, I've gone thru it, but I still don't see where I'm making the error: Code:

Create A Multidimensional Array From XML Doc
Currently I have the following XML document:

<Programs>
<Program>
<ProductTypeName>30 Yr Fixed</ProductTypeName>
<Rate>6.250</Rate>
<APR>6.274</APR>
<InvestorName>Helos</InvestorName>
<Payment>2832.298</Payment>
</Program>
<Program>
<ProductTypeName>30 Yr Fixed</ProductTypeName>
<Rate>9.250</Rate>
<APR>9.293</APR>
<InvestorName>Avalon</InvestorName>
<Payment>3784.306</Payment>
</Program>
<Program>
<ProductTypeName>5/1 Arm</ProductTypeName>
<Rate>6.375</Rate>
<APR>6.399</APR>
<InvestorName>Carl1</InvestorName>
<Payment>2869.802</Payment>
</Program>
</Programs>

I load it up in a domdocument and iterate through it with the following:

$returns = array();
for($i = 0; $i < $xmlproducttype->length; $i++)
{
$returns[$i]['ProductTypeName'] =
$xmlproducttype->item($i)->nodeValue;
$returns[$i]['InvestorName'] =
$xmlinvestorname->item($i)->nodeValue;
$returns[$i]['Rate'] = $xmlrate->item($i)->nodeValue;
$returns[$i]['APR'] = $xmlapr->item($i)->nodeValue;
$returns[$i]['Payment'] = $xmlpayment->item($i)->nodeValue;
}

Giving me the following style array:

Using A Loop To Create An Array
I am trying to populate an array with information found in a mysql database. By selecting a state they would then see every resort that contains the selected state in it's row... Kind of like a tree navigation system. Code:

Create Array With Loop
I have got a problem creating an array. I have 3 arrays with words in them. I read those words and compare them with eachother to set the final number of words and give them a score. I do this with a couple of loops and set new a variable which should become a new array.

This new array (word_combi) contains the word, the number of times is was in the total list and the score. I have got the code I use below (which doesn't work)...can anyone tell me my error and point out the way to fix this? PHP Code:

How To Create New Array With Each Loop
I've got a while loop that's doing some stuff, and what I want is for it to create a new array each time. I only seem to be able to add to the existing array each time though - I'm sure there must be a simple way of doing this but it evades me at the moment!

while(condition){
//do some stuff
//create an array $dirarray[]
//amend values in array
//save as new array each time? e.g.$dirarray1[], $dirarray2[] etc. until loop finished
}

How Can I Create A Random 'Phrase' Generator Without Using A Database In PHP3???
I would like to set up a rotating, random phrase generator online. I hav a list of phrases and would like them to pop up randomly as the page is loaded or reloaded...

I've played aroud with random number generators...but how would I get phrases to show up rather than numbers?

How To Create Html List From Such Array ?
I've got an example array like this:

$myArr = array(
array("jj", "0", "jjj"),
array("ee", "0", "eee"),
array("bb", "ee", "bbb"),
array("ll", "ee", "lll"),
array("ff", "0", "fff"),
)

Where each row is an array with columns: id of list element, id of parent
list element ("0" means main node) and content of the element. So, from my
array I'd like to create a list like this:

<ul>
<li>jjj</li>
<li>eee
<ul>
<li>bbb</li>
<li>eee</li>
</ul>
</li>
<li>fff</li>
<ul>

Create A Delimited Text Array
How can I create a delimited text file to work with this script. I would like to put this first part in a text file and load it into an array so the php script can parse it. Code:

Create Multidimensional Array Dynamically
I'm already trying for some days to create an array dynamically. I have the following situation:

I have an array of strings.

$data["base:foo:bar"] = "test1";
$data["base:foo2:bar"] = "test2";
$data["base:foo2:bar2"] = "test3";
$data["base:foo:bar2"] = "test4";

This array should be converted in a multidimensional array. The keys for this array are the above keys separated by colons. The dimension of the array varies form situation to situation. Code:

Create Array(?) Of Subdirectory Names
I want to output an RSS feed based on text in identically named files located in different subdirectories (at the same level). So the structure looks something like: /dir/subdir1/text.txt, /dir/subdir2/text.txt, /dir/subdir3/text.txt, etc.

Therefore, how can I create an array of these subdirectory names, and then loop through those directories to echo the text.txt content?

Problems With Dynamic Checkbox - Need To Create Array
The problem I have concerns a dynamically created table/form which pulls in results from a user search of a mysql database. This works fine and pulls in results (title/author/isbn/price) and dynamically creates the table dependent upon how many results are found. For each result there is a dynamically created checkbox, which is bound to a unique field from the database(in this case isbn).

My problem then is: the dynamically created checkbox submits an isbn value to the next page - an order form. However I need that a user can select a number of checkboxes from the table. At the moment, each selection overwrites the other. It may be vary obvious - but I need to work out some way of storing the checkbox info in an array that gets submitted to my order form page.

at the moment the code for my checkbox within the html form is:

<input name="isbn_input" type="checkbox" id="isbn_input" value="<?php echo $row_Rs_panozzo_search['isbn']; ?>" />
</font></td>

This works passing one value through to my order form, but I need to set it up so it passes multiple values.

Create A Optgroup Dynamically Based On The Value Of An Array
how to create a optgroup dynamically based on the value of an
array...

for eg....

Which Tool To Use To Create Form For A Database? How To Build A Interfaces (or Web Pages) In Easy Way?
how to build a interfaces (or web pages) in easy way? how to build a form in easy way? how to automate and create web pages with a tool? which tool to use to create form for a database? I mean there is a way or a tool which help me to build an interfaces (web pages) to deal with the data in a database?

Loop Through Array And Create Variable Session Variable Names
As part of my user authentication class I've written a method that sets session variables. I pass an array to the function by reference which contains elements populated with information from the users table in the DB (name, street, country etc)

At the moment the function looks like this:

/* Set the session variables for easy access to user data */
function _setSessionData(&$userData) {
$_SESSION['loggedOn'] = true; // Logged on

$_SESSION['userID'] = $userData['UserID'];
$_SESSION['username'] = $userData['UserName'];
$_SESSION['password'] = $userData['Password'];
$_SESSION['firstName'] = $userData['FirstName'];
$_SESSION['surname'] = $userData['Surname'];
$_SESSION['email'] = $userData['Email'];
$_SESSION['street'] = $userData['Street'];
$_SESSION['city'] = $userData['City'];

return true;
}

What I'm wondering is if it is possible to loop through the $userData array, and dynamically name and populate the session variables rather than listing them all and assigning like I have?

Inserting Array To Database
inserting array from form into database. But it give an 'no such index in string error'. I tried $bands[]=HTTP_POST_VARS[band]; and all it does is insert the last value of the array Code:

Array From Database Entries
All I need is to create an array with the results from a database column.

Building An Array From A Database
Just a quick questions. I'm retrieving two fields from a database one being "id" and the other "name". I am currently using this to load the results

$i=0;
while($row = $db->fetchArray($results)) {
nameArray[$i] = $row;
$i++;

Which fetches the results by Association and gives me these results:

Array (
[0] => Array ( [id] => id1 [name] => FirstName )
[1] => Array ( [id] => id2 [name] => SecondName )
)

is there some way to modify the code so I get this result:

Array (
[id1] => FirstName
[id2] => SecondName
)

It seeem like it should be possible but I just can't seem to work it out.

Inserting An Array Into Database
If I have the following problem.

$adults=$_POST['adults'];//lets say its 2
$children=$_POST['children'];//lets say its 3
$rooms =array('101','102');

foreach($rooms as $roomnumber){
$insertSQL = "INSERT INTO bookings (roomNumber, adults, children) VALUES ( '$roomnumber', '$adults', '$children')";
$Result1 = mysql_query($insertSQL) or die(mysql_error());
}
This works BUT..each room gets (say) 2 adults and 3 children whereas I want the numbers spread over each room so that room 101 gets maybe 2 people and room 102 gets 3 people or vice versa and not double -up on the number of overall people. In a real life situation the user would choose the number of rooms and adults etc so the solution would need to allow for this. Can anyone see a way of doing this?

Pulling Database Value In To Array
How do I pull information from one of the fields in my database and put this into an array. The information in the field is stored as follows with a comma between each number 1342,1873

I need to get these numbers in to the array, then after this I can pass each value and check this against another table in my database. I tried $arr=array($row['numbers']); and of course it did not work. I need it so when pulled from the database it formats like below

$arr=array("1342","1873");

foreach ($arr as $value)
{
// rest of code //
}