Guest User

Untitled

a guest
May 20th, 2018
272
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. This is the code.............
  2.  
  3. <?php
  4. $database_host = "localhost";
  5. $database_username = "£$%^$%^$£%^";
  6. $database_password = "$%£^£$%^$%^";
  7. $database_name = "$%^£$%^$%^";
  8.  
  9.  
  10. @mysql_connect($database_host, $database_username, $database_password) or die('Could not connect: ' . mysql_error());
  11.  
  12. mysql_select_db($database_name) or die(mysql_error());
  13.  
  14. $sqlstr = "SELECT * from members";
  15.  
  16. //var_dump($sqlstr);
  17.  
  18. $data = mysql_query($sqlstr);
  19. $result = mysql_fetch_array($data);
  20. var_dump($result);
  21.  
  22. ?>
  23.  
  24. This is the output.....
  25.  
  26.  
  27. array(16) {
  28. [0]=>
  29. string(8) "10009999"
  30. ["userid"]=>
  31. string(8) "10009999"
  32. [1]=>
  33. string(5) "Dusty"
  34. ["firstname"]=>
  35. string(5) "Dusty"
  36. [2]=>
  37. string(5) "Smith"
  38. ["lastname"]=>
  39. string(5) "Smith"
  40. [3]=>
  41. string(8) "ACME INC"
  42. ["company"]=>
  43. string(8) "ACME INC"
  44. [4]=>
  45. string(5) "dusty"
  46. ["username"]=>
  47. string(5) "dusty"
  48. [5]=>
  49. string(22) "dsmith@democompany.com"
  50. ["emailaddress"]=>
  51. string(22) "dsmith@democompany.com"
  52. [6]=>
  53. string(8) "password"
  54. ["password"]=>
  55. string(8) "password"
  56. [7]=>
  57. string(0) ""
  58. ["avatar"]=>
  59. string(0) ""
  60. }
Add Comment
Please, Sign In to add comment