PHP - Html Form Inside Php If Statement

I am trying to create a daily event listing.

The list will have Day & Date as the heading. Then it will list the events ORDERED BY the time.

First thing I'd like to do is skip or not show the days that do not have an event.
Ex.
Monday, January 23, 2012
7am event
8am event
6pm event

since Tuesday has no events, I'd like tuesday to not be in the list, but if the next tuesday has an event It'll need be visible.
Tuesday, January 24, 2012
(No events)

Wednesday, January 25, 2012
9am event
12 pm event
8pm event

The 2nd thing I'd like to do is If a particular day and time has more than one event, I'd like the time to show once and then list the events.
ex.
Monday, January 23, 2012
7am event
        event
        event
8am event
6pm event


Here's the code: since the listing is for a range of 7 days I've only included 3 days worth of code. I've include the mysql_statements for pulling the information as well as the php code to show how it's being rendered and placed.  HTML excluded.

Code: [Select]
<?php
//TODAY
$today2 = date('l, F j, Y');//php to format date

$today_rehearsals = mysql_query(" SELECT Id, date, time, title, campus, room, ministry, category FROM events
     LEFT JOIN dates on events.dateId=dates.dateId
     LEFT JOIN time ON events.timeId=time.timeId
     LEFT JOIN campus ON events.campusId=campus.campusId
     LEFT JOIN rooms ON events.roomId=rooms.roomIdLEFT JOIN ministries on events.ministryId=ministries.ministryId
     LEFT JOIN category on events.categoryId=category.categoryIdWHERE ministry='music' AND date='$today' OR category='music' AND date='$today'            
     ORDER By date, time")

//////DAY  ONE
$day1= mktime(0,0,0, date("m"), date("d")+1, date("Y")); //php to get current date and add 1 day
$day_1 = date("l, F j, Y", $day1); //php to format date

$day1_rehearsal = mysql_query("SELECT Id, date, time, title, campus, room, ministry, category FROM events 
     LEFT JOIN dates ON events.dateId=dates.dateIdLEFT JOIN time ON events.timeId=time.timeId
     LEFT JOIN campus ON events.campusId=campus.campusId
     LEFT JOIN rooms ON events.roomId=rooms.roomId
     LEFT JOIN ministries ON events.ministryId=ministries.ministryId
     LEFT JOIN category ON events.categoryId=category.categoryId
     WHERE ministry='music' AND date=CURDATE()+1 OR category='music' AND date=CURDATE()+1 ORDER BY time" ) or die(mysql_error());

/////DAY 2
$day2= mktime(0,0,0, date("m"), date("d")+2, date("Y")); //php to get current date and add 2 days
$day_2 = date("l, F j, Y", $day2); //php to format date

$day2_rehearsal = mysql_query("SELECT Id, date, time, title, campus, room, ministry, category FROM events 
     LEFT JOIN dates ON events.dateId=dates.dateIdLEFT JOIN time ON events.timeId=time.timeId
     LEFT JOIN campus ON events.campusId=campus.campusId
     LEFT JOIN rooms ON events.roomId=rooms.roomId
     LEFT JOIN ministries ON events.ministryId=ministries.ministryId
     LEFT JOIN category ON events.categoryId=category.categoryId
     WHERE ministry='music' AND date=CURDATE()+2 OR category='music' AND date=CURDATE()+2 ORDER By time")or die(mysql_error()); 



////TODAY
echo "$today2"; //renders Today's date 
    
     while($row = mysql_fetch_array( $today_rehearsals )){ 
          $time=date_create($row['time']);//grab time for db          
          $for_time=date_format($time, 'g:i a');//format time for viewing on page   

           echo "$for_time";           
           echo $row['title'];           
           echo $row['campus'] . " " . $row['room'];    
     }


////day1
echo "$day_1"; //renders day_1's (tomorrow's) date

     while($row = mysql_fetch_array( $day1_rehearsal )){ 
          $time=date_create($row['time']);//grab time for db         
          $for_time=date_format($time, 'g:i a');//format time for viewing on page
                          
          echo "$for_time";          
          echo $row['title'];          
          echo $row['campus'] . " " . $row['room'];
          }

////day2
echo "$day_2"; //renders day_2's (day after tommorrow) date

     while($row = mysql_fetch_array( $day2_rehearsal )){                      
         $time=date_create($row['time']);//grab time for db
         $for_time=date_format($time, 'g:i a');//format time for viewing on page                                     

          echo "$for_time"; 
          echo $row['title'];
          echo $row['campus'] . " " . $row['room'];
          }

MOD EDIT: code tags fixed . . .

I am wondering if it is possible to create 2 queries, and use 1 while statement?
Something like:

Code: [Select]
while (($row = mysql_fetch_array($rs_getevent)) && ($row = mysql_fetch_array($rs_getevent2))) {
Is something like this possible?

I have a bunch of checkboxes I am pulling from a database, like so.
Code: [Select]
<?$true_query = mssql_query("SELECT * FROM checkbox_datbase ORDER BY ID ASC");
                  while ($true_row = mssql_fetch_assoc($true_query))
                  {
                  $eth_id = $true_row['ID'];
                  $eth_name = $true_row['Value'];
                  echo "<input type=\"checkbox\" name=\"eth_$eth_id\" value=\"1\" class=\"input\" id=\"Ethnic_01\"/>$eth_name <br />";
                  }
?>How do I put these into a database that I have settup where it needs to match up with a userid. I am trying to do this, and can get it to look correctly by echoing out the various parts, but I can't put while loops into a variable, right? So how would I get all of this into one line in my $sql variable?

Code: [Select]
echo "INSERT INTO new_database (UserId,";
                  $true_query = mssql_query("SELECT * FROM checkbox_datbase ORDER BY ID ASC");
                  while ($true_row = mssql_fetch_assoc($true_query))
                  {
                  $eth_id = $true_row['ID'];
                  $eth_eth_id = $_POST['eth_' . $eth_id . ''];
                       echo " $eth_id, ";
                      }
                      echo "DateUpdated) VALUES ('$user_ID', ";
                     
                    $true_query = mssql_query("SELECT * FROM checkbox_datbase ORDER BY ID ASC");
                  while ($true_row = mssql_fetch_assoc($true_query))
                  {
                  $eth_id = $true_row['ID'];
                  $eth_eth_id = $_POST['eth_' . $eth_id . ''];
                       echo "'$eth_eth_id', ";
                      }
                     echo "'$currenttime')";
This echoes something that looks like this
INSERT INTO user_ethnicity (UserId, 1, 2, 3, 4, 5, 6, 7, 8, DateUpdated) VALUES ('', '', '', '', '', '', '', '', '', '2012-01-23 13:24:18 PM')
, which I need the actual statement to be
$sql = "INSERT INTO user_ethnicity (UserId, 1, 2, 3, 4, 5, 6, 7, 8, DateUpdated) VALUES ('259', '', '', '1', '', '1', '', '', '', '2012-01-23 13:24:18 PM')";

Can anyone help me with this?

This topic has been moved to JavaScript Help.

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

Is it possible to have a loop inside a mysql select statement? If yes, can someone please give me an idea.

Hi I am new to PHP and this is my first post one here so appologies is this questions seems a bit dumb!

I have an if clause such that if a button is pressed on my web page then i want to reload the page and include a new form on it.

I am having a problem getting the $_SERVER['PHP_SELF'] command to work from iside a echo command. I must not be escaping the code correctly with back slashes:

I currently have the line :

 
echo"<form method=\"POST\" action=\"\<?$_SERVER['PHP_SELF']?\>\">";


However this doesnt seem to work as my page just doesnt display in the browser.

Any advice is much appreciated.

Thanks for taking the time to read.

Before I explain my problem here are the files I have created -

create.php

Code: [Select]
<form action="#" method="post">
Name:<input type="text" name="tab"/>Number of Fields:<input tabindex="text" name="colnum"/>
<input type="submit" />
</form>
<?php 

if(isset($_POST['tab']) and isset($_POST['colnum'])){ 
    if($_POST['colnum']>0) 
    { 
        echo '<form action="createn.php" method="post">'; 
        foreach(range(1,$_POST['colnum']) as $index) 
        { 
            echo $index; 
            echo ') ColName<input type="text" name="colname'.$index.'"> '; 
            echo 'Type<input type="text" name="type'.$index.'">'; 
            echo '<input type="hidden" name="tab" value="'.$_POST['tab'].'"/>'; 
            echo '<input type="hidden" name="colnum" value="'.$_POST['colnum'].'"/>'; 
            echo '<br/>'; 
             
        } 
        echo '<input type="submit"/>'; 
        echo '</form>'; 
    } 
    else 
    echo "Number of fields should be greater then 0"; 
} 
else 
{ 
    echo "Fill in both the fields"; 
} 
?>
createn.php
Code: [Select]
<?php 
$conn=oci_connect('scott','tiger'); 
$tabname=$_POST['tab']; 
foreach(range(1,$_POST['colnum']) as $index) 
{ 
    echo $_POST["colname".$index]; 
    echo $_POST["type".$index]; 
        echo '<br/>'; 
} 

echo "Table name =".$tabname; 

$query='create table '.$tabname.'('.$_POST["colname1"].' '.$_POST["type1"].')'; 
$statement=oci_parse($conn,$query); 
if(oci_execute($statement)) 
{ 
    echo "Table created"; 
} 
else 
{ 
    echo 'no table created'; 
} 
?>

Create.php explanation ->
On running it gives a form asking for table name and number of fields:
Suppose I enter table name as "EMP" and no. of fields as "2".. and press submit.. now on the same page I'll get two sets of field each containing 2 boxes (ie Name and Type)..
When I fill in both the field set with let's say -
1) Name: -"empno" Type: -"number"
2) Name: -"ename" Type: -"varchar2"
and press submit it the form submits the values to "createn.php"

Createn.php explanation ->
On this file I want to form a statement to create a new table with all the inputed data... ie something as follows -
"create table <table_name>(<column 1> <type1>,<column 2> <type2>,....)"

The code I have written in this file puts only 1 column and it's type as I have manually entered it. But suppose I don't know how many column is user going to put in.. then in that case how can I code the above stated statement in bold?

Hi,   I have the following script which displays a banner image based on a cookie. It also displays a banner if there is no cookie. What I would like to do is to display the banners based on cookies, but instead of displaying the "no-cookie.gif" image, I want to insert some HTML content.   What would be the best way to do this?    

$( document ).ready(function() {

    var acode = getVar('agent');

    if (code) SetCookie("code", code, 1);

    else

        code = ReadCookie("code");

    

    var imgsrc = "images/" + code + ".gif";

    var img = new Image();

    

    img.onerror = function (evt) {

          document.getElementById("headimg").src = "images/no-cookie.gif";

      }

    

    img.onload = function (evt) {

          document.getElementById("headimg").src = imgsrc;

        

      }

   

    

});

  Thanks!

Hey, I posted a thread before about a news cms I've been developing. And right now I'm trying to flesh out the css of the articles I post on the home page. Now the problem I having is everytime I place a <span class=""></span> or <p class=""></p> or even <div class=""></div>, my web page does NOT load, and instead gives me an error.

Code: [Select]
Parse error: syntax error, unexpected T_STRING in /home/content/d/j/s/djsmiley/html/index.php on line 405
Now, I know it's possible to add css to a PHP echo statement, but I'm clearly doing something wrong.

Here's the code for the php echo statement with the css included:

Code: [Select]
<?
include("dbconnect.php"); //include the file to connect to the database
$getnews = mysql_query("SELECT * FROM mynews ORDER BY id DESC"); //query the database for all of the news

while($r=mysql_fetch_array($getnews)){ //while there are rows in the table
extract($r); //remove the $r so its just $variable

echo("<br><span class="NewsID">$type</span> <span class=h2>$title</span><br><br>
<em>posted by <strong>$user</strong> | added on $time</em><br><br>
$message<br><br>
<label class="fltlft2"><img src="../../Websites/DJSmiley.Net/images/Icons/Arrows/Right.png" width="20" height="20"/></label><a href=$url>Read more - $url</a>
<div class="newsLikeShareRate">
  <table width="100%" border="0">
<tr>
  <td width="3%" height="21"><script src="http://connect.facebook.net/en_US/all.js#xfbml=1"></script>
  <fb:like href="$url" show_faces="true" width="450" font="arial"></fb:like>
                              </td>
<td width="65%"><a name="fb_share" id="fb_share4" type="icon_link"
   share_url="$url">Share</a>
  <script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share"
type="text/javascript"></script></td>
  <td width="32%">Rate this article:
   </td>
</tr>
  </table>
</div>");

}

?>
If you're wondering why there's a facebook script in there, I made it to where everytime a new post is added, a facebook like and share button are added, and are assigned the url I specify when the article is posted.

Well, I think that's it for the code. Can anyone tell me what I'm doing wrong?

I need some help with this. I created an index.php page and I inserted an include statement that referred to a header.html page. It works when working it in MS Webmatrix but when I put it on my server I only get my index.php page. My include statement will not get the header.html page. What am I doing wrong?  I also tried changing all of my files to .php extensions also and still the same.

Here is my index.php file:
 

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Braswell Electric</title>
<link rel="stylesheet" href="braswellelectric.css">
</head>

<body>
<div>
<?php include('/includes/header.html');?>
<?php include('/includes/aside.html');?>

<article class="About">
<header class="AboutHeader">
<h2>About Us</h2>
</header>
<p><b>Braswell Electric</b> is a family business owned and operated by Jim and Joyce Braswell located in Sylacauga, Alabama. Braswell Electris has been in business in Sylacauga for 25 years and covers the greater Talladega County area. We do new homes, remodels, or any small electrical issues you may have. We are licensed and insured and we are here for your residential needs.</p>

<img src="pics/Coach Light.jpg" alt="Coach Light" >
<img src="pics/Outside Plug.jpg" alt="Outside Plug">
<img src="pics/Service.jpg" alt="Service">

</article>
</div>
</body>
</html>

Here is my header.html file

<!DOCTYPE html>

<html lang="en">
<head>
<meta charset="utf-8" />
<title></title>

</head>
<body>
<header class="Header">
<h1 style="display: none">Braswell Electric</h1>
<img src="pics/lightning1.jpg" alt="Header Pic">
</header>

</body>
</html>

Edited by Ch0cu3r, 27 August 2014 - 12:37 PM.

hi silly little question but if I want to bracket something inside PHP how do I do it eg my code is

Code: [Select]
  <th class="alignright"><?php echo $ass_descrip; ?>&nbsp;
                           (<?php echo $ass_accro ; ?>) &nbsp;<?php echo FindTypeName ($type_id); ?></th>
printing out         British Eventing  (BE) 

But the brackets at the moment are outside the PHP I want to put a conditional on it and include the brackets inside my conditional statement.?

Hi there i was wondering how i would go about using html tags inside the php tags so i could put data from a database into a textarea / text input i had a go but had no such luck with this attempt:

<?php 

echo "Title:<br>";
echo "<input type="text" name="title" value="$row['Title']">";

?>
the code above is to give you an idea of what i want to do, if you can point me to any guides or show me how it will be greatly appriciated

Thanks,

Blink359

Hi.


I created forms with condition to only view Items which is = Min Lot, now my problem is if no items that = Min Lot the select option below was displayed and the save button. I want to display them only also if the if condition is true. I mean if the condition was not satisfied no display, now in my code it happened is the Issued BY, Received By, Approved BY, Requested By and save button was still display.. How can I also display only them if the condition was satisfied?


Thank you

here is my code:


<?php                                                                          
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);  
?>
<html>
<title>Stock Requisition</title>
<head>
<link rel="stylesheet" type="text/css" href="kanban.css">



<script type="text/javascript">
function save_sr(){
    var sr_date = document.getElementById("sr_date").value;
    var sr_number = document.getElementById("sr_number").value;
    var Items_ = document.getElementById("Items_").value;
    var SubItems = document.getElementById("SubItems").value;
    var ItemCode = document.getElementById("ItemCode").value;
    var DemandedQty = document.getElementById("DemandedQty").value;
    var UoM = document.getElementById("UoM").value;
    var Class = document.getElementById("Class").value;
    var Description = document.getElementById("Description").value;
    var BINLocation = document.getElementById("BINLocation").value;
    var RequestedBy = document.getElementById("RequestedBy").value;
    var ApprovedBy = document.getElementById("ApprovedBy").value;
    var ReceivedBy = document.getElementById("ReceivedBy").value;
    var IssuedBy = document.getElementById("IssuedBy").value;
    var Items1 = document.getElementById("Items1").value;
    var SubQty_ = document.getElementsByTagName('input');
    var SubQty = SubQty_[9].getAttribute("value");
    var sr_number_hide = document.getElementById("sr_number_hide").value;
    
  document.frmMain.action="StockRequisitionSave1.php?sr_date="+sr_date+"&sr_number="+sr_number+"&Items_="+Items_+
    "&SubItems="+SubItems+"&ItemCode="+ItemCode+"&DemandedQty="+DemandedQty+"&UoM="+UoM+"&Class="+Class+"&Description="+
    Description+"&BINLocation="+BINLocation+"&RequestedBy="+RequestedBy+"&ApprovedBy="+ApprovedBy+"&ReceivedBy="+ReceivedBy+
    "&IssuedBy="+IssuedBy+"&Items1="+Items1+"&sr_number_hide="+sr_number_hide+"&SubQty="+SubQty;
    document.frmMain.submit();
   alert("Stock Requisition data save.");
   //window.location = "StockRequisition1.php";
   window.location = "StockRequisitionDisplay1.php";
}

</script>

<script type="text/javascript">

function test_(cmpd, mult) {

     var len_ = (document.frmMain.elements.length) - 1;

     for (i=0; i <= len_; i++ ) {

       var cmp = "_" + cmpd;    
       var strPos_ = document.frmMain.elements[i].id.indexOf(cmp)
         
              if (strPos_ != -1) {
              var strPos = document.frmMain.elements[i].id.indexOf("_");
              
var strId = document.frmMain.elements[i].id.slice(strPos + 1) + "_" + document.frmMain.elements[i].id.slice(0,strPos);
    document.frmMain.elements[i].value = (document.getElementById(strId).value * mult).toFixed(2); 
     } 
    }   
    
    
}
 
</script>

</head>
<body>
<form name="frmMain" method="post"> 
   <div>
<table>
<thead>
<th>Items</th>
<th>Sub Items</th>
<th>Item Code</th>
<th>Demanded Qty</th>
<th>UoM</th>
<th>Class</th>
<th>Description</th>
<th>BIN Location</th>
</thead>
<?php

$DemandedQty = $_POST['DemandedQty'];

$sql = "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";
$res_bom = mysql_query($sql, $con);
$totalDistinct = mysql_num_rows($res_bom);

if ($totalDistinct > 0) {
    while ($row = mysql_fetch_assoc($res_bom)) {
        $Comp[] = substr($row['Items'], 12, 3);
       // $Comp = substr($cmpdArray, 12, 3);
    }
}


 foreach ($Comp as $Comp) {   


    $sql = "SELECT COUNT(WIP_1) AS WIP_1 FROM KANBAN_REPORT_OPEN WHERE SUBSTRING(LOT_CODE, 9) = '$Comp' AND WIP_1 > 0";  
    $resultWip = mysql_query($sql, $con);
    $wip_1 = mysql_result($resultWip, 0 , "WIP_1");
    $wip1Accum = $wip1Accum + $wip_1;
    
    $sql = "SELECT COUNT(WIP_2) AS WIP_2 FROM KANBAN_REPORT_OPEN WHERE SUBSTRING(LOT_CODE, 9) = '$Comp' AND WIP_2 > 0";  
    $resultWip = mysql_query($sql, $con);
    $wip_2 = mysql_result($resultWip, 0 , "WIP_2");
    $wip2Accum = $wip2Accum + $wip_2; 
    
    $sql = "SELECT COUNT(WIP_3) AS WIP_3 FROM KANBAN_REPORT_OPEN WHERE SUBSTRING(LOT_CODE, 9) = '$Comp' AND WIP_3 > 0";  
    $resultWip = mysql_query($sql, $con);
    $wip_3 = mysql_result($resultWip, 0 , "WIP_3");
    $wip3Accum = $wip3Accum + $wip_3; 

    $sql = "SELECT COUNT(WIP_4) AS WIP_4 FROM KANBAN_REPORT_OPEN WHERE SUBSTRING(LOT_CODE, 9) = '$Comp' AND WIP_4 > 0";  
    $resultWip = mysql_query($sql, $con);
    $wip_4 = mysql_result($resultWip, 0 , "WIP_4");
    $wip4Accum = $wip4Accum + $wip_4; 

    $sql = "SELECT COUNT(WIP_5) AS WIP_5 FROM KANBAN_REPORT_OPEN WHERE SUBSTRING(LOT_CODE, 9) = '$Comp' AND WIP_5 > 0";  
    $resultWip = mysql_query($sql, $con);
    $wip_5 = mysql_result($resultWip, 0 , "WIP_5");
    $wip5Accum = $wip5Accum + $wip_5; 

    $total = $wip_1  +  $wip_2 + $wip_3 + $wip_4 + $wip_5;

    

$sql = "SELECT Compounds, Min_Lot FROM param_settings WHERE Compounds = '$Comp'";
$res_param = mysql_query($sql);

$row_param = mysql_fetch_assoc($res_param);

$Compounds = $row_param['Compounds'];
$Min_Lot = $row_param['Min_Lot'];
 
    
if($Comp = $Compounds && $total == $Min_Lot){    
$sql = "SELECT DISTINCT Items FROM bom_subitems WHERE SUBSTR(Items,13,3) = '$Compounds' ORDER BY Items";

$res_bom = mysql_query($sql, $con);
while($row = mysql_fetch_assoc($res_bom)){
    
    $Items = $row['Items'];
    $Items_ = substr($Items, 12, 3);
    
echo "<tr>
        <td style='border: none;font-weight: bold;'>&nbsp;<input type='name' value='$Items_' name='Items_[]' id='Items_' readonly = 'readonly' style = 'border:none;width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td style='border:none;'>&nbsp;</td>
        <td style='border:none;'>&nbsp;</td> 
        <td style='border: none;'><center><input type='text' style='text-align: right;' name='DemandedQty[]' id='DemandedQty' size='12' onkeyup='test_(\"$Items_\", this.value)' value=''></center></td>     
        </tr>"; 
             
$sql = "SELECT Items, SubItems, ItemCode, UoM, Class, Description, BINLocation, Quantity FROM bom_subitems WHERE Items = '$Items' ORDER BY Items"or die(mysql_error());

$res_sub = mysql_query($sql, $con);  
 $counter = 0;
 while($row_sub = mysql_fetch_assoc($res_sub)){
     $joinId = $counter . "_" .  $Items_;      
     $Items = $row_sub['Items'];
     $Items1 = substr($Items, 12, 3);
     $SubItems = $row_sub['SubItems'];
     $ItemCode = $row_sub['ItemCode'];
     $UoM = $row_sub['UoM'];
     $Class = $row_sub['Class'];
     $Description = $row_sub['Description'];
     $BINLocation = $row_sub['BINLocation'];
     $Quantity = $row_sub['Quantity']; 
     $joinId2 =  $Items_ . "_" . $counter;

    echo "<tr>
        <td style='border: none;'>&nbsp;<input type='hidden' value='$Items1'  name='Items1[]' id='Items1'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='SubItems[]' id='SubItems' value='$SubItems'  readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='ItemCode[]' id='ItemCode' value='$ItemCode'  readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td><input class='txt' type='text' name='SubQty[]' id='$joinId' readonly = 'readonly' size='12' style= 'border:none;text-align:right'/><input type='hidden' id='$joinId2' value='$Quantity' /></td>
        <td style='border: none;' size='3'>&nbsp;<input type='text' name='UoM[]' id='UoM' value='$UoM' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='3'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Class[]' value='$Class' name='Class' id='Class' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Description[]' value='$Description' id='Description' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size= '30'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='BINLocation[]' value='$BINLocation' id='BINLocation' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>     
        </tr>";    
 $counter  = $counter  + 1;
}
}
}
} 
                 
?>
</table>
</div>
<?php
   $RequestedBy = array('AAA', 'BBB', 'CCC', 'DDD');
   
   $ApprovedBy = array('EEE', 'FFF', 'GGG', 'HHH');
   
   $ReceivedBy = array('III', 'JJJ', 'KKK', 'LLL');
   
   $IssuedBy = array('MMM', 'NNN', 'OOO', 'PPP'); 

?>

 <div id='Requested_By'>
<label>Requested By:</label>
 <select name="RequestedBy">
 <option value="Select">Select</option>
 <option value="AAA" <?php if($_POST['RequestedBy'] == 'AAA') echo "selected='selected'"; ?>>AAA</option>
  <option value="BBB" <?php if($_POST['RequestedBy'] == 'BBB') echo "selected='selected'"; ?>>BBB</option>
 <option value="CCC" <?php if($_POST['RequestedBy'] == 'CCC') echo "selected='selected'"; ?>>CCC</option>
  <option value="DDD" <?php if($_POST['RequestedBy'] == 'DDD') echo "selected='selected'"; ?>>DDD</option>
 </select>
</div>

<div id='Approved_By'>
<label>Approved By:</label>
<select name="ApprovedBy">
<option name='Select'>Select</option>
<option value="EEE" <?php if($_POST['ApprovedBy'] == 'EEE') echo "selected='selected'"; ?>>EEE</option>
  <option value="FFF" <?php if($_POST['ApprovedBy'] == 'FFF') echo "selected='selected'"; ?>>FFF</option>
 <option value="GGG" <?php if($_POST['ApprovedBy'] == 'GGG') echo "selected='selected'"; ?>>GGG</option>
  <option value="HHH" <?php if($_POST['ApprovedBy'] == 'HHH') echo "selected='selected'"; ?>>HHH</option>
</select>
</div>

<div id='Received_By'>
<label>Issued By:</label>
<select name="IssuedBy">
<option name='Select'>Select</option>
<option value="III" <?php if($_POST['ReceivedBy'] == 'III') echo "selected='selected'"; ?>>III</option>
  <option value="JJJ" <?php if($_POST['ReceivedBy'] == 'JJJ') echo "selected='selected'"; ?>>JJJ</option>
 <option value="KKK" <?php if($_POST['ReceivedBy'] == 'KKK') echo "selected='selected'"; ?>>KKK</option>
  <option value="LLL" <?php if($_POST['ReceivedBy'] == 'LLL') echo "selected='selected'"; ?>>LLL</option>

</select>
</div>

<div id='Issued_By'>
<label>Received By:</label>
<select name="ReceivedBy">
<option name='Select'>Select</option>
<option value="MMM" <?php if($_POST['IssuedBy'] == 'MMM') echo "selected='selected'"; ?>>MMM</option>
  <option value="NNN" <?php if($_POST['IssuedBy'] == 'NNN') echo "selected='selected'"; ?>>NNN</option>
 <option value="OOO" <?php if($_POST['IssuedBy'] == 'OOO') echo "selected='selected'"; ?>>OOO</option>
  <option value="PPP" <?php if($_POST['IssuedBy'] == 'PPP') echo "selected='selected'"; ?>>PPP</option>

</select>
</div>

<div id="save_btn">
<input type="button" name="button" value="save" onClick="save_sr()" style="width: 5em;">

</div>

</form>
</body>
</html>



I will attach my sample form output

I am having trouble implementing PHP inside a HTML attribute. Every time I try to fix it, I seem to make things worse. Can someone please help me:

<INPUT name="id" type="text" value=""<?php echo "$row['id']"; ?>"">

How can this be written in PHP?

Code: [Select]
echo '<IMG alt="" src=".$row['id']/thumb.png">';