PHP - Please Help - Select Db Where Field Is An Array And Loop Table? How?

Hi all, probably a fairly straightforward question, but I can't find the answer I'm looking for:

I have an array 'idents' that contains ID numbers. I now want to write a MySQL query that selects all values of the table-field 'email' where the field 'ID' = any of the IDs stored in 'idents'. Then I want to put those emails in an array 'emails'.

So e.g. my table is as follows:
ID         |   email
----------------------
111111 |   email1
222222 |   email2
333333 |   email3
444444 |   email4
555555 |   email5
666666 |   email6

and the array 'idents' is as follows: '111111','444444','555555'

then I want the query to return 'emails' = array('email1','email4','email5');

Thanks for your help!

I have an array of data in which I want to display in a table with the first row of data to not be formatted. In the second row of data, I want it formatted with the CSS class of "success". When I run this code, I do not get any formatting of any rows in the table. I have tried various different options without success. Any help would be greatly appreciated.

 

<?php
$counter = 0;
      while($row = mysql_fetch_array($query)) {
           if($counter % 2 == 0) {
                 //output data from each row of data with no class of "success"
                 echo "<tr class='text-left'>";
                       if (empty($row[endDate])) {
                          echo "<td>".$row[startDate]."</td>";  /* only one date */
                          } else {
                                echo "<td>".$row[startDate].'-'.$row[endDate]."</td>";  /*date range */
                           }
                 echo "<td>".$row[rideName]."</td>";
                 echo "<td>".$row[rideDesc]."</td>";
                 echo "<td>".$row[location]."</td>";
                 echo "<td><a href='".$row[link]."'>".$row[source]."</a></th>";
                 echo "</tr>";
                $counter++;
           } else {
                           //output data from each row
                 echo "<tr class='text-left success'>";
                                            if (empty($row[endDate])) {
                                                echo "<td>".$row[startDate]."</td>";
                                            } else {
                                                echo "<td>".$row[startDate].'-'.$row[endDate]."</td>";
                                            }
                 echo "<td>".$row[rideName]."</td>";
                 echo "<td>".$row[rideDesc]."</td>";
                 echo "<td>".$row[location]."</td>";
                 echo "<td><a href='".$row[link]."'>".$row[source]."</a></th>";
                 echo "</tr>";    
                $counter++;
           } /* end if else */
      } /* end while */
?>

Edited January 12, 2020 by Wal-Wal-2
Copied wrong set of code

First page adds a new job number, then the order page loaded with the job number id as a get id. Basically there is a while loop in the order page which shows products/services client can order and he chooses what he requires 'one or eight services' (8 in total) and some other variables like date of order and client name etc. Here is the order item code

The first sql statement executes fine, but in the second sql query nothing happens


$sql="insert into job_order(order_num,order_date,order_customer_id, order_remarks) values(".$_GET['id'].",NOW(),".$_POST['companyBox'].",'".$_POST['remarkBox']."');"; $res=mysql_query($sql);  $id=mysql_insert_id();   foreach($_POST as $key => $value) {          if(!empty($value)) {           $key.' => '.trim(strip_tags($value));            $order="INSERT INTO orderprod (order_num,prod_id,order_amount,teeth_amount) VALUES ('$_GET[id]','$value','$value','$value');"; $orderres=mysql_query($order) or die(mysql_error()); } }?>$sql="insert into job_order(order_num,order_date,order_customer_id,
order_remarks)
values(".$_GET['id'].",NOW(),".$_POST['companyBox'].",'".$_POST['remarkBox']."');";
$res=mysql_query($sql);

$id=mysql_insert_id();


foreach($_POST as $key => $value) {


        if(!empty($value)) { 
 
         $key.' => '.trim(strip_tags($value));  
     
         $order="INSERT INTO orderprod (order_num,prod_id,order_amount,teeth_amount) VALUES
('$_GET[id]','$value','$value','$value');";
$orderres=mysql_query($order) or die(mysql_error());
}
}
?>



=============

This is the formI have removed parts which are irrelevant. Please note that dateBox and companyBox are not required to be looping as they are only for first table,



