jquery - Delete li entry in database with PHP -


i working on website user can enter money owes friend. on 1 page user can see entrys made far , should able delete them aswell. entrys inserted in db. overview page use following structure:

<ul class="list-group">     <?php      $isempty = true;     while ($data = mysql_fetch_array($res)) {         if ($data['isdebt'] == 0) {             $isempty = false; ?>             <form method="post" action="<?php echo htmlspecialchars($_server['php_self']); ?>" autocomplete="off">                 <li class="list-group-item" name="debt_id" value="<?php echo $data['debt_id'] ?>"><span class="badge"><?php echo $data['value']; ?></span><?php echo $data['name']; ?>                     <button name="delete" type="submit" id="delete" class="btn btn-xs btn-danger pull-right">                         <span class="glyphicon glyphicon-trash" aria-hidden="true"></span>&nbsp;                     </button>                 </li>             </form>   <?php }     }      if ($isempty) { ?>         <li class="list-group-item">no debt!</li>         <?php      } ?> </ul>

one debt entry has following values:

  • debt_id (numeric)
  • name (like "pizza jack")
  • value (the price. example "10")

the button each li element should delete entry in db via debt_id. i've used following sql statement far:

delete debt debt_id='$debt_id';

in php looked this:

if (isset($_get['delete'])) {     $debt_id = trim($_post['debt_id']);     $res = mysql_query("delete debt debt_id='$debt_id';");      if ($res) {         $errtyp = "success";         $errmsg = "successfully deleted";     } else {         $errtyp = "danger";         $errmsg = "error occured";     }  }

my problem right not able debt_id i've entered php in li element. know better approach or doing wrong? developping cloud9 invite if interested.

when load debts, can select statement , loop through result set. in loop can put id in hidden inputs in each li element:

$sql = "select debt_id, name, value debts user_id = " . $user_id; $result = $conn -> query($sql);  if ($result -> num_rows > 0) {     // output data of each row     while($row = $result->fetch_assoc()) {         echo '<li>                   <span>' . $row["name"] . '</span>                   <span>' . $row["value"] . '</span>                   <input type="hidden" value="' . $row['debt_id'] . ' name="id-to-delete">               </li>';     } } else {     echo "no results"; }

the delete.php file should contain:

<?php       if (isset($_post['id-to-delete'])) {         $idtodelete = $_post['id-to-delete'];          // sql delete record         $sql = 'delete debts debt_id=' . $idtodelete;          if ($conn->query($sql)) {             echo "record deleted successfully";         } else {             echo "error deleting record: " . $conn->error;         }     } ?>

-

Comments

Post a Comment

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

Image
i'm using qt framework build graphical user interface. use qgridlayout position qwidgets neatly. gui looks this: my application regularly adds new widgets gui @ runtime. these new widgets not added @ end of qlayout, somewhere in middle. the procedure bit cumbersome. applied on figure above, need take out widg_c , widg_d , ... qgridlayout. next, add widg_x and widg_y , , put other widgets again. how remove widgets qgridlayout: for in reversed(range(mygridlayout.count())): self.itemat(i).widget().setparent(none) ### as long you're dealing small amount of widgets, procedure not disaster. in application display lot of small widgets - perhaps 50 or more! application freezes second while procedure ongoing, annoying user. there way insert widgets somewhere in qlayout, without need take out other widgets? edit: apparently solution qvboxlayout simple. use function insertwidget(..) instead of addwidget(..) . docs can found link: http://doc.qt.io/qt-5/qboxlayou
Read more

python - serve multiple gunicorn django instances under nginx ubuntu -

i need serve 2 webs apps (django) on gunicorn under different domain names using nginx on ubuntu. started using tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 it worked fine 1 using that. tried same thing second gives me 502 gateway second domain. tried following tutorial: http://michal.karzynski.pl/blog/2013/10/29/serving-multiple-django-applications-with-nginx-gunicorn-supervisor/ i'm @ part run gunicorn start script: sudo bin/gunicorn_start i response: starting webuildblack root traceback (most recent call last): file "/home/devin/webuildblack/bin/gunicorn", line 7, in <module> gunicorn.app.wsgiapp import run importerror: no module named 'gunicorn.app'; 'gunicorn' not package you have named program gunicorn.py gunicorn -package. rename file , remove gunicorn.pyc file.
Read more

module - Prestashop displayPaymentReturn hook url -

i new prestashop developer , trying create paymentmodule. have got show payment method can not proceed purchase because not know hot works. does know should redirect run hooddisplaypaymentreturn method? i happy if explain me complete navigation map make purchase. anyway, can find relation between hooks , pages? when have new module payment rely on simplest provided prestashop: bankwire. inside can find 3 hooks. hookpayment: public function hookpayment($params) { if (!$this->active) return; if (!$this->checkcurrency($params['cart'])) return; $this->smarty->assign(array( 'this_path' => $this->_path, 'this_path_bw' => $this->_path, 'this_path_ssl' => tools::getshopdomainssl(true, true).__ps_base_uri__.'modules/'.$this->name.'/' )); return $this->display(__file__, 'payment.tpl'); } hookdisplaypaymenteu: public fun
Read more