PHP - Multiple Requires

Hello all,

   I am trying to learn OOP in PHP so please forgive my ignorance. I seem to be having difficulty inserting data into my database from checkbox items. My database has a column for each each fruit. I would like for each column to be populated with either a one(1) for checked or a zero(0)  for not checked. Currently, my attempts have failed. I can either get all checkboxes to insert all zeros or I can get the first column to insert a one(1) while the others as zeros. Is there anybody here that can help me figure out what I am doing wrong and help me to re-work my code so I can get this to work? If anybody can help me using OOP methods that would be fantastic. Thank you all in advance.

 

$preffruit->create_preffruit(array(

  'fruit_apple' => escape(Input::get(['fruit_selection'][0]) ? 1 : 0),
  'fruit_orange' => escape(Input::get(['fruit_selection'][1]) ? 1 : 0),
  'fruit_banana' => escape(Input::get(['fruit_selection'][2]) ? 1 : 0),
  'fruit_pear' => escape(Input::get(['fruit_selection'][3]) ? 1 : 0),
  'fruit_kiwi' => escape(Input::get(['fruit_selection'][4]) ? 1 : 0)

  ));

<input type="checkbox" name="fruit_selection[]" value="fruit_apple">
<input type="checkbox" name="fruit_selection[]" value="fruit_orange">
<input type="checkbox" name="fruit_selection[]" value="fruit_banana">
<input type="checkbox" name="fruit_selection[]" value="fruit_pear">
<input type="checkbox" name="fruit_selection[]" value="fruit_kiwi">



public function insert_preffruit($table, $fields = array()) {
			
			$keys = array_keys($fields);
			$values = '';
			$x = 1;			
			
			foreach($fields as $field) {
				$values .= '?';
				if($x < count($fields)) {
					$values .= ', ';
				}
				$x++;
			}		
				
				$sql = "INSERT INTO preffruit (`user_id`, `" . implode('`, `', $keys) . "`) VALUES (LAST_INSERT_ID(), {$values})";		
			
			if(!$this->query($sql, $fields)->error()) {
				return true;
			}			
			
			return false;
		}

 

Edited September 23, 2020 by ke-jo

Ok so i want to grab an id from the checkbox then grab the option drop down associated with that check box and update a mysql row here is my code so far

any help is awesome help taaaanks guys

<?php
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());
$query = "SELECT * FROM tickets ORDER BY id DESC";
$result = mysql_query($query) or die(mysql_error());

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

print "<input name='delete[]' value='{$row['id']}' type='checkbox'>";
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());
$query2 = "SELECT * FROM admin";
$result2 = mysql_query($query2) or die(mysql_error());
print "<form name='namestoupdate' method='post' action='update.php'>\n";
print '<select>';
while($row2 = mysql_fetch_array($result2))
{
if ($row2['priv']==prov){print '<option value="'.$row2['user'].'" name="prov['.$i++.']">'.$row2['user'].'</option>';}
}
print '</select>';
print "<input type='submit' value='submit' />";
print "</form>";
}
?>


Visual aid

This seems to be a bit of a challenge but I am creating a multiple page form and on one of the pages I have a select field. I would like the user to have the ability to select multiple options but I am using some functions to move the data in hidden fields from page to page. I don't think my functions are jiving with my my foreach loop cause I keep getting an invalid argument error.

Thanks in advance for any help.

Here is my function:

    function setSelected($fieldName, $fieldValue) {
        if(isset($_POST[$fieldName]) && $_POST[$fieldName] == $fieldValue) {
            echo 'selected="selected"';
        }
    }

And here is my loop:

    $selections = "";
   
    if(isset($_POST["selections"])) {
        foreach ($_POST["selections"] as $selection) {
            $selections .= $selection . ", ";
        }
    }

I have a search where I want to be able to search a string of words. The search is going to be looking in 2 different table joined by a left outer join. The tables are "quotes" and "categories".

