Advertisement
Guest User

asd

a guest
Jun 20th, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.12 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "nombreusuario";
  4. $password = "tuclave";
  5. $dbname = "nombrebasedatos";
  6.  
  7. // Creas la conexion
  8. $conn = new mysqli($servername, $username, $password, $dbname);
  9. // Check connection
  10. if ($conn->connect_error) {
  11.     die("Connection failed: " . $conn->connect_error);
  12. }
  13.  
  14. $sql1 = "CREATE TABLE IF NOT EXISTS `nombretutabla' // Pones el codigo con que creas la tabla
  15.  
  16. if ($conn->query($sql) === TRUE) {
  17.    echo "New record created successfully";
  18. } else {
  19.    echo "Error: " . $sql . "<br>" . $conn->error;
  20. }
  21.  
  22.  
  23. for ($y = 0; $y<=$maxpersonas ; $y++){
  24.     $sql3 = "INSERT INTO nombretabla (firstname)
  25.     VALUES ('$nombre')";//ejemplo
  26.     if ($conn->query($sql3) === TRUE) {
  27.    echo "New record created successfully";
  28.     } else {
  29.    echo "Error: " . $sql . "<br>" . $conn->error;
  30.     }
  31.     for($x = 0; $x<=$maxnotas ; $x++){
  32.     $sql3 = "INSERT INTO nombretabla (nota)
  33.     VALUES ('$nota') WHERE firstname = $nombre";
  34.     if ($conn->query($sql3) === TRUE) {
  35.    echo "New record created successfully";
  36.     } else {
  37.    echo "Error: " . $sql . "<br>" . $conn->error;
  38.     }
  39.     }
  40. }
  41.  
  42.  
  43. $conn->close();
  44. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement