PHP :: Displaying Data From Array

Inputing And Displaying Data
i have a website that will list certain shops in my area. i want these shops to be displayed in a table with 4 columns on my website, the first being the name of the shop and when you click on the shop it links you to there website. the rest of the columns will be different images depending on what service they provide.

i thought i could create a form that allows me to input the name of the shop etc, but each time i submit the form it adds the information to my database and creates a new row each time i submit a new shop on the table on my website page.

im very new to php and sql so it would be helpful if you could link me to a tutorial that sort of tells you how to do this or add me on msn.

plus i was just wondering if it is worth buying a book about php and mysql or should i stick to online tutorials. if it is, please recommend me some.

Grabbing Data From A Table And Displaying It
I'm grabbing data from a table and displaying it but I want to to spand out into multiple pages...I got it all setup but when I click on the next link nothing happens... I got it setup at "3" right now just for testing..I have 5 entries in the database.. anyways could someone help me out? here is the code:

<?php

// Get connection info
include "../connect.php";
// End connection info
if(!$rowstart) $rowstart=0;
// Start database select
$result = mysql_query(
"SELECT * FROM links WHERE notactive='$notactive' order by date desc limit $rowstart,3"); //Select Database
$result2 = mysql_query("select * from links");
if (!$result) {
echo("<P>Error performing query: " .
mysql_error() . "</P>"); exit(); }
// Display the text of each host
while ( $row = mysql_fetch_array($result) ) {
if ($notactive = 1) {
echo ("<table width=500 height=57 border=0 cellpadding=0 cellspacing=0>");
echo ("<tr>");
echo ("<td align=left valign=top><strong>" . $row["name"] . "</strong></td>");
echo ("</tr>");
echo ("<tr>");
echo ("<td align=left valign=top>" . $row["desc"] . "</td>");
echo ("</tr>");
echo ("<tr>");
echo ("<td align=left valign=top><a href=" . $row["url"] . ">". $row["url"] ."</a></td>"); }
echo ("</tr>");
echo ("<br><br>");
echo ("</table>");
}
if ($rowstart>$numrows)
{
echo "<A HREF=$php_self?rowstart=rowstart-3>";
echo "< Previous Page</A>";
}
echo "|";
$numrows=mysql_num_rows($result2);
if($rowstart+3<$numrows)
{
echo "<A HREF='$php_self?$rowstart=rowstart+3'>Next Page></A>";
}
?>

Displaying Data Based On Variable
A Newbie to PHP so please forgive any ignorance of simple methods.

I am trying to develop a site that is driven by a MYSQL database. Dependant on which domain you have been redirected from I need to somehow pickup the domain redirected from and set a global constant to only pull from relative MySQL data e.g FOO = xyz.

This site will obviously have multiple users and I need a way to ensure that user A will be browsing xyz while user B will be browsing abc.

The way I can think of but not entirely sure how to get working in PHP is to assign a Value to the session (FOO) and then on database queries uses WHERE foo_ID = (FOO).

PHP MySQL Query Not Displaying Data
I am having some problems with a database query that I am trying to do.
I am trying to develop a way to search a database for an entry and
then edit the existing values. Upon submit, the new values are updated
in all corresponding tables (the function of the pages in question).
However, on the page that does the DB update, I also want to do some
checks on the data before performing the update.

Now, the problem that I am running into is that when I don't update the
primary key field (keyid) the page is running into the section where it
displays a message that the keyid already exists. This only happens
when the keyid on the previous page is not changed.

Upon troubleshooting the problem I found that the very first SELECT
statement does not seem to be returning any rows despite the fact that
the statement, when run on the SQL server, returns exactly one row. If
any could provide some assistance with this matter, I would be most
appreciative.

Code:
<?php
session_start();
header("Cache-control: private"); //IE 6 Fix

