0

I have two arrays, and my problem is when I pick one value of first array it must also remotely picked the same value of the second array.

Explain :

array ("Volvo","BMW","Toyota");

array ("200","300","400");

It's like when I choose "Volvo" it must also remotely choose "200" OR when I choose "BMW" it must also remotely choose "300" and so on...

how can I do this please help;

thanks for your help..

3
Contributors
4
Replies
25
Views
3 Years
Discussion Span
Last Post by gabrielcastillo
0
$value = $_POST['car']; //assuming coming from form

$cars = array ("Volvo","BMW","Toyota");
$nums = array ("200","300","400");

$index = array_search($value, $cars);
$num = $nums[$index];

echo $value . ': ' . $num; //test

Edited by diafol

0

I tried to expand your code on a query..

<?php 
include('mysqli_connect.php');

if(isset($_POST['submit'])){

    $prod_id = $_POST['prod_id'];
    $value = $_POST['sizeStatus']; //assuming coming from form

     $sql1 = "select * from tbl_product where prod_id = $prod_id";//SQLquery

    $result1 = mysqli_query($con,$sql1);
    $row = mysqli_fetch_array($result1);

    $sizes = $row['sizes'];//assuming coming from database : 1, 2, 3
    $colour = $row['colors'];//assuming coming from database : red, blue, pink 

    $arraySize = explode(',',$sizes);
    $arrayColour = explode(',',$colour);
    $index = array_search($value, $arraySize);
    $num = $arrayColour[$index];
    echo $value . ': ' . $num; //test 

}
?>

<!---// FORM  //-->
<form method="post" action=""> 
<?php
        $sql = "select * from tbl_product where prod_id = 468"; //SQLquery
        $result = mysqli_query($con,$sql);
        $row = mysqli_fetch_array($result);
        $prod_id = $row['prod_id'];
        $sizes = $row['sizes'];

        echo '<input type="hidden" name="prod_id" value="'.$prod_id.'">';
        $temp = explode(',',$sizes);
        echo "<select name='sizeStatus'>";
        foreach($temp as $size){
        echo "<option>".trim($size)."</option>";
        }   
        echo "</select>";

?>
<input type="submit" name=" submit">
</form>

the SIZE VALUE was right .. but the COLOUR VALUE is always RED .. why please help ..

Edited by markii.borabon_1: grammar

0

why are you exploding sizes? How do you have the size column defined? Try not to mix php with html if you can.

<form method="post" action="">
<?php 
    $sql = "SELECT * FROM tbl_product WHERE prod_id = '468'";
    $results = mysqli_query($con, $sql);

    $row = mysqli_fetch_array($results);

    $sizes = explode(',',$row['size']);
?>

<input type="hidden" name="prod_id" value="<?php echo $row['prod_id']; ?>" />

<select name="sizeStatus">
<?php foreach($sizes as $size): ?>
    <option value="<?php echo trim($size); ?>"><?php echo trim($size); ?></option>
<?php endforeach; ?>
</select>
<input type="submit" name=" submit">
</form>

Also give your option a value like above.

Edited by gabrielcastillo

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.