Mam problem z moim kodem, który niestety był przerabainy przez kilka osóbi po ostatnich zmianach przestał działać. Chciałbym prosić o pomoc w znalezieniu błędu
CODE
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html dir="ltr" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Database</title>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<meta name="description" content="Ressel" />
<meta http-equiv="Content-Language" content="en" />
<meta name="keywords" content="" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link href="style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" media="screen, print, handheld" type="text/css" href="calendar.css" />
<script type="text/javascript" src="calendar.js"></script>
</head>
<body>
<div id="right_col">
<span class="link_home"><a href="index.html">Home</a></span><br>
<span class="link_about"><a href="About us.html">About us</a></span><br>
<span class="link_services"><a href="Services.html">Services</a></span><br>
<span class="link_gallery"><a href="Gallery.html">Calendar</a></span><br>
<span class="link_ref"><a href="References.html">References</a></span><br>
<span class="link_diplomas"><a href="Database.php">Database</a></span><br>
<span class="link_courses"><a href="Courses.html">Courses</a></span><br>
<span class="link_awards"><a href="Awards.html">Awards</a></span><br>
<span class="link_contact"><a href="Contact.html">Contact</a></span><br>
</div>
<div id="page_content">
<br>
<?php
$connection = @mysql_connect('mysql.sh192531.website.pl', 'sh192531_user2', 'Michal13')
or die('MySQL connection ERROR !<br />Error: '.mysql_error());
echo "Connected to MySQL!<br />";
$db = @mysql_select_db('sh192531_mysql', $connection)
or die('Database connection ERROR !<br />Error: '.mysql_error());
echo "Connected to database!<br />";
$wykonaj = mysql_query("SET charset utf8");
echo "<br /><br />";
$zapytanie = "SELECT IdPracownika, Imie, Nazwisko, Nrtelefonu FROM Pracownik BY LAST ASC";
$wykonaj = mysql_query($zapytanie);
$znaleziono = mysql_num_rows($wykonaj);
if ($znaleziono == "0") {
print "No records has been found";
}
else {
print "Found $znaleziono record(s), ordered by last name <br>";
echo "Overall view";
}
?>
<style type="text/css">
.auto-style1 {
text-align: center;
}
.auto-style2 {
color: #FF0000;
}
.auto-style3 {
background-color: #1AFFE5;
}
</style>
<table border="1">
<tr>
<th style="height: px; text-transform:uppercase;" class="auto-style2">IdPracownika</th>
<th style="height: px; text-transform:uppercase;" class="auto-style2">Imie</th>
<th style="height: px; text-transform:uppercase;" class="auto-style2">Nazwisko</th>
<th style="height: px; text-transform:uppercase;" class="auto-style2">Nrtelefonu</th>
</tr>
<?php
while ($row = mysql_fetch_array($wykonaj)) {
echo "<tr><td>".$row{'IdPracownika'}."</td><td>".$row{'Imie'}."</td><td>".$row{'Nazwisko'}."</td><td>".$row{'Nrtelefonu'}."</td></tr>";
}
echo "</table>";
?>
<?php
//usuwanie
if(isset($_POST['form1'])) {
switch($_POST['form1']){
case '10' : {
if(!empty($_POST['Nazwisko']))
{
$Nazwisko=$_POST['Nazwisko'];
if(isset($_POST['submit1'])) {
$zapytanie3 = "DELETE FROM `Pracownik` WHERE `Nazwisko` = '$Nazwisko'";
mysql_query($zapytanie3) or die(mysql_error());
print("$last1 has been deleted");
}
}
else
echo "Please write last name to delete.";
};
break;
//dodawanie
case '11' : {
if(!empty($_POST['IdPRacownika'])&&!empty($_POST['Imie'])&&!empty($_POST['Nazwisko'])&&!empty($_POST['Nrtelefonu'])&&!empty($_POST['IdBrygady']))
{
$IdPracownika=$_POST['IdPracownika'];
$Imie=$_POST['Imie'];
$Nazwisko=$_POST['Nazwisko'];
$Nrtelefonu=$_POST['Nrtelefonu'];
$IdBrygady=$_POST['IdBrygady'];
if(isset($_POST['submit11'])) {
$zapytanie2 = "INSERT INTO `Pracownik` (`IdPracownika`, `Nazwisko`,`Imie`,`Nrtelefonu`,`IdBrygady`) VALUES ('$id1, '$first1','$last11','$nr1','$teamid1')";
mysql_query($zapytanie2) or die(mysql_error());
print("Data has been added to the database");
}
}
else
echo "Please fill all boxes with texts";
};
break;
}
echo "<br />";
?>
<br />
//mysql_close($connection);
<br><br><br><br><br><br><br><br>
</div>
<div id="footer">
</div>
</body>
</html>
<html dir="ltr" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Database</title>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<meta name="description" content="Ressel" />
<meta http-equiv="Content-Language" content="en" />
<meta name="keywords" content="" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link href="style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" media="screen, print, handheld" type="text/css" href="calendar.css" />
<script type="text/javascript" src="calendar.js"></script>
</head>
<body>
<div id="right_col">
<span class="link_home"><a href="index.html">Home</a></span><br>
<span class="link_about"><a href="About us.html">About us</a></span><br>
<span class="link_services"><a href="Services.html">Services</a></span><br>
<span class="link_gallery"><a href="Gallery.html">Calendar</a></span><br>
<span class="link_ref"><a href="References.html">References</a></span><br>
<span class="link_diplomas"><a href="Database.php">Database</a></span><br>
<span class="link_courses"><a href="Courses.html">Courses</a></span><br>
<span class="link_awards"><a href="Awards.html">Awards</a></span><br>
<span class="link_contact"><a href="Contact.html">Contact</a></span><br>
</div>
<div id="page_content">
<br>
<?php
$connection = @mysql_connect('mysql.sh192531.website.pl', 'sh192531_user2', 'Michal13')
or die('MySQL connection ERROR !<br />Error: '.mysql_error());
echo "Connected to MySQL!<br />";
$db = @mysql_select_db('sh192531_mysql', $connection)
or die('Database connection ERROR !<br />Error: '.mysql_error());
echo "Connected to database!<br />";
$wykonaj = mysql_query("SET charset utf8");
echo "<br /><br />";
$zapytanie = "SELECT IdPracownika, Imie, Nazwisko, Nrtelefonu FROM Pracownik BY LAST ASC";
$wykonaj = mysql_query($zapytanie);
$znaleziono = mysql_num_rows($wykonaj);
if ($znaleziono == "0") {
print "No records has been found";
}
else {
print "Found $znaleziono record(s), ordered by last name <br>";
echo "Overall view";
}
?>
<style type="text/css">
.auto-style1 {
text-align: center;
}
.auto-style2 {
color: #FF0000;
}
.auto-style3 {
background-color: #1AFFE5;
}
</style>
<table border="1">
<tr>
<th style="height: px; text-transform:uppercase;" class="auto-style2">IdPracownika</th>
<th style="height: px; text-transform:uppercase;" class="auto-style2">Imie</th>
<th style="height: px; text-transform:uppercase;" class="auto-style2">Nazwisko</th>
<th style="height: px; text-transform:uppercase;" class="auto-style2">Nrtelefonu</th>
</tr>
<?php
while ($row = mysql_fetch_array($wykonaj)) {
echo "<tr><td>".$row{'IdPracownika'}."</td><td>".$row{'Imie'}."</td><td>".$row{'Nazwisko'}."</td><td>".$row{'Nrtelefonu'}."</td></tr>";
}
echo "</table>";
?>
<?php
//usuwanie
if(isset($_POST['form1'])) {
switch($_POST['form1']){
case '10' : {
if(!empty($_POST['Nazwisko']))
{
$Nazwisko=$_POST['Nazwisko'];
if(isset($_POST['submit1'])) {
$zapytanie3 = "DELETE FROM `Pracownik` WHERE `Nazwisko` = '$Nazwisko'";
mysql_query($zapytanie3) or die(mysql_error());
print("$last1 has been deleted");
}
}
else
echo "Please write last name to delete.";
};
break;
//dodawanie
case '11' : {
if(!empty($_POST['IdPRacownika'])&&!empty($_POST['Imie'])&&!empty($_POST['Nazwisko'])&&!empty($_POST['Nrtelefonu'])&&!empty($_POST['IdBrygady']))
{
$IdPracownika=$_POST['IdPracownika'];
$Imie=$_POST['Imie'];
$Nazwisko=$_POST['Nazwisko'];
$Nrtelefonu=$_POST['Nrtelefonu'];
$IdBrygady=$_POST['IdBrygady'];
if(isset($_POST['submit11'])) {
$zapytanie2 = "INSERT INTO `Pracownik` (`IdPracownika`, `Nazwisko`,`Imie`,`Nrtelefonu`,`IdBrygady`) VALUES ('$id1, '$first1','$last11','$nr1','$teamid1')";
mysql_query($zapytanie2) or die(mysql_error());
print("Data has been added to the database");
}
}
else
echo "Please fill all boxes with texts";
};
break;
}
echo "<br />";
?>
<br />
//mysql_close($connection);
<br><br><br><br><br><br><br><br>
</div>
<div id="footer">
</div>
</body>
</html>