Jump to content

Search the Community

Showing results for tags 'table'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Welcome to PHP Freaks
    • Announcements
    • Introductions
  • PHP Coding
    • PHP Coding Help
    • Regex Help
    • Third Party Scripts
    • FAQ/Code Snippet Repository
  • SQL / Database
    • MySQL Help
    • PostgreSQL
    • Microsoft SQL - MSSQL
    • Other RDBMS and SQL dialects
  • Client Side
    • HTML Help
    • CSS Help
    • Javascript Help
    • Other
  • Applications and Frameworks
    • Applications
    • Frameworks
    • Other Libraries
  • Web Server Administration
    • PHP Installation and Configuration
    • Linux
    • Apache HTTP Server
    • Microsoft IIS
    • Other Web Server Software
  • Other
    • Application Design
    • Other Programming Languages
    • Editor Help (PhpStorm, VS Code, etc)
    • Website Critique
    • Beta Test Your Stuff!
  • Freelance, Contracts, Employment, etc.
    • Services Offered
    • Job Offerings
  • General Discussion
    • PHPFreaks.com Website Feedback
    • Miscellaneous

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Age


Donation Link

  1. How would I go about adding a search feature, css, and a hidden rows feature/next buttons to this table I have written in PHP? There are about 5000+ items listed in this table, so it's crucial that it's a fast search bar. Any help would be greatly appreciated. I was trying to use jquery but everything is messed up and the search + features don't show up. $fp=fopen("csv/inventory4.html",'w'); $write=fputs($fp,$html_body,strlen($html_body)); $i=0; $content = file("webinvt.txt"); foreach($content as $line) { $l=csv_split($line); if(!strstr($l[11],"SET")) { if($i==10) { $tmp = '<tr>'; $write=fputs($fp,$tmp,strlen($tmp)); $i=0; } $onhand = (int)$l[15]; $committed = (int)$l[16]; $avail = $onhand - $committed; $wcdate = substr($l[23],4); $eastdate = substr($l[19],4); if(strstr($l[1],"DISC")) { $html_body ='<tr "> <td>'.$l[0].'</td> <td>'.$l[1].'</td> <td>'.$l[12].'</td> <td>'.$avail.'</td> <td>'.$l[17].'</td> <td>'.$l[18].'</td> <td>'.$eastdate.'</td> <td>'.$l[21].'</td> <td>'.$l[22].'</td> <td>'.$wcdate.'</td> </tr>'; } else { $html_body ='<tr> <td>'.$l[0].'</td> <td>'.$l[1].'</td> <td>'.$l[12].'</td> <td>'.$avail.'</td> <td>'.$l[17].'</td> <td>'.$l[18].'</td> <td>'.$eastdate.'</td> <td>'.$l[21].'</td> <td>'.$l[22].'</td> <td>'.$wcdate.'</td> </tr>
  2. Hello everybody, I have created a table with fixed cell width and height for each cell. Now I would like to put some text, which end with a number into the cells. I assume the height is good enough for a paragraph of 2 lines only, but the number should always be aligned right at the bottom line. I have tried this CSS: .para { display:block; margin-left:0px; margin-right:0px;} .para span { display:block; margin-left:0px; margin-right:0px; float:right; text-align:right;} With this HTML: <td height='40'><p class="para">Here is the description. <span>135</span></p></td> It works ok, but if the words and the number only spans one single line, the number will be right-aligned at Line 1 instead. On the other hand, if I change float:right to float:bottom-right, when the words spans 2 lines, the number will be dropped to the right side of Line 3. Is there any way to solve the problem so that the number is always shown on Line 2 and right-aligned? Thanks! Pengi.
  3. Hello guys, I'm having trouble making a loop to display the data in a table, I need the loop to display a table with the following data: example: 1 2 3 1 2 3 4 5 6 4 5 6 7 8 9 My code: <?php echo '<table width="100%" border="1" cellspacing="0" cellpadding="0">'; $contador = 1; while ($contador <= 10) { if($contador % 2){ for($x=0;$x<2;$x++){ echo "<tr><td>Registro $contador</td>"; } }else{ echo "<td>Registro $contador</td></tr>"; } ++$contador; } echo '</table>'; ?> Help me!
  4. I have a dynamic php page that has a series of select boxes at the top. When the user changes what is in the select boxes a div at the bottom of the page gets populated with a table via an ajax call to a php script. I am need of a button on that page that a user can click that will give them the option to save that displayed table as a .csv file. I have been looking all over for a solution that will work in both ie and ff, and am not coming up with anything. Any help would be great. Thanks!
  5. Im now making a simple project called student attendance.. I've just managed the register/login part.. Right now, these are the tables that i created so far.. http://i272.photobucket.com/albums/jj178/r1nk_2008/1_zpsf1765f1c.png http://i272.photobucket.com/albums/jj178/r1nk_2008/2_zpsa1a1310a.png http://i272.photobucket.com/albums/jj178/r1nk_2008/3_zps092b7ff1.png http://i272.photobucket.com/albums/jj178/r1nk_2008/4_zps1fffbc49.png What i need right now is some advice on how :- The lecturer can select the course_id that have been assigned and then list of subject he/she teach will appear.. Based on what subject he/she clicked, an attendance table appear with list of students in that class and week 1- week XX (checkbox for attendance).. Do i need to assign some primary and foreign key in my tables or adding some more necessary tables?
  6. Hello. I am one of the millions of noobs out there. I have a script designed to look up database and return search results to a table. The page however is blank so nothing is being output at all. Even the source is empty when I look at it. So the script starts with a simple index page to enter the search term and then submit. The search.php page then has the following parsed into the browser url = search.php?query=death&submit=Search I have tried searching google for all sorts of reasons for blank pages but none appear to help as they all appear to be unrelated. the script i am using on the search page is below, I want to learn so some pointers would be useful please. <?php mysql_connect("localhost", "user", "password") mysql_select_db("db") or die(mysql_error()); $query = $_GET['query']; $min_length = 1; if(strlen($query) >= $min_length) { $query = htmlspecialchars($query); $query = mysql_real_escape_string($query); echo "<table border='0' width='300' align='center'>"; echo "<tr align='center' bgcolor='#002C40' > <td height='35px' width='150px'>Title</td> <td>Author</td></tr>"; $raw_results = mysql_query("SELECT * FROM avathar15 WHERE (`user` LIKE '%".$query."%') OR (`alliance` LIKE '%".$query."%')"); if(mysql_num_rows($raw_results) > 0) { while($results = mysql_fetch_array($raw_results)) { echo "<tr align='center' bgcolor='#0f7ea3'> <td height='25px'>".$results['title']."</td> <td>".$results['text']."</td></tr>" ; } } else{ echo "<tr align='center' bgcolor='#6C0000'> <td colspan='2' height='25px'>No results</td> <tr>"; echo "</table>"; } } else{ echo "Minimum length is ".$min_length; } ?>
  7. Hi I have a list of youtube videos in a flat file database. I would like to print a thumbnail of these videos out to the end user in a table. The results need to have pagination as well as a dynamic table so i can display say 3 rows and 3 columns per page. The column amount will also need to be adjustable in case i wish to change the columns from 3 to 4 for example: $video_file_data[]; //This is the array in which all video info will be stored $start = $_REQUEST['start']; //pagination setting $videos_per_page = 9; //Show 9 Vids per page $table_colums = 3; //Amount of columns needed to display results per page $num = count ($video_file_data); //Number of lines in data array $max_pages = @ceil($num / $videos_per_page); //Maximum number of Pages $cur = @ceil($start / $videos_per_page)+1; for($i=$start;$i<min($num,($start+$videos_per_page)+0);$i++) { list($date_added, $video_title, $youtube_url) = explode('|', trim($video_file_data[$i])); // <--- Table needs to go } The info stored in $video_file_data[] would look something like this: date 1."|".title 1."|".youtube url 1 date 2."|".title 2."|".youtube url 2 date 3."|".title 3."|".youtube url 3 date 4."|".title 4."|".youtube url 4 Many thanks for the help
  8. HI i am new to php coding, i am developing a blog site. I want to know what will be the database table for cms of this blog; blog is about posting a post, editing the post, comments, admin panel. What will be database tables and what should be entries?
  9. Hi, I have form that displaying report per week. First thing to do is choose what week then automatically display the date/shift that week ranges. here is my weekly_report.php <?php error_reporting(0); session_start(); ob_start(); date_default_timezone_set("Asia/Singapore"); include('connection.php'); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <title>Weekly Report</title> <head> <link rel="stylesheet" type="text/css" href="op_report.css" /> <script type="text/javascript" src="jquery.js"></script> <script type='text/javascript' src='jquery.autocomplete.js'></script> <link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" /> <script type="text/javascript"> //----auto complete week--// $().ready(function() { $("#week_selected").autocomplete("get_week_list.php", { width: 115, matchContains: true, mustMatch: true, selectFirst: false }); $("#week_selected").result(function(event, data, formatted) { $("#week_number").val(data[1]); }); }); /*AJAX*/ function AJAX(){ var xmlHttp; try{ xmlHttp=new XMLHttpRequest(); // Firefox, Opera 8.0+, Safari return xmlHttp; } catch (e){ try{ xmlHttp=new ActiveXObject("Msxml2.XMLHTTP"); // Internet Explorer return xmlHttp; } catch (e){ try{ xmlHttp=new ActiveXObject("Microsoft.XMLHTTP"); return xmlHttp; } catch (e){ alert("Your browser does not support AJAX!"); return false; } } } } //-----get weekdata from week---// function getweekdata() { // if (window.event.keyCode==13 || window.event.keyCode==10) { divid = "week_data"; var url = "get_weekly_data.php"; var str = "id=" + document.getElementById("week_number").value; var xmlHttp = AJAX(); xmlHttp.onreadystatechange = function(){ if(xmlHttp.readyState > 0 && xmlHttp.readyState < 4){ // document.getElementById(divid).innerHTML=loadingmessage; } if (xmlHttp.readyState == 4) { if (xmlHttp.status == 200) { var jsonart = xmlHttp.responseText; document.getElementById(divid).innerHTML = jsonart; } } } xmlHttp.open("POST", url, true); xmlHttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded"); xmlHttp.setRequestHeader("Content-length", str.length); xmlHttp.setRequestHeader("Connection", "close"); xmlHttp.send(str); // } } </script> </head> <body onload=document.getElementById("week_selected").focus();> <form name="weekly_report" action="" method="post"> <div id="ddcolortabs"> <ul> <li> <a href="index.php" title="Operator's Shift Report"><span>Operator's Shift Report</span></a></li> <li id="current"> <a href="weekly_report.php" title="Reports"><span>Reports</span></a></li> </ul> </div> <br/> <div> <table> <tr> <td style="border: none;">Type Week:</td> <td><input type="text" name="week_selected" id="week_selected" value="" size="15" onkeyup="getweekdata();"></td> </tr> </table> </div> <input type="hidden" name="week_number" id="week_number"> <div id='week_data'> </div> </form> </body> </html> //get_week_list.php <?php ob_start(); include "connection.php"; $q = strtolower($_GET["q"]); if ($q == '') { header("HTTP/1.0 404 Not Found", true, 404); } //else (!$q) return; else{ $sql = "select week_id, week_number from week_list where week_number LIKE '$q%'"; $rsd = mysql_query($sql); $cnt = mysql_num_rows($rsd); if($cnt > 0) { while($rs = mysql_fetch_array($rsd)) { $pid = $rs['week_id']; $pname = $rs['week_number']; echo "$pname|$pid\n"; } } else { header("HTTP/1.0 404 Not Found", true, 404); } } ?> and here is my get_weekly_data.php // which display the data for that week. <?php ob_start(); include "connection.php"; if($_POST["id"]) { $sql = "select r.report_date, s.shift_type FROM op_reports AS r, shift_list AS s WHERE WEEK(report_date) + 1 = '" . ($_POST["id"]) . "' GROUP BY shift_type ORDER BY shift_id ASC"; $res = mysql_query($sql); echo "<table>"; echo "<tr>"; echo "<th>Comp</th>"; while($row = mysql_fetch_assoc($res)) { $report_date = $row['report_date']; $report_shift = $row['shift_type']; echo "<th>$report_date/$report_shift</th>"; } echo "</tr>"; $sql_r = "select r.report_date, s.shift_type FROM op_reports AS r, shift_list AS s WHERE WEEK(report_date) + 1 = '" . ($_POST["id"]) . "' GROUP BY shift_type ORDER BY shift_type DESC"; $res_r = mysql_query($sql_r); echo "<tr>"; echo "<th></th>"; while($r = mysql_fetch_assoc($res_r)){ echo "<th>Output</th>"; } echo "</tr>"; $sql_comp = "SELECT DISTINCT p.process_name , r.process_id, r.report_shift FROM op_reports AS r JOIN process_list AS p ON (p.process_id = r.process_id) WHERE WEEK(report_date) + 1 = '" . ($_POST["id"]) . "' GROUP BY process_name ORDER BY p.process_name ASC"; $res_comp = mysql_query($sql_comp); echo "<tr>"; while($row_comp = mysql_fetch_assoc($res_comp)) { $process = $row_comp['process_name']; $process_id = $row_comp['process_id']; echo "<td>$process</td>"; $comp = "SELECT DISTINCT o.compound_type, o.process_id, o.shift_date FROM op_output AS o WHERE process_id = '$process_id' GROUP BY o.shift_id, compound_type ORDER BY compound_type ASC"; $c = mysql_query($comp); echo "<tr>"; while($co = mysql_fetch_assoc($c)) { $compound_type = $co['compound_type']; $process_i = $co['process_id']; $shift_date = $co['shift_date']; echo "<td>$compound_type</td>"; $sql_output = "SELECT DISTINCT o.compound_type, SUM(o.compound_output) AS compound_output, o.process_id, o.shift_id, o.shift_date FROM op_output AS o WHERE process_id = '$process_id' AND o.compound_type = '$compound_type' GROUP BY o.shift_id, o.shift_date, compound_type ORDER BY o.shift_id ASC"; $res_output = mysql_query($sql_output); while($row_output = mysql_fetch_assoc($res_output)) { $compound_output = $row_output['compound_output']; $shift = $row_output['shift_id']; $compound = $row_output['compound_type']; $date = $row_output['shift_date']; if($shift == 1 && $date == $shift_date) { echo"<td>$compound_output</td>"; } else { echo "<td></td>"; } if($shift == 2 && $date == $shift_date) { echo"<td>$compound_output</td>"; } else { echo "<td></td>"; } if($shift == 3 && $date == $shift_date) { echo"<td>$compound_output</td>"; } else { echo "<td></td>"; } if($shift == 4 && $date == $shift_date) { echo"<td>$compound_output</td>"; } else { echo "<td></td>"; } if($shift == 5 && $date == $shift_date) { echo"<td>$compound_output</td>"; } else { echo "<td></td>"; } } echo "</tr>"; } } echo "</tr>"; echo "</table>"; } ?> I attached my sample screenshots that display by this code and also a format that I need to display and the database. My problem now is on displaying of output per date/shift. It's been todays that I tried to fixed this. I hope somebody can help me. Thank you so much sample updated.zip
  10. Hello, i have a table i have to fill out with info regarding other tables, is a join possible or do i have to make 2 queries? This is what i have right now. $date = date("Y-m-d H:i:s"); $sql = "INSERT INTO tblpaqueteria ( sender_id, reciever_id, AddTime, Estatus, ubicacion, tipo,slocalidad_id,rlocalidad_id ) VALUES ( '{$_POST['id_send']}', '{$_POST['id_rec']}', '{$date}', '0' , '0', '{$_POST['tipo_paq']}',0,0 )"; $res = mysql_query($sql,$this->conn); return $sql; What i need now is to change some of my insert into dynamic ones, i have to enter into "slocalidad_id" and into "ubicacion" the "id" of a table called localidad, and this id is being referenced from a table called "usuarios" (users) where "$_POST['id_send']" where localidad_id marks the id i need to insert into tblpaqueteria. I am not sure if I explained myself correctly so ill try and make an example. usuarios So for my sql above, without joins i would be receiving from POST id_send = 2 and from id_rec 11 so my query should insert this $sql = "INSERT INTO tblpaqueteria ( sender_id, reciever_id, AddTime, Estatus, ubicacion, tipo,slocalidad_id,rlocalidad_id ) VALUES ( '{$_POST['id_send']}', '{$_POST['id_rec']}', '{$date}', '0' , '2', '{$_POST['tipo_paq']}',2,4 )"; notice the numbers "2" and "4" being inserted, those are the ones i don't know how to enter dynamically, i think its a join, but i don't know how to use them in an insert. Thanks a lot
  11. Hi guys, i am not a coder , but know some basics, i am using elgg(opensource social network) in my project work, i am facing some problem, please help guys, elgg usess htmLAWED for security reason, so dont want to disable it, but want to modify it, i want to allow only table tags and its class, please go through the below example/problem i am facing, In editor i pasted this code and saved it. INPUT CODE : <table class="ttmarkcust" width="499" height="233" border="0" > <tr> <td class="tttimage" width="266" rowspan="2"><img src="#" width="243" height="100" /></td> <td class="tttprice" width="110" height="60">Rs.999/-</td> <td class="tttdiscount" width="101">75% OFF!</td> </tr> <tr> <td class="tttcoupons" height="66" colspan="2">SUPERHOTDEAL</td> </tr> <tr> <td class="tttvo"> <a href="#"><img src="#" width="150" height="42" /></a></td> <td class="tttbn" colspan="2"><a href="#"><img src="#" width="150" height="42" /></a> <br /></td> </tr> </table> When i click the post again and clicked Edit then SHOW SOURCE in editor i am seeing these codes: its filtering the code OUTPUT CODE: <table width="499" border="0"> <tr> <td width="266" rowspan="2"><img src="#" width="243" height="100" alt="image"></td> <td width="110" height="60">Rs.999/-</td> <td width="101">75% OFF!</td> </tr> <tr> <td height="66" colspan="2">SUPERHOTDEAL</td> </tr> <tr> <td> <a href="#"><img src="#" width="150" height="42" alt="image"></a></td> <td colspan="2"><a href="#"><img src="#" width="150" height="42" alt="image"></a> <br></td> </tr> </table> this is the htmLAWED file: https://github.com/Elgg/Elgg/blob/master/mod/htmlawed/vendors/htmLawed/htmLawed.php please help guys, i dont want filter to table and its classes, please help! Thank you
  12. Hey guys, i've been searching the web trying to figure out the best method of storing images in a database table when it comes to user registration. Basically, users will register with only 3 elements: Upload Image( turned into Avatar/Thumbnail), E-mail, and Password. Now i've figured out the basics on how to store user information such as the e-mail and pass, but I still haven't found any direct answers on the topic of properly managing user avatars/thumbnails. Now these avatars will be displayed everytime the user posts, much like any forum or social network. So, do I store the image itself in the database? Do I store it in a user_avatar file/directory on the server and have a direct link in the table to fetch and display the image? What would be the best method to go about this? I thought about maybe having a table with user_ID, avatar_ID and avatar_link(direct link to image).
  13. Hello, I have a table as follows; echo " <form method='get'> <center><img border='0' src='contest_winner.jpg' alt='test' width='452' height='384' class='center'></center> <table class='imagetable center'> <tr> <th>5/36</th> <th>6/40</th> </tr> <tr> <td> <select name='game1'> <option value='1'>111111</option> <option value='2'>222222</option> </select> </td> <td> <select name='game2'> <option value='1'>111111</option> <option value='2'>222222</option> </select> </td> </tr> <tr> <td> <input name='send1' type='submit' value='Check'> </td> <td> <input name='send2' type='submit' value='Check'> </td> </tr> <tr> <td> <-------- image here -----------> </td> <td> <-------- image here -----------> </td> </tr> </table> </form>"; I would like to add an image between TD's at the last TR of the table. How can I do it dynamically? Best Regards.
  14. Hello, i cant understand what the problem is .... when i add the css file you cant see what i echo out but only the tables and when i delete the css file everithing work fine... Here is the php file. maybe something is wrong here.. $sql = "SELECT * FROM producten"; $myData = mysql_query($sql,$con); echo '<table border="0" width="100%" cellpadding="0" cellspacing="0" id="product-table"> <tr> <th class="table-header-check"><a id="toggle-all" ></a> </th> <th class="table-header-repeat line-left minwidth-1"><a href="">Product</a> </th> <th class="table-header-repeat line-left minwidth-1"><a href="">Categorie</a></th> <th class="table-header-repeat line-left"><a href="">Beschrijving</a></th> <th class="table-header-repeat line-left"><a href="">Nr</a></th> <th class="table-header-repeat line-left"><a href="">Prijs</a></th> <th class="table-header-options line-left"><a href="">Options</a></th> </tr>'; while($record = mysql_fetch_array($myData)){ echo "<tr>"; echo '<td><input type="checkbox"/></td>'; echo "<td>" . " " . $record['Product'] ." </td>"; echo "<td>" . " " . $record['Item'] . " </td>"; echo "<td>" . " " . $record['Description'] . " </td>"; echo "<td>" . " " . $record['Extra'] . " </td>"; echo "<td>" . " " . $record['Valuta'] . " </td>"; echo "<td>" . " " . $record['Price'] . " </td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?> Thanks for any help.
  15. hi, im a newbie here. im seeking help for my problem. i am also new in php but have some knowledge in sql here's my problem. my boss wants to enable update the baking chamber table once the Estimated End Time reached only. meaning if the end time doesn't meet there will be a pop up on the page that operator cannot finished unless the estimated end time is reached. Please kindly help check my code and see screenshot attached for your reference. Thanks in advanced guys. if($_POST['submit']=="Bake Finished") { $time = strftime('%I:%M %p'); $hours = strftime('%H'); $min = strftime('%M'); $query=mysql_query("SELECT * FROM tbl_baking_chamber"); while($result=mysql_fetch_array($query)) { $recno=$result['RecNo']; if(isset($_POST[$recno])!=NULL) { mysql_query("UPDATE tbl_baking_chamber set tbl_baking_chamber.TotalTime='$TotalTime' where RecNo='".$recno."'"); mysql_query("UPDATE tbl_baking_chamber set tbl_baking_chamber.EndTime='$CurrentDate - $time' where RecNo='".$recno."'"); mysql_query("UPDATE tbl_baking_chamber set tbl_baking_chamber.Status='Finished' where RecNo='".$recno."'"); } } } if($_POST['submit']=="On Baking" || $_POST['submit']=="Bake Finished") { echo "<table class='tbl_Forbaking' cellspacing='1' border='0' width='680'>"; echo "<form action='Applications.php?type=BGABaking' method='post'>"; echo "<tr>"; //echo "<td class='text2' align='center' bgcolor='e3e6e5' height='40'>"."MODEL"."</td>"; echo "<td class='text2' align='center' bgcolor='e3e6e5'>"."SERIAL NUMBER"."</td>"; echo "<td class='text2' align='center' bgcolor='e3e6e5'>"."DEFINED <br> BAKE TIME"."</td>"; echo "<td class='text2' align='center' bgcolor='e3e6e5'>"."BATCH"."</td>"; echo "<td class='text2' align='center' bgcolor='e3e6e5'>"."LOCATION"."</td>"; echo "<td class='text2' align='center' bgcolor='e3e6e5'>"."START TIME"."</td>"; echo "<td class='text2' align='center' bgcolor='e3e6e5'>"."ESTIMATED <br> END TIME"."</td>"; echo "<td class='text2' align='center' bgcolor='e3e6e5'>"."<input type='submit' name='submit' value='Bake Finished' class='btn_Bake'>"."</td>"; $Query = mysql_query("SELECT * FROM tbl_baking_chamber where Status='On Baking'"); $count = mysql_num_rows($Query); $bgcolor="e3e6e5"; while($result = mysql_fetch_array($Query)) { if($bgcolor=='e3e6e5') { $bgcolor='e9ebea'; } else { $bgcolor='e3e6e5'; } echo "<tr>"; //echo "<td class='text1' align='center' bgcolor='$bgcolor'>".$result['Model']."</td>"; echo "<td class='text1' align='center' bgcolor='$bgcolor'>".$result['Serial']."</td>"; echo "<td class='text1' align='center' bgcolor='$bgcolor'>".$result['BakingHours']."</td>"; echo "<td class='text1' align='center' bgcolor='$bgcolor'>".$result['Batch']."</td>"; echo "<td class='text1' align='center' bgcolor='$bgcolor'>".$result['Chamber']."</td>"; echo "<td class='text1' align='center' bgcolor='$bgcolor'>".$result['StartTime']."</td>"; echo "<td class='text1' align='center' bgcolor='$bgcolor'>".$result['SEndTime']."</td>"; echo "<td class='text1' align='center' bgcolor='$bgcolor'>"."<input type='checkbox' value='$result[RecNo]' id='$result[RecNo]' name='$result[RecNo]'>"."</td>"; } echo "</form>"; echo "<tr>"; echo "<td>"."<br/>"; echo "<tr>"; echo "<td class='text4'>"."Total QTY.: $count"; echo "</table>"; }
  16. I can not update the table like i want, when i want to change one row everything changes when i click update ! so what i want is when i click update to change only the row i want and not all the rows. Thanks for any help. <?php $con = mysql_connect("localhost","root",""); if (!$con){ die("Can not connect: " . mysql_error()); } mysql_select_db("food",$con); if(isset($_POST['update'])){ $UpdateQuery = " UPDATE producten SET Product='$_POST[product]', Item='$_POST[item]', Description='$_POST[description]', Extra='$_POST[extra]', Valuta='$_POST[valuta]', Price='$_POST[price]', Nummer='$_POST[nummer]' WHERE Product='$_POST[hidden]'"; mysql_query($UpdateQuery, $con); }; if(isset($_POST['delete'])){ $DeleteQuery = "DELETE FROM producten WHERE Product='$_POST[hidden]'"; mysql_query($DeleteQuery, $con); }; if(isset($_POST['add'])){ $AddQuery = "INSERT INTO producten (Product, Item, Description, Extra, Valuta, Price, Nummer) VALUES ('$_POST[uproduct]','$_POST[uitem]','$_POST[udescription]','$_POST[uextra]','$_POST[uvaluta]','$_POST[uprice]','$_POST[unummer]')"; mysql_query($AddQuery, $con); }; $sql = "SELECT * FROM producten"; $myData = mysql_query($sql,$con); echo "<table border=1> <tr> <th>Product</th> <th>Item</th> <th>Description</th> <th>Extra</th> <th>Valuta</th> <th>Price</th> <th>Nummer</th> </tr>"; while($record = mysql_fetch_array($myData)){ echo "<form action=mydata6.php method=post>"; echo "<tr>"; echo "<td>" . "<input type=text name=product value=" . $record['Product'] . " </td>"; echo "<td>" . "<input type=text name=item value=" . $record['Item'] . " </td>"; echo "<td>" . "<input type=text name=description value=" . $record['Description'] . " </td>"; echo "<td>" . "<input type=text name=extra value=" . $record['Extra'] . " </td>"; echo "<td>" . "<input type=text name=valuta value=" . $record['Valuta'] . " </td>"; echo "<td>" . "<input type=text name=price value=" . $record['Price'] . " </td>"; echo "<td>" . "<input type=text name=nummer value=" . $record['Nummer'] . " </td>"; echo "<td>" . "<input type=hidden name=hidden value=" . $record['Product'] . " </td>"; echo "<td>" . "<input type=submit name=update value=update" . " </td>"; echo "<td>" . "<input type=submit name=delete value=delete" . " </td>"; echo "</tr>"; echo "</form>"; } echo "<form action=mydata6.php method=post>"; echo "<tr>"; echo "<td><input type=text name=uproduct></td>"; echo "<td><input type=text name=uitem></td>"; echo "<td><input type=text name=udescription></td>"; echo "<td><input type=text name=uextra></td>"; echo "<td><input type=text name=uvaluta></td>"; echo "<td><input type=text name=uprice></td>"; echo "<td><input type=text name=unummer></td>"; echo "<td>" . "<input type=submit name=add value=add" . " </td>"; echo "</form>"; echo "</table>"; mysql_close($con); ?>
  17. can anyone help me with this I do not know if this is safe, if not can someone tell me how I can do this? $id //* is pagination $per_page //* how many i show per page $getquery = mysql_query("SELECT * FROM `videos` WHERE $construct ORDER BY date DESC LIMIT $id, $per_page"); Any help is appreciated
  18. I have the following code set up to insert data into my table. This is just a test to see if it will work before I go further into development. I know I'm able to connect to my data as I have a message appear when that happens, but it won't insert data into the table for some reason. $phoneNumber = "0786352373"; $firstName = "jennifer"; $lastName = "dunne"; $profilePicture = ""; $photo = ""; $video = ""; $text = "text is here yes yes eys"; $call = "call is here yes yes eys"; $activity = "this is jennifers activity"; $latitude = "-50.889473"; $longitude = "3.845738"; $date = "23/05/2012"; $time = "13:29"; $sql = "INSERT INTO member (phoneNumber, firstName, lastName, profilePicture, photo, video, text, call, activity, latitude, longitude, data, time) "; $sql .= "VALUES ('$phoneNumber', '$firstName', '$lastName', '$profilePicture', '$photo', '$video', '$text', '$call', '$activity', '$latitude', '$longitude', '$data', '$time')"; if (!mysqli_query($sql, $con)) { die('Error: ' . mysqli_error()); } else { echo "Comment added"; } mysqli_close($con); I do get an error message come up, but all it says is the following and doesn't shine light on the situation at all. Error: I'm very new to mysql and always seem to struggle with it but want to get over my fear of it. :-)
  19. Hi, here is some code for my site, where images are displayed with text underneath. It is set up in a table, but all the images and text go horizontally, and I need it to go vertically. Please help. <center> <table border="1" rules="cols" width="100%"> <tr> <? foreach($top_ratings as $key => $image) : ?> <td valign="top"><img src="http://mywebsite.com/images/<?=$image->filename?>" width="100%"/></td> <? endforeach ?> </tr> <tr> <? foreach($top_ratings as $key => $image) : ?> <td valign="top">Score: <?=$image->score?></td> <? endforeach ?> </tr> <tr> <? foreach($top_ratings as $key => $image) : ?> <td valign="top">Performance: <?=$image->performance?></td> <? endforeach ?> </tr> <tr> <? foreach($top_ratings as $key => $image) : ?> <td valign="top">Won: <?=$image->wins?></td> <? endforeach ?> </tr> <tr> <? foreach($top_ratings as $key => $image) : ?> <td valign="top">Lost: <?=$image->losses?></td> <? endforeach ?> </tr> </table> </center>
  20. Hello all, I'm having a bit of a problem with my code here. I'm trying to allow the user to enter a number (an office number) from a database, and based on that value, after submitting it, an html table will fill with the appropriate results (lastName, firstName, jobTitle). For whatever reason, though, I keep getting this error: "Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in... <website name> <line number>" It's very weird, because I'm doing this straight from notes / w3 and I'm still getting errors. I'm still new to this, so I'm sorry if I'm sounding completely inexperienced... well I am haha. Anyway, here's the code: <!DOCTYPE html > <html lang ="en"> <head> <title> Homepage </title> </head> <body bgcolor="gray"> <h1 align=middle> Welcome to the Site </h1> <?php DEFINE ('DB_USER', '*******); DEFINE ('DB_PASSWORD', '******'); DEFINE ('DB_HOST','*****'); DEFINE ('DB_NAME','******'); $dbc = @mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME) or die ('Could not connect to MySQL: '.mysqli_connect_error($dbc) ); mysqli_set_charset($dbc, 'utf8'); //$r = @mysqli_query($dbc, $q); ?> <form action ="Homepage.php" method="get"> Enter Office Code: <input type="text" name="oCode" id="OfficeCode" maxlength="15"> <input type="submit" name="formSubmit" value="Submit"> </form> <? $code = $_GET['oCode']; $result = mysqli_query($dbc, "select lastName, firstName, jobTitle from Employees where OfficeCode='$code'"); echo "<table border='1'>"; echo "<tr>"; echo "<th>LastName</th>"; echo "<th>FirstName</th>"; echo "<th>Job Title</th>"; echo "</tr>"; while ($row = mysqli_fetch_array($result)) //this is where I'm getting the error { echo "<tr>"; echo "<td>" . $row['lastName'] . "</td>"; echo "<td>" . $row['firstName']. "</td>"; echo "<td>" . $row['jobTitle'] . "</td>"; echo "</tr>"; } echo "</table>"; mysqli_close($dbc); ?> Any help would be great. Thank you!
  21. Could someone show me how to make a table that displays data from a Database and allows you to add and delete from it.
  22. Hello friends,I've a code which I've added below and i want the contents of the first three columns(Sl no,Usn,Name) to be inserted from a mysql database,and the remaining colums have text fields where the end user will enter the information which should be stored in some other mysql table.I was successfull in inserting from mysql to html table but i had troubles dealing with other colums ..I had to create multiple tables and join them which resulted in two tables of different height and the overall look and feel was not good..even had trouble dealing with css and javascript support .So i just want to know if is there a way to insert data from my database to the first three columns without effecting the other colums and also by retaining the js nd css support.I've also attached a small screenshot of how the table looks.(Sorry for poor english ) my code:- <!-- Row Highlight Javascript --> <script type="text/javascript"> window.onload=function(){ var tfrow = document.getElementById('tfhover').rows.length; var tbRow=[]; for (var i=1;i<tfrow;i++) { tbRow[i]=document.getElementById('tfhover').rows[i]; tbRow[i].onmouseover = function(){ this.style.backgroundColor = '#f3f8aa'; }; tbRow[i].onmouseout = function() { this.style.backgroundColor = '#ffffff'; }; } }; </script> <style type="text/css"> table.tftable {font-size:12px;color:#333333;width:100%;border-width: 1px;border-color: #a9a9a9;border-collapse: collapse;} table.tftable th {font-size:12px;background-color:#b8b8b8;border-width: 1px;padding: 8px;border-style: solid;border-color: #a9a9a9;text-align:center;} table.tftable tr {background-color:#ffffff;} table.tftable td {font-size:12px;border-width: 1px;padding: 8px;border-style: solid;border-color: #a9a9a9;} table.input {text-align:center;} </style> <table id="tfhover" class="tftable" border="1"> <tr> <th rowspan = "2"> Sl No</th> <th rowspan = "2"> USN</th> <th rowspan = "2"> Name</th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> </tr> <tr align = "center"> <th> IA Marks </th> <th> IA Marks </th> <th> IA Marks </th> <th> IA Marks </th> <th> IA Marks </th> <th> IA Marks </th> <th> IA Marks </th> <th> IA Marks </th> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "s1i" size = "2" /> </td> <td> <input type = "number" name = "s1e" size = "2" /> </td> <td> <input type = "number" name = "s2i" size = "2" /> </td> <td> <input type = "number" name = "s2e" size = "2" /> </td> <td> <input type = "number" name = "s3i" size = "2" /> </td> <td> <input type = "number" name = "s3e" size = "2" /> </td> <td> <input type = "number" name = "s4i" size = "2" /> </td> <td> <input type = "number" name = "s4e" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> my database table :- +-------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+----------------+ | id | int(3) | NO | PRI | NULL | auto_increment | | usn | varchar(15) | YES | | NULL | | | name | char(50) | YES | | NULL | | +-------+-------------+------+-----+---------+----------------+
  23. Is there a better way to load table values into drop down menus? Basically I have 3 different drop down options which need to have data loaded into them from the same table in a database. Here is what I have so far. It works but I feel like there must be a better way to make this happen. <?php include("connect.php"); mysql_connect("$server", "$username", "$password") or die(mysql_error()); mysql_select_db("$database") or die(mysql_error()); // HEADER INCLUDE include("header.php"); echo "<br/><br/>"; echo "<form action='add-record2.php' method='post'>"; // GET ALL DATA FOR "LOCATION" FROM "ADMIN" TABLE $location = mysql_query("SELECT Location FROM admin") or die(mysql_error()); echo "Location:"; echo "<select name='location'>"; while($row = mysql_fetch_array( $location )) { echo "<option value='". $row['Location'] ."'>"; echo $row['Location']; echo "</option>"; } echo "</select><br/> Task Description: <textarea rows='4' cols='50' name='task'></textarea><br/> Responsibility: <select name='responsibility'>"; // GET ALL DATA FOR "RESPONSIBILITY" FROM "ADMIN" TABLE $responsibility = mysql_query("SELECT Responsibility FROM admin") or die(mysql_error()); while($row = mysql_fetch_array( $responsibility )) { echo "<option value='". $row['Responsibility'] ."'>"; echo $row['Responsibility']; echo "</option>"; } echo "</select><br/> Type: <select name='type'>"; // GET ALL DATA FOR "TYPE" FROM "ADMIN" TABLE $type = mysql_query("SELECT Type FROM admin") or die(mysql_error()); while($row = mysql_fetch_array( $type )) { echo "<option value='". $row['Type'] ."'>"; echo $row['Type']; echo "</option>"; } echo "</select><br/> Frequency(days): <input type='text' name='frequency'> <input type='submit'> </form>"; // END OF FORM ?> Thanks John
  24. Hello, New here so apologies if I commit any rule breaks regarding posting. I have been given basic javascript functions with in a HTML page that is supposed to fetch values from a already created database and input these values into the table on the page. Please see this link as an example: http://www.eng.nene.ac.uk/~10406206/CSY2028/Ajax/Ajax.html As you can see there is a table with headers. When the 'Load Database' button is clicked the function is supposed to load the database values into the correct cells. However this does not happen. There is an alert which displays correct information from the database but the values do not get entered into the table? I need to know why this is the case as I have no idea where to go to fix this. Edit: The alert was displaying my database values but now it is not. No errors displaying in the console. I am new to Javascript and Ajax coding so I apologise in advance. Below is the Javascript Functions. <script language="Javascript"> var xmlHttpReq = false; var xmlHttpReq2 = false; var xmlHttpReq3 = false; function appendRecord (id, carname, fueltype, transmission, enginesize, doors, total, available) { //rowcount ++; //if (firstname == "") return; mytable = document.getElementById ("DBTable"); mycurrent_row = document.createElement ("tr"); mycurrent_row.setAttribute ("id", "DB"+id); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (id); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (carname); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (fueltype); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (transmission); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (enginesize); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (doors); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (total); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (available); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); mycurrent_input = document.createElement ("input"); mycurrent_input.setAttribute ("type", "button"); mycurrent_input.setAttribute ("value", "modify"); mycurrent_input.setAttribute ("onclick", "modifyOrUpdateRecord (" + id + ", this)"); mycurrent_cell.appendChild (mycurrent_input); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); mycurrent_input = document.createElement ("input"); mycurrent_input.setAttribute ("type", "button"); mycurrent_input.setAttribute ("value", "delete"); mycurrent_input.setAttribute ("onclick", "deleteRecord (" + id + ")"); mycurrent_cell.appendChild (mycurrent_input); mycurrent_row.appendChild (mycurrent_cell); mytable.appendChild (mycurrent_row); } function loadDatabaseRecordsCallback () { if (xmlHttpReq.readyState == 4) { alert ("From Server (Load Records):\n" + xmlHttpReq.responseText); var record = xmlHttpReq.responseXML.getElementsByTagName('record'); var s = ""; for (var i = 0; i < record.length; i ++) { var rec = record[i]; var id = rec.getElementsByTagName("ID")[0].firstChild.data; var carname = rec.getElementsByTagName("CARNAME")[0].firstChild.data; var fueltype = rec.getElementsByTagName("FUELTYPE")[0].firstChild.data; var transmission = rec.getElementsByTagName("TRANSMISSION")[0].firstChild.data; var enginesize = rec.getElementsByTagName("ENGINESIZE")[0].firstChild.data; var doors = rec.getElementsByTagName("DOORS")[0].firstChild.data; var total = rec.getElementsByTagName("TOTAL")[0].firstChild.data; var available = rec.getElementsByTagName("AVAILBLE")[0].firstChild.data; appendRecord (id, carname, fueltype, transmission, enginesize, doors, total, available); } } } function loadDatabaseRecords () { // Mozilla/Safari if (window.XMLHttpRequest) { xmlHttpReq = new XMLHttpRequest(); } // IE else if (window.ActiveXObject) { xmlHttpReq = new ActiveXObject("Microsoft.XMLHTTP"); } alert ("To Server (Load Records):\n\nload.php"); xmlHttpReq.open('GET', "load.php", true); xmlHttpReq.onreadystatechange = loadDatabaseRecordsCallback; xmlHttpReq.send(null); } The loaddatabaserecords function calls the load.php file which is below <?php $link = mysql_connect ("194.81.104.22", "xxxx", "xxxxx"); mysql_select_db ("db10406206"); $query = "SELECT * from XYZ"; $result = mysql_query ($query); header ("Content-Type: application/xml"); print ("<?xml version=\"1.0\" ?>"); print "\n<database>\n"; for ($i = 0; $i < mysql_num_rows ($result); $i ++) { $row = mysql_fetch_object ($result); print " <record>\n"; print " <id>$row->ID</id>\n"; print " <carname>$row->CARNAME</carname>\n"; print " <fueltype>$row->FUELTYPE</fueltype>\n"; print " <transmission>$row->TRANSMISSION</transmission>\n"; print " <enginesize>$row->ENGINESIZE</enginesize>\n"; print " <doors>$row->DOORS</doors>\n"; print " <total>$row->TOTAL</total>\n"; print " <available>$row->AVAILABLE</available>\n"; print " </record>\n"; } print "</database>\n"; mysql_close ($link); ?> Finally this is the html table etc etc. <form name="f1"> <input value="Load Database" type="button" onclick='JavaScript:loadDatabaseRecords()'></p> </form> <table id="DBTable" border="2"> <tr> <td width="20">ID</td> <td width="100">Car Name</td> <td width="100">Fuel Type</td> <td width="100">Transmission</td> <td width="80">Engine size</td> <td width="20">Doors</td> <td width="20">Total</td> <td width="20">Available</td> </tr> <form name="myform"> <tr> <td><input type="text" name="id"></td> <td><input type="text" name="carname"></td> <td><input type="text" name="fueltype"></td> <td><input type="text" name="transmission"></td> <td><input type="text" name="enginesize"></td> <td><input type="text" name="doors"></td> <td><input type="text" name="total"></td> <td><input type="text" name="available"></td> <td colspan="2"><input type="button" value="add" onClick="JavaScript:addNewRecord()"></td> <td colspan="2"><input type="checkbox" value="update" onClick="JavaScript:updateRecord()"></td> <td colspan="2"><input type="checkbox" value="delete" onClick="JavaScript:deleteRecord()"></td> </tr> </form> </table> So, I just want to know whats going wrong. I have spent so many hours researching how to get my database values into the html table. The only responses I have had so far is to display the data in other ways etc. However, i need to display the values in the table as there is other functions that will use the information. Any help would be greatly appreciated. Thanks. Joey
  25. I'm wondering if it's possible in an easy way that when I use while function to call out a bunch of data and put them into table but I want to use css to make it one row with regular background and one row with light background. hopefully what I sad make sense.... this is what I have echo "<style type='text/css'>"; echo "th {background: #CEED5E;}"; echo "</style>"; echo "<table border=1>"; echo "<tr><th>Product ID</th><th>Title</th><th>Author</th><th>Description</th></tr>"; while ($row = mysqli_fetch_assoc($result)) { echo "<tr><td>" . $row["id"] . "</td><td>" . $row["title"] . "</td><td>" . ucwords(strtolower($row["authorFirstName"] . " " . $row["authorLastName"])) . "</td><td>" . $row["description"] . "</td></tr>"; } echo "</table>";
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.