Search the Community

I am finding that if I have "0"(zero) value in form select option, it won't select this option or submit data. If I change this value to any other number to text, it will work. Is there a way to fix this? I have to have an option where I am able to choose to submit "0" value to the database table. <option value="0" <?php if(empty($_POST['special'])) {} else { if($_POST['special'] == 0) { echo 'selected'; } } ?> >None</option>

I succeed to create the vertical data, but I just add checkbox in data table in PHP. I know how to set up the value in checkbox, but i can't figure how to put name and value that from database. for example, when you can see name list in columns, you click checkbox that which has name that selected data from database. here example in code: I can get value from outside of php in html: <input type="checkbox" name="???" value="<?php echo $data['Name'] ?>"> But I can't figure to set up the value that inside php: echo "<tr><td><input type="checkbox" name="???" value=?></td></tr>"; my point is I can use echo to print, but echo is used already, php cannot take two name code in same time, same line number. Can you help? If you want to see my full code in php, Let me know...I will put my code in next comment in this thread. Thank you so much! Gary Taylor

$sqld = "SELECT * FROM orders WHERE `id`='$delete' AND `name`='$inf2[name]' AND `email`='$inf2[email]' LIMIT 1"; $csql = $db->query($sqld); $ccheck = $csql->fetch(PDO::FETCH_NUM); $cinf = $csql->fetch(PDO::FETCH_ASSOC); $quantity = $cinf[quantity]; $code = $cinf[code]; $stmt11 = $db->prepare('UPDATE feeds SET quantity=quantity-:quantity WHERE code=:code'); $stmt11->bindValue(':quantity', $quantity, PDO::PARAM_STR); $stmt11->bindValue(':code', $code, PDO::PARAM_STR); $stmt11->execute(); $id = $delete; $name = $inf2[name]; $stmt2 = $db->prepare("DELETE FROM orders WHERE id=:id AND name=:name"); $stmt2->bindValue(':id', $id, PDO::PARAM_STR); $stmt2->bindValue(':name', $name, PDO::PARAM_STR); $stmt2->execute(); OK, i have just been told i should start using PDO instead of mysql to update my tables. This code works to delete the order but doesn't update the feeds section. All this is new to me so far and i think i am getting the hang of it. Should i still be using the quantity=quantity-:quantity or is there another way to do it with PDO? Sorry, i posted this in the wrong forum. Hope someone here can help until it's moved

Hi all, This seems like it should be really simple but to me it's not. I have an array in a variable called $numbers. When I run print_r ($numbers) I get the following... $earchForNumber = '0304'; // Array called $numbers Array ( [0] => Array ( [0] => 0219, 0220, 0221, 0222, 0223 ) [1] => Array ( [0] => 0301, 0302, 0303, 0304 ) [2] => Array ( [0] => 1230, 1231, 0101, 0102 ) ) if (in_array($earchForNumber, $numbers)) {echo 'The key is' . $key;} What I need to do is search for a number within all of the sub arrays and find the key which it belongs to. So if I wanted to find the key for the value of $earchForNumber (0304) it would return a key of 1. There are tons of posts on stack overflow about this sort of thing but I can't find any that perform this task. I played around with inarray() but couldn't get any joy. Any ideas?

Hi guys, before I get to the main part of my question, I first wanted to ask whether there is a maximum number of values you should store in an array. If for example you have 5000 boxes that people can choose from and eventually all 5000 boxes will be chosen, is it save to store all of the chosen boxes in an array? For example box1,box5,box7,box21 are already chosen, then someone chooses box2,box3,box4 and it adds to the same array, is that feasible with up to 5000 values in total? My thoughts on it were that it would probably be more feasible than giving each box it's own column!? Secondly, assuming the above is ok, how would I go about ensuring nobody could choose a box already chosen? Basically, if somebody chooses box3 and box4, how can I check that these don't exist in the column before adding them so they don't duplicate? Hope this makes some sense and isn't just gobblydeegook! Finally, if somebody in the Users table chooses box3 and box4 from SaleID5, what would be the best way of storing what they've chosen in the User table to use the data when they're viewing what they've got?! Many thanks in advance guys.