$sql="SELECT q.id, q.username, q.quote, q.by, q.voteup, q.votedown, q.servtime, c.quote_id, c.label FROM quotes q LEFT OUTER JOIN categories c ON q.id = c.quote_id WHERE ( q.username LIKE '$srch' OR q.quote LIKE '$srch' OR q.`by` LIKE '$srch' OR c.label LIKE '$srch')";
   
The above mysql statement works and returns values..BUT if say, I search "john" and "funny", and a quote is posted by the user "john", but has a category of "funny" it will output the same quote twice. I was wondering if there was a way to see if a quote has either 1 term or both terms, if so display that quote but only display it once. Below is what the query is outputting.


[100] => Array
        (
            [id] => 100
            [username] => John
            [quote] => new test quote blah blah
            [by] => John
            [voteup] => 0
            [votedown] => 0
            [servtime] => 2010-12-02 @ 16:27:03
            [label] => Array
                (
                    [0] => Historic
                    [1] => Serious
                    [2] => Funny
                )

        )


Here is the code in full.


////
$sword = explode(" ",$search);
foreach($sword as $sterm){
$srch="%".$sterm."%";
echo"$srch<br />";
$sql="SELECT q.id, q.username, q.quote, q.by, q.voteup, q.votedown, q.servtime, c.quote_id, c.label FROM quotes q LEFT OUTER JOIN categories c ON q.id = c.quote_id WHERE ( q.username LIKE '$srch' OR q.quote LIKE '$srch' OR q.`by` LIKE '$srch' OR c.label LIKE '$srch')";
$result=mysql_query($sql);
while($row=mysql_fetch_object($result)){
$quote[$row->id]['id'] = $row->id;
$quote[$row->id]['username'] = $row->username;
$quote[$row->id]['quote'] = $row->quote;
$quote[$row->id]['by'] = $row->by;
$quote[$row->id]['voteup'] = $row->voteup;
$quote[$row->id]['votedown'] = $row->votedown;
$quote[$row->id]['servtime'] = $row->servtime;
$quote[$row->id]['label'][] = $row->label;
}
echo"<pre>";
print_r($quote);
echo"</pre>";


I don't think this is the fastest way of doing this, as it loops for each item in the db, per each keyword that is search.

Any help would be great!!
-BaSk

I have a form where a user can duplicate part of a form like below:


I've named the fields with the HTML arrays (ie. "fieldName[]") and came up with this:

//--> CONTROLLERS
$system_controllers_qty = $_POST['system_controllers_qty'];
$system_controllers_make = $_POST['system_controllers_make'];
$system_controllers_model = $_POST['system_controllers_model'];
$system_controllers_serial_no         = $_POST['system_controllers_serial_no'];
for ($i = 0; $i < count($system_controllers_qty); $i++)
{
echo "qty " . clean($system_controllers_qty[$i]) . "<br/>";
echo "make " . clean($system_controllers_make[$i]) . "<br/>";
echo "model " . clean($system_controllers_model[$i]) . "<br/>";
echo "serial_no " . clean($system_controllers_serial_no[$i]) . "<br/>";
}

//--> CPUS
$system_cpus_qty = $_POST['system_cpus_qty'];
$system_cpus_model = $_POST['system_cpus_model'];
$system_cpus_serial_no = $_POST['system_cpus_serial_no'];
$system_cpus_speed = $_POST['system_cpus_speed'];
for ($i = 0; $i < count($system_cpus_qty); $i++)
{
echo "qty " . clean($system_cpus_qty[$i]) . "<br/>";
echo "model " . clean($system_cpus_model[$i]) . "<br/>";
echo "serial_no " . clean($system_cpus_serial_no[$i]) . "<br/>";
echo "speed " . clean($system_cpus_speed[$i]) . "<br/>";
}

//--> DISKS
$system_disks_qty = $_POST['system_disks_qty'];
$system_disks_make = $_POST['system_disks_make'];
$system_disks_model_no = $_POST['system_disks_model_no'];
$system_disks_size = $_POST['system_disks_size'];
$system_disks_serial_no = $_POST['system_disks_serial_no'];
for ($i = 0; $i < count($system_disks_qty); $i++)
{
echo "qty " . clean($system_disks_qty[$i]) . "<br/>";
echo "make " . clean($system_disks_make[$i]) . "<br/>";
echo "model_no " . clean($system_disks_model_no[$i]) . "<br/>";
echo "size " . clean($system_disks_size[$i]) . "<br/>";
echo "serial_no " . clean($system_disks_serial_no[$i]) . "<br/>";
}

//--> MEMORY
$system_memory_qty = $_POST['system_memory_qty'];
$system_memory_serial_no = $_POST['system_memory_serial_no'];
$system_memory_manf = $_POST['system_memory_manf'];
$system_memory_part_no = $_POST['system_memory_part_no'];
$system_memory_size = $_POST['system_memory_size'];
for ($i = 0; $i < count($system_memory_qty); $i++)
{
echo "qty " . clean($system_memory_qty[$i]) . "<br/>";
echo "serial " . clean($system_memory_serial_no[$i]) . "<br/>";
echo "manf " . clean($system_memory_manf[$i]) . "<br/>";
echo "part_no " . clean($system_memory_part_no[$i]) . "<br/>";
echo "size " . clean($system_memory_size[$i]) . "<br/>";
}


This just outputs all the fields I post at the moment. Say I have 3 different disk types, it's going to loop 3 times. Is it possible to make this all into 1 giant query or am I better off doing each query separately? Each section is a different table.

does anyone have a code todo this? a snippet or soemthing ive tried a few diffrent ones ive seen but nothing that works.. it takes whats submited in search, then takes the words, breaks them up and creates a query string with all the diffrent feilds... here is what phpadmin produces when i search

 SELECT *  FROM `breedclads`.`activeamahorse` WHERE (`id_entered` LIKE '%green%' OR `uuid` LIKE '%green%' OR `ama_hr_coat` LIKE '%green%' OR `breedable` LIKE '%green%' OR `ama_hr_sex` LIKE '%green%' OR `ama_hr_age` LIKE '%green%' OR `date_entered` LIKE '%green%' OR `ama_hr_eyes` LIKE '%green%' OR `ama_hr_eyes_type` LIKE '%green%' OR `ama_hr_mane` LIKE '%green%' OR `ama_hr_tail` LIKE '%green%' OR `ama_hr_luster_coat` LIKE '%green%' OR `ama_hr_luster_hair` LIKE '%green%' OR `ama_hr_gleam_coat` LIKE '%green%' OR `ama_hr_gleam_hair` LIKE '%green%' OR `ama_hr_parents` LIKE '%green%' OR `ama_hr_sale_type` LIKE '%green%' OR `ama_hr_sale_price` LIKE '%green%' OR `ama_hr_location` LIKE '%green%' OR `auction_date` LIKE '%green%' OR `picture_type` LIKE '%green%' OR `picture_name` LIKE '%green%' OR `picture_size` LIKE '%green%' OR `picture_content` LIKE '%green%' OR `ama_hr_coat_type` LIKE '%green%' OR `ama_hr_coat_gloom` LIKE '%green%' OR `ama_hr_hair_gloom` LIKE '%green%' OR `ama_hr_slurl` LIKE '%green%' OR `class_link_key` LIKE '%green%')  AND  (`id_entered` LIKE '%albino%' OR `uuid` LIKE '%albino%' OR `ama_hr_coat` LIKE '%albino%' OR `breedable` LIKE '%albino%' OR `ama_hr_sex` LIKE '%albino%' OR `ama_hr_age` LIKE '%albino%' OR `date_entered` LIKE '%albino%' OR `ama_hr_eyes` LIKE '%albino%' OR `ama_hr_eyes_type` LIKE '%albino%' OR `ama_hr_mane` LIKE '%albino%' OR `ama_hr_tail` LIKE '%albino%' OR `ama_hr_luster_coat` LIKE '%albino%' OR `ama_hr_luster_hair` LIKE '%albino%' OR `ama_hr_gleam_coat` LIKE '%albino%' OR `ama_hr_gleam_hair` LIKE '%albino%' OR `ama_hr_parents` LIKE '%albino%' OR `ama_hr_sale_type` LIKE '%albino%' OR `ama_hr_sale_price` LIKE '%albino%' OR `ama_hr_location` LIKE '%albino%' OR `auction_date` LIKE '%albino%' OR `picture_type` LIKE '%albino%' OR `picture_name` LIKE '%albino%' OR `picture_size` LIKE '%albino%' OR `picture_content` LIKE '%albino%' OR `ama_hr_coat_type` LIKE '%albino%' OR `ama_hr_coat_gloom` LIKE '%albino%' OR `ama_hr_hair_gloom` LIKE '%albino%' OR `ama_hr_slurl` LIKE '%albino%' OR `class_link_key` LIKE '%albino%')  AND  (`id_entered` LIKE '%69%' OR `uuid` LIKE '%69%' OR `ama_hr_coat` LIKE '%69%' OR `breedable` LIKE '%69%' OR `ama_hr_sex` LIKE '%69%' OR `ama_hr_age` LIKE '%69%' OR `date_entered` LIKE '%69%' OR `ama_hr_eyes` LIKE '%69%' OR `ama_hr_eyes_type` LIKE '%69%' OR `ama_hr_mane` LIKE '%69%' OR `ama_hr_tail` LIKE '%69%' OR `ama_hr_luster_coat` LIKE '%69%' OR `ama_hr_luster_hair` LIKE '%69%' OR `ama_hr_gleam_coat` LIKE '%69%' OR `ama_hr_gleam_hair` LIKE '%69%' OR `ama_hr_parents` LIKE '%69%' OR `ama_hr_sale_type` LIKE '%69%' OR `ama_hr_sale_price` LIKE '%69%' OR `ama_hr_location` LIKE '%69%' OR `auction_date` LIKE '%69%' OR `picture_type` LIKE '%69%' OR `picture_name` LIKE '%69%' OR `picture_size` LIKE '%69%' OR `picture_content` LIKE '%69%' OR `ama_hr_coat_type` LIKE '%69%' OR `ama_hr_coat_gloom` LIKE '%69%' OR `ama_hr_hair_gloom` LIKE '%69%' OR `ama_hr_slurl` LIKE '%69%' OR `class_link_key` LIKE '%69%')




i need this to be made when people search with mutliple words  as you can see it searchs each feilds for the green then each feild for albino, so on.. but i wont ever know what there searching for

Please help me, thanks

Hello all! I'm having some issues with a snippet that I found online and have edited to how I want it.

Basically the code works at the moment, except if I were to search for 2 or 3 terms, it would search the columns username/action/result/changes for any result that have any of the words rather than results that include both terms, instead of either.

I want the query to be like (assuming 2 search terms):

Quote

username LIKE '%$filter%' OR action LIKE '%$filter%' OR result LIKE '%$filter%' OR changes LIKE '%$filter%' AND username LIKE '%$filter%' OR action LIKE '%$filter%' OR result LIKE '%$filter%' OR changes LIKE '%$filter%'


and not:

Quote

username LIKE '%$filter%' OR action LIKE '%$filter%' OR result LIKE '%$filter%' OR changes LIKE '%$filter%' OR username LIKE '%$filter%' OR action LIKE '%$filter%' OR result LIKE '%$filter%' OR changes LIKE '%$filter%'


It needs an AND instead of an OR, but I'm not sure how to go around doing it.

Here's the code as it is at the moment:

$filter = ($_POST['filter']); 

$query = "SELECT * FROM activity WHERE"; 

$searchresult = explode(" ", $filter); 

     foreach ($searchresult as $key => $filter) { 
$query .= " username LIKE '%$filter%' OR action LIKE '%$filter%' OR result LIKE '%$filter%' OR changes LIKE '%$filter%'"; 
     if ($key != (sizeof($searchresult) - 1))   
$query .= " AND ";
     }
$query .= "ORDER BY id DESC"; 

Sorry if this is a little confusing to understand, hope someone understands what I need.

I want to echo out a few subcategories per main category.
It should be a maximum of 20 entries per column

At this stage I have the following... It echo's the results out in 4 columns and not what I want.
Any suggestions?

$query = "SELECT 
adsubcat.name AS subname, adsubcat.linkname AS sublink, adcat.clinkname AS clink
FROM adsubcat 
JOIN adcat ON adcat.id=adsubcat.catid
WHERE adsubcat.catid='$catid' ORDER BY adsubcat.name ASC";
$result = mysql_query($query) or die(mysql_error());

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

$count = 0;

print '<table style="text-align:left;margin-left:0px;width:943px;">'."\n";
while ($row = mysql_fetch_assoc($result)){
$gal = '<a href="'.$root.'/'.$row['clink'].'/'.$row['sublink'].'">'.$row['subname'].'</a>';
if ($count == 0){
print '<tr>';
}
++$count;
print '<td>'.$gal.'</td>';
if ($count == 4){
$count = 0;
print'</tr>'."\n";
}
}
print'</table>'."\n";
}

