PHP - Example Please - Ftp, Sftp, Scp Combo

Hi,
I am developing a web application using PHP and MySQL. I am filling my combobox with the value fetched from the MySQL database. I want to retain the selected value of the combo box in postback. I am able to do it with the statiic values. But in this case I am binding the combbox   dynamically with the values from the database. Can anybody please help me?
Thanks,
Regards,
Viji

Hi there,

I am working on a PHP web form and I have a combo box and I'm trying to sort the values in it.

The values in the combo box are filled using an arraylist:

$WeightArray = array('' => '',
    '0|100' => '100g or Less',
    '101|250' => '101g to 250g', 
    '251|500' => '251g to 500g',
    '501|1000' => '501g to 1kg',
    '1000|2000' => '1kg to 2kg',
    '2000|3000' => '2kg to 3kg',
    '3000|4000' => '3kg to 4kg',
    '4000|5000' => '4kg to 5kg',
    '5000|6000' => '5kg to 6kg',
    '6000|7000' => '6kg to 7kg',
    '7000|8000' => '7kg to 8kg', 
    '8000|9000' => '8kg to 9kg',  
    '9000|10000' => '9kg to 10kg',
    'customValues' => 'Custom Values'
    );

The values get properly filled in the combo box. Thats fine. Its just that the values are not sorted the way I want them to. The Grams and Kilograms are all mixed. It should output in the order defined in the array.

See the ScreenShot I've taken and see the difference in the values defined and the output.

I tried few sorting methods like

ksort($WeightArray);
But still the same output.

Whats the good trick to sort values in Combo as per the array.

All comments and feedback are always welcomed.

Thank you.

I am trying to make a function that will generate a random number letter combo but the letters can only be abcde, no others. It must come out in the format, 1a~3d~9b~ etc. This is what I have so far:

Code: [Select]
function randomNumLet($amount){
$theNos = array('1', '2', '3', '4', '5', '6', '7', '8', '9');
$theLet = array('a', 'b', 'c', 'd', 'e');
$combo = '';
for($i=0;$i<$amount;++$i)
{
$rand_num = array_rand($theNos, 1);
$rand_let = array_rand($theLet, 1);
$combo .= $theNos[$rand_num[0]].$theLet[$rand_let[0]].'~';
}
return $combo;
}


$num_let = randomNumLet(2);
echo $num_let;
And it returns just '~~' with no numbers or letters. I'm a bit stuck here and would appreciate any help. How can I make the function output 1a~4d~ etc?

Cheers,
Joe

Hi Guys. Hopefully someone can help me with this...New to coding and pretty lost on this.
I have a Mysql database which is displaying results to my webpage with no problems. However I would like to be able to add a combo box to my webpage that would update the mysql database results based on the combo box selection. For example if Ford is chosen from the combo box, the webpage would refresh and show all the results for Ford in the webpage. Can someone please help me?

Here is the code I have at the moment that works just fine. But results of the database are based on the WHERE statement.

Quote

<?php
$con = mysql_connect("server","database","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("a5525005_cars", $con);

$result = mysql_query("SELECT * FROM `cars` WHERE Makel='Ford'");

echo "<table class='ex1' border='0' width='113%' style=text-align:center; cellpadding='6' cellspacing='0'>

</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr style=font-family:verdana;font-size:80%;>";
 
    echo "<td width=13%>" . $row[""] . "<img src=\"" . $row["Photo"] . "\"></a>";
    echo '<td width="14%"><a class="mylink" href="' . $row['URL'] . '">' . $row['Model'] . '</a></td>';   
    echo '<td width="5%"><a class="mylink" href="' . $row['URL'] . '">' . $row['Year'] . '</a></td>';
    echo '<td width="4%"><a class="mylink" href="' . $row['URL'] . '">' . $row['Fuel'] . '</a></td>';
       
echo "</tr>";
  }
echo "</table>";
mysql_close($con);
?>

Hi there...

I am working on a PHP web form. I have Group name and its Member details stored in the database.

The Group names from the database table gets populated in a combo box. Now what I'm trying to accomplish is, as soon I select a Group name, all its members should appear in a Label (or something) under the combo box with a textbox field next to the member name for me to assign the member position.

How can we go about doing this. Please see the Screenshot I've attached and you'll have the idea as to what we're trying to accomplish here.

All comments and feedback are welcomed!

Thank you!

Hi there.

I am trying to sort values in a combo box stored in an array. The array is written in t his way. Here this is in proper sorting:


 $WeightArray = array('' => '',
    '100gOrLess' => '100g or Less',
    '101g-250g' => '101g to 250g', 
    '251g-500g' => '251g to 500g',
    '501g-1kg' => '501g to 1kg',
    '1kg-2kg' => '1kg to 2kg',
    '2kg-3kg' => '2kg to 3kg',
    '3kg-4kg' => '3kg to 4kg',
    '4kg-5kg' => '4kg to 5kg',
    '5kg-6kg' => '5kg to 6kg',
    '6kg-7kg' => '6kg to 7kg',
    '7kg-8kg' => '7kg to 8kg', 
    '8kg-9kg' => '8kg to 9kg',  
    '9kg-10kg' => '9kg to 10kg',
    '10kg-11kg' => '10kg to 11kg', 
    '11kg-12kg' => '11kg to 12kg' 
    );


Now when I call this array and put in a combo it is displayed as shown in the Screenshot. It is displaying as, 10kg, 11kg 1kg ... in the incorrect order.

I tried few sort() functions but I am not able to sort the array as shown in the screenshot attached.

Kindly let me know how I can sort the values in the Combo box.

Thank you!!

I have a simple database table that has the names of countries listed with just 2 fields ID & country. I want to use this in a form to choose the country and provide statistics regarding that country. I know how to get the data from MySQL, but I don't know how I can use this in the form as a selection? How do I get the options to iterate all of the countries so that when the form is displayed a combo type box is displayed with a dropdown list?   I have not shown any code as I am not sure if this is possible.   Please can anyone advise if this is possible and if so some example code?

Hi there,

I am having a PHP form with simple combo box. Here is the code:

<form name="form1" method="get" action="">
  <select name="select" onChange="form1.submit()">
    <option value='value1'>My Value1</option>
    <option value='value2'>My Value2</option>
    <option value='value3'>My Value3</option>
  </select>
</form>

Now the form is successfully being submitted upon 'onChange' event. The only thing I am trying to do is to retain the value of the new option. As every time I select the value from the combo, it goes back and displays the 'value 1' even when I select value 3 or 2.

How do I make the combo box retain the value as 3 (when I select option 3) after the form is submitted.

Please reply.

Thank you!

Hi Good day Can someone pls help me regarding with this matter.
I have a page for inserting records. And I have a combobox that is fetched through the specific field in database. I also have a table of records, for each row i have an href edit which throws the values to its respective texbox and combobox. 
THE PROBLEM is that when i click the href edit, the value from a selected row was not displayed from the combobox