PHP :: Building An Array From A Database

Extracting Database And Building A Table
I have a mySql database with

tblDiary
DateEmployeeClient
1/1/04SmithBloggs
2/1/04JonesUnited
2/1/04SmithCentral
.....etc

tblEmployee
NumberName
1Smith
2Jones
....etc

Thing is I need to get it to display HTML in a date table like this:

MondayTuesdayWednesday...etc
1/1/042/1/043/1/04
SmithBloggsCentral_____
Jones______United_____
....etc

and if the user clicks on say Bloggs it takes them to the booking so
it can be amended or if they click on _____ it sets up a new entry in
tblDiary.

I will be using tblDiary.Data and tblDiary.Employee as a compound
primary key.

Building An Array Of Files
I'm working on a function to map a php project that's gotten a little
unwieldly. I'd like to have a reference of all files like the output
of the unix tree command, like this:
..
|-- index.php
| |-- menu.php
| |-- content.php
| |-- admin_page.php
| | |-- admin_function1.php.inc
| | |-- admin_function2.php.inc
| | |-- admin_function3.php.inc
| | `-- admin_subpage.php
| | |-- admin_subfunction1.php.inc
| | |-- admin_subfunction1.php.inc
| | `-- admin_subfunction1.php.inc
| `-- user_page.php
| |-- user_function1.php.inc
| |-- user_function2.php.inc
| |-- user_function3.php.inc
| `-- user_subpage.php
| |-- user_subfunction1.php.inc
| |-- user_subfunction1.php.inc
| `-- user_subfunction1.php.inc
|
|-- orphan_page.php
`-- deprecated_page.php

I have a function that can create such text output ( or close enough )
from an array structure like this:

Array (
[0] =./index.php
[1] =Array (
[0] =./clients.php
[1] =Array (
[0] =./login_function.inc
[1] =./client.php
[2] =./client_new.php
[3] =./client_edit.php
)
[2] =./inventory.php
[3] =Array (
[0] =./login_function.inc
[1] =./inventory_item_add.php
[2] =./inventory_item_remove.php
)

[4] =./daily_report.php
[5] =./weekly_report.php
[6] =./monthly_report.php
[7] =./catalog.php
[8] =Array (
[0] =./login_function.inc
[1] =./catalog_item_add.php
[2] =./catalog_item_remove.php
)
[9] =./orders.php
[10] =Array (
[0] =./login_function.inc
[1] =./view_order.php
[2] =./order_new.php
[3] =./order_edit.php
)
[11] =./invoices.php
[12] =Array (
[0] =./login_function.inc
[1] =./view_invoice.php
[2] =./invoice_new.php
[3] =./invoice_edit.php
[4] =./invoice_print.php
[5] =./invoice_email.php
)
)
[2] =./clients_old.php
[3] =./old_inventory.php.....

Building Multi Dimensional Array
I am trying to build a multi dimensional array from an unsorted array. I have an array made up of the lines in a text file, each line is a comma seperated set of fields. The first two fields are the lines id and it's parents id; eg Line ID, Parent ID, Data

1, 1 , one
2, 2, two
3, 3, three
4, 1, four
5, 4, five
6, 1, six
7, 2, seven

I am trying to build a multi dimensional array so that the final array would look like;

-- one
---- four
------ five
---- six
-- two
---- seven

Building Array Of Difft Results For Return
I have 2 functions that I want to call from a subroutine, and then return their results; one result is an array, the other will be an array of arrays. The first will be the information about a product, $product, with values like $product['title'], product['id'], etc.

The second will be an array of arrays, each line of which contains information about an element of the product. I.e., $item[0]['title'], $item[2]['value'], etc. How would I best combine these so I can RETURN the total thing from the function, and then how would I refer to the parts in the calling code? For example, if I said Code:

Building An Array And Passing The Variables Through Pages
I have a form that inserts a variable and then shows the variable where needed. simple... i think. I have it working, but I can't seem to add elements to the array. Also anytime I go to another section I lose the information. from the variable. here is the basic bit of code used. Code:

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.

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 //
}

Inserting An Array Into A Database
I'm trying to insert an array into a database along with other information and finding it very difficult. I want to insert a row into the database for each container that I get from "insert page 1". I get the amount of containers needed

(insert page 1)
<input type="text" name="number_of_containers" size="2">

