Page 2 of 2
Posted: Sun Nov 06, 2005 7:13 pm
by yum-jelly
Just change this....
Code: Select all
$zeile=mysql_fetch_array($result);
echo "{$zeile['eqdes']} - {$zeile['designer']} - {$zeile['value']} - {$zeile['beschreibung']} - {$zeile['eqdesignation']}";
mysql_close();
?>
To this...
Code: Select all
if ( mysql_num_rows ( $result ) > 0 )
{
while ( $zeile = mysql_fetch_assoc ( $result ) )
{
echo "{$zeile['eqdes']} - {$zeile['designer']} - {$zeile['value']} - {$zeile['beschreibung']} - {$zeile['eqdesignation']}";
}
}
else
{
echo 'Query returned 0 rows';
}
mysql_close();
?>
yj
Posted: Sun Nov 06, 2005 7:39 pm
by joecrack
Yeah ... nice one - working ..
just one more thing
i want to delete a file:
Code: Select all
<html><body>
<?php
error_reporting(E_ALL);
$db = mysql_connect("localhost","root","") or die ("MySQL-Fehler: " . mysql_error());
mysql_select_db("safe",$db) or die ("MySQL-Fehler: " . mysql_error());
$sql = "SELECT * FROM sam_artikel" or die ("MySQL-Fehler: " . mysql_error());
$result=mysql_query($sql) or die(mysql_error());
if ( mysql_num_rows ( $result ) > 0 )
{
while ( $zeile = mysql_fetch_assoc ( $result ) )
{
echo "<p>{$zeile['eqdes']} - {$zeile['designer']} - {$zeile['value']} - {$zeile['beschreibung']} - {$zeile['eqdesignation']}</p>";
}
}
else
{
echo 'Query returned 0 rows';
}
if ($knopf && $knopf=="delete"){
if ($_POST['number'] != ""){
@delete($_POST['number'],$db);
}
}
mysql_close();
?>
<br><br>Welchen Artikel wollen Sie löschen? Geben Sie bitte die id ein:<br><br>
<form method="post">
<input type="text" name="number" length="3">
<input type="submit" name="knopf" value="delete">
</body>
</html>
Something is still wrong!
Posted: Sun Nov 06, 2005 8:05 pm
by yum-jelly
Change this....
Code: Select all
if ($knopf && $knopf=="delete"){
if ($_POST['number'] != ""){
@delete($_POST['number'],$db);
}
}
To this....
Code: Select all
if ( isset ( $_POST['knopf'] ) && $_POST['knopf'] == 'delete' )
{
if ( isset ( $_POST['number'] ) && intval ( $_POST['number'] ) != 0 )
{
$sql = "DELETE FROM sam_artikel WHERE column_id = " . intval ( $_POST['number'] );
mysql_query ( $sql ) or die ( 'MySQL-Fehler: ' . mysql_error () );
}
}
Then....
Change * column_id * in my code to the * column_name in your database * that contains the * id * to delete by!
yj
Posted: Sun Nov 06, 2005 8:22 pm
by joecrack
*** OMG ***
PERFEKT
THANK YOU SO MUCH
Posted: Sun Nov 06, 2005 8:36 pm
by joecrack
OHHH one more thing ...
the files that i want to delete are not just numbers ...
some files are also named dss or something like that ..
with the delete script i use now i can only delete numbers !!!
Posted: Sun Nov 06, 2005 11:10 pm
by yum-jelly
Ok then change this....
Code: Select all
if ( isset ( $_POST['knopf'] ) && $_POST['knopf'] == 'delete' )
{
if ( isset ( $_POST['number'] ) && intval ( $_POST['number'] ) != 0 )
{
$sql = "DELETE FROM sam_artikel WHERE column_id = " . intval ( $_POST['number'] );
mysql_query ( $sql ) or die ( 'MySQL-Fehler: ' . mysql_error () );
}
}
to this....
Code: Select all
if ( isset ( $_POST['knopf'] ) && $_POST['knopf'] == 'delete' )
{
if ( isset ( $_POST['number'] ) && trim ( $_POST['number'] ) != '' )
{
$sql = "DELETE FROM sam_artikel WHERE column_id = '" . mysql_real_escape_string ( $_POST['number'] ) . "'";
mysql_query ( $sql ) or die ( 'MySQL-Fehler: ' . mysql_error () );
}
}
Then like before....
Change * column_id * in my code to the * column_name in your database * that contains the * id * to delete by!
yj
Posted: Mon Nov 07, 2005 12:54 am
by joecrack
hmmmm
no thats not working
i chaged it like this:
Code: Select all
if ( isset ( $_POST['knopf'] ) && $_POST['knopf'] == 'delete' )
{
if ( isset ( $_POST['number'] ) && trim ( $_POST['number'] ) != '' )
{
$sql = "DELETE FROM sam_artikel WHERE eqdes = '" . mysql_real_escape_string ( $_POST['number'] ) . "'";
}
}
now its not deleten anything ...
not even numbers...=(
Posted: Mon Nov 07, 2005 6:58 am
by yum-jelly
Maybe your PHP version is old!
in my code change this....
Code: Select all
mysql_real_escape_string ( $_POST['number'] )
to this....
yj
Posted: Mon Nov 07, 2005 7:43 am
by feyd
mysql_real_escape_string() (when using MySQL) is suggested over using addslashes()