//continue if authenticated
if ($_SESSION['auth'] == 1)
{

//get variables from post
$keyid = $_POST['keyid'];
$username = $_POST['username'];
$corpid = $_POST['corpid'];
$usergroupname = $_POST['usergroupname'];
$oldkeyid = $_POST['oldkeyid'];
$oldcorpid = $_POST['oldcorpid'];
echo("Keyid: $keyid");

// Connect to MySQL
mysql_connect ("address.com", "user", "pass")
or die ('I cannot connect to the database because: ' .
mysql_error());
//select database on server
mysql_select_db ("seniorproject");

//SQL Statement
$sql = "SELECT keyid, corpid FROM users
WHERE keyid='".$keyid"'";

// Execute the query and put results in $result

$result = mysql_query( $sql )
or die ( 'Unable to execute query.' );
echo mysql_result($result,0);

// Count number of matches and print to screen
$numrows = mysql_numrows( $result );
if ($numrows == 1)
{echo(" SQL Query: $sql");
$result_ar = mysql_fetch_row($result);
$result_ar = mysql_fetch_row($result);
$dbkeyid = $result_ar['keyid'];
$dbcorpid = $result_ar['corpid'];
echo("<br> CorpID: $corpid <br>");
echo(" DBCorpid: $dbcorpid <br>");
echo(" DBKeyID: $dbkeyid <br>");
if($dbcorpid == $oldcorpid)
{
//If this condition is true, then KEYID has not changed. Execute
code

// Formulate the query

$sql = "UPDATE users
SET corpid = '".$corpid."', username = '".$username."',
usergroup = '".$usergroupname."', keyid = '".$keyid."'
WHERE keyid = '".$oldkeyid."'";........

Displaying Data In A Editing Form
I have a form that has three checkboxes. A,B&C. Data from A & C has been entered into the database by serializing it.I now want to create a edit form where the user can view his choices ticked.

<form action="postoDb.php">
A<input type="checkbox" name="Choice[]" value="A">
B<input type="checkbox" name="Choice[]" value="B">
C<input type="checkbox" name="Choice[]" value="C">
</form>

//postodb.php
$bn = serialize($Choice);
sql ="insert into table (choice) values('$bn')";

Displaying Rows Of Data As Columns?
Does anyone know of an efficient way to retreive data from a mysql db
and display the record rows as collumns?

I have been doing this:
<display headers>
<while ($row = mysql_fetch_array($result)) { >
<display row 1 of result>
<display row 2... } >
<end table>

but I want to do this instead:
<col 1 header > <row 1 col 1> <row 2 col1> <row3 col1>
<col 2 header> <row 1 col 2> <row 2 col2> <row3 col2>
<col 3 header> <row 1 col 3> <row 2 col3> <row3 col3>

Question About Displaying MySQLl Data
Could someone point in the correct direction with regards to displaying my
data in "nicer" format. I have figured out ( with the tutorials on the web,
and the O'Reilly PHP & MySQL book) how to store, retrieve, manipulate, and
display my data using PHP. But when I do display, it is the block format.
I can't seem to find a tutorial that gets into a "prettier" type of display.

Is this a HTML issue?

I am a newbie to this stuff

Displaying Data In Html Table.
I wondered if anyone could offer some guidance, I trying to write a
php script to connect to a database, and display the records in a
table.

I found the code here in a php4 text, and when I run this directly
through the php intrupeter, the line Successfully connected is display
and 4 as the number of rows.

The database table we connect to, has three field username, firstname,
surname.

When I tried a while loop, to display the data in a table. No values
were displayed.

Could anyone possibly demonstrate how to display the username,
firstname, surname values in a basic table?

<?php
function db_connect(){
global $MYSQL_ERRNO, $MYSQL_ERROR;

$link_id = mysql_connect("localhost","user04", "password04");

if(!$link_id){
$MYSQL_ERROR = "Connection failed";
return 0;
}
else if(empty($dbname) && !mysql_select_db("database04")){
$MYSQL_ERROR = mysql_error();
return 0;
}
else return $link_id;
}

!$link_id = db_connect();
if(!$link_id) die(error_message('Error connecting'));

$result = mysql_query("SELECT * FROM users");
if(!$result) error_message('Error in selection');
else echo "Successfully connected. ";

$query_data = mysql_fetch_row($result);
$total_records = $query_data[0];

if(!$total_records) error_message('No records');
else echo "$total_records.";
?>

Displaying Data From A Flat File?
ive got a flatfile database sorted out, all i need now is how to store individual flat files per user and how to paginate that data. Just to make sure i'm doing everything right, i'll post the code below Code:

Drop-down Displaying MySQL Data
I've got this dropdown trying to call the data in...basically, I only want it to show if it is an upcoming event. Past events are hidden away in the archives.

I can get it to work if I remove the if ($row['date'] etc, but not with it in. Can anyone spot any errors with my code? Code:

Displaying X Every Y From A Db Array
ok this is probly the easiest question and i knew how to do it before but cant find it again.

ok how do you display x every n from a load of records like from a db.

so for example, display <tr> every 6 records from a db?

cause i want to display a load of pictures, and i am gonna show 6 then make another row of 6, etc. so i need to add <tr> and </tr> to start and stop the rows.

Displaying Line Breaks From MySQL Data
when i retrieve data from a MySQL database which i have put line breaks in they do not show in html, i understand that this is because HTML ignores spaces unless they are formatted as   i know i could use the <pre> tag to show it as it was given, which removes all styling from the text, i need to convert the breaks in MySQL into <br> or <br><br> (to start a new paragraph)

Combining Data From Two Fields, Displaying With Another Table
What I am trying to do is pull data from two tables and display it on one page. The code below doesn't display any errors, but all it prints is the results from the first query. Ideas? Thanks.

(I also need to somehow put a variable in for the warranty table data so it is tied to the product_status table data. You can see there is a WHERE in the first query of pid, but no WHERE in the second query. That is a seperate question, though. It would make this way too long, so I will post it separately). PHP Code:

Hide Characters When Displaying Recordset Data ?
i have a mysql and php website, some of the products have an _ underscore (epson_dx500 eg) . i display these items listed vert down the page, i want the data in the table to stay the same but when displayed on the page i want to hide the underscore.

Displaying Array In Checkboxes
Objective:
User have a multi (20) checkboxes ($notif_empr_city) to select his preferences regarding being informed of new events in cities selected. If user selects one or more cities, the result is imploded into an array($ned_array) stored in the database in the field (notif_empr_city (varchar 255 NOT NULL)). Untill here, no problems with this.

Problem:
The problems start when trying to get this array out of the database in order to check or not (depending if the condition exists) the respective checkboxes again. This to enable the user to select more or unselect his preferences. The code I was using for displaying this array was the following, and isn't displaying any data that exists in the database. What is preventing from checkboxes to get checked ?
Code:

Displaying An Array With Its Keynames
I have an array with string and numerical indices:
$arr ['x'][0] = 10;
$arr ['y'][1] = 90;
$arr ['d'][1] = 45;
$arr ['y'][0] = 34;

Keys are not in a sorted order and preferably it stays that way. How can I
display the results like this:
x0 : 10
y1: 90
d1: 45
y0: 34

,using a foreach loop ? I tried with array_keys () like so:
foreach ($arr as $a) {
echo array_keys($a)." $a <br>";
}

but my output is this:
Array 10
Array 90
Array 45
Array 34

Is a foreach just not possible here or do I need to use another function or
this one differently ?

Displaying Binary Data To Browser And Set Mime Type
I am looking for a link or help on how to set the
mime type in my php script as well as send binary data to the browser
window instead of having it ask me to save the file.

Displaying Array Results In Table
I'd like to display the results of an array in a table format with the Alias, Alias Destination & Username as column headings & the results underneath. PHP Code:

Displaying Prev() And Next() Values From An Array
I have a simple table stored in an array and I want walk through the array and retrieve the current record values, next record values, and previous record values - or each record. I can output the current record values, but is there a way to output the next and previous record values using the Next() and Prev() functions. Code:

Array Data Matches But Array Created In Loop Doesn't Work
I have the exact same data in two arrays, but only the array created
like so will work:

Displaying Data From Mysql Database In A Drop Down List On Form.
I'm trying to do is display data from two different mysql tables from the same database in a drop down list on a html form. I have a fixtures table with the player1(userid), player2(userid), gameid, game, score1 and 2, what I want is to use the userid to get the players first name and surname from the members table (as it is a unique id), I need to do this bit before displaying it in the drop down. I think i need 2 querys to do this but when I have tried it it just echo's a blank value or the userid not the forname and surname that I want. I'm using the fetch_array function but just can't see where I'm going wrong, Code:

Displaying An Array From Rows Retrieved From Mysql
I have a web site where users can add pages to it. When they make a new web page the url of the page and username of the user who created it is stored in Mysql. When the user logs back in the users previously made pages are displayed as links or atleast should be. Below is the code that I am using. PHP Code:

Searching And Displaying A 'record' In A Multidimensional Array
I have a multidimensional array that fills with data from a database. The array could look like this: Code:

Trying To Calculate An Average Array From An 2d Data Array
I'm trying to calculate an average array from an 2d data array.
my problem is that my function does not generate an average array but just
one value. but i do not understand why it does not work.

code:
-----
function calculateAverageRating($rating_matrix)
{
$average_rating = array();
foreach($rating_matrix as $cus_id => $ratings)
{
$counter = 0;
$sum = 0;
foreach($ratings as $pro_id => $item_rate)
{
$counter++;
$sum += $item_rate;
}
echo $cus_id."->".($sum/$counter)."<br>";
$average_rating[$cus_id] = ($sum / $counter);
}
echo "<hr>";
echo "<table> <tr>";
foreach($average_rating as $key => $value);
{
echo "<td>$key::$value</td>";
}
echo "</tr></table>";
return $average_rating;
}

wanted:

input -> output

1 1 1 1
2 2 2 2
4 4 4 4

but my functions just does:

input -> output

1 1 1
2 2 2
4 4 4 4

How To Add Data To An Array
I have a question about how to add to an array. below is a test program for an associative array in which the value is also an array. I can work out how to fill the array when it is declared (as shown) but I have not been able to understand how to add another set of data later on. PHP Code:

Get Data Into An Array
how can i take this data and create an array? i have no idea where to
start.

"STEAM_0_1_9791900"
{
"Freq""3"
"Count""3"
"1""something"
"Namefreq""3"
"2""something else"
"3""anything"
}

Help With Displaying Selecting A Date Range And Displaying Results
I wish to create a simple form that allows the selection of a start date and a stop date with the ability to select what columns to be displayed in the result page.

Getting Array Data Into A Variable
I've spent most of today trying to solve this problem, but sadly no
luck.
I have an shopping basket based on an array which stores the name,
product id, quantity and price for products, i want to take the
Information in the array and output the Quantity and Product ID
information into variables so that i can pass them into a Select
Statement and submit the order to the database.

The Current Code to Show the cart is listed below: -

function show_cart() {
if (isset($_SESSION["item_count"]) && $_SESSION["item_count"] > 0) {
echo "<table class="basket"border="0">";
echo
"<tr><td>Item</td><td>Price</td><td>Amount</td><td>Subtotal</td></td></tr>";

$total = 0;
for($i=0; $i<$_SESSION["item_count"]; $i++) {

echo "<td><a
href=insertselfpagehere.php?deleteitem=1&ProdID=".$_SESSION["items"][$i][0].">";

$item=$_SESSION["items"][$i][0];
echo $_SESSION["items"][$i][1]."</a></td>";
echo "<td>".$_SESSION["items"][$i][2]."</td>";
echo "<td>*".$_SESSION["items"][$i][3]."</td>";
$subtotal = $_SESSION["items"][$i][2] * $_SESSION["items"][$i][3];
echo "<td align="right">$subtotal</td>";
echo "</tr>";
$total += $subtotal;
}
echo "<tr><td><b>total</b></td><td align="right"
colspan="3">$total</td></tr></table>";
}

else {
echo "No items";
}
}

Array Only Prints First Row Of Data
I've used the following code to display some info about a users perscription history from a database. The code below works fine but only shows one row of data when there are 17 in the database for one particular user...(this applies to al users) Why may this be?? It only prints the first bit of data in the array! Code:

Getting Data Out Of Three Dimensional Array
I want to extract data from 3-dimensional array into one dimensional array here's example of two arrays that i add into one: PHP Code:

Incoming Data Into Array?
I'm opening a remote file on a regular basis, the data is in the
following format and has a line feed of "0D 0A". The spaces are 20 in hex
mode.

2006-07-26 22:00:03.000000 4.370996 51.656616
2006-07-26 22:00:03.000000 2.599964 49.286836
2006-07-26 22:00:03.000000 0.876824 48.418013
2006-07-26 22:00:04.000000 1.543656 50.926529
2006-07-26 22:00:04.000000 1.070219 48.759254

Firstly, this incoming data is oldest first and is continually updating.
However it only shows the previous hours data. My main aim is to take this
data and split it into an array. Currently I'm using file_get_contents(),
and am just wondering what the best method to get this into a workable
format?

Array Of Form Data
After submitting form data to a page called procform.php, I want to be
able to see a list or array of all the inputs that were submitted from
the form. I scoured the PHP books I own and did some google searches,
but found nothing in this regard. I know I can use $myformvar in
procform.php if I know the form had an input like this: <input
type=hidden name=myformvar value=190> But, surely, there must be a way
to get a list of all the variables assigned from the form in PHP, right?

Returning An Array Data
I am parsing an XML file and returning the data back as an array. However, nothing returns back even though I can echo the data to the screen. Here is the code:

Cleaning Up Data In An Array
I have an array with 10 items in it. How do I go about clearing all spaces before the data?

Ex:
Before: jacob
After: jacob

Also some of the data looks like this, World of Warcraft Guide

How do I go about checking each value for this   and replacing it with a space if its there?

Set Array To Re-use Data From DB Inquiry?
I have a page which make multiple inquiries to a local mySQL DB, and in my attempt to avoid adding to the number of inquiries I am trying to set an array to a string of data pulled from a inquiry inside of a loop, specifically: Code:

Adding Data To An Array
I'm trying to make a simple shopping basket script, but am a little unsure of the best way to do it. I want an array where items can be added/removed with a simple form and displayed as a list, but I'm a little unsure how to go about doing it. Code:

Addslashes To Array Data
I have a script that takes the form contents and inserts into the MySQL database. The form elements are written out dynamically via PHP. The form looks like this:

<form... etc.>
<input type="text" name="edu[]" />
<input type="text" name="edu[]" />
<input type="text" name="edu[]" />

</form>

On the page that processes the form, my script looks like: ...

Incrementing Array Of Data From A Form
I'm trying to take a set of data generated by a form (web) which will basically be a set of yes/no data. I need to take that information (it's a poll/survey we're conducting on customer satisfaction) and increment a stored text file with the results.

If I have 25 ppl hit the page, 20 say no, 5 say yes (to up to 30 questions), I need to see that in the text file: 30 questions with 2 columns of info and possibly a 3rd column for the few questions that ask "if not, please explain" -- OR if someone has a better way to generate the file.....??

Using An Array To Insert Data Into A Table.
This works:
$col1 = 2;
$col2 = 2;
$col3 = 2;
$col4 = 2;
$query = "INSERT INTO test (a,b,c,d) VALUES ($col1,$col2,$col3,$col4)";

and this does not

$col = array(2,2,2,2);

$query = "INSERT INTO test (a,b,c,d) VALUES ($col)";

Writing Data From An Array To A File
I'm am writing a script to basicly function as a news script but will be modified/made for anoter purpose. Anyways, I have been sucessful in opening the data file, seporating each (item; in an array), and then dividing each item up (item1||item2||item3, etc.) for use in the script and display purposes.

When each item is printed out and "delete" link/button is printed under each. When clicked will pass an action (delete) and an item_key (the items ID). From there I would like it to do the following:

Unset the item that was clicked for deletion (via item_key)
Open the data file
Write the remaining items in the array back to the data file
Close the data file

I set the following up at first for testing so that it wouldn't actually do anything with the data file but just unset the delete item and print (echo) the rest to make sure it was doing want I wanted it to do. And everything seemed fine. When I changed it to open, write, etc to the file something must me wrong. It just delete's everything. Can anyone tell me what I need to do to fix this buy the code:

PHP Array Email Data In CSV Format
I have a web form which collects data and then does a POST action to call a PHP file which takes the data and sends it to an email address. This all works fine, but right now when I get the data in my email I get it back as follows:

Date Submitted: 7/28/07
Name: Mark Jones

I do not want the Labels with the : (I just want the data emailed) Basically what I need to be able to do is easily copy this data into an Excel file when I get it. With the labels include with the :, the data all gets put into the same column in Excel, so I need to remove the labels. I'm pretty sure I have to modify something in my code listed in Red below, but not sure what or if thats the only thing. Code:

Displaying Data From Array

I have a data stored in an array. Want to display it in Internet Explorer... However,could not display it.