PHP - Option Chosen Disappears!!

I have a form where there are various fields one can edit and replace images as well. The problem is when one tries to replace the image they choose. It only replaces the path of the file on column "imageurl1" on the MySQL database and not on the one that was chosen. I'm also getting a "Invalid argument supplied for foreach()"

Here is the script

Code: [Select]
<?php
session_start();
include('SimpleImage.php');
$image = new SimpleImage();    
//error_reporting(E_ALL); 


// image upload folder
    $image_folder = 'images/classified/'; 
// fieldnames in form
$all_file_fields = array('image1', 'image2' ,'image3', 'image4', 'image5', 'image6', 'image7', 'image8', 'image9', 'image10', 'image11', 'image12');
// allowed filetypes
$file_types = array('jpg','gif','png');
// max filesize 5mb
$max_size = 5000000;
//echo'<pre>';print_r($_FILES);exit;

$time = time();
$count = 1;

foreach($all_file_fields as $fieldname){ 
if($_FILES[$fieldname]['name'] != ''){

$type = substr($_FILES[$fieldname]['name'], -3, 3);

// check filetype
if(in_array(strtolower($type), $file_types)){

//check filesize
if($_FILES[$fieldname]['size']>$max_size){
$error = "File too big. Max filesize is ".$max_size." MB";

}else{

// new filename
$filename = str_replace(' ','',$myusername).'_'.$time.'_'.$count.'.'.$type;

// move/upload file
$image->load($_FILES[$fieldname]['tmp_name']);
if($image->getWidth() > 150) { //if the image is larger that 150.
$image->resizeToWidth(500); //resize to 500.
}
$target_path = $image_folder.basename($filename); //image path.

$image->save($target_path); //save image to a directory.

//save array with filenames
$images[$count] = $image_folder.$filename;
$count = $count+1;

}//end if

}else{ $error = "Please use jpg, gif, png files";

}//end if
}//end if
}//end foreach



if($error != ''){ echo $error;
}else{
//error_reporting(E_ALL);
//ini_set('display_errors','On');

$id = $_POST['id'];
$id = substr($id, 0,5);
if($id < 1 || $id > 99999) exit;

  $servername = "localhost";
  $username = "";
  $password = "";

if(!$_POST["title"] || !$_POST["rent"] || !$_POST["fees"]){
header('location: fields.php');

}else if (!(preg_match('#^\d+(\.(\d{2}))?$#',($_POST["rent"])))){
header('location: rent.php');

}else{
$conn =  mysql_connect($servername,$username,$password)or die(mysql_error());
mysql_select_db("apts",$conn);

// validate id belongs to user
$sql_check = "SELECT * FROM apts WHERE id = '".$id."' AND username = '".$myusername."'";
$res = mysql_query($sql_check,$conn) or die(mysql_error());
$count = mysql_num_rows($res);

if ($count > 0){

$sql_images = "";
foreach($images as $number => $imagedetail){
if($imagedetail != ''){
$sql_images .= "imageurl".$number." = '".mysql_real_escape_string($imagedetail)."',";
}
}
$sql = "UPDATE apartments SET title = '".mysql_real_escape_string($_POST['title'])."', description = '".mysql_real_escape_string($_POST['description'])."', cross_streets = 

'".mysql_real_escape_string($_POST['cross_streets'])."', county = '".mysql_real_escape_string($_POST['county'])."', town = '".mysql_real_escape_string($_POST['town'])."', service = 

'".mysql_real_escape_string($_POST['service'])."', phone = '".mysql_real_escape_string($_POST['phone'])."', contact = '".mysql_real_escape_string($_POST['contact'])."', office = 

'".mysql_real_escape_string($_POST['office'])."', pets = '".mysql_real_escape_string($_POST['pets'])."', email = '".mysql_real_escape_string($_POST['email'])."', rooms = 

'".mysql_real_escape_string($_POST['rooms'])."', bath = '".mysql_real_escape_string($_POST['bath'])."', square = '".mysql_real_escape_string($_POST['square'])."', rent = 

'".mysql_real_escape_string($_POST['rent'])."', fees = '".mysql_real_escape_string($_POST['fees'])."', service = '".mysql_real_escape_string($_POST['service'])."', feeornofee = 

'".mysql_real_escape_string($_POST['feeornofee'])."', lease = '".mysql_real_escape_string($_POST['lease'])."', video= '".mysql_real_escape_string($_POST['video'])."', zipcode = 

'".mysql_real_escape_string($_POST['zipcode'])."',".$sql_images." videotitle = '".mysql_real_escape_string($_POST['videotitle'])."' WHERE id = '".$id."'";


//replace info with the table name above
$result = mysql_query($sql,$conn) or die(mysql_error());
header('location: apartments.php');


}else{
header('location: somethingwrong.php');
}
}
}
 
?>

Hello PHP world!

I have this roll-down-select-menu working, reflecting a column in my database.
I am able to retrieve the selected value after submit, that takes me to another code page.

But I would like to use this value on the form page, that contains the roll-down-menu and the submit button. Is there a way to enter the chosen value into this variable $uan, without having to submit the page first?

I tried to retrieve the value on this page with the POST lines at the button, but without luck.
I think the value is only entered upon submit?

Thanks in advance for your clever advice.

Best regards Morris

<?php
$query = "SELECT * FROM Uniq_artist_name" ;
$result = mysql_query($query);
echo'<select name="uan">';
while($row = mysql_fetch_assoc( $result )) {
        echo '<option value="'.$row['uniqartistname'].'">'. $row['uniqartistname'] .'</option>'; }
echo '</select>';

$uan = $_POST["uan"];
echo "$uan";
?>