I use a for loop to make the necessary amount of form fields for two variables and then have two static ones. What I want to do is enter in one row per container. Code:

Putting Content From Database Into Array
I have a problem with the following code, what i try to reach is that i want to compare a value with a value out of the database and if equal then display that else display that.
The problem is that i can't put the content from a database row into an array, the following: PHP Code:

Place Banners From Database In An Array
i wonder how i can place my banners information from a database into an array. I try to reach a method like this: PHP Code:

Create Array From 2 Database Fields
I want to create an array of product prices, with the product id as the index and the product price as the value, so i can place the prices for particular products wherever i want on my page.

Both product id and price are taken from the Products table
SELECT prod_id, prod_price FROM Products

Due to the client wanting an unusual layout, I cant just loop a table with the data, I need to be able to print $Price[2]; (for product id 2) wherever I like, for example.

Fastest Way To Do Database / Array Search
I am trying to write a script that allows users to search through a
database of names. But rather than give a search string and then return
all those that match, I would like it to search each time the user
types a new letter in the text box.

That's badly explained - this example might help!

The user types "r" and I displays all the names with r in them. The
user continues and types "i" so the textbox shows "ri" and displayed
are all the results with "ri" in them. I as doing currently this by
re-querying the SQL database where the names are hosted but it takes
too long to query, return and refresh the page.

What would be a better way of storing this database info to allow a
faster search? Maybe load it into a PHP array first (stored in another
file) and search within that? (Can you do 'clever' searches in PHP?) Or
into a javascript array? The list could be upwards of 1000 names.

The databse shouldn't change that often so I could have a script that
updates the array every 24 hours or every time a new name is added.

To Insert Array Value In Database---important
ihad an array in php and iwant to insert its value in database
the coding is:

