PHP - Moved: Retrieving Field Names And Values From Database

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=334042.0

Hi all.  I've got a little function to generate a simple form depending on the input.  What I'd like to do is alias the field names that get output to make them a little more human readable.  However, I'm not entirely sure how to do that with the output that I get.

The function....
function build_form($table_name){
$result=mysql_query("SELECT * FROM $table_name");
$num=mysql_num_rows($result);
$i=1;
echo "<table>";
while ($i < mysql_num_fields($result)) {
$fields=mysql_fetch_field($result,$i);
echo "<tr><td>" . $fields->name . "</td><td><input type=\"text\" size=\"30\" name=\"" . $fields->name . "\" /></td></tr>";
$i++;
};
echo "</table>";
};

Q:  Where would I have to modify the output from mysql_fetch_field?

My modified function...
function build_form($table_name){
$result=mysql_query("SELECT * FROM $table_name");
$num=mysql_num_rows($result);
$i=1;
echo "<table>";
while ($i < mysql_num_fields($result)) {
$fields=mysql_fetch_field($result,$i);
                $field_name=str_replace("_"," ",$fields->name);
echo "<tr><td>" . $field_name . "</td><td><input type=\"text\" size=\"30\" name=\"" . $field_name . "\" /></td></tr>";
$i++;
};
echo "</table>";
};

Not sure if that will work, but am I heading in the right direction?  Any help is much appreciated!

Hi All, small question here. I was just playing around with a small script I made to obtain an ip-address, remove the dots and than glue the parts together. Not for any use but for practice. But I am having difficulties to accessing the array values. But maybe that because its the first time i am using explode() and print_r. If someone has a spare minute I would be pleased to be enlightened.

<?php
             $ip=$_SERVER['REMOTE_ADDR'];
             echo $ip.'<br />';
             $cleaned_ip = substr($ip,0,6);
             echo $cleaned_ip.'<br />';
             $cleaned_ip2 = print_r(explode('.', $ip, 6)).'<br />';
             // this is the point where I dont know how to get the array values.
             // echo $cleaned_ip2[0].[1].[2];   that doesnt work. ;(
         ?>

Hi.

The idea:

I want to pull a client record and simply place all the row columns into editable form field text boxes. Once the user reviews and edits a submit button will update the record.

What I have:

Code: [Select]
$Query01 = "SELECT * FROM `CustomerSignups`
WHERE `Id` = '$_GET[Id]'";
$Result01 = mysql_query($Query01) or die("Error 01: " . mysql_error());

