asad_black

thank you so much

if u explain this thing in code then i will be very thankful of u:(

hi i want to create a login page in which user login his username and id...! In which distinguish a administrator and normal user when they login. when administrator login it redirect to admin page. when normal user login it redirect to normal user page. my database contain 4 fields. userid, username, password, category category contain value '1' or '0' for difference b/w user either its administrator or normal user. '1' for administrator and '0' for normal user but i dont know how to do the in the PHP coding. my code is: <?php $host="localhost"; // Host name $username="myweb"; // Mysql username $password="myweb"; // Mysql password $db_name="hms"; // Database name $tbl_name="login"; // Table name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // username and password sent from form $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; $cate='1'; // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword' and category='1'"; $result=mysql_query($sql); // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table row must be 1 row if($count==1){ // Register $myusername, $mypassword and redirect to file "login_success.php" session_register("myusername"); session_register("mypassword"); header("location:login_success.php"); } else { echo "Wrong Username or Password"; } ?> plz solve my problem as soon as possible

thankx bricktop

em facing problem in update records. form submit successfully nut records is not updating. i dont whats the problem. kindly solve my problem as soon as possible this is form page <form id="form1" name="form1" method="post" action="update_teacher_records_process.php"> <p>Name : <!-- name of this text field is "name" --> <input name="teachername" type="text" id="teachername" value="<? echo $row['teachername']; ?>"/> <br /> Email : <!-- name of this text field is "email" --> <input name="cellno" type="text" id="cellno" value="<? echo $row['cellno']; ?>"/> <br /> Tel : <!-- name of this text field is "tel" --> <input name="residentialadd" type="text" id="residentialadd" value="<? echo $row['residentialadd']; ?>"/> </p><br><br> <input name="tuition_asg" type="text" id="tuition_asg" value="<? echo $row['tuition_asg']; ?>"/> <p> <input type="submit" name="Submit" value="Submit" /> </p> </form> this is my update code <?PHP include("admin_conn.php"); // Get parameters from form. $teachid=$_POST['teachid']; $teachername=$_POST['teachername']; $cellno=$_POST['cellno']; $residentialadd=$_POST['residentialadd']; $tuition_asg=$_POST['tuition_asg']; // Do update statement. mysql_query("UPDATE teachers set teachername='$teachername', cellno='$cellno', residentialadd='$residentialadd', tuition_asg='$tuition_asg' where teachid='$teachid'"); // Re-direct this page to select.php. header("location:view_teacher_records.php"); exit; ?> datatype in database is text.

this is my sample page http://tutioninn.com/comment/testpage.php now i want to do paging in current comment section...! but i dont want to page change or refresh...! so i want to use AJAX paging...! but i have no idea about ajax paging..! so kindly solve my problem as soon as possible this is code of above link page...! <style type="text/css"> <!-- body { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; } .bold { font-weight: bold; } .italics { font-style: italic; } .underline { text-decoration: underline; } .strikethrough { text-decoration: line-through; } .overline { text-decoration: overline; } .sized { text-size: } .quotecodeheader { font-family: Verdana, arial, helvetica, sans-serif; font-size: 12px; font-weight: bold; } .codebody { background-color: #FFFFFF; font-family: Courier new, courier, mono; font-size: 12px; color: #006600; border: 1px solid #BFBFBF; } .quotebody { background-color: #FFFFFF; font-family: Courier new, courier, mono; font-size: 12px; color: #660002; border: 1px solid #BFBFBF; } .listbullet { list-style-type: disc; list-style-position: inside; } .listdecimal { list-style-type: decimal; list-style-position: inside; } .listlowerroman { list-style-type: lower-roman; list-style-position: inside; } .listupperroman { list-style-type: upper-roman; list-style-position: inside; } .listloweralpha { list-style-type: lower-alpha; list-style-position: inside; } .listupperalpha { list-style-type: upper-alpha; list-style-position: inside; } --> </style> <?php //Local copy function BBCode($Text) { // Replace any html brackets with HTML Entities to prevent executing HTML or script // Don't use strip_tags here because it breaks [url] search by replacing & with amp $Text = str_replace("<", "<", $Text); $Text = str_replace(">", ">", $Text); // Set up the parameters for a URL search string $URLSearchString = " a-zA-Z0-9\:\/\-\?\&\.\=\_\~\#\'"; // Set up the parameters for a MAIL search string $MAILSearchString = $URLSearchString . " a-zA-Z0-9\.@"; //Non BB URL Search //$Text = eregi_replace("([[:alnum:]]+)://([^[:space:]]*)([[:alnum:]#?/&=])", "<a href=\"\\1://\\2\\3\" target=\"_blank\" target=\"_new\">\\1://\\2\\3</a>", $Text); //$Text = eregi_replace("(([a-z0-9_]|\\-|\\.)+@([^[:space:]]*)([[:alnum:]-]))", "<a href=\"mailto:\\1\" target=\"_new\">\\1</a>", $Text); if (substr($Text,0, 7) == "http://"){ $Text = eregi_replace("([[:alnum:]]+)://([^[:space:]]*)([[:alnum:]#?/&=])", "<a href=\"\\1://\\2\\3\">\\1://\\2\\3</a>", $Text); // Convert new line chars to html <br /> tags $Text = nl2br($Text); } else { // Perform URL Search $Text = preg_replace("/\[url\]([$URLSearchString]*)\[\/url\]/", '<a href="javascript:go(\'$1\',\'new\')">$1</a>', $Text); $Text = preg_replace("(\[url\=([$URLSearchString]*)\](.+?)\[/url\])", '<a href="javascript:go(\'$1\',\'new\')">$2</a>', $Text); //$Text = preg_replace("(\[url\=([$URLSearchString]*)\]([$URLSearchString]*)\[/url\])", '<a href="$1" target="_blank">$2</a>', $Text); // Convert new line chars to html <br /> tags $Text = nl2br($Text); } // Perform MAIL Search $Text = preg_replace("(\[mail\]([$MAILSearchString]*)\[/mail\])", '<a href="mailto:$1">$1</a>', $Text); $Text = preg_replace("/\[mail\=([$MAILSearchString]*)\](.+?)\[\/mail\]/", '<a href="mailto:$1">$2</a>', $Text); // Check for bold text $Text = preg_replace("(\[b\](.+?)\[\/b])is",'<span class="bold">$1</span>',$Text); // Check for Italics text $Text = preg_replace("(\[i\](.+?)\[\/i\])is",'<span class="italics">$1</span>',$Text); // Check for Underline text $Text = preg_replace("(\[u\](.+?)\[\/u\])is",'<span class="underline">$1</span>',$Text); // Check for strike-through text $Text = preg_replace("(\[s\](.+?)\[\/s\])is",'<span class="strikethrough">$1</span>',$Text); // Check for over-line text $Text = preg_replace("(\[o\](.+?)\[\/o\])is",'<span class="overline">$1</span>',$Text); // Check for colored text $Text = preg_replace("(\[color=(.+?)\](.+?)\[\/color\])is","<span style=\"color: $1\">$2</span>",$Text); // Check for sized text $Text = preg_replace("(\[size=(.+?)\](.+?)\[\/size\])is","<span style=\"font-size: $1px\">$2</span>",$Text); // Check for list text $Text = preg_replace("/\[list\](.+?)\[\/list\]/is", '<ul class="listbullet">$1</ul>' ,$Text); $Text = preg_replace("/\[list=1\](.+?)\[\/list\]/is", '<ul class="listdecimal">$1</ul>' ,$Text); $Text = preg_replace("/\[list=i\](.+?)\[\/list\]/s", '<ul class="listlowerroman">$1</ul>' ,$Text); $Text = preg_replace("/\[list=I\](.+?)\[\/list\]/s", '<ul class="listupperroman">$1</ul>' ,$Text); $Text = preg_replace("/\[list=a\](.+?)\[\/list\]/s", '<ul class="listloweralpha">$1</ul>' ,$Text); $Text = preg_replace("/\[list=A\](.+?)\[\/list\]/s", '<ul class="listupperalpha">$1</ul>' ,$Text); $Text = str_replace("[*]", "<li>", $Text); // Check for font change text $Text = preg_replace("(\[font=(.+?)\](.+?)\[\/font\])","<span style=\"font-family: $1;\">$2</span>",$Text); // Declare the format for [code] layout $CodeLayout = '<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td class="quotecodeheader"> Code:</td> </tr> <tr> <td class="codebody">$1</td> </tr> </table>'; // Check for [code] text $Text = preg_replace("/\[code\](.+?)\[\/code\]/is","$CodeLayout", $Text); // Declare the format for [quote] layout $QuoteLayout = '<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td class="quotecodeheader"> Quote:</td> </tr> <tr> <td class="quotebody">$1</td> </tr> </table>'; // Check for [code] text $Text = preg_replace("/\[quote\](.+?)\[\/quote\]/is","$QuoteLayout", $Text); // Images // [img=http://pathtoimage] $Text = preg_replace("/\[img\]http://(.+?)\[\/img\]/", '<img src="$1">', $Text); // [img=widthxheight]image source[/img] $Text = preg_replace("/\[img\=([0-9]*)x([0-9]*)\](.+?)\[\/img\]/", '<img src="$3" height="$2" width="$1">', $Text); return $Text; } //quick script to make the data look nice function formatDate($val) { list($date, $time) = explode(" ", $val); list($year, $month, $day) = explode("-", $date); list($hour, $minute, $second) = explode (":", $time); return date("l, m.j.y @ H:ia", mktime($hour, $minute, $second, $month, $day, $year)); } function getComments($tutid){ //creates a function that can easily be called from any page //create the css code to make the form look good. You can edit this to change colors, etc: echo " <style> /*COMMENTS *------------------------------------*/ .postedby { padding: 0 0 0 18px; background: url(images/abullet.gif) no-repeat 0 4px; } h3.formtitle { margin : 0px 0px 0px 0px; border-bottom: 1px dotted #ccc; padding-bottom: 8px; } .commentbody { border-top: 1px dotted #ccc; } /*gray box*/ .submitcomment, #submitcomment, #currentcomments, #rating, .textad { background-color: #F5F5F5; border: 1px dotted #ccc; padding: 5px; padding: 5px; margin: 20px 0px 0px 0px; } /*FORMS *------------------------------------*/ .form { font-size: 70%; background-color: #FAFAFA; border: solid 1px #C6C6C6; padding: 2px; } .formtext { background-color: #FAFAFA; border: solid 1px #C6C6C6; padding: 2px; border-bottom: 1px dotted #ccc } .form:hover, .formtext:hover { background: white; } .form:focus, .formtext:focus { background: white; border: solid 1px #000000; } .submit { background-color: #D3D3D3; border: solid 1px #C6C6C6; border-right: solid 1px #9A9A9A; border-bottom: solid 1px #9A9A9A; } .submit:hover, .submit:focus { background: #EDEDED; } </style> "; //fetch all comments from database where the tutorial number is the one you are asking for $commentquery = mysql_query("SELECT * FROM comments WHERE tutorialid='$tutid' ORDER BY date") or die(mysql_error()); //find the number of comments $commentNum = mysql_num_rows($commentquery); //create a headline echo "<div id=\"currentcomments\" class=\"submitcomment\"><h3 class=\"formtitle\">Current Comments</h3>\n"; echo $commentNum . " comments so far (<a href=\"#post\">post your own</a>)\n"; //for each comment in the database in the right category number... while($commentrow = mysql_fetch_row($commentquery)){ //for security, parse through the bbcode script //the number corresponds to the column (the message is always stored in column 4 //COUTING STARTS at 0!!! $commentbb = BBCode($commentrow[4]); //create the right date format $commentDate = formatDate($commentrow[6]); echo "<div class=\"commentbody\" id=\"$commentrow[0]\">\n <p>$commentbb</p>\n <p class=\"postedby\">Posted by "; if($commentrow[3]){ echo "<a href=\"$commentrow[3]\">$commentrow[2]</a> "; } else { echo "$commentrow[2] "; } echo "on $commentDate | #$commentrow[0]</p>\n \n</div>"; } echo "</div>"; } function submitComments($tutid2,$tuturl){ //a javascript script to make sure all the required fields are filled in ?> <script language="javascript"> function form_Validator(form) { if (form.name.value == "") { alert("Please enter your name."); form.name.focus(); return (false); } if (form.message.value == "") { alert("Please enter your message."); form.message.focus(); return (false); } return (true); } //--> </script> <?php //create the form to submit comments //you can add more fields, but make sure you add them to the db table and the page, submitcomment.php echo " <a name=\"post\"> <div id=\"submitcomment\" class=\"submitcomment\"> <form name=\"submitcomment\" method=\"post\" action=\"submitcomment.php\" onSubmit=\" return form_Validator(this)\"> <table width=\"100%\"> <tr> <th colspan=\"2\"><h3 class=\"formtitle\">Leave your comment:</h3></th> </tr> <tr> <th scope=\"row\"><p class=\"req\">Name:</p></th> <td><input class=\"form\" tabindex=\"1\" id=\"name\" name=\"name\" /></td> </tr> <tr> <th scope=\"row\"><p class=\"opt\">Email:</p></th> <td><input class=\"form\" tabindex=\"2\" id=\"email\" name=\"email\" /></td> </tr> <tr> <th scope=\"row\"><p class=\"opt\">URL:</p></th> <td><input class=\"form\" tabindex=\"3\" id=\"url\" name=\"url\" /></td> </tr> <tr valign=\"top\"> <th scope=\"row\"><p class=\"req\">Comments:</p><br /></th> <td><textarea class=\"formtext\" tabindex=\"4\" id=\"message\" name=\"message\" rows=\"10\" cols=\"50\"></textarea></td> </tr> <tr> <td> </td> <td><input type=\"submit\" name=\"post\" class=\"submit\" value=\"Submit Comment\" /><br /> <p>Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted. </p> <p>No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.</p> </td> </tr> </table> <input type=\"hidden\" name=\"tuturl\" value=\"$tuturl\" /> <input type=\"hidden\" name=\"tutid2\" value=\"$tutid2\" /> </form> </div> "; } ?>

kindly give me the idea that how to add my website in the first page of google search engine while searching keywords related to my website..! meta tag keywords is useful or not?

i want to select all record except selected one...! i dont know how to do these..! kindly give me a reply ...!

thankx for the reply...! yeah i have a field in the database with the name of v_hits if you modified my code or show to do this implement then i will be very thankful of you..!

this is my page: http://www.tutioninn.com/id_videos.php?v_id=13 now in this page i want to show that how many times people visit this video..! also this value save in the database...! like: http://www.jugnoo.tv/idpage.php?id=29 i have no idea about it..! kindly solve my problem soon:( this is my code $result = mysql_query("SELECT * FROM my_vid WHERE v_id =$vid_id"); echo "<table border='0' width='50%' align='center'> <tr valign=top> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr valign=top>"; // echo "<td>" . $row['v_name'] . "</td>"; echo "<br>"; echo "<td align='center' style='font:Arial, Helvetica, sans-serif; font-size:14px; font-weight:bold; text-transform:uppercase;'>" . $row['v_name'] . "</td>"; echo "</tr>"; echo "<tr valign=top>"; echo "<td align='center' style='font:Arial, Helvetica, sans-serif; font-size:14px; color:#006699'>" . $row['v_des'] . "</td>"; echo "</tr>"; echo "<tr valign=top>"; echo "<td>" . $row['v_emb'] . "</td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?>

for example:(

this is my sample page ...! http://tutioninn.com/wallpaper.php in which images in a table show in a vertical direction but i want to show it horizontal way..! like this page: http://neosmart.net/gallery/v/wallpapers/Vista/official/Textures/ this is my code of selecting record...! if u have better code from this code kindly reply me as soon as possible. $sql = "SELECT * FROM wallpapers ; $result = mysql_query($sql); echo "<table border='1' cellpadding='3' cellspacing='3' width='60%'>"; echo "<tr>"; // while there are rows to be fetched... while ($list = mysql_fetch_assoc($result)) { // echo data { echo "<td ><a href=\"idpage.php?id=" . $list["id"] . "\"><img src=\"" . $list["w_th"] . "\" ></a></td>"; echo "<td ><a href=\"idpage.php?id=" . $list["id"] . "\">". $list['w_name']. "</a>"; echo "</td>"; } echo "</tr>"; }

thank you so much sir

this is my page : http://jugnoo.tv/category_story.php in which list of videos is exist...! click on the thumbnail video will be started..! now i want to display that how many viewers visit the videos like on youtube and the no. visits shows on that page when after clicking on the thumbnail...! for example i want to display the no. of visits on the following page: http://jugnoo.tv/idpage.php?id=68 i have already database and also want to save no. of visit of individual videos in database...! i have no idea how to do this..! http://jugnoo.tv/idpage.php?id=68 the code of above page in which i want to display the no. of visits..! <table width="100%" cellpadding="0" cellspacing="0" class="playertable" border="0"> <tr> <td bgcolor="#FF9900"> <?php $vid_id = $_GET['id']; $con = mysql_connect("localhost","sample","sample"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("sample", $con); $result = mysql_query("SELECT * FROM links WHERE id =$vid_id"); echo "<table border='0'> <tr valign=top> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr valign=top>"; //echo "<td>" . $row['kw'] . "</td>"; //echo "<td>" . $row['des'] . "</td>"; echo "<td>" . $row['embed'] . "</td>"; echo "<td width='20'></td>"; echo "<td class=ddesc>" . $row['ddes'] . "</td>"; //echo "<td valgin=top >" . $row['text'] . "</td></center>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?></td> </tr> </table>

hi...! em working on this site http://jugnoo.tv and currently working on the rate this video script..! when you visit the following link you will see the list of video. http://jugnoo.tv/category_activity.php when you click on any thumbnail of video the video will be played and you will also see the rate this video on the bottom of the player...! now my problem is that: this script work on the one video means when rate any video it will show same rating on every video...! <?php $vid_id = $_GET['id']; $con = mysql_connect("localhost","sample","sample"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("sample", $con); $result = mysql_query("SELECT * FROM links WHERE id =$vid_id"); echo "<table border='0'> <tr valign=top> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr valign=top>"; //echo "<td>" . $row['kw'] . "</td>"; //echo "<td>" . $row['des'] . "</td>"; echo "<td>" . $row['embed'] . "</td>"; echo "<td width='20'></td>"; echo "<td class=ddesc>" . $row['ddes'] . "</td>"; //echo "<td valgin=top >" . $row['text'] . "</td></center>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?></td> </tr> </table> </td> <td bgcolor="#FFFFFF"> </td> </tr> <tr bgcolor="#FF0000"> <td valign="top" bgcolor="#FFFFFF"> </td> <td height="35" colspan="2" valign="top" bgcolor="#FFFFFF"> //************THIS IS RATING SCRIPT******// <?php rating_form("test2"); ?><br> //************end of script******// <?php include("lowermenu.php"); ?></td> the above code is my code where include the rate script and this is actual code of rating: <?php class rating{ public $average = 0; public $votes; public $status; public $table; private $path; function __construct($table){ try{ $pathinfo = pathinfo(__FILE__); $this->path = realpath($pathinfo['dirname']) . "/database/ratings.sqlite"; $dbh = new PDO("sqlite:$this->path"); $this->table = $dbh->quote($table); // check if table needs to be created $table_check = $dbh->query("SELECT * FROM $this->table WHERE id='1'"); if(!$table_check){ // create database table $dbh->query("CREATE TABLE $this->table (id INTEGER PRIMARY KEY, rating FLOAT(3,2), ip VARCHAR(15))"); $dbh->query("INSERT INTO $this->table (rating, ip) VALUES (0, 'master')"); } else { $this->average = $table_check->fetchColumn(1); } $this->votes = ($dbh->query("SELECT COUNT(*) FROM $this->table")->fetchColumn()-1); }catch( PDOException $exception ){ die($exception->getMessage()); } $dbh = NULL; } function set_score($score, $ip){ try{ $dbh = new PDO("sqlite:$this->path"); $voted = $dbh->query("SELECT id FROM $this->table WHERE ip='$ip'"); if(sizeof($voted->fetchAll())==0){ $dbh->query("INSERT INTO $this->table (rating, ip) VALUES ($score, '$ip')"); $this->votes++; //cache average in the master row $statement = $dbh->query("SELECT rating FROM $this->table"); $total = $quantity = 0; $row = $statement->fetch(); //skip the master row while($row = $statement->fetch()){ $total = $total + $row[0]; $quantity++; } $this->average = round((($total*20)/$quantity),0); $statement = $dbh->query("UPDATE $this->table SET rating = $this->average WHERE id=1"); $this->status = '(thanks!)'; } else { $this->status = '(already scored)'; } }catch( PDOException $exception ){ die($exception->getMessage()); } $dbh = NULL; } } function rating_form($table){ $ip = $_SERVER["REMOTE_ADDR"]; if(!isset($table) && isset($_GET['table'])){ $table = $_GET['table']; } $rating = new rating($table); $status = "<div class='score'> <a class='score1' href='?score=1&table=$table&user=$ip'>1</a> <a class='score2' href='?score=2&table=$table&user=$ip'>2</a> <a class='score3' href='?score=3&table=$table&user=$ip'>3</a> <a class='score4' href='?score=4&table=$table&user=$ip'>4</a> <a class='score5' href='?score=5&table=$table&user=$ip'>5</a> </div> "; if(isset($_GET['score'])){ $score = $_GET['score']; if(is_numeric($score) && $score <=5 && $score >=1 && ($table==$_GET['table']) && isset($_GET["user"]) && $ip==$_GET["user"]){ $rating->set_score($score, $ip); $status = $rating->status; } } if(!isset($_GET['update'])){ echo "<div class='rating_wrapper'>"; } ?> <div class="sp_rating"> <div class="rating">Rating:</div> <div class="base"><div class="average" style="width:<?php echo $rating->average; ?>%"><?php echo $rating->average; ?></div></div> <div class="votes"><?php echo $rating->votes; ?> votes</div> <div class="status"> <?php echo $status; ?> </div> </div> <?php if(!isset($_GET['update'])){ echo "</div>"; } } if(isset($_GET['update'])&&isset($_GET['table'])){ rating_form($_GET['table']); } i adopt the rate script from http://www.colorpowered.com/colorrating/