Chce zrobić upload do z pliku txt bazy.czy ktoś z was mógł by mi powiedzieć jak to zrobić z góry dzięki za pomoc.
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Zmienna Predefiniowana $_FILES - by Arkadiusz WĹ‚odarczyk - videokurs.pl</title>
<style>
tr,td,th {padding: 10px; width:100px; text-align: center;border: 1px black solid;}
table {border: 1px black solid;}
</style>
</head>
<body>
<?php
$mysqlConnection = @mysql_connect("localhost", "tomaszko_cms", "pBCQfohqTS") or die(mysql_error());
mysql_select_db("tomaszko_cms") or die(mysql_error());
mysql_set_charset("utf8");
?>
</table>
</form>
<br /><br />
<form action="index.php" method="post" enctype="multipart/form-data">
<div>
<input type="hidden" name="MAX_FILE_SIZE" value="30720" />
<input type="file" name="plik" />
<input type="submit" value="Dodaj plik" />
</div>
</form>
<?php
if(isset($_FILES['plik']))
{
@print_r($_FILES['plik']);
@move_uploaded_file($_FILES['plik']['tmp_name'], "nazwa.txt" );
switch($_FILES['plik']['error'])
{
case 0:
echo "plik został pomyślnie zuploadowany";
break;
case 1:
echo "Za duĹĽy plik (php.ini)";
break;
case 2:
echo "Za duĹĽy plik";
break;
case 3:
echo "Niepełny plik";
break;
case 4:
echo "Nie wybrano pliku";
break;
default:
echo "BĹ‚Ä…d ktĂłrego nie przewidziano prosimy o kontakt";
}
}
?>
<h1>Lista rekordĂłw</h1>
<form action="index.php" method="post">
<table>
<tr>
<th>ID</th><th>Email</th><th></th>
</tr>
<?php
$nazwaPliku = "nazwa.txt";
$wskaznik = @fopen($nazwaPliku, "a+");
if ($wskaznik)
{
$query = "INSERT INTO email_baza (email) VALUES ('".$_POST['email2']."')";
mysql_query($query) or die(mysql_error());
}
else
{
echo "Nie ma takiego pliku";
}
@fclose($wskaznik);
?>
<?php
if(isset($_GET['usun']))
{
$query = "DELETE FROM email_baza WHERE id = '".$_GET['id']."'";
mysql_query($query) or die(mysql_error());
}
/*if(isset($_POST['dodaj']))
{
$query = "INSERT INTO email_baza (email) VALUES ('".$_POST['email2']."')";
mysql_query($query) or die(mysql_error());
}*/
if(isset($_POST['aktualizuj']))
{
$query = "UPDATE email_baza SET email = '".$_POST['email3']."'";
mysql_query($query) or die(mysql_error());
}
?>
<?php
$query = "SELECT * FROM email_baza";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
echo "<tr>";
echo "<td>".$row['id']."</td>"."<td>".$row['email']."</td>"."<td>"."<a href='?usun=1&id=".$row['id']."'>Usun</a> <a href='?edytuj=1&id=".$row['id']."'>Edytuj</a>"."</td>";
echo "</tr>";
}
?>
<tr>
<td><strong>Dodawanie</strong></td><td><input type='text' name='email2'></td><td><input type='submit' name='dodaj' value='Dodaj'></td>
</tr>
<?php
if(isset($_GET['edytuj']))
{
$query = "SELECT * FROM email_baza WHERE id='".$_GET['id']."'";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
echo'
<tr>
<td><strong>Edycja</strong><input style="display:none;" type="text" name="id3" value="'.$row['id'].'"></td><td><input type="text" name="email3" value="'.$row['email'].'"></td><td><input type="submit" name="aktualizuj" value="Aktualizuj"></td>
</tr>';
}
}
mysql_close($mysqlConnection);
?>
</body>
</html>