********* MySQL Database *********
mysql> desc users;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| uname | varchar(20) | YES | | NULL | |
+-------+-------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
mysql> alter table message modify mid int AUTO_INCREMENT;
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc message;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| mid | int(11) | NO | PRI | NULL | auto_increment |
| uid | int(11) | YES | | NULL | |
| msg | varchar(50) | YES | | NULL | |
+-------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
********* index.php *********
<html>
<body>
<fieldset>
<center>
LOGIN
<div style="border:1px solid blue;margin-top:100;margin-bottom:100;px;padding:10px;height=400;width:200px">
<form action="login.php" method="post">
Username : <input type="text" name="uname" /></br>
Password: <input type="text" name="pass" /></br>
<input type="submit" name="submit" value="submit"?>
</form>
</div>
</center>
</fieldset>
</body>
</html>
********* login.php *********
<?php
echo "okkk";
print_r($_POST);
$db = mysql_connect("localhost","ossuser","ossuser");
mysql_select_db("ossdb",$db);
echo "Connection Established";
$qry = "select * from users where uname='".$_POST['uname']."' and pass='".$_POST['pass']."'";
echo "</br> Qry : ".$qry;
$result = mysql_query($qry,$db);
echo "rows:".mysql_num_rows($result);
if(!mysql_num_rows($result)){
echo "</br> Invalid User Name or Password";
//$qry ="insert into users(uname,pass) values('".$_POST['uname']."','".$_POST['pass']."')";
//echo "</br> Qry : ".$qry;
//$result =mysql_query($qry,$db);
//echo "</br> New User Added";
}
else{
echo "</br> Valid User";
session_start();
$_SESSION['username'] = $_POST['uname'];
header("Location:window.php");
}
?>
********* window.php *********
<html>
<frameset ROWS="70%,30%">
<frame name="f1" src="/display.php">
<frame name="f2" src="/send.php">
</frameset>
</html>
********* send.php *********
<html>
<body>
<fieldset>
<center>
</dr>
<table><tr><td>
<div style="border:1px solid blue;margin-top:10;margin-bottom:10;px;padding:10px;height=400;width:300px">
:)<img src='/chat/smilies/smile.gif'>;(<img src='/chat/smilies/tongue.gif'>:(<img src='/chat/smilies/sad.gif'>
;)<img src='/chat/smilies/s1.gif'>))<img src='/chat/smilies/s2.gif'>()<img src='/chat/smilies/s3.gif'>
</div></td><td>
<div style="border:1px solid blue;margin-top:10;margin-bottom:10;px;padding:10px;height=400;width:400px">
<form action="send.php" method="post">
</br><input type="text" name="msg"/>
<input type="submit" name="send" value="send"/>
</form>
</div>
</td></tr></table>
</center>
</fieldset>
<?php
session_start();
$db = mysql_connect("localhost","ossuser","ossuser");
mysql_select_db("ossdb",$db);
//echo "Connection Established";
if(isset($_POST['send'])){
$qry = "select id from users where uname='".$_SESSION['username']."'";
echo "</br> Qry : ".$qry;
$result = mysql_query($qry,$db);
$id=mysql_result($result,0,"id");
//echo "</br> ID : ".mysql_result($result,0,"id");
$qry="insert into message(uid,msg) values(".$id.",'".$_POST['msg']."')";
//echo "</br> Qry : ".$qry;
//print_r($_POST);
$result = mysql_query($qry,$db);
}
?>
</body>
</html>
********* display.php *********
<html>
<head>
<META HTTP-EQUIV="Refresh" CONTENT="3">
</head>
<body>
<fieldset>
<center>
</dr><div style="border:1px solid blue;margin-top:10;margin-bottom:10;px;padding:10px;height=400;width:400px">
<?php
session_start();
$db = mysql_connect("localhost","ossuser","ossuser");
mysql_select_db("ossdb",$db);
echo "WELCOME : ".$_SESSION['username'];
//print_r($_SESSION);
$qry = "select uid,msg from message order by mid desc limit 5";
$result = mysql_query($qry,$db);
//echo "</br> ID : ".mysql_result($result,0,"mid");
?>
<!-- <textarea name="mess" rows="20" cols="40"> -->
</div>
</dr><div style="border:1px solid blue;margin-top:10;margin-bottom:10;px;padding:10px;height=400;width:400px">
<table style="padding-right:19px;text-align:left;"><tr><td>
<?
$images = array('smile','tongue','sad','s1','s2','s3');
$smiles = array(':)',';(',':(',';)','))','()');
for($i=4;$i>=0;$i--){
$qry2 ="select uname from users where id=".mysql_result($result,$i,"uid");
$result2 = mysql_query($qry2,$db);
$msg = mysql_result($result,$i,"msg");
for($j=0;$j<3;$j++){
$msg=str_replace($smiles[$j],"<img src='/chat/smilies/".$images[$j].".gif'>",$msg);
}
echo "<b>".mysql_result($result2,0,"uname")." : </b>";echo $msg;
//echo str_replace(":)","<img src='/chat/smilies/smile.gif'/>",mysql_result($result,$i,"msg"));
//echo mysql_result($result,$i,"msg");
echo "</br>";
}
?>
</br>
<!-- </textarea> -->
</td></tr></table>
</div>
</center>
</fieldset>
</body>
</html>
**********************************
Sunday, November 6, 2011
0 comments:
Post a Comment