Search the Community

Hi I am new in PHP. I have used dropdown to bind with my sql data. It is ok But I could not insert data into table only from dropdown. Other controls like text can be inserted. I have given code below. Pls advise me. Maideen <?php require_once '../inc/header.php'; ?> <div class="portlet light bordered"> <div class="portlet-title"> <div class="caption"> <i class="icon-social-dribbble font-green"></i> <span class="caption-subject font-green bold uppercase">Parameter</span> </div> </div> <form class="forget-form" action="../classes/cls.parameter.php" method="POST"> <div class="portlet-body"> <div class="form-group"> <label for="default" class="control-label">Parameter Details</label> <input id="default" type="text" class="form-control" placeholder="Parameter Details" name="paramdetails"> </div> <div class="form-group"> <label for="single" class="control-label">Parameter head</label> <select id="paramhead" class="form-control select2" name="paramhead"> <option>-- Select --</option> <?php $sql = "select * from tbl_paramhead order by paramhead"; $stmt = $pdo->prepare($sql); $stmt->execute(); while ($row = $stmt->fetch()) { echo '<option value>' .$row['paramhead']. '</option>'; } ?> </select> </div> </div> <div class="form-actions"> <button type="submit" class="btn green uppercase btn btn-danger mt-ladda-btn ladda-button" data-style="zoom-out" name="paramhead">Submit</button> </div> </form> </div> <?php require_once '../inc/footer.php'; ?> <?php require_once '../inc/config.php'; if(isset($_POST['paramhead'])) { if($_SERVER["REQUEST_METHOD"] == "POST") { $paramhead =$_POST['paramhead']; $paramdetails =$_POST['paramdetails']; $bool = true; $sql="insert into tbl_parameter(paramhead,paramdetails) values ('$paramhead','$paramdetails')"; $stmt=$pdo->prepare($sql); $stmt->execute(); $pdo = null; print '<script>alert("Saved");</script>'; print '<script>window.location.assign("../admin/parameter.php");</script>'; } } ?>

Hi all, I am new to this (programmed on mainframe many years). I created a dropdown selection populated from an SQL table. my problem is if I use mysql_*, the selection is populated and works correct but if I change the mysql_* to mysqli_*, it will not work (I know my connect and slect database work, because i do not go into "or die" part). My coding below: $intIdField = 'code'; $strNameField = 'name'; $strTableName = 'country'; $strNameOrdinal = 'name'; $strMaskName = 'select country'; $strOrderField = 'name'; $strMethod="ASC"; echo "<select name=\"$strNameOrdinal\">\n"; echo "<option value=\"NULL\">".$strMaskName."</option>\n"; $strQuery = "select $intIdField, $strNameField from $strTableName order by $strOrderField $strMethod"; if (!$strQuery) { die("query failed:" . mysql_error()); } echo mysql_query ("set character_set_results='utf8'"); $rsrcResult = mysql_query($strQuery); while($arrayRow = mysql_fetch_assoc($rsrcResult)) { echo $row["name"]; echo $row["code"]; $strA = $arrayRow["$intIdField"]; $strB = $arrayRow["$strNameField"]; echo "<option value=\"$strA\">$strB</option>\n"; } echo "</select>"; It only populates the block with "select country" but if you click on the down arrow, notyhing comes up. as I say, the above coding work but as soon as I change to mysqli, it does not, what am I doing wrong? Thank you in advance

I've been looking at this for a bit and can't seem to figure what's going on? I have used this code before and never had this issue.... I'm tryig to populate a dropdown menu from a MySql DB. The dropdown menu seems to skip the first array... I attached a screenshot that hopefully show's what I'm talking about.. any thoughts?

Hi, I have found a script off the internet that is very simple, it just allows my menu to have a drop down list. It is basically this script: http://jsfiddle.net/297t6/ Here's the change I want to make that I don't know how to do: When the user hovers over a menu item, it drops down; if you then hover over another menu item, that first menu item is still sliding down and then coming back up. I want the drop down to disappear as soon as the user hovers over the next menu item. Is this possible to implement with this code: $(function(){ $('ul#menu li').hover(function(){ //$('#drop' , this).css('display','block'); $(this).children('ul').delay(0).slideDown(500); }, function(){ $(this).children('ul').delay(0).slideUp(50); }); });

Hi, i want to build a dynamic mega drop down menu using php please help me how to do this. regards, Anil

Hi there I am trying to create a search form to retrive rates form multiple selections and then display the results. i have created the database in mysql database name: Rates in that there are the following 6 tables:- 1.Country 2.Area 3.Region 4.destination 5.airline 6.rate_table 1)The country has the following columns:- Country_code,Country_name,Area and Region 2)The Area table has the following columns:- Area_code,Area name and Country 3)The Region table has the following coulumns:- Region_Code,Region_Name and Country 4)The destination has the following columns:- Dest_Code,Dest_Name and Dest_Country 5. The Airline Table has the following columns:- Airline_Code and Airline_Name 6) The Rates Table has the following columns:- Rate_ID,Rate_Airline,Rate_Destination and Rate I managed to create my first drop down using the code below:- <?php //create connection $connectmysql=mysql_connect("localhost","root","root"); if (!$connectmysql) { die('Not Connected :' . mysql_error()); } $db_selected=mysql_select_db('rates',$connectmysql); ?> <?php $result = mysql_query("SELECT Country_Name FROM Country ORDER BY Country_Name") or die(mysql_error()); while ($row=mysql_fetch_array($result)) { $Country_Name=$row["Country_Name"]; $options.='<option value="'.$row['Country_Name'].'">'.$row['Country_Name'].'</option>'; }; ?> <html> <body> <SELECT NAME=catid> <OPTION VALUE=0>choose</option> <?php echo $options;?> </SELECT> </HTML> the stucture plannned is country-->region--->Area--->destination--->Airline and then search. if the country is selected then the next drop down should show the region automatically in the next dropdown and for the area drop down.The destination drop down should only show destinations for the county selected and the airline should only show the list of airlines. then the rate results should show based on these cliterias. Thanks and Regards Keith