balkan7 Posted October 30, 2006 Share Posted October 30, 2006 Parse error: parse error, unexpected $end in C:\web\5\index.php on line 380index.php[code]<?php//------------------------------------------//database connectionmysql_connect("localhost", "root", "123450") or die(mysql_error());mysql_select_db("dzeki") or die(mysql_error());//end database connection//------------------------------------------//------------------------------------------//echo out a navigation panelecho "<center><a href='index.php'>Pregled na Kategoerii</a> | <a href='index.php?akcija=dodaj'>Dodaj SoftwareAdd Tutorial</a></center>";//------------------------------------------//------------------------------------------//begin main navigation (tutorials.php?action=)switch($_GET['action']){ //------------------------------------------ //this case adds a tutorial. //pretty self-explanitory //------------------------------------------ case "dodaj": //if the form to enter a new //tutorial hasn't been submitted, //show it if(!isset($_POST['dodaj'])) { echo " <table border='0' cellpadding='0' cellspacing='0' width='500'> <form action='$self?akcija=dodaj' method='post'> <tr> <td>Sifra:</td> <td><input type='text' name='sifra'></td> </tr> <tr> <td>Naslov:</td> <td><input type='text' name='naslov'></td> </tr> <tr> <td>Opis:</td> <td><textarea name='opis' cols='40' rows='5'></textarea></td> </tr> <tr> <td>Kategorija:</td> <td> <select name='kategorija'> "; //now what we are doing here is looping through //the categorys table and getting all the //categorys and putting them into a select //so the user can select which category //the tutorial is on $query = mysql_query("SELECT * FROM software_kategorija ORDER BY id ASC") or die(mysql_error()); while($row = mysql_fetch_array($query)) { echo "<option>- Izberi -</option>"; echo "<option value='$row[id]'>$row[kategorija]"; } echo " </select> </td> </tr> <tr> <td>CD & DVD:</td> <td> <select name='cd'> "; //now what we are doing here is looping through //the categorys table and getting all the //categorys and putting them into a select //so the user can select which category //the tutorial is on $query = mysql_query("SELECT * FROM software_cd ORDER BY id ASC") or die(mysql_error()); while($row = mysql_fetch_array($query)) { echo "<option>- Izberi CD -</option>"; echo "<option value='$row[id]'>$row[cd]"; } echo " </select> </td> </tr> <tr> <td>Novo?</td> <td><input type='checkbox' name='novo' value='1' checked></td> </tr> <tr> <td colspan='2'><center><input type='submit' name='dodaj' value='Submit New Software'></center></td> </tr> </form> </table> ";}//else, error check, enter itelseif(isset($_POST['dodaj'])){ $name = mysql_real_escape_string(strip_tags($_POST['name'])); $naslov = mysql_real_escape_string(strip_tags($_POST['naslov'])); $opis = mysql_real_escape_string(strip_tags($_POST['opis'])); $kategorija = mysql_real_escape_string(strip_tags($_POST['kategorija'])); $cd = mysql_real_escape_string(strip_tags($_POST['cd'])); $novo = mysql_real_escape_string($_POST['novo']); $datum = date("m/d/Y"); //we begin error checking.... $error_msg = array(); if(empty($name)) { $error_msg[] = "Please insert a name!<br />"; } if(empty($naslov)) { $error_msg[] = "Please insert a naslov!<br />"; } if(empty($opis)) { $error_msg[] = "Please insert a opis!<br />"; } if(empty($kategorija)) { $error_msg[] = "Please insert a kategorija!<br />"; } if(empty($cd)) { $error_msg[] = "Please select CD!<br />"; } //print the errors, if any if(count($error_msg)>0) { echo "<strong>ERROR:</strong><br>\n"; foreach($error_msg as $err) echo "$err"; } //everythings ok, insert it to the DB else { $sql = "INSERT INTO software (sifra, naslov, opis, kat_id, cd_id, novo, datum, validen) VALUES ('$sifra', '$naslov', '$opis', '$kat_id', '$cd_id', '$novo', '$datum', '0')"; mysql_query($sql) or die(mysql_error()); echo "Softwerot e uspesno dodaden, za pregled!"; } } break; //------------------------------------------ //this case gets the specified [ID] in the url //(tutorials.php?action=viewcategory&id=[ID] //and gets all the tutorials listed under that //category ID (cat_id) //------------------------------------------ case "pregled": //if there is an ID given... if($_GET['id']) { //get the id, put it into a variable, cast to an INT //(for security purposes) $id = (int)$_GET['id']; $query = mysql_query("SELECT * FROM software WHERE kat_id = '$id' AND validen = '1'") or die(mysql_error()); //if no results, show that there are no tutorials //for that category if(mysql_num_rows($query) == 0) { echo "Nema software vo ovaa Kategorija!"; } //else, there is..show em else { echo "<h1>Softwares</h1>"; //loop through the tutorials //show all tutorials echo "<table border='0' cellpadding='0' cellspacing='0' width='500'>"; while($row = mysql_fetch_array($query)) { echo " <tr> <td>Sifra:</td> <td><b>$row[sifra]</b></td> </tr> <tr> <td>Naslov:</td> <td><b>$row[naslov]</b></td> </tr> <tr> <td>Opis:</td> <td>$row[opis]</td> </tr> <tr> <td>Kategorija:</td> <td>$row[kat_id]</td> </tr> <tr> <td>CD & DVD:</td> <td>$row[cd_id]</td> </tr> <tr> <td>Novo:</td> <td>$row[novo]</td> </tr> <tr> <td>Datum:</td> <td>$row[datum]</td> </tr> <tr> <td>Izmeni:</td> <td colspan='2'><b><a href='$self?akcija=izmeni&id=$row[id]'>Izmeni</a></b></td> </tr> <tr> <td colspan='2'><hr /></td> </tr> "; } echo "</table>"; }}else{ echo "Momentalno nema Softwares!";}break;//------------------------------------------//this case gets the given [ID]//action=viewtutorial&id=[ID]//and gets that tutorial ID from the database//and displays it!//------------------------------------------case "izmeni"://if there is an ID given..if($_GET['id']){ //set $id to the URL id, cast to an INT //for security purposes $id = (int)$_GET['id']; //query the database $query = mysql_query("SELECT * FROM software WHERE id = '$id'") or die (mysql_error()); //if no rows returned... if(mysql_num_rows($query) == 0) { echo "That ID is not in the database!"; } //else, show it! else { //update the views for this tutorial! $popravi = mysql_query("UPDATE software SET naslov = '$naslov', opis = '$opis', kat_id = '$kat_id', cd_id = '$cd_id', novo = '$novo' WHERE id = '$id'") or die(mysql_error()); //loop through the database while($row = mysql_fetch_array($query)) { echo " <table border='0' cellpadding='0' cellspacing='0' width='500' style='border: 1px solid black; padding: 3px;'> <tr> <td colspan='2'>Software: <b>$row[naslov]</b></td> </tr> <tr> <td>Naslov:</td> <td><input type='text' name='naslov' value='$row[naslov]'></td> <tr> <td>Opis:</td> <td><textarea name='opis' cols='40' rows='5' value='$row[opis]'></textarea></td> </tr> <tr> <td>Kategorija:</td> <td> <select name='kategorija'> "; //now what we are doing here is looping through //the categorys table and getting all the //categorys and putting them into a select //so the user can select which category //the tutorial is on $query = mysql_query("SELECT * FROM software_kategorija ORDER BY id ASC") or die(mysql_error()); while($row = mysql_fetch_array($query)) { echo "<option>- Izberi -</option>"; echo "<option value='$row[id]'>$row[kategorija]"; } echo " </select> </td> </tr> <tr> <td>CD & DVD:</td> <td> <select name='cd'> "; //now what we are doing here is looping through //the categorys table and getting all the //categorys and putting them into a select //so the user can select which category //the tutorial is on $query = mysql_query("SELECT * FROM software_cd ORDER BY id ASC") or die(mysql_error()); while($row = mysql_fetch_array($query)) { echo "<option>- Izberi CD -</option>"; echo "<option value='$row[id]'>$row[cd]"; } echo " </select> </td> </tr> <tr> <td>Novo?</td> <td><input type='checkbox' name='novo' value='1' checked></td> </tr> <tr> <td colspan='2'><center><input type='submit' name='izmeni' value='Submit New Software'></center></td> </tr> </form> </table> </tr> <tr> <td colspan='2' style='border: 1px solid black;'><center><b>Software</b></center><br />$row[text]</td> </tr> <tr> "; } //---------------------------- //this part of the code //checks to see if the submitter //wants an email left for support //---------------------------- $new = "Novo"; if($row['novo'] == 1) { echo $new; } echo " </tr> <tr> <td><hr /></td> </tr> "; }//------------------------------------------//default case, this is shown default//in this instance, we are going to make the default case show//all the categories that you can view tutorials on//------------------------------------------$query = mysql_query("SELECT * FROM software_kategorija") or die(mysql_error());//if the number of rows returned is 0, then say, no categoriesif(mysql_num_rows($query) == 0){ echo "Nema Kategorii!";}//if anything else, then there has to be categories. show em.else{ echo "<h1>Software Kategorii:</h1> "; //while loop to loop through the database and display results! while($row = mysql_fetch_array($query)) { echo " <table border='0' cellpadding = '0' cellspacing='0' width='500'> <tr> <td>Ime za Kategorija:</td> <td>$row[kategorija]</td> </tr> <tr> <td><a href='$self?akcija=pregled&id=$row[id]'>Pogedni ja Kategorijata</a></td> </tr> <tr> <td><hr /></td> </tr> </table> "; } } break; } //end navigation //------------------------------------------ ?> [/code] Link to comment https://forums.phpfreaks.com/topic/25640-resolved-what-im-missing/ Share on other sites More sharing options...
Demonic Posted October 31, 2006 Share Posted October 31, 2006 There isnt even a line 380 anyways here this should be fixed.[code]<?php//------------------------------------------//database connectionmysql_connect("localhost", "root", "123450") or die(mysql_error());mysql_select_db("dzeki") or die(mysql_error());//end database connection//------------------------------------------//------------------------------------------//echo out a navigation panelecho "<center><a href='index.php'>Pregled na Kategoerii</a> | <a href='index.php?akcija=dodaj'>Dodaj SoftwareAdd Tutorial</a></center>";//------------------------------------------//------------------------------------------//begin main navigation (tutorials.php?action=)switch($_GET['action']){ //------------------------------------------ //this case adds a tutorial. //pretty self-explanitory //------------------------------------------ case "dodaj": //if the form to enter a new //tutorial hasn't been submitted, //show it if(!isset($_POST['dodaj'])) { echo " <table border='0' cellpadding='0' cellspacing='0' width='500'> <form action='$self?akcija=dodaj' method='post'> <tr> <td>Sifra:</td> <td><input type='text' name='sifra'></td> </tr> <tr> <td>Naslov:</td> <td><input type='text' name='naslov'></td> </tr> <tr> <td>Opis:</td> <td><textarea name='opis' cols='40' rows='5'></textarea></td> </tr> <tr> <td>Kategorija:</td> <td> <select name='kategorija'> "; //now what we are doing here is looping through //the categorys table and getting all the //categorys and putting them into a select //so the user can select which category //the tutorial is on $query = mysql_query("SELECT * FROM software_kategorija ORDER BY id ASC") or die(mysql_error()); while($row = mysql_fetch_array($query)) { echo "<option>- Izberi -</option>"; echo "<option value='$row[id]'>$row[kategorija]"; } echo " </select> </td> </tr> <tr> <td>CD & DVD:</td> <td> <select name='cd'> "; //now what we are doing here is looping through //the categorys table and getting all the //categorys and putting them into a select //so the user can select which category //the tutorial is on $query = mysql_query("SELECT * FROM software_cd ORDER BY id ASC") or die(mysql_error()); while($row = mysql_fetch_array($query)) { echo "<option>- Izberi CD -</option>"; echo "<option value='$row[id]'>$row[cd]"; } echo " </select> </td> </tr> <tr> <td>Novo?</td> <td><input type='checkbox' name='novo' value='1' checked></td> </tr> <tr> <td colspan='2'><center><input type='submit' name='dodaj' value='Submit New Software'></center></td> </tr> </form> </table> ";}//else, error check, enter itelseif(isset($_POST['dodaj'])){ $name = mysql_real_escape_string(strip_tags($_POST['name'])); $naslov = mysql_real_escape_string(strip_tags($_POST['naslov'])); $opis = mysql_real_escape_string(strip_tags($_POST['opis'])); $kategorija = mysql_real_escape_string(strip_tags($_POST['kategorija'])); $cd = mysql_real_escape_string(strip_tags($_POST['cd'])); $novo = mysql_real_escape_string($_POST['novo']); $datum = date("m/d/Y"); //we begin error checking.... $error_msg = array(); if(empty($name)) { $error_msg[] = "Please insert a name!<br />"; } if(empty($naslov)) { $error_msg[] = "Please insert a naslov!<br />"; } if(empty($opis)) { $error_msg[] = "Please insert a opis!<br />"; } if(empty($kategorija)) { $error_msg[] = "Please insert a kategorija!<br />"; } if(empty($cd)) { $error_msg[] = "Please select CD!<br />"; } //print the errors, if any if(count($error_msg)>0) { echo "<strong>ERROR:</strong><br>\n"; foreach($error_msg as $err) echo "$err"; } //everythings ok, insert it to the DB else { $sql = "INSERT INTO software (sifra, naslov, opis, kat_id, cd_id, novo, datum, validen) VALUES ('$sifra', '$naslov', '$opis', '$kat_id', '$cd_id', '$novo', '$datum', '0')"; mysql_query($sql) or die(mysql_error()); echo "Softwerot e uspesno dodaden, za pregled!"; } } break; //------------------------------------------ //this case gets the specified [ID] in the url //(tutorials.php?action=viewcategory&id=[ID] //and gets all the tutorials listed under that //category ID (cat_id) //------------------------------------------ case "pregled": //if there is an ID given... if($_GET['id']) { //get the id, put it into a variable, cast to an INT //(for security purposes) $id = (int)$_GET['id']; $query = mysql_query("SELECT * FROM software WHERE kat_id = '$id' AND validen = '1'") or die(mysql_error()); //if no results, show that there are no tutorials //for that category if(mysql_num_rows($query) == 0) { echo "Nema software vo ovaa Kategorija!"; } //else, there is..show em else { echo "<h1>Softwares</h1>"; //loop through the tutorials //show all tutorials echo "<table border='0' cellpadding='0' cellspacing='0' width='500'>"; while($row = mysql_fetch_array($query)) { echo " <tr> <td>Sifra:</td> <td><b>$row[sifra]</b></td> </tr> <tr> <td>Naslov:</td> <td><b>$row[naslov]</b></td> </tr> <tr> <td>Opis:</td> <td>$row[opis]</td> </tr> <tr> <td>Kategorija:</td> <td>$row[kat_id]</td> </tr> <tr> <td>CD & DVD:</td> <td>$row[cd_id]</td> </tr> <tr> <td>Novo:</td> <td>$row[novo]</td> </tr> <tr> <td>Datum:</td> <td>$row[datum]</td> </tr> <tr> <td>Izmeni:</td> <td colspan='2'><b><a href='$self?akcija=izmeni&id=$row[id]'>Izmeni</a></b></td> </tr> <tr> <td colspan='2'><hr /></td> </tr> "; } echo "</table>"; }}else{ echo "Momentalno nema Softwares!";}break;//------------------------------------------//this case gets the given [ID]//action=viewtutorial&id=[ID]//and gets that tutorial ID from the database//and displays it!//------------------------------------------case "izmeni"://if there is an ID given..if($_GET['id']){ //set $id to the URL id, cast to an INT //for security purposes $id = (int)$_GET['id']; //query the database $query = mysql_query("SELECT * FROM software WHERE id = '$id'") or die (mysql_error()); //if no rows returned... if(mysql_num_rows($query) == 0) { echo "That ID is not in the database!"; } //else, show it! else { //update the views for this tutorial! $popravi = mysql_query("UPDATE software SET naslov = '$naslov', opis = '$opis', kat_id = '$kat_id', cd_id = '$cd_id', novo = '$novo' WHERE id = '$id'") or die(mysql_error()); //loop through the database while($row = mysql_fetch_array($query)) { echo " <table border='0' cellpadding='0' cellspacing='0' width='500' style='border: 1px solid black; padding: 3px;'> <tr> <td colspan='2'>Software: <b>$row[naslov]</b></td> </tr> <tr> <td>Naslov:</td> <td><input type='text' name='naslov' value='$row[naslov]'></td> <tr> <td>Opis:</td> <td><textarea name='opis' cols='40' rows='5' value='$row[opis]'></textarea></td> </tr> <tr> <td>Kategorija:</td> <td> <select name='kategorija'> "; //now what we are doing here is looping through //the categorys table and getting all the //categorys and putting them into a select //so the user can select which category //the tutorial is on $query = mysql_query("SELECT * FROM software_kategorija ORDER BY id ASC") or die(mysql_error()); while($row = mysql_fetch_array($query)) { echo "<option>- Izberi -</option>"; echo "<option value='$row[id]'>$row[kategorija]"; } echo " </select> </td> </tr> <tr> <td>CD & DVD:</td> <td> <select name='cd'> "; //now what we are doing here is looping through //the categorys table and getting all the //categorys and putting them into a select //so the user can select which category //the tutorial is on $query = mysql_query("SELECT * FROM software_cd ORDER BY id ASC") or die(mysql_error()); while($row = mysql_fetch_array($query)) { echo "<option>- Izberi CD -</option>"; echo "<option value='$row[id]'>$row[cd]"; } echo " </select> </td> </tr> <tr> <td>Novo?</td> <td><input type='checkbox' name='novo' value='1' checked></td> </tr> <tr> <td colspan='2'><center><input type='submit' name='izmeni' value='Submit New Software'></center></td> </tr> </form> </table> </tr> <tr> <td colspan='2' style='border: 1px solid black;'><center><b>Software</b></center><br />$row[text]</td> </tr> <tr> "; } //---------------------------- //this part of the code //checks to see if the submitter //wants an email left for support //---------------------------- $new = "Novo"; if($row['novo'] == 1) { echo $new; } echo " </tr> <tr> <td><hr /></td> </tr> "; }//------------------------------------------//default case, this is shown default//in this instance, we are going to make the default case show//all the categories that you can view tutorials on//------------------------------------------$query = mysql_query("SELECT * FROM software_kategorija") or die(mysql_error());//if the number of rows returned is 0, then say, no categoriesif(mysql_num_rows($query) == 0){ echo "Nema Kategorii!";}//if anything else, then there has to be categories. show em.else{ echo "<h1>Software Kategorii:</h1> "; //while loop to loop through the database and display results! while($row = mysql_fetch_array($query)) { echo " <table border='0' cellpadding = '0' cellspacing='0' width='500'> <tr> <td>Ime za Kategorija:</td> <td>$row[kategorija]</td> </tr> <tr> <td><a href='$self?akcija=pregled&id=$row[id]'>Pogedni ja Kategorijata</a></td> </tr> <tr> <td><hr /></td> </tr> </table> "; } } break; } } //end navigation //------------------------------------------ ?>[/code] Link to comment https://forums.phpfreaks.com/topic/25640-resolved-what-im-missing/#findComment-117043 Share on other sites More sharing options...
balkan7 Posted October 31, 2006 Author Share Posted October 31, 2006 thank you for help, i fix now ... Link to comment https://forums.phpfreaks.com/topic/25640-resolved-what-im-missing/#findComment-117050 Share on other sites More sharing options...
trq Posted October 31, 2006 Share Posted October 31, 2006 [quote]thank you for help, but now in index.php?akcija=dodaj show blank page ?[/quote]Im not sure what you think your code does but nowhere does a descision get made about what to do if $_GET['akcija'] == dodaj. Link to comment https://forums.phpfreaks.com/topic/25640-resolved-what-im-missing/#findComment-117052 Share on other sites More sharing options...
balkan7 Posted October 31, 2006 Author Share Posted October 31, 2006 yes thanks i forget for that, now fixed ... Link to comment https://forums.phpfreaks.com/topic/25640-resolved-what-im-missing/#findComment-117055 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.