H5获取外界设备手机的摄像头

相关推荐

• 如何使用动态rowspan显示数据库中的数据 phpmysql

  8年前
  回答 2 已采纳 Iam newbie in php programing, i have some problames with showing data from mysql database using php and html. this is my tables : location :id_location location component :id_comopnent id_location comonen sub_component :id_sub_component id_comopnent sub_component How can i get following output: location |-----------|-------------| | component |sub component| |-----------|-------------| | | Data | | Data |-------------| | | Data | |-----------|-------------| | | Data | | |-------------| | Data | Data | | |-------------| | | Data | |-----------|-------------| location |-----------|-------------| | component |sub component| |-----------|-------------| | | Data | | Data |-------------| | | Data | |-----------|-------------| | | Data | | Data |-------------| | | Data | |-----------|-------------| Location (according to the data) this is my code <?php $dsn = "mysql:host=localhost;dbname=kampus_hijau"; $dbc = new PDO($dsn, 'root', ''); $sql1 = "SELECT * FROM Lokasi ORDER BY id_location"; $stmt1 = $dbc->prepare($sql1); $stmt1->execute(); while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)) { $location++; echo "Location $location : ".$row1['location']; ?> <table width="469" border="1"> <tr bgcolor="#00FFFF"> <th width="109" class="rounded" scope="col">Component</th> <th width="248" class="rounded" scope="col">Sub Component</th> <th>Nilai</th> </tr> <?php $query = "SELECT * FROM sub_component,component where sub_component.id_component=component.id_component and component.id_location='$data[id_location]' order by component.id_location"; $stmt = $dbc->prepare($query); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $result[$row['component']][] = $row['sub_component']; } foreach($result as $id => $invoices) { echo '<td rowspan='. count($invoices) . '>' . $id . '</td>'; $count = 0; foreach ($invoices as $invoice) { if ($count != 0) { echo '<tr>'; } echo "<td>$invoice</td>"; echo "</tr>"; $count++; } } ?> </table> <?php } ?> and this the output that i get : with that code, the output form is appropriate, but the data does not appear appropriate, it's always show the data previous in the next table (red box is the data that is repeated ). how can i fix it ?
• 使用rowspan将数据从数据库调用到表中 phpmysql

  9年前
  回答 2 已采纳 I have table "Owner" in my database where one of the field (System) saved data from a textarea box. Table Owner; staf_id || name || system Below is an example of input of the textarea box; aimsweb elearning registration The example shows that each line represent different types system. How am I going to call data from the system field to the table below? table http://img546.imageshack.us/img546/1170/31920845.png When it is called, the columns "Staf ID" and "Name" will increase its rowspan based on the input in the textarea. Is it possible to do that?
• php中的动态rowspan while循环 phpmysql

  6年前
  回答 1 已采纳 I need to achieve a result like this through the values in database: ------------------------------------------------------------------------ Question Marks ------------------------------------------------------------------------ Question 1 | -------------------------------------------------| Question 2 | 5 -------------------------------------------------| Question 3 | but when I do like this: <?php while ( $PQRr = mysql_fetch_array($PQRq) ) { ?> <tr> <td align="center"><?php echo $PQRr["point_title"]; ?></td> <td align="center" rowspan="5"> <?php echo $marks_obtained; ?> </td> </tr> <?php } ?> It actually prints the the last column number of times query executes. How can I make it print just one time? Here's what I am getting currently.
