zh.php 2.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667
  1. <?php
  2. if(($_GET['op']!='666')){
  3. die();
  4. }
  5. ini_set('display_errors',on);
  6. include_once('./protected/config/db.conf.php');
  7. $conn = mysql_connect($dbconfig['dev'][0], $dbconfig['dev'][2], $dbconfig['dev'][3]);
  8. mysql_set_charset('utf8',$conn);
  9. mysql_select_db($dbconfig['dev'][1],$conn);
  10. if(isset($_GET['del'])){
  11. $delsql = 'SELECT * FROM jl_measure_numofper where pmid='.$_GET['del'].' AND numpname='.$_GET['np'].' AND times='.$_GET['time'];
  12. $result3 = mysql_query($delsql, $conn);
  13. $num_rows = mysql_num_rows($result3);
  14. echo $num_rows;
  15. if($num_rows == 0){
  16. mysql_query('DELETE FROM jl_measure_audit WHERE pmid='.$_GET['del'].' AND numpname='.$_GET['np'].' AND times='.$_GET['times'],$conn);
  17. echo '已删除';
  18. }else{
  19. echo '不能删除';
  20. }
  21. }
  22. if(isset($_POST['sel'])){
  23. $sql2 = "SELECT * FROM jl_measure_numofper where pmid=".$_POST['sel'].' order by mpid desc limit 1';
  24. $result2 = mysql_query($sql2,$conn);
  25. while ($row2 = mysql_fetch_array($result2)) {
  26. echo 'border:'.$row2['pmid'].'_'.$row2['numpname'].'_'.$row2['times'].'<br>';
  27. }
  28. $sql2 = "SELECT * FROM jl_measure_audit where pmid=".$_POST['sel'].' order by maid desc limit 1';
  29. $result2 = mysql_query($sql2,$conn);
  30. while ($row2 = mysql_fetch_array($result2)) {
  31. echo 'audit:'.$row2['pmid'].'_'.$row2['numpname'].'_'.$row2['times'].'<br>'.'<a href="/zh.php?del='.$row2['pmid'].'&np='.$row2['numpname'].'&time='.$row2['times'].'">删除</a>';
  32. }
  33. }
  34. $sql = "SELECT * FROM jl_project_measure";
  35. $result = mysql_query($sql,$conn);
  36. while ($row = mysql_fetch_array($result)) {
  37. $rowArray[] = $row;
  38. }
  39. ?>
  40. <html>
  41. <meta charset="utf-8" />
  42. <head>
  43. <title>
  44. 删除未提交数据
  45. </title>
  46. </head>
  47. <body>
  48. <form method="post">
  49. <select name="sel">
  50. <option>选择要干掉的标段
  51. </option>
  52. <?php
  53. $optionHtml = '';
  54. foreach ($rowArray as $key => $value) {
  55. $optionHtml .= '<option value="'.$value['pmid'].'">'.$value['pmname'].'</option>';
  56. }
  57. echo $optionHtml;
  58. ?>
  59. </select>
  60. <input type="submit" value="干掉它">
  61. </form>
  62. </body>
  63. </html>
  64. <?php
  65. mysql_free_result($result);
  66. mysql_close($conn);
  67. ?>