Hello everyone, I am having a pretty basic problem. Below is a piece of my code, the first few lines of "Get Value for Bodyfitting" basically gets a value and assigns it to some variables through a select statement (this later on you will see that the values are being shown through echo on the screen in a form of a javascript dropdown for "Style Selection"), now the second few lines is where I have some issues in the "Value for Field 1", I want to get back a value by getting the answer from the first sql but I can't get the value for "$newBodyfitting" because it is only assigned later on, this will allow me to get a dropdown for a "Select Front", this is dependent on the "Select Style" if you see below, I know it might sound confusing. Thanks in advance. //Get Division $div_query = "SELECT distinct DIVISION, CLOTHDB FROM MTM_DIVISIONS_S ORDER BY CLOTHDB"; $div_result = oci_parse($connect,$div_query); oci_execute($div_result); while ($div_row = oci_fetch_array($div_result, OCI_ASSOC)) { $divArray[] = "{$div_row['CLOTHDB']}"; $divDivArray[] = "{$div_row['DIVISION']}"; } oci_free_statement($div_result); //Get Value for Bodyfitting $bodyfitting_query="SELECT BODYFITTING, BFCODE FROM MTM_STYLES_S WHERE DIVISION= '".$divDivArray[$i]."' AND STYLE_TYPE='BODY' GROUP BY BODYFITTING, BFCODE ORDER BY BODYFITTING"; $bodyfitting_result = oci_parse($connect,$bodyfitting_query); oci_execute($bodyfitting_result); //Get Value for Field1 $field1_query="SELECT MTM_STYLES_S.CODE,MTM_SUFFEX_S.TEXT FROM MTM_STYLES_S,MTM_SUFFEX_S WHERE MTM_SUFFEX_S.DIVISION='".$divDivArray[$i]."' AND (MTM_STYLES_S.FIELD=MTM_SUFFEX_S.FIELD AND MTM_STYLES_S.CODE=MTM_SUFFEX_S.CODE) AND MTM_STYLES_S.STYLE_TYPE='BODY' AND MTM_STYLES_S.BODYFITTING='".$newBodyfitting."' AND MTM_STYLES_S.FIELD=1 ORDER BY MTM_STYLES_S.FIELD,MTM_STYLES_S.CODE"; $field1_result = oci_parse($connect,$field1_query); oci_execute($field1_result); //Setup new dropdown for Style Selection echo "\tClearOptionsFastAlt('bodyfitting');\n"; echo "\t\tdocument.pickDivision.textInput.value='';\n"; echo "var divcomp = division.replace(/^\s+|\s+$/g, '');"; echo "var selectObj = document.pickDivision.bodyfitting;\n"; echo "var numShown = selectObj.options.length;\n"; echo "selectObj.selectedIndex = -1;\n"; echo "\t\t\tselectObj.options[numShown] = new Option('- Select Style -', '');\n"; echo "\t\t\tnumShown++;\n"; while ($bodyfitting_row = oci_fetch_array($bodyfitting_result, OCI_ASSOC)) { $newBodyfitting=$bodyfitting_row['BODYFITTING']; $newBfcode=$bodyfitting_row['BFCODE']; echo "\t\t\tselectObj.options[numShown] = new Option('".$newBfcode.' '.$newBodyfitting."', '".$newBfcode."');\n"; echo "\t\t\tnumShown++;\n"; $y++; } //Setup dropdown new Front dependent on Style above echo "\t\t\tdocument.pickDivision.bodyfitting.options[0].selected = true;\n\n"; echo "\t\tdocument.pickDivision.field1;\n"; echo "\tClearOptionsFastAlt('field1');\n"; echo "\t\tdocument.pickDivision.textInput.value='';\n"; echo "var divcomp = division.replace(/^\s+|\s+$/g, '');"; echo "var selectObj = document.pickDivision.field1;\n"; echo "var numShown = selectObj.options.length;\n"; echo "selectObj.selectedIndex = -1;\n"; echo "\t\t\tselectObj.options[numShown] = new Option('- Select Front -', '');\n"; echo "\t\t\tnumShown++;\n"; while ($field1_row = oci_fetch_array($field1_result, OCI_ASSOC)) { $newField1=$field1_row['TEXT']; $newField2=$field2_row['CODE']; echo "\t\t\tselectObj.options[numShown] = new Option('".$newField1.''.$newField2."');\n"; echo "\t\t\tnumShown++;\n"; $y++; } echo "\t\t\tdocument.pickDivision.field1.options[0].selected=true;\n\n"; oci_free_statement($field1_result); oci_free_statement($bodyfitting_result);