I am trying to export multiple csv files to download from 2 separate tables in my database.

Some background:
I have a web app that links to a phpmyadmin database. There are 2 tables in the database (entering and exiting). These tables hold the phone inventory information of employees currently entering or exiting the organization.

The fields in my tables a

location, firstname, lastname, username, extension, mac, type

What I am trying to do is export the data in these 2 tables to CSV (which I have working now) but I need to have multiple CSVs for each.

For example, for my exiting table, I need to have one CSV export all the fields in the table and I also need another CSV to export just the location and username field. I have a simple html form with a submit button which is currently working now:

<form action="exportexiting.php" method="POST" style="width: 456px; height: 157px">
   <div>
   <fieldset>
   <legend style="width: 102px; height: 25px"><strong>Entering CSV:</strong></legend>
   <input name="Export" type="submit" id="Export" value="Export">
   </fieldset><br/>
   </div>
</form>


This links to my exportexiting.php file:

<?php
$host = 'localhost';
$user = 'root';
$pass = 'xxxx';
$db = 'PhoneInventory';
$table = 'exiting';


 
// Connect to the database
$link = mysql_connect($host, $user, $pass);
mysql_select_db($db);
 
require 'exportcsv.inc.php';

 
exportMysqlToCsv($table);
 
 
 
?>

