Guest User

Untitled

a guest
Jan 13th, 2019
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. Need help connecting to my Mysql database on local server
  2. <?php
  3. include 'includes/databaseform.php';
  4. $query = "SELECT * FROM userchanel";
  5. $result = mysql_query($query);
  6. while($person = mysql_fetch_array($result));
  7. {
  8. echo $person['chanelurl'];
  9. }
  10. ?>
  11.  
  12. <?php
  13. $dbhost = 'localhost';
  14. $dbuser = 'root';
  15. $dbpass ='';
  16. $db = 'mysql_tut';
  17. $conn = mysql_connect($dbhost,$dbuser,$dbpas);
  18. mysql_select_db($userchanel);
  19. ?>
  20.  
  21. $conn = mysql_connect($dbhost,$dbuser,$dbpas);
  22.  
  23. $conn = mysql_connect($dbhost,$dbuser,$dbpass);
  24.  
  25. <?php
  26. $db = new PDO('mysql:dbname=databasename', 'username', 'password',
  27. array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
  28.  
  29. <?php
  30. include 'includes/databaseform.php';
  31. $query = $db->prepare("SELECT * FROM userchanel");
  32. $query->execute();
  33. while(($person = $query->fetch(PDO::FETCH_ASSOC)) !== false);
  34. {
  35. echo $person['chanelurl'];
  36. }
  37.  
  38. <?php
  39. include 'includes/databaseform.php';
  40. $query = $db->prepare("SELECT chanelurl FROM userchanel");
  41. $query->execute();
  42. while(($channelurl = $query->fetch(PDO::COLUMN)) !== false);
  43. {
  44. echo $channelurl;
  45. }
Add Comment
Please, Sign In to add comment