Hello..this is my first attempt to ask a question on this forum..I am trying to be as descriptive as possible what I have is select option in 'chart.php' page and once I select the value,it's passed to another 'getvalue.php' page using get. this 'getvalue.php' page will connect and run sql query with the value I sent and make table from the result and send it back using AJAX callback..it works fine for this concept so far. Now, I am trying something else. I am using google charts to visualize the data. So the thing is I run php code from 'chart.php' page where I manually enter the value for the query to take in and create a result for associative array. This array is linked to a variable myurl[]. Afterwards, in this same page 'chart.php'..I am in my Javascript calling this will variable because there is an option for arraytoDatatable in google charts. once all of this is done, the chart is displayed and everything is fine and happy. Now, what I want to do is select a value from the options and send that value in the same 'chart.php' page and run the query and update the google charts...so far I haven't been able to figure out why can't it send the value to the same page. I am not even sure if php can refer to its own self and call the value. Here's the code: <html> <form id="myform" method="GET" action="<?php echo $_SERVER['$PHP_SELF'];?>"> Select a orbital period (in days) <select id="sf" name="star"> <option value="0">0</option> <option value="0.5">0.5</option> <option value="10">10</option> <option value="100">100</option> <option value="365">365</option> </select> </form> <?php $o = intval($_GET['star']); /*$o = '10';*/ echo "$o<br>"; $con = mysqli_connect('localhost','username','password'); if (!$con) { die('Could not connect: ' . mysqli_error($con)); } mysqli_select_db($con,'mydatabase'); $sql="SELECT * FROM exoplanetdb WHERE pl_orbper >= '".$o."' "; $result = mysqli_query($con,$sql); $myurl[] = "['Mass','Mass,Radius(J)']"; while($row = mysqli_fetch_assoc($result)) { $mass=$row['pl_masse']; $radj=$row['pl_radj']; $myurl[] = "[".$mass.",".$radj."]"; } mysqli_close($con); ?> <!--make the chart--> <script src="https://www.google.com/jsapi"></script> <script> google.load("visualization", "1", {packages:["corechart"]}); google.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ <?php echo(implode(",",$myurl));?> ]); var options = { selectionMode: 'multiple', title: 'Mass vs Size(times Jupiter radius)', hAxis: {title:'Mass(times Earths)'}, vAxis: {title:'Radius(times Jupiter)'} }; var chart = new google.visualization.ScatterChart(document.getElementById('chart_div')); chart.draw(data, options); } </script> </html> if something is unclear..plz ask me..I will try to explain..Thank you for your time