Then to exportcsv.inc.php:

<?php
 
function exportMysqlToCsv($table,$filename = 'export.csv')
{
    $csv_terminated = "\n";
    $csv_separator = ",";
    $csv_enclosed = '';
    $csv_escaped = "\\";
    $sql_query = "select * from $table";
 
    // Gets the data from the database
    $result = mysql_query($sql_query);
    $fields_cnt = mysql_num_fields($result);
 
 
    $schema_insert = '';
 
    for ($i = 0; $i < $fields_cnt; $i++)
    {
        $l = $csv_enclosed . str_replace($csv_enclosed, $csv_escaped . $csv_enclosed,
            stripslashes(mysql_field_name($result, $i))) . $csv_enclosed;
        $schema_insert .= $l;
        $schema_insert .= $csv_separator;
    } // end for
 
    $out = trim(substr($schema_insert, 0, -1));
    $out .= $csv_terminated;
 
    // Format the data
    while ($row = mysql_fetch_array($result))
    {
        $schema_insert = '';
        for ($j = 0; $j < $fields_cnt; $j++)
        {
            if ($row[$j] == '0' || $row[$j] != '')
            {
 
                if ($csv_enclosed == '')
                {
                    $schema_insert .= $row[$j];
                } else
                {
                    $schema_insert .= $csv_enclosed .
               str_replace($csv_enclosed, $csv_escaped . $csv_enclosed, $row[$j]) . $csv_enclosed;
                }
            } else
            {
                $schema_insert .= '';
            }
 
            if ($j < $fields_cnt - 1)
            {
                $schema_insert .= $csv_separator;
            }
        } // end for
 
        $out .= $schema_insert;
        $out .= $csv_terminated;
    } // end while
 
    header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
    header("Content-Length: " . strlen($out));
    // Output to browser with appropriate mime type, you choose
    header("Content-type: text/x-csv");
    //header("Content-type: text/csv");
    //header("Content-type: application/csv");
    header("Content-Disposition: attachment; filename=$filename");
    echo $out;
    exit;
 
}
 
