mysql - Display particular details of a person while clicking on name using php my sql -


this question has answer here:

hi iam trying display particular details of data while clicking on title name .here code. getting errors if use condition , $id=$_get['blog_title'] in blog.php

notice: undefined index: title in c:\xampp\htdocs\accounting\blogs.php on line 6

warning: mysql_fetch_array() expects parameter 1 resource, boolean given in c:\xampp\htdocs\accounting\images.php on line 7

images.php

<table>                  <tbody> <?php include "blogs.php" ; while($row =  mysql_fetch_array($result)) {?>  <tr>     <td><img src="admin/upload/<?php echo $row['image'];?>" height="100" width="100"/></td> <td><a href="blogimages.php?title=<?php echo $row['blog_title'];?>"><?php echo $row['blog_title']; ?></a></td>                   </tr> <?php }?> </tbody> </table>

blog.php

<?php $connection = mysql_connect("localhost", "root", "") or die(mysql_error()); $db = mysql_select_db("accountant", $connection); $id=$_get['title']; $res = "select *  blogs blog_title=$id"; $result=mysql_query($res); ?>

on single page can in following manner:-

blog.php:-

  <?php error_reporting(e_all); ini_set('display_errors',1); $connection = mysqli_connect("localhost", "root", "","accountant"); $new_array = array(); if(isset($_get['title'])){     if($connection){         $res = "select image,blog_title  blogs blog_title='".$_get['title']."'";         $result=mysqli_query($connection,$res);         $i = 0;         if(mysqli_num_row($result)>0){            while($row = mysqli_fetch_assoc($result)){                 $new_array[$i]['image'] = $row['image'];                 $new_array[$i]['blog_title'] = $row['blog_title'];                 $i++;            }          }else{          echo "no record exist";         }      }else{         echo mysqli_error();     } }else{     echo "title not selected"; } ?> <table>                  <tbody> <?php if(count($new_array) >=1){?> <?php foreach($new_array $new_arr){?>     <tr>         <td><img src="admin/upload/<?php echo $new_arr['image'];?>" height="100" width="100"/></td>     <td><a href="blogimages.php?title=<?php echo $new_arr['blog_title'];?>"><?php echo $new_arr['blog_title']; ?></a></td>                       </tr> <?php }?> </tbody> </table> <?php}?>

Comments

Post a Comment

Popular posts from this blog

routing - AngularJS State management ->load multiple states in one page -

Image
i developing site in angularjs ui-router. have situation on button click need change , load 3 state page , 3 looks image .please me how can load multiple pages. in 1 page you need configure router config this: $stateprovider .state("state1", { url: "/url1", controller: "firstcontroller", views: { view1: { templateurl: "templates/template1.html" }, view2: { templateurl: "templates/template2.html" }, view3: { templateurl: "templates/template3.html" } } }).state("state2", { url: "/url2", controller: "secondcontroller", views: { view1: { templateurl: "templates/template4.html" }, view2: { templateurl: "templates/template5.html" }, view3: { templateurl: "templates/template6.html" } }).state("state3", { ...
Read more

python - GRASS parser() error -

i'm trying use grass on python 2.7, i'm having problems @ setting script on idle, i'm getting error @ parser() function: here script: import os import sys gisbase = os.environ['gisbase'] = 'c:\program files (x86)\grass gis 7.0.1rc1' gisrc = 'c:\grassdata' gisdbase = 'c:\grassdata' location = 'newlocation' mapset = 'tc' ld_library_path = 'c:\program files (x86)\grass gis 7.0.1rc1\lib' path = 'c:\program files (x86)\grass gis 7.0.1rc1\etc';'c:\program files (x86)\grass gis 7.0.1rc1\etc\python';'c:\program files (x86)\grass gis 7.0.1rc1\lib';'c:\program files (x86)\grass gis 7.0.1rc1\bin';'c:\python27';'c:\program files (x86)\grass gis 7.0.1rc1\python27';'c:\program files (x86)\grass gis 7.0.1rc1\msys' pythonlib = 'c:\python27' pythonpath = 'c:\program files (x86)\grass gis 7.0.1rc1\etc\python' sys.path.append(os.path.join(os.environ['...
Read more

Swift game error message -

i following ios game tutorial. cannot figure out wrong here. error on these 2 lines. let newangle = percent * 180 - 180 cannon.zrotation = cgfloat(newangle) * cgfloat(m_pi); 180.0 //error "use of unresolved identifier 'percent'" the tutorial uses: cannon.zrotation = cgfloat(newangle) * cgfloat(m_pi)/ 180.0 but changed error suggested import spritekit class gamescene: skscene { var cannon: skspritenode! var touchlocation:cgpoint = cgpointzero override func didmovetoview(view: skview) { /* setup scene here */ cannon = self.childnodewithname("cannon") as! skspritenode } override func touchesbegan(touches: set<uitouch>, withevent event: uievent?) { /* called when touch begins */ touchlocation = touches.first!.locationinnode(self) } override func touchesmoved(touches: set<uitouch>, withevent event: uievent?) { touchlocation = touches.first!.locationinn...
Read more