• 如何在此html表中添加带有动态表值的rowspan？ ajaxphpjavascriptjquery

  4年前
  回答 1 已采纳 I have an AJAX that append tr to a table. The number of tr appended to the table is varies depend on the data returned. This is my AJAX: success : function(data) { var tableData,t1,t2,t3,t4,t5,t6,t7; var no = 1; $.each(data.result_brg, function(index, rows_minta) { t1 = "<tr><td><font size='1'>"+ no++ +"</font></td>"; t2 = "<td align='left'><font size='1'>"+ rows_minta.NamaOutlet +"</font></td>"; t3 = "<td class='barang' style='text-align:left; vertical-align:middle'>"+ rows_minta.NamaBarang +"</td>"; t4 = "<td class='j_minta' style='text-align:right; vertical-align:middle'>"+ rows_minta.jumlah_minta +"</td>"; t5 = "<td></td>"; t6 = "<td class='satuan' style='text-align:left; vertical-align:middle'>"+ rows_minta.Satuan +"</td>"; t7 = "<td></td></tr>"; tableData += t1+t2+t3+t4+t5+t6+t7; $('#tbl_content tbody tr').remove(); $('#tbl_content tbody').append(tableData); }); This is the table displayed: No outlet item stock type unit invoice_no 1 outlet A Book 45 2 outlet A Pen 24 3 outlet A Pencil 87 4 outlet A Ruler 96 5 outlet B Bag 57 6 outlet B Shirt 32 7 outlet C SSD 64 The Table I'm looking for: No outlet item stock type unit invoice_no 1 Book 45 2 Pen 24 outlet A 3 Pencil 87 4 Ruler 96 5 Bag 57 outlet B 6 Shirt 32 7 outlet C SSD 64 Note: The first column is should be centered (valign=middle and text_align=center)
• 带有rowspan的动态表 php

  4年前
  回答 1 已采纳 I have a table generated with a loop with column headers mon trough to fri and time array with 30min intervals for 24hr I have just shorten the example code: $times = array(00:00, 00:30, 01:00, 01:30); $skip = array(); $row = 1; <table> <tr> <td>Time</td><td>Mon</td><td>tue</td> <tr> foreach($times AS $val){ $stmt = $mysqli->prepare(" SELECT `show`,`time_start`,`time_stop`,`show_day` FROM `db_shows` WHERE `time_start`='$val' "); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($myrow[show],$myrow[time_start],$myrow[time_stop],$myrow[show_day]); $stmt->fetch(); // GET THE ROWSPAN $a = new DateTime($myrow[time_start]); $b = new DateTime($myrow[time_stop]); $interval = $a->diff($b); $res = $interval->format('%h'); $res *= 2; $res += 1; // ARRY FOR ROWS TO SKIP TD code in second part // APPLAY DISPLAY NONE IF NEEDED code in second part // BUILD COLUMNS switch($myrow[show_day]){ case "":$tds = "<td> </td><td> </td>"; break; case "mon":$tds = "<td rowspan="$res" style="$mon">$myrow[show]</td><td> </td>"; break; case "tue":$tds = "<td> </td><td rowspan="$res" style="$tue">$myrow[show]</td>"; break; } <tr> <td>$val</td>$tds </tr> $row++; } </table> Now my code works fine generating the the table with the rowspan, but I know I have to remove the necessary td's in the next rows depending on how many rows my rowspan ($res) contain. This is probably the part I'm falling out of the bus :) What I'm trying to achieve here is to get the row number and 'day td' to hide in the rows that follow // ARRY FOR ROWS TO SKIP TD if($res >=2){ $rowCount = $res -1; $rowSkip = $row; for($i=1;$i <= $rowCount; $i++){ $rowSkip++; $skip[$rowSkip] = $myrow[show_day]; } } // LOOK IF ROW HAVE VALUE foreach($skip AS $key2 => $val2){ if($row == "$key2" && $myrow[show_day]="$val2"){ $$val2 = "display:none"; } } I'm not even sure if I'm approaching the whole concept on the right matter, any help will be greatly appreciated. Thank You!! In the end of the day my table should look like this: table
• 在WPF的Page中添加的数据源控件DataGrid不显示数据 visual studio

  9月前
  回答 2 已采纳 在使用.Net Framework的WPF创建桌面应用时，从现有数据库向项目中添加了数据源。 如果将数据源对应的控件添加到窗体（Window）上，那么数据库中的数据可以正常显示。 但是如果将数据源对应的控件添加到页面（Page）上，那么数据库中的数据就显示不出来。 程序中没有添加C#代码。 下面是MainWindow.xaml的代码： ``` ``` 下面是Page1.xaml的代码： ``` ``` 这是程序运行的截图。 
• wpf中添加控件怎么不显示

  6年前
  回答 1 已采纳 新人求指导，代码如下，TextBlock和Button不显示 ``` ``` 运行如图 
• 它只在数据库中正确显示选项 php

  9年前
  回答 3 已采纳 I have a php code where it uses a a switch statement to find any of the values from the textbox and output the correct 'optionId' which matches the $selected_option which matches the value from the textbox. The problem I have though is that lets say there are 4 questions, 3 questions with different options and 1 which has the same optionId as another question. When I insert them in the database it is suppose to look like below: Question OptionId What is my gender O17 //case '19' What is my name O3 //case '5' What is my address O17 //case '19' What is my age O7 //case '9' But instead it is showing only the latest OptionId for both questions like below which is incorrect. Question OptionId What is my gender O7 What is my name O7 What is my address O7 What is my age O7 So what I want to know is why is it displaying only the latest OptionId for all questions? Do I need to loop the switch statement or is there something wrong with the way I loop the $insertQuestion[] as that goes through each Question? $insertquestion = array(); $options = $_POST['gridValues']; switch ($options){ case "3": $selected_option = "A-C"; break; case "4": $selected_option = "A-D"; break; case "5": $selected_option = "A-E"; break; default: $selected_option = ""; break; } $optionquery = "SELECT OptionId FROM Option_Table WHERE (OptionType = '". mysql_real_escape_string($selected_option)."')"; $optionrs = mysql_query($optionquery); while($optionrecord = mysql_fetch_array($optionrs)){ $optionid[] = $optionrecord['OptionId']; } foreach($_POST['questionText'] as $question) { $insertquestion[] = "'". mysql_real_escape_string( $_SESSION['id'] ) . ($_SESSION['initial_count'] > 1 ? $_SESSION['sessionCount'] : '') ."' ,'". mysql_real_escape_string( $_POST['num_questions'] ) ."','". mysql_real_escape_string( $question ) ."','". mysql_real_escape_string( $optionid[] ) ."'"; } $questionsql = "INSERT INTO Question (SessionId, QuestionId, QuestionContent, OptionId) VALUES (" . implode('), (', $insertquestion) . ")"; echo($questionsql) UPDATE: Below is the form code. How it works is the user types in a question in the textarea ('name='questionText') and types in an option (name='gridValues') and then they append them two in a table row (table in the form which id='qandatbl'). This is the question 1. Then they do the same again for second question, then third and etc. Please look at this carefully, it is easy to follow :) <script> function insertQuestion(form) { var context = $('#optionAndAnswer'); var $tbody = $('#qandatbl > tbody'); var $tr = $("<tr class='optionAndAnswer' align='center'></tr>"); var $question = $("<td class='question'></td>"); var $options = $("<td class='option'></td>"); var $questionType = ''; $('#questionTextArea').each( function() { var $this = $(this); var $questionText = $("<textarea class='textAreaQuestion'></textarea>").attr('name',$this.attr('name')+"[]") .attr('value',$this.val()) $question.append($questionText); }); $('.gridTxt', context).each( function() { var $this = $(this); var $optionsText = $("<input type='text' class='gridTxtRow maxRow' />").attr('name',$this.attr('name')) .attr('value',$this.val()) $options.append($optionsText); $questionType = $this.val(); }); $tr.append($question); $tr.append($options); $tbody.append($tr); } </script> <form id="QandA" action="insertQuestion.php" method="post" > <table> <tr> <td rowspan="3">Question:</td> <td rowspan="3"> <textarea id="questionTextArea" rows="5" cols="40" name="questionText"></textarea> </td> </tr> </table> <table id="optionAndAnswer" class="optionAndAnswer"> <tr class="option"> <td>Option Type:</td> <td> <div> <input type="text" name="gridValues" class="gridTxt maxRow" readonly="readonly" /> </div> </td> </tr> </table> <table id="qandatbl" align="center"> <thead> <tr> <th class="question">Question</th> <th class="option">Option Type</th> </tr> </thead> <tbody> </tbody> </table> </form>
• php使用rowspan生成的表 php

  6年前
  回答 3 已采纳 I am using this code to generate a table which will subsequently be modified to upload data to a mysql database. <?php $start_loc_number= 1 ; $start_loc_alpha= 'A' ; $end_loc_number= 10 ; $end_loc_alpha= 'J' ; $out = ''; $out .= '<table border = 1 bordercolor="#FF0000">'; for($tr='A';$tr<=$end_loc_alpha;$tr++) { $out .= "<tr>"; for($td=1;$td<=$end_loc_number;$td++) { $out .= '<td BGCOLOR="#99CCFF">'.$tr.$td.'</td> <td id="sampleID" contenteditable="true"> sampleID</td> <td id="volume" contenteditable="true"> volume</td>' ; } $out .= "</tr>"; } $out .= "</table>"; echo $out; ?> At the moment the table generates 3 cells per iteration in 3 column cells, | coordinates | sample ID | volume | My question relates to how the php code can be altered so to generate a table where the coordinates cell can be arranged as a rowspan over the sampleID and volume cells positioned in 2 rows with the sample ID over the volume cell | | sample ID | coordinates |------------ | | volume
• easyui中datagrid 操作栏格式化为按钮的数据显示错位问题 jquery

  6年前
  回答 1 已采纳 在使用easyui的过程中，通过使用onLoadSuccess将操作栏格式化成按钮之后，就会出现表格中数据错位的问题；将onLoadSuccess注释掉后，恢复正常。 不知道这里面是有什么问题，下面附上界面截图和datagrid的代码，希望大牛们帮忙看看~~感激不尽啊！！   ```JavaScript $(function(){ $('#dg').datagrid({ title:"学员信息", url:'system/studentinfo/data_getalllist', toolbar:'#toolbar', rownumbers:true, pagination:true, collapsible:true, //singleSelect:true, striped:true, fitColumns:true, fit:true, nowrap:false, loadMsg:"正在加载数据，请稍等", frozenColumns:[[ {field:'student_ID',title:'编号',width:50,align:'center',checkbox:true}, {field:'student_NUM',title:'学号',width:80,align:'center',sortable:true}, {field:'student_NAME',title:'姓名',width:80,align:'center'} ]], columns:[[ {field:'student_SEX',title:'性别',width:50,align:'center',rowspan:2}, {field:'rank_NAME',title:'级别',width:80,align:'center',rowspan:2}, {field:'student_IS_PAYTUITION',title:'是否已交学费',width:80,align:'center',rowspan:2, formatter:function(value, record){ if (value == "N") { value = "未交费"; return '' + value + ''; } else { value = "已交费"; return value; } } }, {field:'tuition_info',title:'学费信息',align:'center',colspan:3}, {field:'student_STARTTIME',title:'注册时间',width:80,align:'center',rowspan:2}, {field:'student_IS_ONSTUDY',title:'是否在学',width:80,align:'center',rowspan:2, formatter:function(value, record){ if (value == "Y") { value = "是"; return value; } else { value = "否"; return '' + value + ''; } } }, {field:'showdetail',title:'详细',width:100,align:'center',rowspan:2, formatter:function(value, row, index){ var btn1 = ''; return btn1; } }, {field:'opr',title:'操作',width:100,align:'center',rowspan:2, formatter:function(value, row, index){ var btn2 = ''; return btn2; } }], [{field:'tuition_TYPE',title:'学费类别',width:80,align:'center'}, {field:'student_TUITION_STARTTIME',title:'交费时间',width:80,align:'center'}, {field:'student_TUITION_ENDTIME',title:'到期时间',width:80,align:'center'} ]], onLoadSuccess:function(data){ $('.detailcls').linkbutton({text:'详细信息',plain:true,iconCls:'icon-edit'}); $('.editcls').linkbutton({text:'编辑',plain:true,iconCls:'icon-edit'}); } }) }); ```