Hey, guys, I'm new in the whole php thing. I believe what I am asking here is super simple to do, I just wasn't able to find it anywhere. In the code below, you guys will notice that not all the fields show in every change of the dropdown menu TYPE, and, of course they don't, that's the whole point. I mean, I have arranged for each TYPE to have it's own fields. The thing is: how can I adapt for the html ECHO code to show ONLY the "labels", I mean, the pieces of HTML in the while($row = mysqli_fetch_array($result)), for the fields that were filled in? I mean, I don't want that in RESULT there are the "labels" of the fields whose values are there. <?php $con=mysqli_connect("localhost","root","","activitytest1"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } if (isset($_POST['submit'])) { $stmt = mysqli_prepare($con, "INSERT INTO activitytest1 (type, author, taskpre, taskdescription, outcome, semipre, semiwhile, exercisedescription, practicepre, practiceinstructions, leadin, gamepre, gameinstructions, videopre, videowhile, videopost, songpre, songwhile, songpost, mimioinstructions, otherinstructions, path, books, grouping, time) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); mysqli_stmt_bind_param($stmt, 'sssssssssssssssssssssssss', $type, $author, $taskpre, $taskdescription, $outcome, $semipre, $semiwhile, $exercisedescription, $practicepre, $practiceinstructions, $leadin, $gamepre, $gameinstructions, $videopre, $videowhile, $videopost, $songpre, $songwhile, $songpost, $mimioinstructions, $otherinstructions, $path, $books, $grouping, $time); $type = $_POST['type']; $author = $_POST['author']; $taskpre = $_POST['taskpre']; $taskdescription = $_POST['taskdescription']; $outcome = $_POST['outcome']; $semipre = $_POST['semipre']; $semiwhile = $_POST['semiwhile']; $exercisedescription = $_POST['exercisedescription']; $practicepre = $_POST['practicepre']; $practiceinstructions = $_POST['practiceinstructions']; $leadin = $_POST['leadin']; $gamepre = $_POST['gamepre']; $gameinstructions = $_POST['gameinstructions']; $videopre = $_POST['videopre']; $videowhile = $_POST['videowhile']; $videopost = $_POST['videopost']; $songpre = $_POST['songpre']; $songwhile = $_POST['songwhile']; $songpost = $_POST['songpost']; $mimioinstructions = $_POST['mimioinstructions']; $otherinstructions = $_POST['otherinstructions']; $path = $_POST['path']; $books = $_POST['books']; $grouping = $_POST['grouping']; $time = $_POST['time']; $submit = $_POST['submit']; mysqli_stmt_execute($stmt); mysqli_stmt_close($stmt); } $result = mysqli_query($con,"SELECT * FROM activitytest1"); while($row = mysqli_fetch_array($result)) { echo "<table width='909' border='1' align='center' cellpadding='5' cellspacing='0'> <tr> <th width='125' scope='col'>Type</th> <th width='680' scope='col'>Description</th> <th width='120' scope='col'>Author</th> </tr></table> <br/> <table width='909' border='1' align='center' cellpadding='5' cellspacing='0'> <tr> <td width='125'>" . $row['type'] . "</th> <td width='680'>Time:" . $row['time'] . " min. <br><br>" . $row['books'] . "<br/>Grouping: " . $row['grouping'] . "<br/>Preview the Task:" . $row['taskpre'] . "<br/>Instructions:" . $row['taskdescription'] . "<br/>Outcome:" . $row['outcome'] . "<br/>Preview the semi-task:" . $row['semipre'] . "<br/>Instructions:" . $row['semiwhile'] . "<br/>Exercise Instructions: " . $row['exercisedescription'] . "<br/> Preview the Practice:" . $row['practicepre'] . "<br/>Practice Instructions:" . $row['practiceinstructions'] . "<br/>Lead-in:" . $row['leadin'] . "<br/>Preview the Game:" . $row['gamepre'] . "<br/>Game Instructions:" . $row['gameinstructions'] . "<br/>Song PRE:" . $row['songpre'] . "<br/>Song WHILE:" . $row['songwhile'] . "<br/>Song POST:" . $row['songpost'] . "<br/>Video PRE:" . $row['videopre'] . "<br/>Video WHILE:" . $row['videowhile'] . "<br/>Video POST:" . $row['videopost'] . "<br/>Mimio Instructions:" . $row['mimioinstructions'] . "<br/>Instructions:" . $row['otherinstructions'] . "<br/><br>Link/Path" . $row['path'] . "<br/></th> <td width='120'>" . $row['author'] . "</th> </tr></table> <br/> <hr size='1'/>"; } mysqli_close($con); ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Test 1</title> </head> <body> <br> <table width="909" border="1" align="center" cellpadding="5" cellspacing="0"> <tr> <th width="125" scope="col">Type</th> <th width="680" scope="col">Description</th> <th width="120" scope="col">Author</th> </tr></table> <br> <form action="index.php" method="POST"> <table width="909" border="1" align="center" cellpadding="5" cellspacing="0"> <td width="125"><label> </label> <select name="type" id="type" onChange="display(this,'Task','Semi-task','Practice','Exercise','Lead-in', 'Game', 'Video','Song','Mimio','Other');"> <option value="Unselected" selected="selected">Choose one:</option> <option value="Task">Task</option> <option value="Semi-task">Semi-task</option> <option value="Practice">Practice</option> <option value="Exercise">Exercise</option> <option value="Lead-in">Lead-in</option> <option value="Game">Game</option> <option value="Video">Video</option> <option value="Song">Song</option> <option value="Mimio">Mimio</option> <option value="Other">Other</option> </select></td> <td width="680"><div id="Task" style="display:none"> Task: <br /> Lead-in/Preview the task: <textarea name="taskpre" cols="70" rows="2"></textarea> <br /> Instructions: <textarea name="taskdescription" cols="70" rows="2"></textarea> <br /> Outcome: <textarea name="outcome" cols="70" rows="2"></textarea> <br /> </div> <div id="Semi-task" style="display:none">Semi-task:<br /> Lead-in/Preview the task: <textarea name="semipre" cols="70" rows="2"></textarea> <br /> Instructions: <textarea name="semiwhile" cols="70" rows="2"></textarea> <br /> </div> <div id="Exercise" style="display:none">Exercise:<br /> Instructions/Obs.: <textarea name="exercisedescription" cols="70" rows="2"></textarea> </div> <div id="Practice" style="display:none"> Practice:<br /> Lead-in/Preview the task: <textarea name="practicepre" cols="70" rows="2"></textarea> <br /> Instructions: <textarea name="practiceinstructions" cols="70" rows="2"></textarea> <br /> </div> <div id="Lead-in" style="display:none"> Lead-in:<br> <textarea name="leadin" cols="70" rows="2"></textarea><br> </div> <div id="Game" style="display:none"> Game:<br /> Lead-in: <textarea name="gamepre" cols="70" rows="2"></textarea> <br /> Instructions: <textarea name="gameinstructions" cols="70" rows="2"></textarea> </div> <div id="Video" style="display:none"> Video: <br /> Pre: <textarea name="videopre" cols="70" rows="2"></textarea> <br /> While: <textarea name="videowhile" cols="70" rows="2"></textarea> <br /> Post: <textarea name="videopost" cols="70" rows="2"></textarea> </div> <div id="Song" style="display:none"> Song: <br /> Pre: <textarea name="songpre" cols="70" rows="2"></textarea> <br /> While: <textarea name="songwhile" cols="70" rows="2"></textarea> <br /> Post: <textarea name="songpost" cols="70" rows="2"></textarea> </div> <div id="Mimio" style="display:none">Mimio:<br /> Instructions:<br> <textarea name="mimioinstructions" cols="70" rows="2"></textarea> </div> <div id="Other" style="display:none">Other:<br /> Instructions:<br> <textarea name="otherinstructions" cols="70" rows="2"></textarea><br /> </div> </td> <td width="120"><input name="author" type="text" size="12" maxlength="25" /></td> </tr> <tr> <td colspan="3"> <select name="books" id="Books"> <option value="books open" selected="selected">books open</option> <option value="books closed">books closed</option> </select> <br /> <select name="grouping"> <option value="individual" selected="selected">individual</option> <option value="pairs">pairs</option> <option value="trios">trios</option> <option value="groups of 3 to 4 students">groups of 3 to 4 students</option> <option value="groups of 5 students">groups of 5 students</option> <option value="divide the class into 2 groups">divide the class into 2 groups</option> <option value="divide the class into 3 groups">divide the class into 3 groups</option> <option value="divide the class into 4 groups">divide the class into 4 groups</option> </select> <br /> about <input name="time" type="text" id="Time" size="1" /> min </td> </tr> <tr> <td colspan="3">Link/Path: <input name="path" type="text" id="Path" size="40" /></td> </tr> <tr> <td colspan="3"><input type="submit" name="submit" value="Post!" /></td> </tr> </table> </form> </body> </html>

hello, i am using google scripts for finding the location base ot search city or street.. everything is working if i am searching from the same index by input tag with some id.. the button is executing some javascript. i am trying to make the search by giving parameter from other index - with $_GET['location']. after that i put one rule - if($_GET[location]){ echo "<script type javascript.. function()." but nothing happens. in the function i put one alert after the if(thislocation), to see if the parameter is givven to the function ant id is, but the location didnt appear. can you help me to understand what i am missing. function submitQuery(thislocation) { if(thislocation){var query=thislocation} else { var query = document.getElementById("location").value; } if (/\s*^\-?\d+(\.\d+)?\s*\,\s*\-?\d+(\.\d+)?\s*$/.test(query)) { var latlng = parseLatLng(query); if (latlng == null) { document.getElementById("location").value = ""; } else { geocode({ 'latLng': latlng }); } } else { geocode({ 'address': query }); } } function geocode(request) { resetMap(); var hash = ''; if (request.latLng) { hash = 'q=' + request.latLng.toUrlValue(6); } else { hash = 'q=' + request.address; } hashFragment = '#' + escape(hash); window.location.hash = escape(hash); geocoder.geocode(request, showResults); } function parseLatLng(value) { value.replace('/\s//g'); var coords = value.split(','); var lat = parseFloat(coords[0]); var lng = parseFloat(coords[1]); if (isNaN(lat) || isNaN(lng)) { return null; } else { return new google.maps.LatLng(lat, lng); } } <input type="text" id="location" style="width:93%; height:30px; font-size:15px;" class="logbut" placeholder="<?php echo $lang['mapinfo'];?>" > </td> <td align="right" style="min-width:46px; vertical-align:middle"> <input type="button" value="<?php echo $lang['search'];?>" class="newclassbutton" onclick="submitQuery()"/> <?php if($_GET['location']){?><script type="text/javascript">submitQuery('<?php echo $_GET['location'];?>')</script><?php } ?>

I have a problem. I have this array. Example... [0] hi.jpg [1] bye.gif [2] blah.png [3] 0000.jpg If I enter a value to a field like "bye.gif". Or let's say I put this on the address bar... http://mysite.com/somepage.php?view=bye.gif I want to get the array index and put that into a variable. Like somehow I want to do a "$_GET['view']" maybe and get the array value and put it into a variable. Like... $imageVar = "index of $_GET['view']" So when run it's like... $imageVar = 1 Hope this doesnt sound like jibberish. i'm kind of a noob. D=

how can i fix it, i can't get the value from the form so it can be deleted : $id=$_POST['id'];

Hello, before i start please sorry for my english, I'm not from english speaking country so my english is not that good. my Question: is there any possibility to put 2 or more values in one input type ? I making something like ordering-system. you can imagine it like : You want buy monitor and there is 3 radio inputs for 19" screen, 22" screen and 24" and next to them are pices: ○ 19" screen - 1100 dollars ○ 22" screen - 1200 dollars ○ 24" screen - 1300 dollars And when i click 'submit' i want to show on another page form.php see what he chose so for example its shows 24" screen - 1200 dollars And there is problem. In <input> is just one value (only for price or name of product - screen in my case) I have this code but it shows only price in form.php : <input type="radio" name="xxx" value="1100 dollars" onclick='check_value(this, 1)'"> (that onclick='check_value(this, 1)' is javascript counting system its irelevant) and in form.php <? echo $_POST["xxx"]; ?> Why? This what i posted works but its only show in form.php '1100 $ dollars' but i want to for example : mac book - 1100 dollars. my idea is something like this : <input type="radio" name="xxx" value="1100 dollars" value2="macbook" onclick='check_value(this, 1)'"> and when i confirm it i want in form.php macbook 1100 dollars I tried it with this code: <input type="radio" name="xxxcena" value="PRICE" onclick='check_value(this, 1)' /> <input type="text" name="xxxtyp" value="PRODUCT" hidden /> and in post.php <tr bgcolor="#f0f8ff"> <td> <? echo $_POST["xxxcena"]; ?> </td> <td> <? echo $_POST["xxxtyp"]; ?> </td> </tr> But it dont work (only shows one product no matters what i chose from my options in form). Please if its not possible can you tell me how to do it? Once again im very sorry for my bad english and i hope someone of you understand what i need. Thanks for any help. -exer