PHP - Data Not Showing Up In Tables??

Hi all,
I want to create a website, where the user can add any number of custom fields, and then put any info there he or she wants.
I then need a site to display the info.
The problem is that I have no idea on what would be the smartest way to do this.
Let's say it was about flowers and they created a "type" field and a "stock" field.
How could i make sure, that the correct stock will be displayed with the correct type field?

Hello, I have done this with SimpleXML variables many times. I seem to be struggling with something really simple as I am venturing out with some JSON. Basically there is a variable $nowcast. Sometimes that node may be empty. So I want to display an alternative message if it is empty like it is now. Unfortunately I am having some struggles and can't get the message to display when the node is empty. What am I missing?    -Thanks

// Lets get parse the data and create the variables
  $json_string = file_get_contents("http://api.wunderground.com/api/REMOVED_KEY/geolookup/conditions/q/TX/Mesquite.json");
  $parsed_json = json_decode($json_string);
  $Updated = $parsed_json->{'current_observation'}->{'observation_time'};
  $location = $parsed_json->{'location'}->{'city'};
  $nowcast = $parsed_json->{'current_observation'}->{'nowcast'};

// Lets make some style classes for your divs
  $divContainer = "width:{$divWidth};background-color:{$bkgColor};color:{$txtColor};border:{$border} 1px solid;font-size{$fontSize};";
  $divHeader    = "width:100%;background-color:{$titleBar};";
  $divWrapper   = "padding: 5px 5px 5px 5px;";
  $pStyle       = "color:{$titleTxt};margin:0 0 2px 2px;";

// If there is an available message display it
  $nowCast = "<h3 class='title'>NWS NowCast<span style='float:right'> {$Updated}</span></h3>";
  $nowCast = "<hr />";
  $nowCast = "<div class='NWSRound'>";
  $nowCast = "<div style='{$divWrapper}'> {$nowcast}</div>";
  $nowCast = "</div>";
  $nowCast = "<table border='0' cellpadding='0' cellspacing='0' width='100%'><tbody><tr><td><img alt='' src='images/1pixel.gif' border='0' height='7' width='7' /></td><td class='shadow-mid' width='100%'><img alt='' src='images/1pixel.gif' border='0' height='7' width='7' /></td><td><img alt='' src='images/1pixel.gif' border='0' height='7' width='7' /></td></tr></tbody></table>";


// If there is no available message then lets display the following
 $noMessage = "<h3 class='title'>NWS NowCast<span style='float:right'> {$Updated}</span></h3>";
 $noMessage = "<hr />";
 $noMessage = "<div class='NWSRound'>";
 $noMessage = "<div style='{$divWrapper}'> No valid short term forecast for {$location} currently available at this time</div>";
 $noMessage = "</div>";
 $noMessage = "<table border='0' cellpadding='0' cellspacing='0' width='100%'><tbody><tr><td><img alt='' src='images/1pixel.gif' border='0' height='7' width='7' /></td><td class='shadow-mid' width='100%'><img alt='' src='images/1pixel.gif' border='0' height='7' width='7' /></td><td><img alt='' src='images/1pixel.gif' border='0' height='7' width='7' /></td></tr></tbody></table>";


if(count(json_decode($nowcast,1))==0) {

    echo $nowCast;

} else {

 echo $noMessage;

}
 

Edited by Texan78, 16 December 2014 - 10:44 PM.

I've put together a very simple form & processing script for my site.. Everything works great except the body of the email i receive when the form is submitted contains everything but the info that has been entered into the fields. I'm sure it's something simple that I'm overlooked, but I'm officially stumped.  What am I doing wrong here? 
<?php
$mymail = 'ordietryingodt@yahoo.com';
$cc = 'New Recruit To Add!';
$BoDy = ' ';
$FrOm = 'FROM:' .$_POST['t1'];
$FrOm .= 'Reply-To:' .$_POST['t1'];
$FrOm .= 'X-MAILER: PHP'.phpversion();
$BoDy .= 'Quake Live Name: ';
$BoDy .= $_POST['t1'];
$BoDy .= "\n";
$BoDy .= 'Age: ';
$BoDy .= $_POST['t2'];
$BoDy .= "\n";
$BoDy .= 'Residing Country: ';
$BoDy .= $_POST['t3'];
$BoDy .= "\n";
$BoDy .= 'Favorite Game Type: ';
$BoDy .= $_POST['t4'];
$BoDy .= "\n";
$send = mail("$mymail", "$cc", "$BoDy", "$FrOm");