echo "<form action=".$config_basedir."./vieworder.php?id=".$_GET['id']."  name=form1 method=post>";?><table><tr><td><h4>JOB ORDER</H4></TD><TD></TD></TR><TR><TD>ORDER NUMBER</TD><TD><?PHP ECHO $_GET['id'] ?></td></tr><tr><td>ORDER DATE</td><td><input type=text name=dateBox></td></tr> <tr><td>COMPANY NAME</td><td><?PHP$sql="select * from customers";$res=mysql_query($sql);echo "<select name=companyBox><option value=''>Please select</option>";WHILE($fetch=mysql_fetch_assoc($res)){ echo "<option value='".$fetch['id']."'>".$fetch['cust_name']."</option>";} echo "</select>"; echo "</td></tr>"; ?>   </table> <table><tr><th>ITEM</th><th>QUANTITY</th><th>N0. of Teeths</th></tr><tr><?PHP$sql="select * from products";$res=mysql_query($sql); WHILE($fetch=mysql_fetch_assoc($res)){ echo "<td><input type=text name=desBox value='".$fetch['prod_id']."'>".$fetch['prod_name']."</td><td><input type=text name=quantBox></td><td><input type=text name=teethBox></td>";echo "</tr>";}echo "</table>";?>echo "<form action=".$config_basedir."./vieworder.php?id=".$_GET['id']."  name=form1 method=post>";
?>
<table>
<tr>
<td><h4>JOB ORDER</H4></TD><TD></TD>
</TR>
<TR>
<TD>ORDER NUMBER</TD><TD><?PHP ECHO $_GET['id'] ?></td>
</tr>
<tr>
<td>ORDER DATE</td><td><input type=text name=dateBox></td>
</tr>

<tr>
<td>COMPANY NAME</td><td>
<?PHP
$sql="select * from customers";
$res=mysql_query($sql);
echo "<select name=companyBox><option value=''>Please select</option>";
WHILE($fetch=mysql_fetch_assoc($res)){

echo "<option value='".$fetch['id']."'>".$fetch['cust_name']."</option>";}
echo "</select>";
echo "</td></tr>";
?>



</table>

<table>
<tr>
<th>ITEM</th><th>QUANTITY</th><th>N0. of Teeths</th>
</tr>
<tr>
<?PHP
$sql="select * from products";
$res=mysql_query($sql);

WHILE($fetch=mysql_fetch_assoc($res)){

echo "<td><input type=text name=desBox value='".$fetch['prod_id']."'>".$fetch['prod_name']."</td>
<td><input type=text name=quantBox></td>
<td><input type=text name=teethBox></td>";
echo "</tr>";}
echo "</table>";
?>



HERE IS THE IMAGE showing the populated services.
http://dubads.com/images/order.jpg

Now I am stumped this is far any help would be awesome

This is what I have gotten so far, this is what it does right now is display the first column of the array as a header for each foreach loop then i've got the data displayed under each header in the loop but what i am trying to understand here is i am trying to get under each header it to have 4 columns or a number of my choosing. Heres an example of what i am trying to do.

A airlie beach Andergrove Alexandra Armstrong Beach Alligator Creek B Bucasia Blacks Beach Beaconsfield Bakers Creek Balberra Bloomsbury Breadalbane Ball Bay Belmunda
This is an example of how it is being displayed right now

A
Airlie Beach   Andergrove   Alexandra   Armstrong Beach   Alligator Creek
B
Bucasia   Blacks Beach   Beaconsfield   Bakers Creek   Balberra   Bloomsbury   Breadalbane   Ball Bay   Belmunda
C
Cannonvale   Calen   Crystal Brook   Cremorne   Chelona   Campwin Beach   Cape Hillsborough   Conway
Heres The Code i have so far.

Code: [Select]
<?php
$file = "widget.csv";
@$fp = fopen($file, "r") or die("Could not open file for reading");
$outputArray = array();
while(($shop = fgetcsv($fp, 1000, ",")) !== FALSE)
{
    $outputArray[array_shift($shop)] =  array_filter($shop);
}
print_r($outputArray);
echo "\n<br />";
//display
echo "<table>";
foreach ($outputArray as $alphabetical=>$value){
echo "<th><b>" . $alphabetical ."</b></th>";
echo "<tr>";
foreach ($value as $key){
echo "<td>" . $key . "</td>";

}
echo "</tr>";
}
echo "</table>";

echo "\n<br />";

?>
Heres my Csv File which i am using as an array in the code

Quote