?>



Again, this is working perfectly for only exporting all the data from the exiting table into one CSV file. My question is, how can I make my one submit button export the 2 CSV files that I need?


Thanks for the help...

Guys will you help me by 

Creating multiple pdf using single command 

using tcpdf in php it will most helpful for me 

SCRATCH THAT! - had a typo...     Hi Guys

I have another SQL question and I hope someone can help.

I'm trying to run a query with two 'IN' statements.  The first IN statement is compiled from a sub-query and the second is hard coded (its from an external list, which is actually much larger than in the example below)

I keep getting an sql error when I run this through PHP MyAdmin but the error isn't giving me much to go on and I'm not even sure if it's valid to run two IN statements in the same query.  Any help on how I might achieve the above would be most welcome!

Oh and postNumber is an integer representing posts but there are some duplicates in the database hence the DISTINCT query

SELECT * FROM `posts` WHERE `postNumber` IN (SELECT DISTINCT(`postNumber`) FROM `post` WHERE `postYear` >2013) OR `postNumber` IN ('10088','9813','7991')

Drongo
Edited by Drongo_III, 30 December 2014 - 12:16 PM.

Hi all,

I will wish to modify this code to get a choice of multiple selection, so I can select multiple category and not a single as it is currently.


Here is the original code:
Code: [Select]
    {if $step==1}
    <div class="form_content">
    <form name="newad" method="post" action="newad.php?step=1">
    <label>{$lng.listings.category}<span class="mandatory"> *</span></label>
    <select id="category" name="category">
    <option value="">{$lng.listings.category}</option>
    {foreach from=$categories item=v name=cat}
    {if $v.parent==1}
    <optgroup label="{$v.str}{$v.name}">
    {else}
    <option value="{$v.id}" {if $tmp.category==$v.id}selected="selected"{/if}>{$v.str}{$v.name|escape:"html"}</option>
    {if ( $smarty.foreach.cat.index!=$categories|@count-1 && $v.parent_id!=$categories[$smarty.foreach.cat.iteration].parent_id) || ($smarty.foreach.cat.index==($categories|@count-1) && $v.parent_id!=0)}
    </optgroup>
    {/if}
   
    {/if}
    {/foreach}
    </select>
   
    {* ----------------------- levels drop down categories --------------------- *}
    {*
           <div>
            <select id="category1" name="category1" class="levels" onChange="chooseCateg(this.form, 1)">
            <option value="">{$lng.listings.category}</option>
            {foreach from=$categories item=v name=cat}
                    {if $v.parent_id==0}
                    <option value="{$v.id}">{$v.name|escape:"html"}</option>
                    {/if}
            {/foreach}
            </select>
            </div>
   
            <div style="display: none;" id="level2">
            <select id="category2" name="category2" class="levels" onChange="chooseCateg(this.form, 2)">
            </select>
            </div>
   
            <div style="display: none;" id="level3">
            <select id="category3" name="category3" class="levels" onChange="chooseCateg(this.form, 3)">
            </select>
            </div>
   
            <div style="display: none;" id="level4">
            <select id="category4" name="category4" class="levels" onChange="chooseCateg(this.form, 4)">
            </select>
            </div>
   
            <div style="display: none;" id="level5">
            <select id="category5" name="category5" class="levels" onChange="chooseCateg(this.form, 5)">
            </select>
      <input type="hidden" name="category" id="category" />
            </div>
    *}
   
    <br/><br/>
   
    <div class="buttons"><strong><input type="submit" name="Choose_categ" id="Choose_categ" value="{$lng.listings.next_step}" /></strong></div>
    <div class="clearfix"></div>
   
    </form>
    </div>
    </div> {* end form_container *}
    {/if} {* end step1 *}

