balkan7
-
Posts
234 -
Joined
-
Last visited
Everything posted by balkan7
-
thank you for help, i fix now ...
-
Parse error: parse error, unexpected $end in C:\web\5\index.php on line 380 index.php [code]<?php //------------------------------------------ //database connection mysql_connect("localhost", "root", "123450") or die(mysql_error()); mysql_select_db("dzeki") or die(mysql_error()); //end database connection //------------------------------------------ //------------------------------------------ //echo out a navigation panel echo " <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 it elseif(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 categories if(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]
-
here is values : [code]<input type="hidden" name="key" size="53" /> <input type="text" name="product" size="53" /> <textarea rows="4" cols="45" name="desc"></textarea> <input type="checkbox" name="new" value="new"> <select size="1" name="select"> <option value="A1">1</option> <option value="A2">2</option> <option value="A3">3</option> </select> <select size="1" name="category"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> </select> <form action="add.php" method="post"> <input type="submit" name="submit" value="submit"> <input type="reset" name="submit2" value="Clear"><br>[/code]
-
i have problem whit this code when i add product only mysql query KEY and Date for other values not take action ? [code]<?php if($_POST['submit']) { $db = mysql_connect("$dbhost", "$dbuser", "$dbpassword")or die("cannot connect server "); mysql_select_db("$dbname")or die("cannot select DB"); $product = addslashes($_POST['program']); $desc = addslashes($_POST['desc']); $select = addslashes($_POST['select']); $date = date("d/m/y h:i:s"); $new = addslashes($_POST['new']); $category = addslashes($_POST['category']); $string = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; $key = ""; for($i=0; $i<5; $i++){ $y = rand(0,strlen($string)-1); $key .= $string[$y]; } $sql = "INSERT INTO `products` (`id`, `key`, `product`, `desc`, `select`, `date`, `new`, `category`) VALUES ('', '$key', '$product', '$desc', '$select', '$date', '$new', '$category')" or die('insert into is wrong'); $result = mysql_query($sql,$db); print "Product Added Successfull.";} ?>[/code]
-
thank you, i was try whit include datebase but show me error, i fix now, thanks again.
-
Warning: Wrong parameter count for mysql_query() [code]$query = mysql_query ($dbname,"select * from top_cats order by catname",$db) or die (mysql_error());[/code]
-
can someone help me ?
-
view demo: [code]http://www.prerodbalab.org/test/index.php[/code] [code]http://www.prerodbalab.org/test/add.php[/code]
-
i have create litle script but i have just only table from datebase, so my problem is not take query values from fields in mysql, only show field key and date, and help me how to finish my litle script and create category for my products, here is competed script: base.sql [code]CREATE TABLE products ( id int(5) NOT NULL auto_increment, key varchar(25) NOT NULL default '', product varchar(65) NOT NULL default '', detail longtext NOT NULL, select varchar(65) NOT NULL default '', date varchar(25) NOT NULL default '', new varchar(25) NOT NULL default '', category varchar(65) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM AUTO_INCREMENT=1 ; [/code] config.php [code]<?php $dbhost = "localhost"; $dbname = "xxx"; $dbuser = "xxx"; $dbpassword = "xxx"; $title = "Products"; $add = "Add new Product"; $key1 = "Key"; $product1 = "Product"; $detail1 = "Detail"; $new1 = "New"; $select1 = "Select"; $category1 = "Category"; $date1 = "Date"; ?>[/code] index.php [code]<?php include("config.php"); // Connect to server and select database. $db = mysql_connect("$dbhost", "$dbuser", "$dbpassword")or die("cannot connect server "); mysql_select_db("$dbname")or die("cannot select DB"); $sql = "SELECT * FROM products ORDER BY id DESC"; $result = mysql_query($sql,$db) or die(mysql_error()); ?> <html> <head> <meta http-equiv="Content-Language" content="en-us"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title><?php echo $title; ?></title> </head> <body bgcolor="#C0C0C0"> <div align="center"> <table border="1" width="90%" style="border-left-style: solid; border-left-width: 2px; border-right: 2px solid #FFFFFF; border-top-style: solid; border-top-width: 2px; border-bottom: 2px solid #FFFFFF" cellpadding="0"> <tr> <td bordercolor="#808080"> <p> </p> <p> </td> </tr> </table> <table border="1" width="90%" cellpadding="0" style="border-left-style: solid; border-left-width: 2px; border-right: 2px solid #FFFFFF; border-top-style: solid; border-top-width: 2px; border-bottom: 2px solid #FFFFFF"> <tr> <td bordercolor="#808080"> </td> </tr> </table> <?php // Start looping table row while($rows = mysql_fetch_array($result)){ ?> <table border="0" width="90%" style="border-left-style: solid; border-left-width: 2px; border-right: 2px solid #FFFFFF; border-top-style: solid; border-top-width: 2px; border-bottom: 2px solid #FFFFFF" cellpadding="0"> <tr> <td style="border-style: solid; border-width: 1px" bordercolor="#808080" bgcolor="#FF6600"> <p align="center"><?php echo $key1; ?></td> <td bordercolor="#808080" style="border-style: solid; border-width: 1px" bgcolor="#FF6600"> <p align="center"><?php echo $product1; ?></php></td> <td style="border-style: solid; border-width: 1px" bordercolor="#808080" bgcolor="#FF6600"> <p align="center"><?php echo $detail1; ?></td> <td style="border-style: solid; border-width: 1px" bordercolor="#808080" bgcolor="#FF6600"> <p align="center"><?php echo $select1; ?></td> </tr> <tr> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <p align="center"> <?php echo $rows['key']; ?></td> <td bordercolor="#808080" style="border-style: solid; border-width: 1px"> <p align="center"><?php echo $rows['product']; ?></td> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <p align="center"> <?php echo $rows['detail']; ?><?php echo $rows['new']; ?></td> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <p align="center"> <?php echo $rows['select']; ?></td> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <p align="center"> <?php echo $rows['category']; ?></td> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <p align="center"> <?php echo $rows['date']; ?></td> </tr> </table> </div> <div align="center"> <table border="1" width="90%" cellpadding="0" style="border: 2px solid #FFFFFF"> <tr> <td bordercolor="#808080"> <p align="center"> </p> <p align="center"></p> <p align="center"> </td> </tr> </table> </div> </body> </html> <?php } ?>[/code] add.php [code]<?php include("config.php"); ?> <html> <head> <meta http-equiv="Content-Language" content="en-us"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title><?php $title; ?></title> </head> <body bgcolor="#C0C0C0"> <div align="center"> <table border="1" width="90%" style="border-left-style: solid; border-left-width: 2px; border-right: 2px solid #FFFFFF; border-top-style: solid; border-top-width: 2px; border-bottom: 2px solid #FFFFFF" cellpadding="0"> <tr> <td bordercolor="#808080"> <p> </p> <p> </td> </tr> </table> <table border="1" width="90%" cellpadding="0" style="border-left-style: solid; border-left-width: 2px; border-right: 2px solid #FFFFFF; border-top-style: solid; border-top-width: 2px; border-bottom: 2px solid #FFFFFF"> <tr> <td bordercolor="#808080"> </td> </tr> </table> <table border="0" width="90%" style="border-left-style: solid; border-left-width: 2px; border-right: 2px solid #FFFFFF; border-top-style: solid; border-top-width: 2px; border-bottom: 2px solid #FFFFFF" cellpadding="0"> <tr> <td style="border-style: solid; border-width: 1px" bordercolor="#808080" bgcolor="#FF6600" colspan="2"> <p align="center"><?php echo $add; ?></td> </tr> <tr> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <?php echo $key1; ?></td> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <input type="hidden" name="key" size="53" /></td> </tr> <tr> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <?php echo $product1; ?></td> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <input type="text" name="product" size="53" /></td> </tr> <tr> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <?php echo $detail1; ?></td> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <textarea rows="4" cols="45" name="detail"></textarea></td> </tr> <tr> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <?php echo $new1; ?></td> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <input type="checkbox" name="new" value="new"></td> </tr> <tr> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <?php echo $select1; ?></td> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <select size="1" name="select"> <option selected>- Select -</option> <option>1</option> <option2</option> <option3</option> <option4</option> <option5</option> <option>6</option> <option>7</option> <option>8</option> <option>9</option> </select></td> </tr> <tr> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <?php echo $category1; ?></td> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <select size="1" name="category"> <option selected>- Category -</option> <option>Name 1</option> <option>Name 2</option> <option>Name 3</option> </select></td> </tr> <tr> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <?php echo $date1; ?></td> <td style="border-style: solid; border-width: 1px" bordercolor="#808080"> <?php echo $date; ?></td> </tr> </table> <table border="1" width="90%" cellpadding="0" style="border: 2px solid #FFFFFF"> <tr> <td bordercolor="#808080"> <p align="center"><br> <form id="form1" name="form1" method="post" action="add.php"> <input type="submit" name="Submit" value="Submit"> <input type="reset" name="Submit2" value="Clear"><br> </td> <tr> <td width="70%" align=right> <div align="center"> <?php $db = mysql_connect("$dbhost", "$dbuser", "$dbpassword")or die("cannot connect server "); mysql_select_db("$dbname")or die("cannot select DB"); if($_POST['Submit']) { $string = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; $key = ""; for($i=0; $i<5; $i++){ $y = rand(0,strlen($string)-1); $key .= $string[$y]; } $product = $_POST['product']; $detail = $_POST['detail']; $select = $_POST['select']; $date = date("d/m/y h:i:s"); $new = $_POST['new']; $category = $_POST['category']; $sql = "INSERT INTO `products` (`id`, `key`, `product`, `detail`, `select`, `date`, `new`, `category`) VALUES ('', '$key', '$product', '$detail', '$select', '$date', '$new', '$category')" or die('insert into is wrong'); mysql_query($sql,$db) or die('query is wrong.'); print "Product Added Successfull."; } ?> </div></td> </tr> </table> </div> </body> </html>[/code]