A,Airlie Beach,Andergrove,Alexandra,Armstrong Beach,Alligator Creek,,,,,,,,,,,,,,
B,Bucasia,Blacks Beach,Beaconsfield,Bakers Creek,Balberra,Bloomsbury,Breadalbane,Ball Bay,Belmunda,,,,,,,,,,
C,Cannonvale,Calen,Crystal Brook,Cremorne,Chelona,Campwin Beach,Cape Hillsborough,Conway,,,,,,,,,,,
D,Dows Creek,Dumbleton,Dolphin Heads,,,,,,,,,,,,,,,,
E,Eimeo,Eton,Erakala,,,,,,,,,,,,,,,,
F,Foulden,Foxdale,Flametree,Farleigh,Freshwater Point,,,,,,,,,,,,,,
G,Glen Isla,Glenella,,,,,,,,,,,,,,,,,
H,Homebush,Hampden,,,,,,,,,,,,,,,,,
I,,,,,,,,,,,,,,,,,,,
J,Jubilee Pocket,,,,,,,,,,,,,,,,,,
K,Kinchant Dam,Kolijo,Koumala,Kuttabul,,,,,,,,,,,,,,,
L,Laguna Quays,,,,,,,,,,,,,,,,,,
M,McEwens Beach,Mackay,Mackay Harbour,Mandalay,Marian,Mia Mia,Middlemount,Midge Point,Mirani,Moranbah,Mount Charlton,Mount Jukes,Mount Julian,Mount Marlow,Mount Martin,Mount Ossa,Mount Pelion,Mount Pleasant,Mount Rooper
N,Narpi,Nebo,Nindaroo,North Eton,,,,,,,,,,,,,,,
O,Oakenden,Ooralea,,,,,,,,,,,,,,,,,
P,Palmyra,Paget,Pindi Pindi,Pinevale,Pioneer Valley,Pleystowe,Preston,Proserpine,,,,,,,,,,,
Q,,,,,,,,,,,,,,,,,,,
R,Racecourse,Richmond,Riordanvale,Rosella,Rural View,,,,,,,,,,,,,,
S,St Helens Beach,Sandiford,Sarina,Seaforth,Slade Point,Shoal Point,Shute Harbour,Shutehaven,Strathdickie,Sugarloaf,Sunnyside,,,,,,,,
T,Te Kowai,The Leap,,,,,,,,,,,,,,,,,
U,,,,,,,,,,,,,,,,,,,
V,Victoria Plains,,,,,,,,,,,,,,,,,,
W,Wagoora,Walkerston,Woodwark,,,,,,,,,,,,,,,,
X,,,,,,,,,,,,,,,,,,,
Y,Yalboroo,,,,,,,,,,,,,,,,,,
Z,,,,,,,,,,,,,,,,,,,

Now I am stumped this is far any help would be awesome

This is what I have gotten so far, this is what it does right now is display each Header above each bit of data and spans across 5 columns for each foreach loop but what i am trying to understand here is i am trying to get the header then the data then another header and data and so on but only about 4 or number of my choosing grouped header/data but select how many are in each column up to 5 columns. Heres an example of what i am trying to do.

A D K N S AlexandraHeadlands DickyBeach KingsBeach Nambour SandstonePoint Aroona Diddillibah KielMountain Ninderry ShellyBeach Doonan KundaPark NoosaHeads SippyDowns B Dulong Kuluin Ningi SunriseBeach Beachmere DeceptionBay Kilcoy NorthArm SunshineBeach BanksiaBeach Noosaville Scarborough Beerburrum E L Beerwah EerwahVale Landsborough O T Bellara Elimbah Tanawha Bellmere Eudlo M P TowenMountain Birtinya Eumundi Maleny Petrie Tewantin Bongaree Mapleton Palmview TwinWaters Bokarina F Marcoola Palmwoods BribieIslandArea Flaxton MarcusBeach Parklands U Buddina ForestGlen MaroochyRiver Parrearra UpperCaboolture Burnside Maroochydore PeregianBeach Buderim G Minyama Pinbarren V Burpengary GlassHouseMountains MoffatBeach PointArkwright Valdora BliBli Mons PelicanWaters H Montville PacificParadise W C Highworth Mooloolaba WeybaDowns CoolumBeach Hunchy Mooloolah Q Warana Caboolture MountainCreek WestWoombye CabooltureSouth I MountCoolum R Woombye Caloundra ImageFlat Morayfield Rosemount Woorim CastawaysBeach Mudjimba Redcliffe WamuranBasin Chevallum J Woodford CoesCreek WoodyPoint Cooroy Wamuran Currimundi Wurtulla X Y YandinaCreek Yandina Z