Thank you for your help

The whole code is below, followed by the part that isn't producing.  It all works extremely well until the last part, and I have two instances of setting a variable to mysql_fetch_assoc that work.  Not sure why the third attempt doesn't.  I'm just trying to have a separate area that outputs 'msg'.

Code: [Select]

$sql = "SELECT * FROM players as p
INNER JOIN schools as s
WHERE p.tid = s.id
ORDER BY status, playerLast";

$results = mysql_query($sql);



echo '<div class="roster">';

$team = mysql_fetch_assoc($results);

echo '<div class="team_info">
<div class="school">' . $team['school'] . '</div>
<div class="coach">Coach ' .$team['coachFirst'] . ' ' . $team['coachLast'] .'</div>
<div>Sectional: ' . $team['sectional'] . '</div>
<div>Class: ' . $team['class'] . 'A</div>
';

echo '</div>';


  $currentStatus = false;  //Flag to detect change in status
    while($player = mysql_fetch_assoc($results))
    {


        if($currentStatus != $player['status'])
        {
            //Status has changed, display status header
            $currentStatus = $player['status'];
echo '<br><b>';
if ($currentStatus == '1')  {echo 'Returning Starters';}
elseif ($currentStatus == '2')  {echo 'Key Returners';}
elseif ($currentStatus == '3')  {echo 'Varsity Newcomers';}
elseif ($currentStatus == '4')  {echo 'Key Freshmen';}
echo '</b><br>';
           // echo "<div><b>{$currentStatus}</b></div>\n";
        }
        //Display player info
        echo $player['playerFirst'] . ' ' . $player['playerLast'] . ', ' . $player['feet'] . '\'' . $player['inches'] . '",' . $player['position'] . ', ' . $player['year'] . ';<br>';
 
    }

        //Player comments
