Inserare date
Stefanescu Mihai 2 years ago PHP
Acest articol face parte din cursul Toate lectiile PHP.
Te poti inscrie la acest curs aici!
Pot fi inserate date intr-o baza de date folosind functia PHP query() si SQL INSERT.
Iata si un exemplu simplu de insert:
<?php
$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'parola';
$dbdb = "test";
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbdb);
if( !$conn ){
die('Nu ma pot conecta: ' . $conn->error());
}
$sql = 'INSERT INTO users(nume, adresa, varsta, data_inregistrarii) VALUES("Mihai", "str. x, nr. 73, bl.91, ap.314", 23, NOW() )';
$retval = $conn->query( $sql );
if( !$retval ){
die('Nu am putut insera datele in baza de date: ' . $conn->error());
}
echo "Succes!";
$conn->close();
?>
Intr-o aplicatie reala datele sunt preluate de la utilizator printr-un formular, sunt validate si sanitizate, iar mai apoi sunt introduse in baza de date.
In exemplul de mai jos verific daca avem magic quotes pornit (magic quotes era o functie care rezolva problema ghilimelelor din string-uri) folosind functia get_magic_quotes_gpc() , daca nu este activata folosim functiaaddslashes().
<html>
<head>
<title>Adaugare inregistrare in baza de date MySQL</title>
</head>
<body>
<?php
if( $_SERVER['REQUEST_METHOD'] === 'POST' ){
$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'parola';
$dbdb = 'test';
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbdb);
if( !$conn ){
die('Nu ma pot conecta: ' . $conn->error());
}
if( !get_magic_quotes_gpc() ){
$nume = addslashes($_POST['username']);
$adresa = addslashes ($_POST['adresa']);
}else{
$nume = $_POST['username'];
$adresa = $_POST['adresa'];
}
$varsta = $_POST['varsta'];
$sql = "INSERT INTO users(nume, adresa, varsta, data_inregistrarii) VALUES('{$nume}', '{$adresa}', '{$varsta}', NOW() )";
$retval = $conn->query( $sql );
if( !$retval ){
die('Nu pot introduce datele in baza de date: ' . $conn->error());
}
echo "Succes!";
$conn->close();
}else{
?>
<form action="<?php $_PHP_SELF ?>" method="POST">
<table width="400" border="0" cellspacing="1" cellpadding="2">
<tr>
<td width="100">Username</td>
<td><input name="username" type="text" placeholder='Username-ul dorit' /></td>
</tr>
<tr>
<td width="100">Adresa</td>
<td><input name="adresa" type="text" placeholder='Adresa curenta' /></td>
</tr>
<tr>
<td width="100">Varsta</td>
<td><input name="varsta" type="text" placeholder="Varsta ta" /></td>
</tr>
<tr>
<td width="100"> </td>
<td> <input type="submit" value="Inregistrare" /> </td>
</tr>
</table>
</form>
<?php
}
?>
</body>
</html>
Get in touch
Pentru nelamuriri, dubii, comentarii si chestii de pe suflet ne putem auzi pe Discord, Reddit sau poti deschide o discutie noua pe forum
Want some Lantus insulin for cheap? The internet's got your back
#
5 months ago
Buy Glimepiride Online without a Doctor's Prescription Buy affordable
Glyburide online without prescription for diabetes
Buy insulin online without prescription Best place to
buy Metformin online
WOW just what I was searching for. Came here by searching for Best hair
loss vitamins for women
order fenofibrate sale <a href="https://fenoficor.com/">buy generic fenofibrate</a> tricor generic
ketotifen order online <a href="https://tofobose.com/">buy imipramine without a prescription</a> tofranil over the counter
how to buy minoxytop <a href="https://abcelemax.shop/">buy flomax for sale</a> buy generic ed pills for sale
acarbose 25mg without prescription <a href="https://tofobose.shop/">acarbose online buy</a> brand griseofulvin
dydrogesterone tablet <a href="https://janozin.shop/">buy dapagliflozin 10mg generic</a> order generic jardiance 25mg
This is the right website for everyone who hopes
to find out about this topic. You understand a whole lot its almost hard
to argue with you (not that I actually will need to…HaHa).
You certainly put a brand new spin on a topic that's been discussed for years.
Wonderful stuff, just excellent!
order florinef 100 mcg for sale <a href="https://acipolax.shop/">buy dulcolax without a prescription</a> buy loperamide 2mg without prescription
buy etodolac pills for sale <a href="https://benedolac.shop/">monograph where to buy</a> buy pletal 100 mg pills
order prasugrel without prescription <a href="https://imocarbam.shop/">prasugrel over the counter</a> buy detrol sale
mestinon usa <a href="https://aelimax.com/">order rizatriptan 10mg generic</a> order maxalt 10mg generic
ferrous 100 mg generic <a href="https://fertonel.com/">ferrous sulfate price</a> buy betapace 40 mg generic
order enalapril 5mg for sale <a href="https://casosin.shop/">doxazosin pill</a> order duphalac generic
zovirax uk <a href="https://aelimax.shop/">order latanoprost</a> order exelon generic
purchase betahistine pills <a href="https://duphstine.shop/">buy betahistine online</a> order benemid online
telmisartan for sale <a href="https://molnenil.shop/">order generic movfor</a> movfor for sale online
buy cenforce <a href="https://enapocen.com/">cenforce 50mg pills</a> order aralen 250mg for sale
🌪️ Discord
