Cod upload cu inregistrare in mysql
Scris: Sâm Noi 06, 2010
Am gasit codul acesta pe site la dvs.
l-am incarcat in ftp am creat baza de date:
Am facut un .htaccess
Cand dau trimitere imi incarca poza in fisier dar datele in baza de date nu.
Test:
I-am facut o conexiune dar, ce am gresit?
Cod: Selectaţi tot
<?php
if(isset($_POST['submit']))
{
$uploadpath = "imagini/"; // Directorul unde incarca pozele
$id=$_POST['id'];
$familie=$_POST['familie'];
$tata=$_POST['tata'];
$mama=$_POST['mama'];
$membri=$_POST['membri'];
$detalii=$_POST['detalii'];
$poza=$uploadpath. basename( $_FILES['poza']['name']);
$baieti=$_POST['baieti'];
$fete=$_POST['fete'];
if(strlen($familie)<1)
{
print "Nu este nici un membru!";
}
else
{
if(move_uploaded_file($_FILES['poza']['tmp_name'], $poza)) {
echo "Fisierul:<b> ". basename( $_FILES['poza']['name']). "</b> a fost incarcat cu succes:";
}
$addemail="Insert into membrii_bisericii(id, familie, tata, mama, membri, detalii, poza, baieti, fete) values('$id', '$familie', '$tata', '$mama', '$membrii', '$detalii', '$poza', '$baieti', '$fete')";
mysql_query($addemail) or die("NU se poate adauga!");
print "Membru adaugat! <a href='adaugare_familie.php'>Inapoi la adaugare!</a>";
}
}
else
{
print "<form action='adaugare_familie.php' method='post' enctype='multipart/form-data'>";
print "ID:<br>";
print "<input type='text' name='id' size='30'><br>";
print "Familie:<br>";
print "<input type='text' name='familie' size='30'><br>";
print "Tata:<br>";
print "<input type='text' name='tata' size='30'><br>";
print "Mama:<br>";
print "<input type='text' name='mama' size='30'><br>";
print "Membrii:<br>";
print "<input type='text' name='membri' size='30'><br>";
print "Baieti:<br>";
print "<input type='text' name='baieti' size='30'><br>";
print "Fete:<br>";
print "<input type='text' name='fete' size='30'><br>";
print "Poza:<br>";
print "<input type='file' name='poza'><br>";
print "Detalii:<br>";
print "<textarea name='detalii' cols='45' rows='3' id='detalii'></textarea><br>";
print "<input type='submit' name='submit' value='Adauga familie'></form>";
}
?>
Cod: Selectaţi tot
CREATE TABLE IF NOT EXISTS `membrii_bisericii` (
`id` int(3) NOT NULL auto_increment,
`familie` varchar(40) NOT NULL default '',
`tata` varchar(20) NOT NULL default '',
`mama` varchar(40) NOT NULL default '',
`membri` varchar(20) NOT NULL default '',
`detalii` varchar(500) NOT NULL default '',
`poza` varchar(5000) NOT NULL,
`baieti` varchar(40) NOT NULL default '',
`fete` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1292 ;
Cod: Selectaţi tot
Options +FollowSymLinks
RewriteEngine on
RewriteRule adaugare_familie.php index.php
Test:
Cod: Selectaţi tot
Fisierul: gfd.jpg a fost incarcat cu succes.NU se poate adauga!