Hi guys. As I am new to PHP, I have a question.

Necessarily, this need not be done in php, if you have something in html or js that can be done, let me know! Well, I have a form where you enter information like name, city, phone and product option. These product options include real estate and auto options. By clicking submit (to submit form), I need to direct the visitor to their chosen product option.

For example, when I filled out the form I chose 'real estate'. When I clicked submit, it went to a page where the real estate-only content appeared.

Note: I already have this code ready below and it already directs the information to the database. However, I don't know how to make him redirect to the customer, the product option he chose.

 

      <form action="simulador.php" method="post" name="dados" id="dados" onSubmit="return validaform()">
            <div class="col-md-5 esquerda">
                           Selecione o bem<br/>
                           <select name="tipo" type="text" class="contat3" placeholder="Selecione o bem">
                           <option value="Im�vel"" 
                           style="background-color: #fff;">Imóveis</option>
                           <option value="Autom�vel"" 
                           style="background-color: #fff;">Automóveis</option>
                           <option value="Moto" style="background-color: #fff;">Motos</option>
                          </select><br/>
                         Selecione o plano<br/>
                         <select name="plano" type="text" class="contat3">
                           <option value="Crédito"" 
                         style="background-color: #fff;">Crédito</option>
                           <option value="Parcela"" 
                         style="background-color: #fff;">Parcela</option>
                         </select><br/>
                       
                         
                         <input name="valorcon" type="text" id="valorcon" class="contat3"  placeholder="Digite o valor" maxlength="1000" /><br/>
                       
                       
                         
                         <input name="nomecon" type="text" id="nomecon" class="contat3"  placeholder="Nome"  maxlength="1000" /><br/>
                        
                    
                                       
                       
                        
                         <input name="telefone" type="text" 
						  onkeypress="Mascara('TEL',this,event);"
						 type="text" id="telefone" class="contat3"  placeholder="Telefone" />
						 
						 <!--- 
						 <input name="tel2" type="text" id="tel2" onkeypress="Mascara('TEL',this,event);" /><br/>
						 --->
                   
                   
                         
                         <input name="emailcon" type="text" id="emailcon" class="contat3"  placeholder="E-mail"  maxlength="1000" /><br/>
                   
                      
                       
                         <input name="cidadecon" type="text" id="cidadecon" class="contat3"  placeholder="Cidade"  maxlength="1000" />
                     
                   
                         <br/><br/><br/>
                         <a id="enviar-form" class="button solid-color" href="#">Enviar</a>
                         <input type="submit" id="enviar-form-btn" style="display: none;" />
                    
            </div>         
       </form>

 

This topic has been moved to JavaScript Help.

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

I am working on a project that uses a drop down list to chose the category when inserting new data into the database. What I want to do now is make the drop down list default to the chosen category on the list records page and the update page. I have read several tutorials, but they all say that I have to list the options and then select the default. But since it is possible to add and remove categories, this approch won't work. I need the code to chose the correct category on the fly.

There are two tables, one that has the category ID and category name.  The second table has the data and the catid which is referenced to the category id in the first table.

Code: [Select]
--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `categories` varchar(37) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

-- --------------------------------------------------------

--
-- Table structure for table `links`
--

DROP TABLE IF EXISTS `links`;
CREATE TABLE IF NOT EXISTS `links` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `catid` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `content` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;


Then is the list records file, I have

Code: [Select]
<?php
include ("db.php");
include ("menu.php");


$result = mysql_query("SELECT categories FROM categories") or die(mysql_error()); 
while ($row = mysql_fetch_array($result)) { 
$categories=$row["categories"];
$options.= '<option value="'.$row['categories'].'">'.$row['categories'].'</option>';
};



$id = $_GET['id'];
$query="SELECT * FROM links ORDER BY catid ASC";
$result=mysql_query($query);

?>
<table width="65%" align="center" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="100%" border="1" cellspacing="0" cellpadding="3">
<tr>
<td colspan="7"><strong>List data from mysql </strong> </td>
</tr>

<tr>
<td align="center"><strong>Category ID</strong></td>
<td align="center"><strong>Category ID</strong></td>
<td align="center"><strong>Name</strong></td>
<td align="center"><strong>URL</strong></td>
<td align="center"><strong>Content</strong></td>
<td align="center"><strong>Update</strong></td>
<td align="center"><strong>Delete</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td>
<SELECT NAME=catid>
<OPTION>Categories</OPTION>
<?php echo $options; ?>
</SELECT>
</td>
<td><? echo $rows['catid']; ?></td>
<td><? echo $rows['name']; ?></td>
<td><a href="<? echo $rows['url']; ?>"><? echo $rows['url']; ?></a></td>
<td><? echo $rows['content']; ?></td>
<td align="center"><a href="update.php?id=<? echo $rows['id']; ?>">update</a></td>
<td align="center"><a href="delete.php?id=<? echo $rows['id']; ?>">delete</a></td>

</tr>
<?php
}
?>
</table>
</td>
</tr>
</table>
<?php
mysql_close();
?>

So, how do I get this code
Code: [Select]
$result = mysql_query("SELECT categories FROM categories") or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
$categories=$row["categories"];
$options.= '<option value="'.$row['categories'].'">'.$row['categories'].'</option>';
};

<SELECT NAME=catid>
<OPTION>Categories</OPTION>
<?php echo $options; ?>
</SELECT>

to give me an output that will be

something like if catid exactly matches categories.id echo categories.categorie  ???

so far everything I have done produces either a default category of the last category,  the catid (which is a number), all of the categories (logical since catid will always be = id, or nothing.  How do I get just the category name? 

I will keep reading and try to figure this out, but any help would be greatly appreciated.

Thanks in advance