Guest User

HOOOOOOOLA

a guest
Feb 13th, 2017
41
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. <?php
  2. $servername = "127.0.0.1:3307"; /*La direccion de tu server*/
  3. $username = "root";/*El user pa ingresar a la base*/
  4. $password = "root";/*La contra para acceder a la base*/
  5. $dbname = "dbo";/*El nombre de la base de datos*/
  6.  
  7. // Create connection
  8. $conn = mysqli_connect($servername, $username, $password, $dbname);
  9. // Check connection
  10. if (!$conn) {
  11. die("Connection failed: " . mysqli_connect_error());
  12. }
  13.  
  14.  
  15.  
  16. $magia = "capybara";
  17. $sql = "SELECT * FROM alta";
  18.  
  19.  
  20. $result = mysqli_query($conn, $magia);
  21. $result_sql = mysqli_query($conn, $sql);
  22.  
  23. if (isset($_POST['valorCaja1'])){
  24. $comprobacion = $_POST['valorCaja1'] == $magia;
  25. }
  26. else{}
  27.  
  28. if($comprobacion == TRUE)
  29. {
  30. echo "acertaste";
  31. if (mysqli_num_rows($result_sql) > 0) {
  32.  
  33. echo "<form><select>";
  34. while($row = mysqli_fetch_assoc($result_sql)) {
  35.  
  36. echo " <option background='red'>".$row['Nombre']."</option>";
  37. }
  38. echo "</select></form>";
  39. }
  40. }
  41. else{
  42. echo "fallaste";
  43. }
  44. mysqli_close($conn);
  45.  
  46.  
  47. ?>
Add Comment
Please, Sign In to add comment