PHP - Php Array Html Formating

Hi Folks,

I understand the basic math to accomplish what I want, at least I think I do   I would like to confirm my logic and I need help with the final output format.

I am coding a simple browser based, resource type of game.  The gamer will select a certain item to produce another item and it will take x time to do it.  Here is the basics of what I want, minus the coding to make it look pretty. 

How do I format $y to show HHH:MM:SS?

Code: [Select]

$complete = time() + $x;

// To show how much time is remaining until completion or complete

$y = $complete - time();

if $y > 0 {

echo $y;

}

else {

echo "complete";

}

Hi!

I'm working a on wordpress website with member pages. Members enter their information via custom fields. Everything is working great except when trying to create a link based on one of those custom field. Unless the member enter his website address in the http://mysite.com format the link my code create is not valid.

This is the code i'm currently using
Code: [Select]
<?php $msite = get_post_meta($post->ID, 'ccio_site', true) ; if (!empty($msite)) { ?><li>Site Internet: <a href="<?php echo ($msite) ; ?>"><?php echo ($msite) ; ?></a></li><?php } ?>
Example of a member page where the format create an error. The input field is: Code: [Select]
www.pechabot.com

Example of a member page where the format is ok. The input field is Code: [Select]
http://www.annuairesgb.com
How can I format the input string so my code will work even if someone doesn't write the full address with the http:?

Thanks a lot for looking

Hello i would like to as a little help on how to proper format an foreach output into an HTML table. I have a small function inside an class, that will retrieve the data of an MySQL table and return the result in 1 array, Outside that function i can get the values displayed i only need to format it to show in an table here's what i have:

function that gets the data
Code: [Select]
function getfansub(){
$subfanarray = array();
        $query = mysql_query("SELECT * FROM anr_fansub WHERE 1");
while($result = mysql_fetch_array($query)){
$subfanarray[] = $result;
}
return $subfanarray;
}

Outside the funtion/class
Code: [Select]
$fansubarray = $mysql->getfansub();
VAR_DUMP( $fansubarray );
echo "<br><br>";
foreach($fansubarray as $name){
echo $name['FansubID'] ." ". $name['Designation'] ." ". $name['Website'] ." ". $name['tracker'] ." ". $name['irc'] ."<br>";
}

The problem i have with the formating  (i really dont know who i can do it) is when he reaches the IRC link he needs to open and close the td and tr brakets of the table. any help or tip is apreciated, thanks in advance

how to format only one specific row based on the value of  one cell in a row?

$result = mysql_query(select bal,  etc. etc ..query )

while($row = mysql_fetch_assoc($result))

echo "<tr>";

echo "<td>" . $row['Account'] . "</td>";

 echo "<td>" . $row['licence'] . "</td>";

 echo "<td>" . $row['own'] . "</td>";

 echo "<td>" . $row['bal'] . "</td>";

  echo "</tr>";

Would appreciate help on how to format only the $row['bal'] output to red colour IF bal >5000

Thanks

Hey guys & gals,

i have the following code:
Code: [Select]
<?php
$date= $_SESSION['date'];
echo $date;
?>
Which is an echo of an earlier page:
Code: [Select]
<?php $_SESSION['date'] = date("c")?>;
How do i format the echo of the first quote code? At present it echo's like so...
Quote

2011-03-30T15:43:43+01:00


...which although is useful for back office purposes, not so easy on the eye for the customer.  How can i format so it's like DATE-MONTH-YEAR?  I have googled this and there are examples, but none for when echoing a $_SESSION which is where i'm falling flat on my face.

I tried this: but it doesn't work :-(
Code: [Select]
echo $startdate ("F j, Y")
Thanks in advance to all who read and reply

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'])); ?>  

I have a table with x ammount of rows and x ammount of columns, in each TD there is an input box which the user fills in, when they press save the information is input into the database in this form at

6,1,2,3,4,5,6,A,1,2,3,4,5,6,B,1,2,3,4,5,6  - the first number is the number of columns, 1- 6 is the top line of TDs (column headers) and then A 1-6 is row 1, B 1-6 is row 2 etc..

 so i then out put the information into a table via a for loop :

