3avLRMrs

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
10if ($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
16if ($conn->query($sql) === TRUE) {
17    echo "New record created successfully";
18} else {
19    echo "Error: " . $sql . "<br>" . $conn->error;
20}
21
22
23for ($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?>