<?php
$nv_pairs = explode('&',$query_string);
$array[50];
list ($name, $value) = explode ('=',$nv_pairs);
$i = 0;
foreach($nv_pairs as $array[$i]) {
$array[$i]=
preg_replace('/\%0d%0a+/',"     
;          
;          
;          
;          
;          
; ",$array[$i]);
$array[$i]= urldecode ($array[$i]);
$array[$i]= preg_replace('/d*=/', " ",$array[$i]);
$array[$i]= urldecode ($array[$i]);
$i++;
}
ksort($array);
while(list($key,$value)=each($array)) {
if (preg_match("/d+/",$value)) {
echo "        
        
        
        
        
        
   $value";
}
else {
echo " $value";
}
}
?>

Inserting An Array Of Photos Into Database
I have a form layed out like so to upload photos and input the file name into the database. Code:

Inserting Data From A Sql Database Into An Array
I am currently working on a project where I need to put information from a sql statement into an array. Currently I can get one row into the array, but the rest aren't showing. I have checked, and all of the information is getting to the array, but I can only get one row to show up.

Here's the code:

while(($row = mysql_fetch_array($result)))
{
$info=array($count=>array('line1'=>$row["first_name"], 'line2'=>$row["last_name"], 'line3'=>$row["product"], 'line4'=>"$".$row["date"]));
$count++;
}

I'm trying to get this array to hold multiple rows from the sql statement, but when I display the array, I can only get one row out of it.

Looping Database Values To Create An Array
I have a fairly simple php code problem I think, I want to loop values from a mysql database within an array to fill the array. I'v never done this before so your help would be valued if someone had the time.

*denotes where I want to use database values*

Update Database With Textbox Array W/ PEAR
I am having slight problems with trying to get my page to work properly. Right now i have a form which displays the information of the rows in the database through textboxes. I have two textbox arrays: name[] and price[].

first i connect to database...

if form was submitted it goes through this code:

Checking If A Value Is Not In An Array And Deleting Record From Database
I have been trying to figure this one out and have come up against a brick wall although I know it should be relatively simple. I have a form that passes an array to a php script from a multiple select box that is created dynamically. If a user deselects an item then I want to delete the record from the database but am having a big problem with it. The table in the dbase is quite simple with just three fields:

id
classid
formid

Basically, the form send through a classid and a formid value and I want to delete any records that have a classid that are not in the form array and have a formid which is passed as a hidden value. I suppose really what I want is to know how to see if a classid is not in the array that is passed.

Retrieving (Data + Fieldnames) From Database To Array?
I'd like to poll a database and get the table contents, as well as the field
names from that table. I've been to php.net but this time I cannot find
something helpful.

I can get the data, and retrieve it into an array noproblem. [1]

I can get the data+fieldnames and put it into a list. [2]

But I cannot seem to be able to fill an array with the data *and* the
fieldnames. If you check both chunks of code, you will se what I'm doing....

Gettting Data From Database The Splitting Up Then Using An Array
in my database i have information like w_2 and i_1. The letter is reference to another table name which I need to use an array for and the number is refernce to an id.

So what I need is for when I get the data for it to be split into the letter and the number separately and then put the letter into an array to get the table name. Code:

Inserting A Complete Array In A Database Field
I have a very big signup form and it is almost impossible to create a full table for it because of very high number of form fields and I dont want to create a field for each of them in my database's table.

but I managed to store all the form values in an array, is there a way to fully insert an array to just one field? and for future use select it again as an array?

Deleting Database Rows From An Array Of Variables
I have a form with a list of checkboxes, which are each filled with a date in the format 27012007, for example. The name of each of the checkboxes is the same as the date.

Basically when the user presses the submit button I would like all rows in the database table "users" with the corresponding column "date" to be deleted when the form variables date correspond to those in the "date" rows. I think all the checked dates might also need to be put into an array. Would anyone know how to do this?

Database Column Matching Elements Of PHP Array
I've got a PHP array with 10 user ID values. I want to run a SELECT query to find all the rows where the UserId column matches something in my array.

Putting An Array In A Mysql Database Table Field
I want to insert an array into my database but i've got a problem with it.

Before i insert the array into the dbase i check if everything is in the array with print_r($array). Everything that should be in the array is in there so i insert it into the dbase.

When i check my dbase with phpmyadmin the field that should contain my array has the word array in it so i assume the array is in the dbase. But when i retrieve the data from my dbase and check my array with print_r i get the following error: Warning: Argument to array_values() should be an array in.

Address Element Of The Array Formed By Query To Database
I am making a function wherein if a query is passed it returns the result set cursor. Now before I return the cursor, I would like to process each element of the array. How do I address each element of the array, considering the field names are as per the query and not known. The function is

function useforquerytodb($thequery){
global $PHP_SELF, $DATABASE;
return mysql_db_query($DATABASE,$thequery);}

Multiple Array Selection From Database Instead Of In-Page Arrays
Have posted before, but will simplify problem here. For original post go to
http://forums.devshed.com/t80025/s.html

I have setup 2 arrays like so in my one page script:

Code: ( php )

Building PHP 4.3.3 With GD 2.0.11
All libraries were installed (precompiled)

This is FreeBSD 5.1
installed zlib, installed jpeg and png libraries (in default directories)
GD 2.0.11 source is in /usr/gd-2.0.11 (compiled and installed flawlesly)

I configured PHP with the following:

../configure --with-gd=/usr/gd-2.0.11 --with-freetype-dir=/usr --enable-g
d-native-ttf --enable-gd-imgstrttf --with-jpeg-dir=/usr --enable-png-
dir=/usr --
with-zlib --with-mysql --with-apxs2=/usr/local/apache2/bin/apxs

When configure came to reading jpeg header, it gave me an error about
libjpeg.a

I need GD, because I want to use coppermine (picture gallery) on my
"future" web site.

Contents of config.log file (from here to end of message):

This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.

configure:1618: checking host system type
configure:1706: checking for gcc
configure:1819: checking whether the C compiler (gcc ) works
configure:1835: gcc -o conftest conftest.c 1>&5
configure:1861: checking whether the C compiler (gcc ) is a cross-compiler
configure:1866: checking whether we are using GNU C
configure:1875: gcc -E conftest.c
configure:1894: checking whether gcc accepts -g
configure:1927: checking whether gcc and cc understand -c and -o together
configure:1942: gcc -c conftest.c -o conftest.o 1>&5
configure:1943: gcc -c conftest.c -o conftest.o 1>&5
configure:1948: cc -c conftest.c 1>&5
configure:1950: cc -c conftest.c -o conftest.o 1>&5
configure:1951: cc -c conftest.c -o conftest.o 1>&5
configure:1978: checking how to run the C preprocessor
configure:1999: gcc -E conftest.c >/dev/null 2>conftest.out
configure:2059: checking for AIX
configure:2086: checking if compiler supports -R
configure:2101: gcc -o conftest -g -O2 conftest.c -R /usr/lib 1>&5
configure:2159: checking for ranlib
configure:2187: checking whether ln -s works
configure:2212: checking for gawk
configure:2212: checking for mawk
configure:2212: checking for nawk
configure:2246: checking for bison
configure:2246: checking for byacc
configure:2290: checking for flex
configure:2324: checking for yywrap in -lfl
configure:2343: gcc -o conftest -g -O2 conftest.c -lfl 1>&5
configure:2367: checking lex output file root
configure:2388: checking whether yytext is a pointer
configure:2407: gcc -o conftest -g -O2 conftest.c -lfl 1>&5
configure:2431: checking for working const
configure:2485: gcc -c -g -O2 conftest.c 1>&5
configure:2510: checking flex version
configure:2650: gcc -o conftest -g -O2 conftest.c 1>&5
/var/tmp//ccQc5UBs.o: In function `main':
/usr/php-4.3.3/configure:2646: undefined reference to `pthread_create'
configure: failed program was:
#line 2632 "configure"...

Building PHP 4.2.x
I was able to build php 4.0.*, (apache 1.3.26, solaris 8) and now want to install the newest version. Here's my issue, i'm runing confgure with:

configure --with-apxs=/opt/apache/bin/apxs

it seems to make it through this part fine, then i run make and my output is below. I don't want mysql support or anything. The same steps work when i do it with php 4.0.* though, so i'm confused. Code:

Building Url From Variable
I am trying to do the following:
I want to assign a string to a variable then use that variable in an
HREF as follows:
<html>
<head>
<title>Test Doc</title>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
</head>
<body>
<?php
$var = "123.htm";
?>
The variable $var has a value of:...

Building Diary
I am building a month view of a diary and am enlisting the help of some previously created script. Although I understand how the calendar1.class creates the table, I am not being clever today and stuck on how to get the data into each day with an event/appointment.

The diary entrys need to be identified by thier cal_id in a SQL table and there is a start and end time to each entry. In each day I need to show the summary of the event and the start time and end time. Can you point me in the right direction? Here is the calendar class: PHP Code:

Building XML From MySQL
I'm getting 'Call to undefined function: new_xmldoc()' when I try the following script.
Does this mean that new_xmldoc is not a valid function. I could not find it in the manual.
Here is the script: PHP Code:

Building A Class
i'm building a class for a upload form and i want to know whats the best way to handle error in a class, like if someone enters a bad email or a bad password whats the best way to stop the class from keep going. Code:

Creating A Building Map
I am looking to impliment a digital maping system similar to google maps where I can take floorplans of my company and map assets to certain locations and search for them after. like google-maps meets an office people-finder so that when you are looking for printer 23-541-a you can just put it in the interface and it will bring up the map of where the asset is in the company.

Building An 'if' Condition On The Fly.
I would like to create the condition of the 'if' function on the fly, meaning :

$condition="$a > $b"; // this variable is a string that contain the 'if' condition
....
$a=1;
$b=1;
if ($condition) {
...
}

I hope you see what I mean here... In fact, I try to build the condition of the 'if' function so at the end it 'virtually' looks like this:

if ($a > $b){
...
}

Of course, here that does not work because $a=$b. Code:

Building A Dynamic If Statement
I am trying to build a dymanic "if" statement for the purpose of building a dynamic evaluation criteria to run agains a set of text data. If I were working with MySQL, it would look like:

$q ="Select * From table";
$q .= " WHERE id > 0";

$query = mysql_query($q);

However, since I am buiding something that looks like:

$q = "($X >= $min) && ($X <= $max)";

if ($y != ''){ $q .= " ($Z == $y"; }

$q .= ")"; if ($q){ do stuff }

Problem is that I know that the "if" is only evaluating whether or not $q is true. I need an alternative to building the dynamic if based of the search criteria the user enters (there are 7 options).

Building A Multi-pages RTF Doc
I'm retrieving datas from the DB (i.e. name, first name and address) and I want to generate standard pages using a RTF document I'v made.

To be more simple, I'm trying to make a mailmerge in PHP. I have a template called template.rtf. I open it, store the content into a variable, make the replacements and generate a RTF file that the user can download. This is OK if I have only one recipient.

But as I have 10 recipients in my DB, I'd like to generate a 10 pages RTF file, and then force the download of the generated file (the user would be able to save or print the new file).

How to generate a 10 pages rtf using a single page rtf template?

CLI Doesn't Install When Building From Source
I compiled 5.2 from source using the usual procedure and noticed that
only the cgi binary was copied to the /usr/bin directory. The CLI
binary was compiled but not copied over as I had expected. I manually
copied it to the /usr/bin directory as "php-cli" and everything worked
great.

Building GET Query Strings
I am currently building a sports web application and have run into a
design question.

In order to create a new coach record, there are two pieces of
information that are needed: 1) username 2) team_id

It seems to me that the best way to do this is to break the problem
into two parts. First, search for the username and append that to the
URL: http://www.mysite.com?username=john

Next, I would present the user with another search box to search for a
team and then add '&team_id=1' to the GET url. The final URL should
look something like

http://www.mysite.com?username=john...action=addcoach

Does anyone know of a good example out there for doing this in a
methodical and elegant fashion?

Building A PHP Site Test Bot
I run quite a large website, and we are going to need to migrate to a new server soon. I have a few hundred PHP pages. The problem is testing them, after i have moved the files to the new server. I can try my best to set up the server in the same way. But the server was first configured a long time ago.

Is there a way for me, using cURL and Regex to maybe get php to follow all links on my site, and Detect 404 errors and PHP errors. Im not too good with cURL yet, though learning. And regular expressions im not great with either.

Building Dynamic Forms
I am trying to build a form that allows the user to choose the options from a large zipcode database that we have. What we would like to do is for the user to enter in the State, City, and Zip code based on data going to and coming back from the database. Here is the scenario:

1. User selects the State from which they are in from a form dropdown menu. (A query from the zip code database gets done and brings up the cities and fills in the next dropdown menu dynamically)

2. Then the user selects a City (A query from the zip code database gets done and brings up the zip codes from the city entered above for the next dropdown menu dynamically)

3. The user select which Zip Code they live in.

PROBLEM: I want the form dropdown menus to be generated automatically when the user selects the option from the previous menu. I know how to do the above if the users go from form to form filling out information. But in this case, it would be much simplier to just have the choices be generated dynamically. I know that I will need to do an OnChange command for the menu, but alas my Javascript Programming isn't up to par.

Building Libpdf_php.so For FreeBSD
I wanted to use the pdflib library for creating pdf on the fly. My web server is running onto freebsd4.2+apache1.13.12+php 4.0.4pl1. I copied the binary library [libpdf-php.so] supplied by pdflib for freebsd and "installed" into php.ini using the extension directive.
I create a simple script and it works fine.

As stated by pdflib this is a demo version. So I decided to compile myself the pdflib library. This kind of operation has no support by pdflib staff, so this is why i ask to you. I see that inside /usr/local/lib I have a file libpdf.so, it's size is about 1.3 MB.
So i replaced the old .so demo with the new one compiled but now the script tell me that pdf_new function is not supported. This is mean of course that i'm using a bad file.

i do not want to compile pdflib into php because my web provider gives to me php as a module for apache,but i simply (hope easily) want to build the pdflib_php.so for freebsd from sources.

Building A Function For Ereg_replacements
for our upcoming zine we are naturally filtering our writers' submissions so that their input doesnt meddle with the coding. i've done all the ereg_replace calls for what we want to substitute certain formatting options with. such as bold, urls and Code:

Building An Online Poll
how I should go about starting a web poll script. The purpose of the web poll is sort of like a "Class Poll" for my school. Which pretty much means that there will be a number of categories such as "Shyest" "Friendliest" "Most Athletic" and so on. Then each category will have a drop box with the names of the students in each class 80 or so names.

A student will come to the poll browse the categories then vote for a person by selecting their name from the drop down box, once they are completed the click the submit button. The results will be based on has the most votes for that category will be the winner. Now I am unsure how to go about the infrastucture of the script do need to use a database or can this be acomplished with arrays.

Building Php Extensions With Cygwin
Has anybody managed to build a Php Extension (Loadable Module)
under Cygwin. I tried to build the example first_module found on
http://www.zend.com/zendapi. It compiles and works well under linux.

Under windows with Apache 2.0.48 or 1.3.29, I managed to compile
it using cygwin compiler but I have the following message :

Warning: dl(): Unable to load dynamic library
'c:phpextensionsfirst_module.dll
(of course, the file is located in the good path)

I only found tutorials using Visual Studio so any experience
feedback about a similar problem would prove to be very usefull.