if($send)
{
echo '<html><head>';
echo '<meta http-equiv="refresh" content="0;URL=/submitted.htm">';
echo '</head><body>Email send....';
echo '</body></html>';
}
?>

Hello:

I have a SELECT dropdown menu that works like this:
Code: [Select]
<?php

$states_arr = array('AL'=>"Alabama",'AK'=>"Alaska",'AZ'=>"Arizona",'AR'=>"Arkansas",'CA'=>"California",'CO'=>"Colorado",'CT'=>"Connecticut",'DE'=>"Delaware",'DC'=>"District Of Columbia",'FL'=>"Florida",'GA'=>"Georgia",'HI'=>"Hawaii",'ID'=>"Idaho",'IL'=>"Illinois", 'IN'=>"Indiana", 'IA'=>"Iowa",  'KS'=>"Kansas",'KY'=>"Kentucky",'LA'=>"Louisiana",'ME'=>"Maine",'MD'=>"Maryland", 'MA'=>"Massachusetts",'MI'=>"Michigan",'MN'=>"Minnesota",'MS'=>"Mississippi",'MO'=>"Missouri",'MT'=>"Montana",'NE'=>"Nebraska",'NV'=>"Nevada",'NH'=>"New Hampshire",'NJ'=>"New Jersey",'NM'=>"New Mexico",'NY'=>"New York",'NC'=>"North Carolina",'ND'=>"North Dakota",'OH'=>"Ohio",'OK'=>"Oklahoma", 'OR'=>"Oregon",'PA'=>"Pennsylvania",'RI'=>"Rhode Island",'SC'=>"South Carolina",'SD'=>"South Dakota",'TN'=>"Tennessee",'TX'=>"Texas",'UT'=>"Utah",'VT'=>"Vermont",'VA'=>"Virginia",'WA'=>"Washington",'WV'=>"West Virginia",'WI'=>"Wisconsin",'WY'=>"Wyoming");
    
    function showOptionsDrop($array){
        $string = '';
        foreach($array as $k => $v){
            $string .= '<option value="'.$k.'"'.$s.'>'.$v.'</option>'."\n";
        }
        return $string;
    }
?>

<form>

<select name="states">
    <option value="0">Choose a state</option>
    <?php echo showOptionsDrop($states_arr); ?>
</select>


</form>

I would like to show all the towns/zipcodes for each individual state with an "onchange" from the SELECT menu.

The table is called "zip_codes" and the City/Zip Codes are called "city" and "zip"

What I would like to do is display them as links, so a user can click into each town and either create a new entry (a restaurant) or update an existing entry.

What would be the best approach for this?

I appreciate the help.

This topic has been moved to JavaScript Help.

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

Hi guys,

This is my first time posting here - im just getting into PHP - i got a question;

I have two databases:

profile(id, name, interests, dob, gender, join_date, email)
interests(id, profile_id, interests)
id being the primary key, and profile_id being the foreign key from profile.

I want to script that returns profile information and all the matching interests (one user can have multiple interests).

This is what i have so far, though it does not work, and i knew it wouldnt;

function get_profile($id) {
   $connection = mysql_open();
   $query = "SELECT * ";
   $query .= "FROM profiles, interests ";
   $query .= "WHERE profile.id=" . $id;
   $query .= " AND interests.profile_id=" . $id;
   $result = @ mysql_query($query, $connection);
   // Transform the result set to an array (for Smarty)
   $entries = array();
   while ($row = mysql_fetch_array($result)) {
      $entries[] = $row;
   }
   mysql_close($connection) or show_error();;
   return $entries;   
}