echo '<hr>';
echo '<div class="coach_comments"><span class="player_name">hello';

while($comments = mysql_fetch_assoc($results)) {


echo $comments['playerFisrt'] . ' ' . $comments['playerLast'] . ':  </span>' . $comments['msg'];
}
echo '</div>';
echo '</div>';



It's all working until what's below.  All I get out of it is the "hello", which is just a test to make sure it wasn't a CSS issue.

Quote


        //Player comments
   echo '<hr>';
   echo '<div class="coach_comments"><span class="player_name">hello';
   
   while($comments = mysql_fetch_assoc($results)) {

      
      echo $comments['playerFisrt'] . ' ' . $comments['playerLast'] . ':  </span>' . $comments['msg'];
   }
echo '</div>';
echo '</div>';

Is there a way where I can have one form submit to multiple phps depending on which button is clicked?

For example if I have:

Code: [Select]
<FORM action="http://localhost/smatrix/phptest/phpcode1.php" name=optionsform METHOD="POST">
<input type="checkbox" name="criteria[]" value="box1">
<input type="checkbox" name="criteria[]" value="box2">

<INPUT TYPE=SUBMIT VALUE="php1" >
<INPUT TYPE=SUBMIT VALUE="php2" >
</form>
Now the other php would be "http://localhost/smatrix/phptest/phpcode2.php" and that is accessed if button "php2" is clicked. Is there any way to do this without using 2 seperate forms? If statements?