This is an example of how it is being displayed right now

A
Airlie Beach   Andergrove   Alexandra   Armstrong Beach
Alligator Creek
B
Bucasia   Blacks Beach   Beaconsfield   Bakers Creek   
Balberra   Bloomsbury   Breadalbane   Ball Bay   Belmunda
C
Cannonvale   Calen   Crystal Brook   Cremorne   
Chelona   Campwin Beach   Cape Hillsborough   
Conway



Heres The Code i have so far.


Code: [Select]
<?php
  $file = "widget.csv";
@$fp = fopen($file, "r") or die("Could not open file for reading");
$outputArray = array();
$count = 0;

while(($shop = fgetcsv($fp, 1000, ",")) !== FALSE)
{
    $outputArray[array_shift($shop)] =  array_filter($shop);
}

echo "<table>";
foreach ($outputArray as $alphabetical=>$value){
    echo "<th colspan='4'><b>" . $alphabetical ."</b></th>";
    echo "<tr>";
foreach ($value as $key){
$afterkey=preg_replace('/\s+/','-',$key);
    if ($count == 4){
    echo '</tr><tr><td><a href="map.php?mapaddress='.$afterkey.'-qld&mapname='.$key.'">'.$key.'</a></td>';
    $count = 0;
    }else{
    echo '<td><a href="map.php?mapaddress='.$afterkey.'-qld&mapname='.$key.'">'.$key.'</a></td>';
    }
$count++;    
}
    echo "</tr>";
$count = 0;
}
    echo "</table>";

    echo "\n<br />";

?>


Heres my CSV File:


Quote

A,Airlie Beach,Andergrove,Alexandra,Armstrong Beach,Alligator Creek,,,,,,,,,,,,,,
B,Bucasia,Blacks Beach,Beaconsfield,Bakers Creek,Balberra,Bloomsbury,Breadalbane,Ball Bay,Belmunda,,,,,,,,,,
C,Cannonvale,Calen,Crystal Brook,Cremorne,Chelona,Campwin Beach,Cape Hillsborough,Conway,,,,,,,,,,,
D,Dows Creek,Dumbleton,Dolphin Heads,,,,,,,,,,,,,,,,
E,Eimeo,Eton,Erakala,,,,,,,,,,,,,,,,
F,Foulden,Foxdale,Flametree,Farleigh,Freshwater Point,,,,,,,,,,,,,,
G,Glen Isla,Glenella,,,,,,,,,,,,,,,,,
H,Homebush,Hampden,,,,,,,,,,,,,,,,,
I,,,,,,,,,,,,,,,,,,,
J,Jubilee Pocket,,,,,,,,,,,,,,,,,,
K,Kinchant Dam,Kolijo,Koumala,Kuttabul,,,,,,,,,,,,,,,
L,Laguna Quays,,,,,,,,,,,,,,,,,,
M,McEwens Beach,Mackay,Mackay Harbour,Mandalay,Marian,Mia Mia,Middlemount,Midge Point,Mirani,Moranbah,Mount Charlton,Mount Jukes,Mount Julian,Mount Marlow,Mount Martin,Mount Ossa,Mount Pelion,Mount Pleasant,Mount Rooper
N,Narpi,Nebo,Nindaroo,North Eton,,,,,,,,,,,,,,,
O,Oakenden,Ooralea,,,,,,,,,,,,,,,,,
P,Palmyra,Paget,Pindi Pindi,Pinevale,Pioneer Valley,Pleystowe,Preston,Proserpine,,,,,,,,,,,
Q,,,,,,,,,,,,,,,,,,,
R,Racecourse,Richmond,Riordanvale,Rosella,Rural View,,,,,,,,,,,,,,
S,St Helens Beach,Sandiford,Sarina,Seaforth,Slade Point,Shoal Point,Shute Harbour,Shutehaven,Strathdickie,Sugarloaf,Sunnyside,,,,,,,,
T,Te Kowai,The Leap,,,,,,,,,,,,,,,,,
U,,,,,,,,,,,,,,,,,,,
V,Victoria Plains,,,,,,,,,,,,,,,,,,
W,Wagoora,Walkerston,Woodwark,,,,,,,,,,,,,,,,
X,,,,,,,,,,,,,,,,,,,
Y,Yalboroo,,,,,,,,,,,,,,,,,,
Z,,,,,,,,,,,,,,,,,,,