while ($get_info = mysql_fetch_row($Result01))
{
foreach ($get_info as $field)
echo "<p>$field</p>";

It displays as expected, a line for each field.

How can I get this to pull the field names also and then I can use those as text box input fields...?

I would like to echo field names in my table on webpage one by one. I know mySQL has "describe" function which will list the complete table, I am looking for a way to display each field name one by one with other stuff in between them like input field or description.

I need to update a particular table and there be a whole lot of field names. I'd like to do it without having to use them the same way you can access then like $row[12] after a "select" query. The standard for updating (at least how I write it) goes like this ...
Code: [Select]
$query = "UPDATE linguistics SET welcome1='$var3', welcome2='$var4' WHERE language = '$lengua'";
Well, I'd like to do it where I don't have to name welcome1 and welcome2, but instead refer to their numerical position within the database. On a "select" query we can do this. Can this be done on an update? Something perhaps like ...
Code: [Select]
$query = "UPDATE linguistics SET 3='$var3', 4='$var4' WHERE language = '$lengua'";
... where 3 and 4 represent the 4th and 5th fields respectively. I know that this particular phrasing doesn't work because I've tried it, but surely there has to be something. This will save me LOTS of time. Thanks!!

I have the following mysql query:
Code: [Select]
        $lead_query=$this->db->query("
   SELECT `first_name`, `last_name` , `state` FROM leads WHERE `lead_id`='$lead_id'
   ");
   $this->view->lead_query=$lead_query->fetchALL();
Now when I retrieve the above details  I need to return the first_name last_name together(separated as space) and the name of the key as client_name in the array.

I need it that way because when i return a json_encode($lead_query), I want to return the first_name.last_name as client_name.

I currently have php code that outputs information from my database, but how do i make it also display the name of the fields beside each entry of the database?

heres my PHP code:
Code: [Select]
<?php

$server = "";      // Enter your MYSQL server name/address between quotes
$username = "";    // Your MYSQL username between quotes
$password = "";    // Your MYSQL password between quotes
$database = "";    // Your MYSQL database between quotes

$con = mysql_connect($server, $username, $password);       // Connect to the database
if(!$con) { die('Could not connect: ' . mysql_error()); }  // If connection failed, stop and display error
mysql_select_db($database, $con);  // Select database to use
// Query database
$result = mysql_query("SELECT * FROM Properties");

if (!$result)
{
    echo "Error running query:<br>";
    trigger_error(mysql_error());
}
elseif(!mysql_num_rows($result))
{
    // no records found by query.
    echo "No records found";
}
else
{
    $i = 0;
    echo '<div style="font-family:helvetica; font-size:15px; padding-left:15px; padding-top:20px;">';
    while($row = mysql_fetch_array($result)) {     // Loop through results
        $i++;
         echo '<img class="image1" src="'. $row['images'] .'" />';   //image
        echo "Displaying record $i<br>\n";
        echo "<b>" . $row['id'] . "</b><br>\n";      // Where 'id' is the column/field title in the database
        echo $row['Location'] . "<br>\n";            // Where 'location' is the column/field title in the database
        echo $row['Property_type'] . "<br>\n";       // as above
        echo $row['Number_of_bedrooms'] . "<br>\n";  // ..
        echo $row['Purchase_type'] . "<br>\n";       // ..
        echo $row['Price_range'] . "<br>\n";         // ..
    }
echo '</div>';
}

mysql_close($con);  // Close the connection to the database after results, not before.
?>



thanks in advance

Okay, so I'm trying to run a query to pull the information from a specific item that they click on in order to edit it.

When I run an echo $query, though, it shows the field names rather than the information from the table.

How can I make it so that it pulls the information rather than the field names?

Here's what I have...


<?php
include("lib.php");
define("PAGENAME", "Edit Equipment");

if ($player->access < 100)

$msg1 = "<font color=\"red\">"; //name error?
$error = 0;

$query = $db->execute("SELECT * FROM items WHERE id=?", array($_POST['id']));

echo "$id";

$result = mysql_query($query);

echo "$query";

$data = mysql_fetch_assoc($result); 

$msg1 .= "</font>"; //name error?


?>


Thanks!!

I have figured out far enough to loop through my table and return a list of check boxes that will be matched to a product. My issue now, is i cannot figure out the proper way to loop through them after they are selected and return them as checked/unchecked for the given product. Thought there is some MySQL involved, that part isn't the problem, I know how to insert into a database or update...when the product is selected from a drop down, I need to be able to populate the checkboxes.

Here is the code i am using to initially display all of the categories to choose from...

<ul class="categories">
  <?php 
    $query = "SELECT * FROM products";
    $result = mysql_query($query) or die(mysql_error());
    while ($row = mysql_fetch_assoc($result)) {
 $category = $row['category'];
 $catId    = $row['id'];  
 echo "<li><input class='catCheck' type='checkbox' name='p_cat[]' value='$catId' /> $category</li>";
    }
  ?>
</ul>



   Thanks guys....

How to output a MySQL timestamp field to correct local time with daylight saving with PHP?   Local time is set in php.ini with: date.timezone = "Europe/London"   Confirmed set with:   <?php echo date_default_timezone_get(); ?>   But when I echo the timestamp field it does not display correct UK time for the record (an hour behind correct UK time).   <?php echo date('jS F Y - g:ia', strtotime($row['Date'])); ?>  

Hi,

I'm having problems retrieving the values from a form posting without getting a warning

My form records playername, hours played and minutes played

Code: [Select]
<li id="input1" style="margin-bottom:4px;" class="clonedInput">
Name:
        <select name="player[1][userid]" id="player[1][userid]" class="playerInput" style="width: 7em;" >
        <option value=""></option>
        <?php
while($row = mysql_fetch_array($sql)) {
echo '<option value="'.stripslashes($row['userid']).'">'.stripslashes($row['name']).'</option>';
}
mysql_data_seek($sql,0);
?>
        </select>       
        <select name="player[1][hours]" id="player[1][hours]">
        <option value="">Hours</option>
        <option value=""></option>
        <?php
for($x = 0; $x <= 23; $x++ ) {
             echo '<option value="'.$x.'">'.$x.'</option>';
}
?>
        </select>
        <select name="player[1][minutes]" id="player[1][minutes]">
        <option value="">Minutes</option>
        <option value=""></option>
        <?php
for($y = 15;  $y <= 59; $y+=15) {
             echo '<option value="'.$y.'">'.$y.'</option>';
}
?>
        </select>
</li>

I use some javascript to create new players as necessary so every player has a userid, hours, minutes played...
After posting the query string looks like this

/cLeagueHandler.php?player[1][userid]=1&player[1][hours]=3&player[1][minutes]=15&player[2][userid]=3&player[2][hours]=6&player[2][minutes]=45&submit=Save+Points

player1
userid = 1
hours = 3
minutes = 15

player2.......

The code i'm using to access the values is

Code: [Select]
        print_r ($_GET); // test display form values
       
foreach ($_GET as $key => $value) {
echo '<br/>'.$key.'<br/> ';
foreach ($value as $iKey => $iValue) { // Line 72
foreach ($iValue as $xKey => $xValue) {
echo " The $xKey for Player $iValue is $xValue <br/>";
}
}
}

The above code displays

Array ( [player] => Array ( [1] => Array ( [userid] => 1 [hours] => 3 [minutes] => 15 ) [2] => Array ( [userid] => 3 [hours] => 6 [minutes] => 45 ) ) [submit] => Save Points )
player
The userid for Player Array is 1
The hours for Player Array is 3
The minutes for Player Array is 15
The userid for Player Array is 3
The hours for Player Array is 6
The minutes for Player Array is 45

submit

Warning: Invalid argument supplied for foreach() in .................cLeagueHandler.php on line 72

Line 72 is foreach ($value as $iKey => $iValue) {

If anyone could help me with this it would be great appreciated.......I want to be able to build and sql string to Insert a players id, hours, minutes into a database......(obviously not incl the submit value!)
Maybe this is not even the best way of approaching this.....I'm quiet new to PHP so apologies if this is long winded...I'm trying to give as much info as possible....

thanks in advance

tmfl

I am building a website that uses session variables extensively.  The site is getting a little complicated, and I am starting to lose track of which session variables are assigned, and what their values are.  Is there some way where I can create a piece of code that will display all of the existing session variables and their values?

I've googled a lot but still can't find much of a clue for how to do this (printing all environment variables in PHP that is).
I know it has something to do with $_ENV and $_SERVER but...

I would be thrilled for some guidance!

Best regards,
Rasekamon

Code: [Select]
$query = mysql_query("SELECT a.*, b.*
         FROM friendlist a
INNER JOIN friendlist b
ON (a.friendemail=b.friendemail)
INNER JOIN users c
ON (b.friendemail = c.EmailAddress)
WHERE a.email = 'asdf@gmail.com'
AND c.Username LIKE '%carol%'
GROUP BY a.id
ORDER BY count(*) DESC");
Code: [Select]
while ($showfriends = mysql_fetch_array($query)) {
     echo $showfriends['Username'];
}
and I would get nothing. It produces the correct number of <div> so i know it's getting through, but it's having trouble displaying the entries?