Hello, i'm trying to create a table with questions and input answers. The problem i'm facing is how can i generate dynamically the input name and value unique because some questions have other dates or criteria. I was thinking of adding in the db a field with the type of the question or a new table with question types then using foreach and if to generate, i don't have much time to test and i'm asking for your help/advise. Hope i was clear enough . PS: I'm using PEAR SIGMA as template.
Code: [Select]
<table class="tablesorter" border="0" cellspacing="1" cellpadding="0">
        <thead>
          <tr>
            <th align="center"><span>&nbsp;</span></th>
            <th align="center"><span>2005 - 2006</span></th>
            <th align="center"><span>2006 - 2007</span></th>
            <th align="center"><span>2007 - 2008</span></th>
            <th align="center"><span>2008 - 2009</span></th>
            <th align="center"><span>2009 - 2010</span></th>
          </tr>
        </thead>
        <tbody>
          <tr>
            <td align="center"><span>preparator</span></td>
            <td align="center"><input type="text" name="pi11_preparator_0506" value="{pi11_preparator_0506}" /></td>
            <td align="center"><input type="text" name="pi11_preparator_0607" value="{pi11_preparator_0607}" /></td>
            <td align="center"><input type="text" name="pi11_preparator_0708" value="{pi11_preparator_0708}" /></td>
            <td align="center"><input type="text" name="pi11_preparator_0809" value="{pi11_preparator_0809}" /></td>
            <td align="center"><input type="text" name="pi11_preparator_0910" value="{pi11_preparator_0910}" /></td>
          </tr>
          <tr>
            <td align="center"><span>asistent</span></td>
            <td align="center"><input type="text" name="pi11_asistent_0506" value="{pi11_asistent_0506}" /></td>
            <td align="center"><input type="text" name="pi11_asistent_0607" value="{pi11_asistent_0607}" /></td>
            <td align="center"><input type="text" name="pi11_asistent_0708" value="{pi11_asistent_0708}" /></td>
            <td align="center"><input type="text" name="pi11_asistent_0809" value="{pi11_asistent_0809}" /></td>
            <td align="center"><input type="text" name="pi11_asistent_0910" value="{pi11_asistent_0910}" /></td>
          </tr>
          <tr>
            <td align="center"><span>lector/șef de lucrări</span></td>
            <td align="center"><input type="text" name="pi11_lector_0506" value="{pi11_lector_0506}" /></td>
            <td align="center"><input type="text" name="pi11_lector_0607" value="{pi11_lector_0607}" /></td>
            <td align="center"><input type="text" name="pi11_lector_0708" value="{pi11_lector_0708}" /></td>
            <td align="center"><input type="text" name="pi11_lector_0809" value="{pi11_lector_0809}" /></td>
            <td align="center"><input type="text" name="pi11_lector_0910" value="{pi11_lector_0910}" /></td>
          </tr>
          <tr>
            <td align="center"><span>conferențiar</span></td>
            <td align="center"><input type="text" name="pi11_conferentiar_0506" value="{pi11_conferentiar_0506}" /></td>
            <td align="center"><input type="text" name="pi11_conferentiar_0607" value="{pi11_conferentiar_0607}" /></td>
            <td align="center"><input type="text" name="pi11_conferentiar_0708" value="{pi11_conferentiar_0708}" /></td>
            <td align="center"><input type="text" name="pi11_conferentiar_0809" value="{pi11_conferentiar_0809}" /></td>
            <td align="center"><input type="text" name="pi11_conferentiar_0910" value="{pi11_conferentiar_0910}" /></td>
          </tr>
          <tr>
            <td align="center"><span>profesor</span></td>
            <td align="center"><input type="text" name="pi11_profesor_0506" value="{pi11_profesor_0506}" /></td>
            <td align="center"><input type="text" name="pi11_profesor_0607" value="{pi11_profesor_0607}" /></td>
            <td align="center"><input type="text" name="pi11_profesor_0708" value="{pi11_profesor_0708}" /></td>
            <td align="center"><input type="text" name="pi11_profesor_0909" value="{pi11_profesor_0909}" /></td>
            <td align="center"><input type="text" name="pi11_profesor_0910" value="{pi11_profesor_0910}" /></td>
          </tr>
        </tbody>
      </table>