Can someone please advise on how this can be done? or do i need to have two query's one for each table ?

Thank you in advance!!

Hey everyone.

I have some experience with PHP and can easily modify existing code, but seem to have trouble writing the logic from scratch.

Situation:

I'm using this Jquery slider ( http://mine.tuxfamily.org/?p=74#more-74 ) and would like to populate the slides with data coming from an XML file. The data will be text, images(URIs), and links to buy. The thing is, each slide will hold 4 items, and then I want to somehow using PHP logic, allow the code to generate the next slide...

In other words, how would I code it so that after 4 entries, it creates a new slide?

I'm imagining a For loop + SimpleXML functions... but just kind of fumbling in the dark here.

Any direction or guidance is greatly appreciated!

Kind regards,
Dey

Hi all,

I am lost again in this PHP world. I am trying to set up a grade book for my reporting system. I have got totally lost in the code and I am need of some help.

Many Thanks

F

Code: [Select]
<?php 
function doquery($query) {
  $db = "prs";
   $link = mysql_connect("localhost","gandalf","A3tti2ca")
     or die("Could not connect to server! Error: ".mysql_error());
   mysql_select_db($db,$link)
     or die("Could not select $db! Error: ".mysql_error());
   $result = mysql_query($query,$link)
     or $result = "Query Error!<p>Query: $query<p>Error: ".mysql_error();
   mysql_close($link);
   return($result);
}

function parseresults($result) {
   if ($line = mysql_fetch_array('$result', MYSQL_ASSOC)) {
        displayform($line);
   } 
        else {
    print "A database problem has occurred. Contact the database administrator<p>";
  }
}


function displayform($line) {
<<<HTML
 <form action="gradebook2.php" method="post">
   <H4>Thank You, <p>
HTML;

   print $line['firstname']." ".$line['surname']." (#".$line['upn'].") in set ".$line['class_set'];
   print ' has been sucessfully added to the system.<p>';
         echo"<form id=\"Gradebook\" name=\"gradebook\" method=\"post\" action=\"gradebook2.php\">
        <table width=\"77%\" border=\"1\" align=\"center\" cellpadding=\"5\" cellspacing=\"0\" bordercolor=\"#de6057\">
         <tr>
           <td width=\"45%\" class=\"footer\">
 <label class=\"form_labels\">Coursework Mark</label>
                                 </td>
           
 <td width=\"55%\">
  <input name=\"cw_mark\" type=\"text\" id=\"cw_mark\" value=".$line['english_cw_mark']." tabindex=\"1\" size=\"6\" maxlength=\"4\" />
<input type=\"hidden\" name=\"upn\" value=".$line['upn'].">
</td>
         </tr>
        
<tr>
           <td class=\"footer\">Coursework Comment </td>
           <td>
  <label>
  <textarea name=\"cw_comment\" id=\"cw_comment\" cols=\"35\" rows=\"7\" value=".$line['english_cw_commnents']."></textarea>
        </label>
</td>
        </tr>
        
<tr>
           <td class=\"footer\"><label class=\"form_labels\">Exam Mark</label></td>
           <td>
<input name=\"exam_mark\" type=\"text\" id=\"exam_mark\" value=".$line['english_exam_mark']." tabindex=\"3\" size=\"6\" maxlength=\"4\">
</td>
         </tr>
       
    <tr>
           <td class=\"form_labels\">Exam Comment </td>
                   <td>
     <label>
             <textarea name=\"exam_comment\" id=\"exam_comment\" cols=\"35\" rows=\"7\" value=".$line['english_exam_comments']."></textarea>
                </label>
         </td>
         </tr>
       
    <tr>
           <td class=\"form_labels\"><label>Commendation in Poetry</label></td>
          <td>
  <select name=\"com_poetry\" id=\"com_poetry\" value=".$line['com_poetry'].">
                         <option value=\"No Commendation\" selected=\"selected\">No Commendation</option>
                        <option value=\"Commendation Awarded\">Commendation Awarded</option>
</select>
</td>
       </tr>
        
       <tr>
            <td class=\"form_labels\"><label>Commendation in Creative Writing</label></td>
             <td>
<select name=\"com_creative\" id=\"com_creative\" value=".$line['com_creative'].">
                    <option selected=\"selected\">No Commendation</option>
                   <option value=\"Commendation Awarded\">Commendation Awarded</option>
</select>
              </td>
                 </tr>
        
<tr>
           <td class=\"form_labels\">Commendation in Literary Interpretation</td>
           <td>
  <select name=\"com_lit_int\" id=\"com_lit_int\" value=".$line['com_lit_int'].">
             <option value=\"No Commendation\" selected=\"selected\">No Commendation</option>
            <option value=\"Commendation Awarded\">Commendation Awarded</option>
</select>
</td>
         </tr>
        
<tr>
          <td class=\"form_labels\"><label>Overall Comments</label></td>
            <td>
    <textarea name=\"overall_comments\" id=\"overall_comments\" cols=\"35\" rows=\"7\" value=".$line['english_overall_commnents'].'"></textarea>
 </td>
         </tr>
       
    <tr>
           <td>&nbsp;</td>
           <td>
<input type=\"reset\" name=\"Reset\" id=\"Reset\" value=\"Reset Form\" tabindex=\"12\" /> &nbsp;&nbsp;
   <input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Submit Form\" tabindex=\"11\" />
</td>
         </tr>
       </table>
  </form>";
}


