[HTML][MySQL][PHP]Parse error: syntax error, unexpected $end

[HTML][MySQL][PHP]Parse error: syntax error, unexpected $end

dhevian Zobacz profil	31.05.2015, 20:16:38 Post #1
Grupa: Zarejestrowani Postów: 1 Pomógł: 0 Dołączył: 31.05.2015 Ostrzeżenie: (0%)	Witam, 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> Powód edycji: [Spawnm]: