php - Disable delete button if record exist in multiple table -


i have here mysql records display in html table delete button. need disable delete button if record exist in both database table.

how can disable delete button per row if record exist in both table? appreciate.

$search = $mysqli1->real_escape_string($_post['bid']); $search = preg_replace("/[^a-za-z0-9 ]/", '', $search); $search = $_post['bid']; $res = $mysqli1->query("select * code item '%$search%' or item_code '%$search%' or cat_code '%$search%' order item_code asc");  while($r = $res->fetch_assoc()){ echo "<tr> <td><a href='#' id='".$r['id']."' class='del'><img src='../images/del.png'></a></td> </tr>"; }

throw in simple if() statement connected both queries in pdo use ->rowcount() not sure in mysqli

so logic you'd need

query1 = counted rows in table1

query2 = counted rows in table2

as if said if exists in both tables should hide you're going work if-or statement

if(query1 == 0 || query2 == 0){  //show button }

what here stands simple:

if(query1 equals 0 rows or query2 equals 0 rows){  //show button } //while don't put else else won't show //so if there value of 1+ rows in both query1 , query2 won't show

if want me provide pdo example reply

edit:

pdo class make easier connect

class database extends pdo {     private $db;     public function database($host, $user, $pass, $db) {         try {             $this->db = new pdo("mysql:dbname=".$db.";host=".$host.";",    $user, $pass);                } catch(pdoexception $e) {             die('an error has occurred! [code: '.$e->getcode().']!  <br/>more info: ['.$e->getmessage().']!');         }     }     public function runquery($query) {         try{             return $this->db->query($query);         } catch(pdoexception $e) {             die('an error has occurred! [code: '.$e->getcode().']!<br/>more info: ['.$e->getmessage().']!');         }            } }

now row counting: updated there little mistake && , 2x query1 check

 $consite = new database('dbhost','dbusername','dbpassword','dbname');  $query1 = $consite->runquery("select * table1");  $query2 = $consite->runquery("select * table2");  if($query1->rowcount() == 0 || $query2->rowcount() == 0) {   //do while statement loop through   //if done while statement shows delete button   //for items not in both tables  }

sorry lazy add while statement ;) if correct can check multiple tables in sql query can 1 query if make multi check following 1 query!

edit: logical steps question:

1) connect database

2) make query table1

3) count entries(records) table1

4) make query table2

5) count entries(records) table2

6) check if one of them equals 0

7) if one of them equals 0 entries (records(rows)) show button


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more