$student_upn = (integer) $_POST["stu_upn"];
$query = "select count(*) as numberRecords from english where upn = ".$student_upn."";
$result = doquery($query);
$row = mysql_fetch_array($result);

if ($row['numberRecords'] == 0)  
{
$query = "select students.upn from students where students.upn = '".$student_upn."'";
$result = doquery($query);
$row = mysql_fetch_array($result);
$cw_mark = $row['english_cw_mark'];
$cw_comment = $row['english_cw_comments'];
$exam_mark = $row['english_exam_mark'];
$exam_comment = $row['english_exam_comments'];
$com_poetry = $row['com_poetry'];
$com_creative = $row['com_creative'];
$com_lit_int = $row['com_lit_int'];
$overall_comment = $row['english_overall_comments'];
$insert = "insert into english (upn, english_cw_mark, english_cw_comments, english_exam_mark, english_exam_comments, com_poetry, com_creative, com_lit_int, english_overall_ comments) values (".$student_upn.",'".$cw_mark."','".$cw_comment."', '".$exam_mark.",'".$exam_comment."','".$com_poetry."','".$com_creative."','".$com_lit_int."','".$overall_comment."',0);
print $insert;
doquery($insert);
}

$query =  select students.upn as upn, firstname, surname, class_set, from customers left join english on students.upn = english.upn where students.upn = ".$student_upn.";
$result = doquery($query);

if (is_resource($result)) {
  parseresults($result);
} else {
   print "$result";
}
print "<a href=\"gradebook.php\"><h4>Grade Another Student</h4></a>";
?>

Hey,   I have am creating a web app to hold customer and job details.. I have the following table structures to hold the data:  

CREATE TABLE Customers (
  customerID int(5) NOT NULL auto_increment,
  customer varchar(25) default NULL,
  contact varchar(25) default NULL,
  phone varchar(25) default NULL,
  email varchar(25) default NULL,
  address varchar(25) default NULL,
  PRIMARY KEY (customerid)
) ENGINE = INNODB;


CREATE TABLE Jobs (
  jobID int(5) NOT NULL auto_increment,
  customerID int(5) NOT NULL default '0',
  invoiceNumber varchar(25) default NULL,
  purchasOrder varchar(25) default NULL,
  orderDate datetime NOT NULL default '0000-00-00',
  dateRequired datetime NOT NULL default '0000-00-00',
  jobStatus varchar(25) default NULL,
  PRIMARY KEY (jobID)
) ENGINE = INNODB;


CREATE TABLE vinyl (
  vinylID int(5) NOT NULL auto_increment,
  jobID int(5) NOT NULL default '0',
  colour varchar(25) default NULL,
  font varchar(25) default NULL,
  size varchar(25) default NULL,
  fileLocation varchar(25) default NULL,
  PRIMARY KEY (vinylID)
) ENGINE = INNODB;


CREATE TABLE screenprint (
  screenprintID int(5) NOT NULL auto_increment,
  jobID int(5) NOT NULL default '0',
  colour varchar(25) default NULL,
  font varchar(25) default NULL,
  size varchar(25) default NULL,
  fileLocation varchar(25) default NULL,
  PRIMARY KEY (screenprintID)
) ENGINE = INNODB;


CREATE TABLE items (
  itemID int(5) NOT NULL auto_increment,
  jobID int(5) NOT NULL default '0',
  supplier varchar(25) default NULL,
  code varchar(25) default NULL,
  colour varchar(25) default NULL,
  style varchar(25) default NULL,
  total varchar(25) default NULL,
  dateOrdered varchar(25) default NULL,
  PRIMARY KEY (itemID)
) ENGINE = INNODB;


CREATE TABLE itemsqty (
  itemqtyID int(5) NOT NULL auto_increment,
  itemID int(5) NOT NULL default '0',
  jobID int(5) NOT NULL default '0',
  size varchar(25) default NULL,
  quanity int(5) NOT NULL default '0',
  PRIMARY KEY (itemqtyID)
) ENGINE = INNODB;


CREATE TABLE embroidery (
  embroideryID int(5) NOT NULL auto_increment,
  jobID int(5) NOT NULL default '0',
  code varchar(25) default NULL,
  stitchCount varchar(25) default NULL,
  quanity int(5) NOT NULL default '0',
  PRIMARY KEY (embroideryID)
) ENGINE = INNODB;

Are these tables set out correctly for the collection of data needed. Also.. am I best to use Foreign Keys? My understanding of using foreign keys is not in place for queries as such, more to keep the tables clean of miss matched records etc?   Thanks

Ok, so I'm not quite sure how to explain this, but here it goes:

I have table A that contains stats for all players in the NHL, and then I have table B with just a few players. These few players in table B are also in table A, but table B has more information on them. I want to take the stats for these players out of table A and put into table B, and I want table B to update along with table A every time those numbers change. How would I do this?

I've got a table (tbl_items) that holds a number of items and the individual information for each. Within 'tbl_items' I also have a row labeled 'category_id' in which each item is given a number (ex: 2).

I've got a separate table (tbl_items_categories) that only has 2 rows: 'category_id' and 'category_name'.

I wasn't sure if a JOIN method would be best for this but what would be the best approach to list all items and within each item, also echo out the name of the category they belong to and not the category_id number?

so I'm trying to change some specific columns in a row in a table of a MySQL database by calling the Doctrine_Query when an option is selected inside an admin panel of my website.

Here are the details:

Table name: chatUsers
I need to find all rows with the person who has a username of: $chatUsers->username (The column inside chatUsers is called username) Once all those rows are found, change the value of all the row's column "type" to "user" Is this even possible?

So far I have:
[/list] Code: [Select]
<?php
function userChatReset(){
     $query = Doctrine_Query::create()->update('db_chatUsers')->set('type', 'user')->where('username = '.$chatUsers->username);

          //execute query
$rows = $query->execute();
echo $rows.' rows updated';
}
?>

...And I'm not sure where to go from there, or if that's even correct. Sorry in advance, I'm not very good with PHP yet.

I have been playing around with this. Thought I had it nailed, and then found that It was fubar when I started to add more entries to the database. I basically want to display 2 tables from my database on the page. One is called "players" the other is called "editlog".

The output with my current script came out as this:


and here is the dreaded code:
<html>
<body>

<u><h3>Performance Point Monitor (PPM): Knights of Shadow WoW Officers.</h3></u>
<?php
include('/home/a3269923/public_html/ppm/admin/config.php');
include('/home/a3269923/public_html/ppm/admin/dbopen.php');
$query="SELECT * FROM players";
$result=mysql_query($query);
$num=mysql_numrows($result);
?>
<table border="1" style="position:absolute;width:500;height:10;left:0;top:70">
<tr>
<th><font face="Arial, Helvetica, sans-serif">PLAYER</font></th>
<th><font face="Arial, Helvetica, sans-serif">POINTS</font></th>
<th><font face="Arial, Helvetica, sans-serif">DATE</font></th>
</tr>
<?php
$i=0;
while ($i < $num) {
$f2=mysql_result($result,$i,"PLAYER_NAME");
$f3=mysql_result($result,$i,"ND_POINTS");
$f4=mysql_result($result,$i,"DATE ADDED");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
</tr>
</table>

<?php
$i++;
}
?>
<?php
include('/home/a3269923/public_html/ppm/admin/config.php');
include('/home/a3269923/public_html/ppm/admin/dbopen.php');

//USER LOG
$query="SELECT * FROM editlog";
$result=mysql_query($query);
$num=mysql_numrows($result);
?>
<table border="1" style="position:absolute;width:600;height:10;left:510;top:70">
<tr>
<th><font face="Arial, Helvetica, sans-serif">USER</font></th>
<th><font face="Arial, Helvetica, sans-serif">TYPE</font></th>
<th><font face="Arial, Helvetica, sans-serif">POINTS</font></th>
<th><font face="Arial, Helvetica, sans-serif">NOTES</font></th>
<th><font face="Arial, Helvetica, sans-serif">DATE</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {
$f1=mysql_result($result,$i,"USER");
$f2=mysql_result($result,$i,"TYPE");
$f3=mysql_result($result,$i,"POINTS");
$f4=mysql_result($result,$i,"NOTE");
$f5=mysql_result($result,$i,"TIMESTAMP");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
</tr>
</table>

<?php
$i++;
}
?>


What am I doing wrong? Halp!

Hey guys,

Not sure how to do this. The basic principle of what I want to do is:

ounit1 number (members table) * ounit1 power (ounit table)
ounit2 number (members table) * ounit2 power (ounit table)

etc to unit12.

The members table has the fields:

username ounit1 ounit2 ounit3 ounit4 etc for the number of units.

The Ounit table has the fields:

Ounit (primary auto increase) opower and a few more that are not needed for this.

So basically, it it possible to  call data from two different tables and multiply it?

So far I've got:

Code: [Select]
<?php 

        $result = mysql_query("SELECT * FROM members WHERE Username='$_SESSION[Username]'") 
                or die(mysql_error());  

     while($row = mysql_fetch_array( $result )) {   

echo '<b>Power</b><br />';
                                echo 'Offence: ' . $row[''] . ' <br />';
echo 'Defence: ' . $row[''] . ' <br />';
echo 'Power: ' . $row[''] . ' <br />';

}
?>
I'm not sure how to call two tables at once.

Any help would be great!

OK, I've scoured the forms on here, searched and tutorial read and even pulled out an old PHP book. Alas, I'm stumped.

First off, my two tables that I'm trying to pull data from:

rubric
-------------------------------------
---- code ---- | ---- title --------
-------------------------------------
ABCD            | Category Name


schedule
----------------------------------------------------
------ name ------ | ------ short_title ------
----------------------------------------------------
ABCD-123-4569   | Title Is Here


Now, none of these share the same value, per say. rubric.code shares the first THREE letters from schedule.name, but that is all.
What I'm trying to do is something similar to the old:

A
apple
automobile

B
banana
basket
bench

C
car
child
crumb

... etc, etc, where the letter heading is actually the rubric.title value and then underneath it it lists all the matching short_title from
schedule where the first four letters of schedule.name match the value of rubric.code - if that even makes sense.

Unfortunately these are the tables I have to work with. If anyone out there has any ideas, I would be thrilled to hear them. Another
thing that is driving me crazy is that this server I'm working on doesn't have error reporting turned on so I've been stuck with just a
white screen to let me know something is amiss.

I'm running PHP Version 5.3.3-7+squeeze8 if that helps.

Thank you!