Conectar con base de datos
Este sería el código que propone la web
https://www.hostinger.es/tutoriales/como-usar-php-para-insertar-datos-en-mysql/
<?php
$servername = "mysql.hostinger.co.uk";
$database = "u266072517_name";
$username = "u266072517_user";
$password = "buystuffpwd";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
$sql = "INSERT INTO Students (name, lastname, email) VALUES ('Thom', 'Vial', 'thom.v@some.com')";
if (mysqli_query($conn, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>
El código que yo he metido ha sido:
<?php
echo"<script>alert('Usted esta siendo redireccionado a la pagina principal')</script>";
$host = "PMYSQL126.dns-servicio.com:3306";
$database = "7456898_general";
$username = "accesogeneral";
$password = "entradas27^27";
$conexion = mysqli_connect($host, $username, $password) or die("Problemas de conexión");
echo"<script>alert('punto 3')</script>";
mysqli_select_db($conexion,"7456898_general") or die ("Problemas al conectar Base de datos");
$nom = $_POST['nom'];
$sql = "INSERT INTO tablabase (nombregeneral) VALUES ('$nom')";
if (mysqli_query($conexion, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conexion);
}
mysqli_close($conexion);
?>
Si quiero ver el valor de variables uso echo:
echo $host;
echo $database;
echo $username;
echo $password;
Si quiero que meta un texto uso:
echo"<script>alert('punto 4')</script>";
https://www.hostinger.es/tutoriales/como-usar-php-para-insertar-datos-en-mysql/
<?php
$servername = "mysql.hostinger.co.uk";
$database = "u266072517_name";
$username = "u266072517_user";
$password = "buystuffpwd";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
$sql = "INSERT INTO Students (name, lastname, email) VALUES ('Thom', 'Vial', 'thom.v@some.com')";
if (mysqli_query($conn, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>
El código que yo he metido ha sido:
<?php
echo"<script>alert('Usted esta siendo redireccionado a la pagina principal')</script>";
$host = "PMYSQL126.dns-servicio.com:3306";
$database = "7456898_general";
$username = "accesogeneral";
$password = "entradas27^27";
$conexion = mysqli_connect($host, $username, $password) or die("Problemas de conexión");
echo"<script>alert('punto 3')</script>";
mysqli_select_db($conexion,"7456898_general") or die ("Problemas al conectar Base de datos");
$nom = $_POST['nom'];
$sql = "INSERT INTO tablabase (nombregeneral) VALUES ('$nom')";
if (mysqli_query($conexion, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conexion);
}
mysqli_close($conexion);
?>
Si quiero ver el valor de variables uso echo:
echo $host;
echo $database;
echo $username;
echo $password;
Si quiero que meta un texto uso:
echo"<script>alert('punto 4')</script>";
Comentarios
Publicar un comentario