Code: [Select]
while($row = mysql_fetch_array($r))
{
$data = explode(',',$row["content_bottom"]);
$datacount = count($data);

echo"<table border='1'><tr><td>Tool Type</td>";
$k = 1;
for ($i = 1; $i <= $datacount; $i++) {

if($data[$i] !=""){
echo "<td>".$data[$i]."</td>";
if($k == $data[0]-1)
{
echo"</tr><tr>";
$k = -1;
}
$k++;
}
}
echo"</table>";

I can see how i would delete a row of information, eg delete B 1-6, but any ideas how I could delete a column? or is there a better way of storing this information?

Hi,  

Hi, i'm getting an error when I load my php code in a browser. Here's my code snippet:
<?php
  mysql_connect("localhost","root");
  mysql_select_db("something");
  $bellProductsArray=array(1=>"Apple_iPhone3GS.jpg",2=>"Apple_iPhone4.jpg");
 
  $result=mysql_query("SELECT Name, Manufacturer FROM bellProducts WHERE ID=1");
  $row=mysql_fetch_assoc($result);
  print "Name: {$row['Name']} Manufacturer: {$row['Manufacturer'] }";
 
?>

<img src=<?php array_values($bellProductsArray); ?>  alt="Apple iPhone 3GS" title="Apple iPhone 3GS" />

**I can't get it to display the first image (eg: Apple_iPhone3GS.jpg), I made sure that I have the image in same directory. please help!1!

I have a table that allows users to add rows, depending on how much data they need to insert. upon submit I'd like to populate another table for review. Now I can generate the data, but I'm having trouble putting the array into a table. Here is the output from the initial page:

Code: [Select]
Array
(
    [quantity] => Array
        (
            [0] => 1
            [1] => 2
            [2] => 3
        )

    [description] => Array
        (
            [0] => 1
            [1] => 2
            [2] => 3
        )

    [unit_cost] => Array
        (
            [0] => 1
            [1] => 2
            [2] => 3
        )

    [shipping] => 4
    [tax] => 5
    [review_po] => Review
)
I need it to look like this:
Quantity | Description | Unit Cost
1             | 1                | 1
2             | 2                | 2
3             | 3                | 3
                Tax              | 4
                Ship             | 5

I think it's a foreach statement, but I'm not having any luck..

If someone could point me in the right direction???

Hi!

I am trying to use the View Model Design Pattern in my application

The problem is that it is the first time I use it and I am a beginner.

So, I have the logic in the Model and the "front end" in View. I am talking about a sign up page.

In the current Html file I am trying to access an error array from the model file and display it to the user above the input field.

 

Here is the a snippet from the Model (Signup.php)

$account = new Account($con); //the account which takes as param the db connection
$error = null; //the array

// anything the user writes gets inside this array
if (isset($_POST["submitButton"])) {

 $firstName = UnifyFormInput::unifyUserFLName($_POST["firstName"]);
 $lastName = UnifyFormInput::unifyUserFLName($_POST["lastName"]);
 $username = UnifyFormInput::unifyFormUserName($_POST["username"]);
 $email = UnifyFormInput::unifyFormEmail($_POST["email"]);
 $password = UnifyFormInput::unifyFormPassword($_POST["password"]);

 //contain true or false based on the query being successful or not
 $success = $account->register($firstName, $lastName, $username, $email, $password);
 if ($success) {
  $_SESSION["userLoggedIn"] = $username;
     header("Location:index.php");
 }else{
    $error = $account->getError(Constants::$registerFailed);

 }
}
//compact — creates array containing variables and their values
//call render function from View file to show the register page content
View::render('register', compact('error'));

And here is the view:

 <?php                 
        if (!empty($error)) {
          echo  $account->getError(Constants::$loginFailed);
       }                        
?>
<input type="text" class="form-control" name="firstName" placeholder= "First Name" value="<?php getInputValue("firstName"); ?>" required>

 

Hi all, I'm trying to set up a situation where a function loops through a multidimensional array and echos an html block for each item in the $skus['skunum'] array and also increments $i each time . ( Each is a product on the site)   
The catch is that I'm trying to have a function within that one that goes through the $skus['sizes'] and echoes an option if the substring (shirt size) exists.

The idea being that I can manage products by adding 4 elements, Skunum, name, price and size.

And well, I'm failing miserably. 

At this point it won't even work because of the variable scope, I'm getting Notice: Undefined variable: skus
from the functions, but am not sure of the right way to get that information.

Am I going about doing this entirely wrong or am I on the right track?

Code: [Select]
<?php $BANDNAME="Apocalypse"; 
$BANDCAPS="APOCALYPSE";
$BANDLOWER="apocalypse";
$SKUCAPS="FGD";
$skus = array
  (
  "skunum"=>array
  (
  "101",
  "102",
  "103", 
  "104",
  "105", 
  "106", 
  "107", 
  "108", 
  "109", 
  "110", 
  "111", 
  "112" 
  ),
  "name"=>array
  (
  "RIDDICK /TSHIRT",
  "MAFIA / TSHIRT",
  "ORACLES / TSHIRT", 
  "AGONY / TSHIRT",
  "BLOODY VIOLINIST / TSHIRT",
  "THE VIOLATION / TSHIRT",
  "AGONY-TOUR DATES / TSHIRT",
  "BAND PHOTO / TSHIRT",
  "SILVER AGONY LOGO / TSHIRT",
  "PHOENIX-TOUR DATES / TSHIRT",
  "PHOENIX / TSHIRT",
  "BLOODY VIOLINIST / ZIP HOOD"
  ),
  "price"=>array
  (
  "15.95",
  "15.95",
  "15.95", 
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "42.95"
  ),  
  "sizes"=>array
  (
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X"
  )
  
  );
 
function makeProducts() {
 //Products Sizes
 $sizes = $skus['sizes'][$i];
 $S="S";$M="M";$L="L";$XL="1";$XXL="2";$XXXL="3";$XXXXL="4";

$small = strpos($sizes,$S);
$medium = strpos($sizes,$M);
$large = strpos($sizes,$L);
$xlarge = strpos($sizes,$XL);
$xxlarge = strpos($sizes,$XXL);
$xxxlarge = strpos($sizes,$XXXL);
$xxxxlarge = strpos($sizes,$XXXXL);

function sizeOptions () {
if($small === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'S">S</OPTION>';
}
if($medium === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'M">M</OPTION>';
}
if($large === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'L">L</OPTION>';
}
if($xlarge === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'X">XL</OPTION>';
}
if($xxlarge === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'XX">XXL</OPTION>';
}
if($xxxlarge === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'XXX">XXXL</OPTION>';
}
if($xxxxxlarge === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'XXXX">XXXXL</OPTION>';
}
}
 
foreach ( $skus['skunum'] as $value){ 
  
   
  

   echo '<!-- PRODUCT BEGIN -->
  <li class="product" >
<a href="product_files/large/'.$SKUCAPS.$skus['skunum'][$i].'jpg" rel="lightbox"><img src="product_files/'.$SKUCAPS.$skus['skunum'][$i].'.png"></a><br>
                            <strong>'.$skus['name'][$i].'</strong><br>('.$SKUCAPS.$skus['skunum'][$i].')<br>$'.$skus['price'][$i].'<br>
                            <form name="'.$SKUCAPS.$skus['skunum'][$i].'" method="GET" target="_blank" action="http://www.jsrdirect.com/cgi-bin/Make-a-Store.cgi">
                            <input type="hidden" name="band" value="'.$BANDCAPS.'"> <input type="hidden" name="back" value="http://www.jsrdirect.com/bands/'.$BANDLOWER.'/index.html">
                            <strong>Qty:</strong>
                            <input type="text" name="quantity" size="1" value="1" >
                            <strong>Size:</strong>&nbsp; 
                            <SELECT name="item">'
.sizeOptions();
'</SELECT>
                            <br><br>
                            <input type="image" src="images/addtocart.png" value="Add To Cart">
                            </form>
                        </li>
                <!-- Product End -->';
   }
  
} // End Function

?>

Hi Everyone,

I have a problem displaying some information from an array (selected from my database). The array is below.

Array ( [0] => Array ( [ssc_skill_categories] => Web  [sc_skill_categories] => Programming ) 
[1] => Array ( [ssc_skill_categories] => Actionscript  [sc_skill_categories] => Programming ) 
[2] => Array ( [ssc_skill_categories] => C#  [sc_skill_categories] => Programming ) 
[3] => Array ( [ssc_skill_categories] => CSS  [sc_skill_categories] => Programming ) 
[4] => Array ( [ssc_skill_categories] => Graphic  [sc_skill_categories] => Designers ) 
[5] => Array ( [ssc_skill_categories] => Logo  [sc_skill_categories] => Designers ) 
[6] => Array ( [ssc_skill_categories] => Illistration  [sc_skill_categories] => Designers ) 
[7] => Array ( [ssc_skill_categories] => Animation  [sc_skill_categories] => Designers ) )


What i would like to to is display this information in a table like so:

<html>
<body>
   <table>
      <tr>
         <td>Programming</td><td>Web</td><td>Actionscript</td><td>C#</td><td>CSS</td>
      <tr>
      <tr>
         <td>Designers</td><td>Graphic</td><td>Logo</td><td>Illistration</td><td>Animation</td>
      <tr>
   <table>
</body>
</html>


I have been trying and failing all day to do this. Posting my "progress" will clog up the thread, so for now i wont post it. Does anyone have an idea how i would achieve this?

Regards,
-Ben

Hello, freaks. I need a little help with the best way to go about this. I have a field in mysql that contains a comma separated string of values. What I need to do is get those values out of the db and list them into editable text fields so the user can update the values in a html form. So far this is my code, I left out all the in betweens - validation, results, etc - for this post...but its there .

SELECT servs FROM services WHERE id = $a_id

$services = $row['servs'];
$srvs = explode(',', $services);

Then for the form:

<?php
foreach ($srvs as $service) { 
?>

<input type="text" name="servs[]" value="<?php echo $service  ?>" />

  <?php } ?>

This gives me a text field for each value of servs, great! But the problem is, the user can enter up to 15 servs. Some currently have less than that saved in the db. I want to give them the ability to 1. edit any of the current servs value and 2. add more values if they have less than 15.

My question is, how do I echo out 15 editable text fields for servs[] no matter the number of values they currently have? And when I go to implode the values, will blank text fields screw everything up?

I can't find anything in the forums that relate to this. I believe it probably will involve $i, but I am not too familiar with counting in php yet, so I could really use some help. Thanks!

Oh - and I am not stuck on using text fields, but I couldn't figure how to make this work using a select list or checkboxes. Any suggestions either way would help. 

This topic has been moved to Ajax Help.

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