Code: [Select]
$new_array2=array_diff($my_array,$itemIds);

$updatedb = mysql_query("UPDATE content_type_ads SET field_expire_value = '666' WHERE $new_array2 = field_item_id_value");
"$new_array2" has only 12 digit numbers for each item in the array, and I want to match them to the "field_item_id_value" field in the table, updating the "field_expire_value" field for the record where they match.  I know I am close because the UPDATE code works before I add the WHERE statement (it of course adds '666' to EVERY field, but for a noobie it's a start!).

Hi,
I'm developing an app using flash AS2 as the front end via PHP and a mySQL database at the backend on my server.

what i'm looking to do is update/insert into a table called 'cards' and at the same time update/insert into another table called 'jingle'. There is a field called 'cardID' in jingle that should be the same as the ID number created in 'cards' thus creating a link between entries in the different tables that can be called up as i choose.

hope i've been clear i just wouldn't know where to start any help would be appreciated.

MySQL client version: 5.0.91
PHPmyAdmin Version information: 3.2.4


thanks in advance

Hi.  I have two select fields one called category and the other sub category.  Both are in the format.
<select name="category" value="

<?php $qGetCat = "SELECT * FROM club_category" ;

$rGetCat = mysql_query($qGetCat);

while ($Cat = mysql_fetch_assoc($rGetCat))

{

?>" />
                                <option value="<?php echo $Cat['categorys'];?>"><?php echo $Cat['categorys']; ?></option>
                                <?php } ?>
                                </select>
<select name="sub_category" value="

<?php $qGetSubCat = "SELECT * FROM sub_categorys" ;

$rGetSubCat = mysql_query($qGetSubCat);

while ($SubCat = mysql_fetch_assoc($rGetSubCat))

{

?>" />
                                <option value="<?php echo $SubCat['sub_categorys'];?>"><?php echo $SubCat['sub_categorys']; ?></option>
                                <?php } ?>
                                </select>


Now I want to make it so that when a particular category is chosen for example self defence.  The sub category when clicked shows all the self defence stuff.  If watersports was chosen sub category would show things like swimming.  What do I need to look up to do this? At the minute there is no link the way I have coded these to fields.

In the database its self there is a;

category table with categoryID and category_name

sub category table with sub_cat_name and categoryID

I think this will work but I have never done this so its making my head hurt just thinking about it.  Does anyone have any advice, tuts or scripts to do this? 

Thank you

Hello.

I am trying to display only one instance of records that have the same memberid in my db. I am using the following statement but it continues to show all of the records that have the same memberid. Any ideas what I may be doing wrong?

Code: [Select]
$sql = "select DISTINCT memberid, event, category, date, enddate, locality, location, address, city, state, zip, contact, phone, notes, doc1, doc2, doc3, doc4, doc5 from event where date >= '$datenow' ORDER by date ASC";
Thanks for any help!

Hi Guys,

Can someone please help me before I kill myself!

I have a table holding details of images to be displayed in a gallery.
The table has columns as 'id', 'image_caption', 'file_path', and 'userid'.

The 'id' column is the unique key, and the 'userid' column is obviously id of the user who uploaded the image.

What I would like to do is select and display one image from each unique userid and then display each image along with the details in my gallery. It doesn't really matter which users image is selected aslong as there is only one for each unique user.

I have been trying a number of ways to do this (DISTINCT / subqueries) but I just cant get anything to work.
Could someone please advise me on how I could get this to work.

Cheers in advance.

Can anybody clarify the usefulness of "AS" and elaborate on how it operates.

If I select a 'bananas' AS 'yeelow fruit' will it change the TITLE in the table?  Or the table that is being viewed?
If I dump a list of 'FRUITS' into and HTML table, will using AS rename each column for me, or is that handled by MY coing of the HTML table?

Hello, i am trying to get my form to list usernames ascending as an option, but the select field just returns blank.

Here is my code:

Code: [Select]
/**
 * editUserForm - Displays the users database table in
 * a nicely formatted field table.
 */

function editUserForm(){
   $q = "SELECT * "
       ."FROM ".TBL_USERS." ORDER BY username ASC";
   $result = $database->query($q);

while ($row = mysql_fetch_assoc($result))
{
echo '<option value="'.$row["username"].'">'.$row["username"].'</option>';
}
}

Code: [Select]
              <form action="/" method="post">

                <div class="column">
                  <p>
                    <select name="user" id="user" placeholder="Select A User To Edit" class="{validate:{required:true}}">
                      <option>Select A User To Edit</option>
                      <? editUserForm(); ?>
                    </select>
                  </p>

                <div class="action_bar">
                  <input type="submit" class="button blue" value="Submit Post" />
                  <a href="#modal" class="modal button">Cancel</a>
                </div>

              </form>

All help is appreciated

I want to select the user from super_administrators, administrators, teachers and students, and give the user permission based from what table he "came". But is giving the "Query failed" error...

Code: [Select]
<?php

//Start session

session_start();



//Include database connection details

require_once('../config/config.php');



//Array to store validation errors

$errmsg_arr = array();



//Validation error flag

$errflag = false;



//Connect to mysql server

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

if(!$link) {

die('Failed to connect to server: ' . mysql_error());

}



//Select database

$db = mysql_select_db(DB_DATABASE);

if(!$db) {

die("Unable to select database");

}



//Function to sanitize values received from the form. Prevents SQL injection

function clean($str) {



$str = @trim($str);



if(get_magic_quotes_gpc()) {

$str = stripslashes($str);

}



return mysql_real_escape_string($str);

}



//Sanitize the POST values

$email = clean($_POST['email']);

$password = clean($_POST['password']);



//Input Validations

if($email == '') {

$errmsg_arr[] = 'O campo Email nao foi preenchido.';

$errflag = true;

}



if($password == '') {

$errmsg_arr[] = 'O campo Senha nao foi preenchido.';

$errflag = true;

}



//If there are input validations, redirect back to the login form

if($errflag) {

$_SESSION['ERRMSG_ARR'] = $errmsg_arr;

session_write_close();

header("location: ../index.php");

exit();

}



//Create query

$qry = "SELECT * FROM super_administrators,administrators,teachers,students WHERE email = '$email' AND passwd = '".md5($_POST['password'])."'";

$result = mysql_query($qry);

$member = mysql_fetch_assoc($result);

$table = mysql_field_table('$result', '0');



//Check whether the query was successful or not



if($result) {



if(mysql_num_rows($result) == 1) {



if($table == 'super_administrators')  {

session_regenerate_id();

$_SESSION['SESS_ID'] = $member['id'];

$_SESSION['SESS_NAME'] = $member['name'];

$_SESSION['SESS_EMAIL'] = $member['email'];

session_write_close();

header("location: ../users/sadmin/index.php");

exit();

}



if($table == 'administrators')  {

session_regenerate_id();

$_SESSION['SESS_ID'] = $member['id'];

$_SESSION['SESS_SCHOOL_ID'] = $member['school_id'];

$_SESSION['SESS_NAME'] = $member['name'];

$_SESSION['SESS_EMAIL'] = $member['email'];

session_write_close();

header("location: ../users/admin/index.php");

exit();

}



if($table == 'teachers')  {

session_regenerate_id();

$_SESSION['SESS_ID'] = $member['id'];

$_SESSION['SESS_SCHOOL_ID'] = $member['school_id'];

$_SESSION['SESS_NAME'] = $member['name'];

$_SESSION['SESS_EMAIL'] = $member['email'];

session_write_close();

header("location: ../users/prof/index.php");

exit();

}



if($table == 'students')  {

session_regenerate_id();

$_SESSION['SESS_ID'] = $member['id'];

$_SESSION['SESS_SCHOOL_ID'] = $member['school_id'];

$_SESSION['SESS_CLASS_ID'] = $member['class_id'];

$_SESSION['SESS_NAME'] = $member['name'];

$_SESSION['SESS_REGISTRATION'] = $member['registration'];

$_SESSION['SESS_EMAIL'] = $member['email'];

session_write_close();

header("location: ../users/aluno/index.php");

exit();

}



} else {



$errmsg_arr[] = 'Suas informacoes de login estao incorreta. Por favor, tente novamente.';

$errflag = true;

$_SESSION['ERRMSG_ARR'] = $errmsg_arr;

session_write_close();

header("location: ../index.php");

exit();

}



} else {

die("Query failed");

}

?>

I created a drop-down menu using a MySQL statement in php for a form.
My drop down menu works fine, but I want to assign a default value to it (normal text) the value will never change,
thus I do not need to extract the default value from the table, I already know the value.

Here is the basic snippet from the script:

<?php
   include("../includes/xxx.php");
   $cxn = mysqli_connect($host,$user,$password,$dbname);
   $query = "SELECT DISTINCT `plant_id` FROM `plant` ORDER BY `plant_id`";
   $result = mysqli_query($cxn,$query);
      while($row = mysqli_fetch_assoc($result))
      {
      extract($row);
      echo "<option value='$plant_id'>$plant_id</option>\n";
      }
?>

Hi guys,
sorry...i'm a newbiiii and actually not that firm with php.
i create some formualrs using while loop.
the forms and input fields receives their names including a variable out of the database.

by submitting to another page almost all values are transmitted except the value of the select field.

I'm acutally using that ( it's just a shortcut ):

 

