database - retrieve data from db and display it in table in php .. see this code whats wrong with it? - 


  $db = mysql_connect("localhost", "root", "");   $er = mysql_select_db("ram");   $query = "insert names values('$name','$add1','$add2','$mail')";   $result = mysql_query($query);   print "<p> person's information inserted </p>";   $result = mysql_query("select * names"); ?>  <table border="2">    <tr>       <th>name</th>       <th>address line 1</th>       <th>address line 2 </th>       <th>e-mail id </th>     </tr>     <?      while ($array = mysql_fetch_row($result));     {         print "<tr> <td>";         echo $array[0];          print "</td> <td>";         echo $array[1];          print "</td> <td>";         echo $array[2];          print "</td> <td>";         echo $array[3];          print "</td> </tr>";     } ?>

try this:

<?php   # init mysql connection   if( !( $db = mysql_connect( 'localhost' , 'root' , '' ) ) )     die( 'failed connect mysql database server - #'.mysql_errno().': '.mysql_error();   if( !mysql_select_db( 'ram' ) )     die( 'connected server, failed connect database - #'.mysql_errno().': '.mysql_error();   # prepare insert query   $inserttpl = 'insert `name` values( "%s" , "%s" , "%s" , "%s" )';   $insertsql = sprintf( $inserttpl ,                  mysql_real_escape_string( $name ) ,                  mysql_real_escape_string( $add1 ) ,                  mysql_real_escape_string( $add2 ) ,                  mysql_real_escape_string( $mail ) );  # execute insert query   if( !( $insertres = mysql_query( $insertsql ) ) ){     echo '<p>insert of row database failed - #'.mysql_errno().': '.mysql_error().'</p>';   }else{     echo '<p>person\'s information inserted</p>'   }   # prepare select query   $selectsql = 'select * `names`';  # execute select query   if( !( $selectres = mysql_query( $selectsql ) ) ){     echo 'retrieval of data database failed - #'.mysql_errno().': '.mysql_error();   }else{     ?> <table border="2">   <thead>     <tr>       <th>name</th>       <th>address line 1</th>       <th>address line 2</th>       <th>email id</th>     </tr>   </thead>   <tbody>     <?php       if( mysql_num_rows( $selectres )==0 ){         echo '<tr><td colspan="4">no rows returned</td></tr>';       }else{         while( $row = mysql_fetch_assoc( $selectres ) ){           echo "<tr><td>{$row['name']}</td><td>{$row['addr1']}</td><td>{$row['addr2']}</td><td>{$row['mail']}</td></tr>\n";         }       }     ?>   </tbody> </table>     <?php   }  ?>

notes, cautions , caveats

your initial solution did not show obvious santisation of values before passing them database. how sql injection attacks (or un-intentional errors being passed through sql) occur. don't it!

your database not seem have primary key. whilst these not, technically, necessary in usage, practice, , make more reliable way of referring specific row in table, whether adding related tables, or making changes within table.

you need check every action, @ every stage, errors. php functions nice enough have response return under error condition. job check conditions go - never assume php expect, how expect, , in order expect. how accident happen...

my provided code above contains alot of points where, if error has occured, message returned. try it, see if error messages reported, @ error message, and, if applicable, error code returned , research.

good luck.


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc...
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use...
Read more