<form id='contact-form".$KitchConfigID."' name='contact-form".$KitchConfigID."' action='_pages/_kitchenconfig/adm_saveKitchConfig.php?Nav=".$NavHash."&kcid=".$KitchConfigID."' method='POST'>
  
  <div class='row'>

    <div class='col-sm-12'>
      <div class='md-form mb-0 form-sm'>
        <input value='".$KitchConfig."' type='text' id='configname".$KitchConfigID."' name='configname".$KitchConfigID ."' class='form-control'>
        <label for='configname".$KitchConfigID ."' class=''>Config Name:</label>
      </div>
    </div>

  </div>

  <div class='row'>
    <div class='col-sm-12'>
      <div class='md-form mb-0 form-sm'>
        <select id='designer_".$KitchConfigID."' name='designer_".$KitchConfigID."' class='mdb-select md-form' searchable='Search here..' onchange='changeInput(this.value, ".$SelField.");'>");
          $designersql = "SELECT * FROM `tbl_contacts` ORDER BY `FirstName`";
          $resultdesigner = $conn->query($designersql);

          if ($resultdesigner->num_rows > 0) {
          $resultdesigner->MoveFirst;
          echo("<option value='designer_".$KitchConfigID."'></option>");
          while($rowdesigner = $resultdesigner->fetch_assoc()) {
          $DesignerName = $rowdesigner["FirstName"]." ".$rowdesigner["LastName"];
          $DesignerID = $rowdesigner["ContactID"];
          if($rowdesigner["ContactID"]==$rowkitch["Designer"]){
          echo("<option value='".$DesignerID."' selected='selected'>".$DesignerName."</option>");
          }
          else {
          echo("<option value='".$DesignerID."'>".$DesignerName."</option>");
          }
          }
          }
          echo("</select>
        <input type='text' name='".$SelField."' value='' />
        <label for='designer_".$KitchConfigID."' class=''>Designer:</label>
      </div>
    </div>
  </div>
  
  
  <div class='md-form mb-0 float-right'>
    <button type='submit' class='btn btn-outline-danger waves-effect btn-sm float-right'>Save <i class='fas fa-magic ml-1'></i></button>
  </div>

For the Output i use:
 

    $upd_KitchConfigID = $_GET["kcid"];
    if(isset($_POST["configname$upd_KitchConfigID"]))
        {
           $upd_KitchConfig = $_POST["configname$upd_KitchConfigID"];
        }
        else
        {
            $upd_KitchConfig = 'NotSet';
            $ErrMsg = $ErrMsg . 'No KitchConfig, ';
        }
    
    if(isset($_POST["designer$upd_KitchConfigID"]))
        {
           $upd_KitchConfigDesigner = $_POST["designer_$upd_KitchConfigID"];
        }
        else
        {
            $upd_KitchConfigDesigner = 1;
            $ErrMsg = $ErrMsg . 'No Designer, ';
        }

echo("designer_$upd_KitchConfigID: ".$_POST["designer_$upd_KitchConfigID"]."<br><br>");

The value of ConfigName is well....BUT
for Designer i receive "Undefined index: designer..."

and i do not know why.
I'm shure it's a mistake by my stupid coding...but i can't find the error.

Maybe anybody of you guys can help me out?
thnx in advance!!!

BR,
Max