Jump to content

Ibshas25

Members
 View Profile  See their activity

  • Posts

    53

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by Ibshas25

  1. Ibshas25
    i get this error when trying to perform a operation. ??? help [Method not found: 'System.Data.IDataReader INVU.Data.DataAccessLayer.SqlHelper.ExecuteReader(System.String, System.Object[,], System.Data.IsolationLevel, System.Data.IDbConnection ByRef, System.Data.IDbTransaction ByRef)'. Source: INVU.Business.Proxy Target: Inner: Stack: at INVU.Business.Proxy.Proxy.HandleException(Exception ex) at INVU.Business.Proxy.Proxy.HandleException(Exception ex, MethodBase mb, Object obj, Object[] parameters) at INVU.Business.Proxy.Node.IndexNodeAndRevisions(TemplateAttributeLink[] attribs, NodeData[] nodes, Int32 infoTypeId, Int32 templateId, NodeData newParent, Int32 secureLocationId, String workflowText, Boolean indexRevisions, NodeData[]& indexedRevisions) at INVU.Services.NodeAccess.Index(TemplateAttributeLink[] attribs, NodeData[] nodes, Int32 infoTypeId, Int32 templateId, NodeData newParent, Int32 secureLocationId) at INVU.Services.SecureAccessServer.File.ConvertMultipageDocumentEx(DocumentInfo docInfoIn, HashValue hashCode, ConvertMultipageDocumentInfo info) at INVU.Services.SecureAccessServer.File.ConvertMultipageDocument(DocumentInfo docInfo, HashValue hashCode, ConvertMultipageDocumentInfo info)Further information : Assembly Version : 6.4.1065.0 *** Environment *** Current directory : C:\Program Files\INVU Services Ltd\INVU6 Machine name : SPARE_0810 OS Version : Microsoft Windows NT 5.1.2600 Service Pack 3 Processor count : 2 Current user : IHassan Current user netbios domain name : EBP User interactive mode : True CLR version : 2.0.50727.3620 /]
  2. Ibshas25
    this is what i have tried on lines 79 to 89 but does not work <div style="OVERFLOW: auto; WIDTH: 350px; HEIGHT: 100px"> <span id="prjlist"></span> <h2><span></span></h2> <ul id="sliding-navigation"> </td></tr> <tr><td colspan="2"> <?php if($_SESSION[issysadmin]=="Y") { echo "<li class="sliding-element"><h3>Projects Page</h3></li> "; echo " <li class="sliding-element"><a href="UserSearchPBT.html">User Managment</a></li>"; echo " <li class="sliding-element"><a href="RolSearchPBT.html">Roles Managment</a></li>"; echo " <li class="sliding-element"><a href="teams1.html">Teams</a></li>"; </ul> } ?> </td></tr>
  3. Ibshas25
    lines 79 to 89 is where i want to add the above for styling on the page <?php error_reporting(E_ALL ^ E_NOTICE);?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title> Project Name List Menu </title> <link rel="stylesheet" type="text/css" href="stylespb.css" /> <script type="text/javascript" src="jquery-1.4.3.js"></script> <script type="text/javascript" src="jquery.json-2.2.js"></script> <script type="text/javascript" src="prjlistmenu.js"></script> <style type="text/css"> body { color:#999 font-size:12px; font-family:Arial, Helvetica, sans-serif; } form { display:block; width:260px; } form .input{ width:100px; float:right; } form label { width:260px; clear:both; text-align:right; white-space:nowrap; } form textarea { display:block; width:260px; } form .input_1_Chr { width:10px; float:left; } </style> </head> <?php session_start(); if ($_SESSION['isloggedin']=="Y") { echo "userid=".$_SESSION[userid]." user =".$_SESSION[user]; } else { // echo "invalid user now redirect to login page here"; header("Location: login.php"); exit; } ?> <body> <div id="navigation-block"> <img src="background.jpg" id="hide" /> <h2><span></span></h2> <p><h1> Project Name List Menu</h1></p> <form id="iletisim"> <div id="formdiv"> <table><tr><td colspan="2"><span id="successfailmessage"></span></td></tr> <tr><td colspan="2"> </td></tr> <tr><td colspan="2"> <div style="OVERFLOW: auto; WIDTH: 350px; HEIGHT: 100px"> <span id="prjlist"></span> </td></tr> <tr><td colspan="2"> <?php if($_SESSION[issysadmin]=="Y") { echo " <a href='RolSearchPBT.html'> <span> Role Management</span></a>"; echo "<a href='teams1.html'> <span> Teams Management</span></a>"; echo "<a href=''> <span> Methodology Management</span></a>"; } ?> </td></tr> </table> <input type="hidden" id= "prjid" value="0" name="prjid" /> <input type="hidden" id= "prjname" value="" name="prjname" /> <input type="hidden" id= "userid" value="<?php print $_SESSION[userid]; ?>" name="userid" /> </div> </form> </body> </html>
  4. Ibshas25
    i want to portray this code within echo but cant seem to get it to work specially with "LI classes" <ul id="sliding-navigation"> <li class="sliding-element"><h3>Projects Page</h3></li> <li class="sliding-element"><a href="UserSearchPBT.html">User Managment</a></li> <li class="sliding-element"><a href="RolSearchPBT.html">Roles Managment</a></li> <li class="sliding-element"><a href="teams1.html">Teams</a></li> <li class="sliding-element"><a href="">Methodologies</a></li> </ul>
  5. Ibshas25
    cant work out this mysql syntax error "operation":"medupdate","medid":"","name":"ibo","medyear":"5","medmonth":"21","medday":"1","recuser":1,"SuccFail":"fail","SuccFailMessage":"error occured You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''WHERE med_id=' at line 2","ResultData":""} $sql="update metodology set med_description='".$req['name']."', med_year='".$req['medyear']."', med_month='".$req['medmonth']."', med_day='".$req['medday']."', med_recorddate= now(), med_recorduserid= 1'"; $sql.= " WHERE med_id=".$req['medid'];
  6. Ibshas25
    where do i add this gif for it to work. currently i added it to the actually add button but doesnt seem to work... any ideas function useradd() { alert ("user add a geliyor"); //alert ("team add a geliyor"); var username = $("#username").attr("value"); var name = $("#name").attr("value"); var surname = $("#surname").attr("value"); var passwd1 = $("#passwd1").attr("value"); var email = $("#email").attr("value"); var phone = $("#phone").attr("value"); var mobphone = $("#mobphone").attr("value"); var issysadmin = $("#issysadmin").attr("value"); var isuseractive = $("#isuseractive").attr("value"); var data = { "operation" : "useradd", "username" : username, "name" : name, "surname" : surname, "password" : passwd1, "email" : email, "phone" : phone, "mobphone" : mobphone, "issysadmin" :issysadmin, "isuseractive" :isuseractive, "recuser" :1 } var dataString = $.toJSON(data); $.post('UserSearchPBT.php', { data: dataString}, useraddResult, "text"); } function useraddResult(res) { var obj = $.evalJSON(res); $("#successfailmessage").html(obj.SuccFailMessage); if (obj.SuccFail=="success") { $("#userid").val(""); $("#username").val(""); $("#name").val(""); $("#surname").val(""); $("#passwd1").val(""); $("#passwd2").val(""); $("#email").val(""); $("#phone").val(""); $("#mobphone").val(""); $("#issysadmin").val(""); $("#isuseractive").val(""); $("#useradd").show('<img src="indicator.gif" />'); $("#userlist").html(""); } //userlistgenerate(); }
  7. Ibshas25
    the error is now solved.. there was nothing wronge with the sql as i stated before even with the error was pointing towards this. when using a unix based system dreamweaver does not provide the code line breaking for unix. once doing this it all started to work. thanks for your feedback guys.
  8. Ibshas25
    the sql q works fine
  9. Ibshas25
    <b>Warning</b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/export/SOI-50/students/m2009/abhr428/web/WebIbs/prjlistmenuPBT.php</b> on line <b>36</ just cant seem to get this to work.. help????? <?php include("JSON.php"); require_once("connectdb.php"); $req = json_decode(stripslashes($_POST['data']), true); $req["SuccFail"]="fail"; $req["SuccFailMessage"]="Error Occured."; $req["ResultData"]=""; //$logFile = 'logFile'; //error_log("isl=baþladý: ", 3, $logFile); if ($req['operation'] == "prjsearch") // select için veri geldi { // error_log("isl==select oluþuyor: ", 3, $logFile); $sql= "SELECT pr.prj_id, pr.prj_projectname ,pr.prj_startdate,med_description, tea_rolId, "; $sql.=" DATE_FORMAT(prj_startdate,'%d-%m-%Y') as prj_startdate, DATE_FORMAT(prj_enddate,'%d-%m-%Y') as prj_enddate , CASE prj_iscompleted WHEN 'Y' THEN 'Completed' WHEN 'N' THEN 'Not Completed' else 'Undefined' end as prj_iscompleted from teams "; $sql.=" LEFT JOIN projects as pr ON prj_id = tea_projectid "; $sql.=" LEFT JOIN metodology as med ON med.med_id = pr.prj_metodid " ; $sql.=" WHERE tea_userId =".$req["userid"]; $sql.=" GROUP by pr.prj_id, pr.prj_projectname,pr.prj_startdate order by pr.prj_startdate desc "; //error_log($sql, 3, $logFile); $result = mysql_query($sql); $reslist = "<table border='1'><tr><th>Project Id</th><th>Name</th><th>Methodology</th><th>Start Date</th><th>End date</th><th>Condition</th></tr>"; while($row = mysql_fetch_array($result)) { // error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile); $reslist .= "<tr><td><a href='#'onclick='javascript:PrjSearchChoose(".$row['prj_id'].", ".$row['tea_rolId'].");' >".$row['prj_id']."</a></td><td>".$row['prj_projectname']."</td><td>".$row['med_description']."</td><td> ".$row['prj_startdate']."</td><td>".$row['prj_enddate']."</td><td>".$row['prj_iscompleted']."</td> </tr>"; } // error_log($reslist, 3, $logFile); // error_log("$reslist: ".$reslist, 3, $logFile); $reslist .= "</table>"; $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully selected."; //alert($reslist); $req["ResultData"]=$reslist; mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } else if ($req['operation'] == "setuserrights") // set user rights { $sql= "select rol_projectMng, rol_teamsMng,rol_rolesMng,rol_usersMng,rol_metodMng,rol_ranklevel from roles where rol_Id = ".$req["rolid"]; // error_log($sql, 3, $logFile); $result=mysql_query($sql); $row=mysql_fetch_array($result); //if username exists if(mysql_num_rows($result)>0) { $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="user rights come."; //$row = mysql_fetch_array($result) //select rol_projectMng, rol_teamsMng,rol_rolesMng,rol_usersMng,rol_metodMng,rol_ranklevel from roles where rol_Id = 3 $_SESSION['projectMng']=$row['rol_projectMng']; $_SESSION['teamsMng']=$row['rol_teamsMng']; $_SESSION['rolesMng']=$row['rol_rolesMng']; $_SESSION['usersMng']=$row['rol_usersMng']; $_SESSION['metodMng']=$row['rol_metodMng']; $_SESSION['rol_ranklevel']=$row['rol_ranklevel']; $req["SuccFailMessage"]=$row['rol_projectMng'].$row['rol_teamsMng'].$row['rol_rolesMng'].$row['rol_usersMng'].$row['rol_metodMng'].$row['rol_ranklevel']; mysql_close($conn); //error_log($row['rol_ranklevel'].",".$row['projectMng'] , 3, $logFile); header("Content-type: text/plain"); echo json_encode($req); return; } else { header("Content-type: text/plain"); echo json_encode($req); //error_log("invalid", 3, $logFile); return; } } ?>
  10. Ibshas25
    i understand but to give access to certain pages would i need to put this code as well in the certain page e.g roles <?php if (isset($_SESSION['loggedUser'])) { echo 'You are logged in as: '.$_SESSION['loggedUser'].' <br>'; //echo '<a href="logoutPage1.php">Log out</a><br>'; //echo '<a href="profile_page.html">Jump to the Profile page</a><br>'; ?> <br> <INPUT TYPE="BUTTON" VALUE="Jump to the Project page" ONCLICK="window.location.href='projectBookAdmin.php'"> <?php } else { if (isset($usr_username)) { //if tried and failed to log in echo 'Could not log you in.<br>'; } else { // Have not tried to log in or have logged out echo 'You are not logged in.<br>'; } ?>
  11. Ibshas25
    so how would i set these sessions into my login page??????not sure where n what code to use 1-rol_projectMng` , sessionàisprojectadmin = rol_projectMng `rol_teamsMng` , sessionàisteamsadmin = rol_teamsMng `rol_rolesMng` , sessionàisrolesadmin = rol_rolesMng `rol_usersMng` , sessionàisusersadmin = rol_usersMng `rol_workBreakDowNMng` , sessionàworkbreakdowadmin = rol_workBreakDowNMng ` rol_DashboardMng ` , sessionàdashboardadmin = rol_DashboardMng ` usr_issysadmin ` , sessionàissysadmin = rol_DashboardMng ` rol_ranklevel ` , sessionàrolranklevel =rol_ranklevel <?php session_start(); if (isset($_POST['username']) && isset($_POST['password'])) { // if the user has just tried to log in $usr_username = $_POST['username']; $usr_password = $_POST['password']; //Connect to your Database $conn = mysql_connect("vega.soi.city.ac.uk", "", "") or die("Could not connect to MySQL Server: " . mysql_error()); //Select your Database mysql_select_db("abhr428") or die("Could not select database"); //form query $query = 'SELECT * FROM users WHERE usr_username = "'.$usr_username.'" AND usr_password = "'.$usr_password.'" '; //Execute query $result = mysql_query($query); //Count results $rowNo = mysql_num_rows($result); if ($rowNo > 0) { // if in the database register the user $_SESSION['loggedUser'] = $usr_username; mysql_free_result($result); mysql_close($conn); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <link href="stylesheet1.css" rel="stylesheet" type="text/css"/> <style type = "text/css"> #container { width: 250px; margin: auto; float:none; border:width:200px;height:100px;border:1px solid blue;"> } #logo1 { width: 250 px; height: 180 px; float:left; } h1 { font-size:8pt; } h2 { font-size:7px; } </style> </head> <body> <center> <div style="width:220px;height:260pt;border:5px solid #FFFFFF;"> <div id= "logo1"><img src="images/FINALlogo.jpg" width="60" height="50" /></div> <p><h1> Welcome to Project Book</h1></p> <h2> The methodology based mobile project management tool</h2> <br><a href="ProjectSignUp.php">Register</a></br> <?php if (isset($_SESSION['loggedUser'])) { echo 'You are logged in as: '.$_SESSION['loggedUser'].' <br>'; //echo '<a href="logoutPage1.php">Log out</a><br>'; //echo '<a href="profile_page.html">Jump to the Profile page</a><br>'; ?> <br> <INPUT TYPE="BUTTON" VALUE="Jump to the Project page" ONCLICK="window.location.href='projectBookAdmin.php'"> <?php } else { if (isset($usr_username)) { //if tried and failed to log in echo 'Could not log you in.<br>'; } else { // Have not tried to log in or have logged out echo 'You are not logged in.<br>'; } ?> <form method="post" action="projectBookF.php"> <table> <tr> <label> <td>Username: </td></label> <td><input type="text" name="username"></td> </tr> <tr> <label><td>Password: </td></label> <td><input type="password" name="password"></td> </tr> <tr> <td colspan="2" align="center"> <input type="submit" value="Log in"></td> </tr> </table> </form> </div> </center> <?php } ?> </div> </body> </html>
  12. Ibshas25
    i am getting this error below and i know its something small but cant see it.. help <b>Warning</b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/export/SOI-50/students/m2009/abhr428/web/WebIbs/projectSearchPBT1.php</b> on line <b>30</b><br /> <?php include("JSON.php"); require_once("connectdb.php"); $req = json_decode(stripslashes($_POST['data']), true); $req["SuccFail"]="fail"; $req["SuccFailMessage"]="Error Occured."; $req["ResultData"]=""; //$logFile = 'logFile'; // error_log("isl=baþladý: ", 3, $logFile); if ($req['operation'] == "projectsearch") // select için veri geldi { // error_log("isl==select oluþuyor: ", 3, $logFile); $sql= "select prj_id,prj_projectname,prj_metodid,prj_startdate, prj__enddate ,prj_iscompleted from projects "; // $sql.=" where (rol_id is null or rol_id = ". $req['rol'][0]['rolid']." ) and "; $sql.= "where (prj_projectname is null or prj_projectname like '". $req['prj'][0]['name']."%' ) "; $sql .= " order by prj_id"; // error_log($sql, 3, $logFile); $result = mysql_query($sql); //select rol_Id,rol_name,rol_projectMng,rol_teamsMng, rol_rolesMng ,rol_usersMng,rol_metodMng,rol_ranklevel,rol_recorddate,rol_recordId from roles where (rol_name is null or rol_name like '%' ) order by rol_name $reslist = "<table border='1'><tr><th>Project Id</th><th>Name</th><th>Project methof</th><th>Start Date</th><th> End date</th><th>Is project completed</th></tr>"; while($row = mysql_fetch_array($result)) { // rolid,name ,projectMng,teamsMng,rolesMng,usersMng,metodsMng,ranklevel // error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile); $reslist .= "<tr><td><a href='#' onclick='javascript:ProjectSearchChoose(".$row['prj_id'].", ".chr(34).$row['prj_projectname'].chr(34).",".chr(34).$row['prj_metodid'].chr(34).", ".chr(34).$row['prj_startdate'].chr(34).",".chr(34).$row['prj_enddate'].chr(34).",".chr(34).$row['prj_iscompleted'].");' >".$row['prj_id']."</a></td><td>".$row['prj_projectname']."</td><td>".$row['prj_metodid']."</td><td> ".$row['prj_startdate']."</td><td>".$row['prj_enddate']."</td><td>".$row['prj_iscompleted']."</td></tr>"; } // error_log($reslist, 3, $logFile); // error_log("$reslist: ".$reslist, 3, $logFile); $reslist .= "</table>"; $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully selected."; //alert($reslist); $req["ResultData"]=$reslist; mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } ?>
  13. Ibshas25
    cheers thats a geat example
  14. Ibshas25
    could you please give a simple example like the one ive posted please, as im still abit unsure thanks in advanced
  15. Ibshas25
    is this a good way of doing a simple admin different rights e.g if secret word then go to adminpage.php session_start(); $captcha = $_POST["captcha"] ; $secretword = $_SESSION["secretword"] ; if (strcmp( $captcha, $secretword )) { // it's a bot } else { // matched -- it's a human }
  16. Ibshas25
    <?php include("JSON.php"); require_once("connectdb.php"); $req = json_decode(stripslashes($_POST['data']), true); $req["SuccFail"]="fail"; $req["SuccFailMessage"]="Error Occured."; //$logFile = 'logFile'; // error_log("isl=baþladý: ", 3, $logFile); if ($req['operation'] == "usersearch") // select için veri geldi { // error_log("isl==select oluþuyor: ", 3, $logFile); $sql= "select usr_id, usr_username,usr_name,usr_surname,usr_email,usr_mobphone,usr_phone,usr_isuseractive from users"; $sql.=" where (usr_name is null or usr_name like '". $req['user'][0]['name']."%' ) and "; $sql.= "(usr_surname is null or usr_surname like '". $req['user'][0]['surname']."%' ) "; $sql .= " order by usr_name , usr_surname"; // error_log($sql, 3, $logFile); // error_log("sql: ".$sql, 3, $logFile); // error_log("\n", 3, $logFile); $result = mysql_query($sql); $reslist = "<table border='1'><tr><th>User Id</th><th>Username</th><th>Name</th><th>Surname</th><th>Email</th><th>Is Active</th></tr>"; while($row = mysql_fetch_array($result)) { // error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile); $reslist .= "<tr><td><a href='#' onclick='javascript:UserSearchChoose(".$row['usr_id'].", ".chr(34).$row['usr_username'].chr(34).",".chr(34).$row['usr_name'].chr(34).", ".chr(34).$row['usr_surname'].chr(34).",".chr(34).$row['usr_email'].chr(34).", ".chr(34).$row['usr_phone'].chr(34).",".chr(34).$row['usr_mobphone'].chr(34).", ".chr(34).$row['usr_isuseractive'].chr(34).");' >".$row['usr_id']."</a></td><td>".$row['usr_username']."</td><td>".$row['usr_name']."</td><td> ".$row['usr_surname']."</td><td>".$row['usr_email']."</td><td>".$row['usr_isuseractive']."</td></tr>"; } // error_log($reslist, 3, $logFile); // error_log("$reslist: ".$reslist, 3, $logFile); $reslist .= "</table>"; $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully selected."; //alert($reslist); $req["ResultData"]=$reslist; mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } else if ($req['operation'] == "userlist") // select için veri geldi { // error_log("isl==teamslist select oluþuyor: ", 3, $logFile); $sql="select usr.usr_name,usr.usr_surname where usr.usr_id =".$req['user'][0][usr_id]; $sql.=" order by usr.usr_name , usr.usr_surname "; $result = mysql_query($sql); $reslist = "<table border='1'><tr><th>Users Info</th> </tr>"; while($row = mysql_fetch_array($result)) { // error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile); //$user = $row['usr_name']." ".$row['usr_surname']; //$user = $row['usr_name']." ".$row['usr_surname']; $reslist .= "<tr><td><a href='#' onclick='javascript:userListChoose(".$row['usr_name'].chr(34).",".chr(34).$row['usr_surname'].chr(34).");'> </a></td></tr>"; $reslist .= "</table>"; $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully selected."; //alert($reslist); $req["ResultData"]=$reslist; mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } if ($req['operation'] == "userdelete") // teams silmek için geldi. { //error_log("isl==teamdelete: ", 3, $logFile); //$sql="delete from teams where tea_id=".$req['teamid']; mysql_query("delete from users where usr_id=".$req['userid']); //error_log("mysql_affected_rows= ".mysql_affected_rows($con), 3, $logFile); //var $affrows = mysql_affected_rows(); if ( mysql_affected_rows() > 0 ) { $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully deleted."; //error_log("isl==teamdelete:success ", 3, $logFile); } else { $req["SuccFail"]="fail"; //operation success or fail $req["SuccFailMessage"]="error occured ". mysql_error(); // error_log("isl==teamdelete:fail ", 3, $logFile); } mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } else if ($req['operation'] == "useradd") // teams silmek için geldi. { //error_log("isl==teamdelete: ", 3, $logFile); //$sql="delete from teams where tea_id=".$req['teamid']; $sql="insert into users VALUES (null,". $req['userId'].",".$req['username'].",".$req['usersurname'].", ".$req['useremail']." , ".$req['userphone'].", ".$req['usermob'].", ".$req['useractive'].",now(),".$req['recuser'].")"; mysql_query($sql); //error_log($sql, 3, $logFile); //var $affrows = mysql_affected_rows(); if ( mysql_affected_rows() > 0 ) { $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully added."; //error_log("isl==teamdelete:success ", 3, $logFile); } else { $req["SuccFail"]="fail"; //operation success or fail $req["SuccFailMessage"]="error occured ". mysql_error(); // error_log("isl==teamdelete:fail ", 3, $logFile); } mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } } ?>
  17. Ibshas25
    deleting works, but can't seem to get the add to work???? any ideas <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Search User</title> <link href="stylesheet1.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="jquery-1.4.3.js"></script> <script type="text/javascript" src="jquery.json-2.2.js"></script> <style type="text/css"> body { font-size:12px; font-family:Arial, Helvetica, sans-serif; } form { display:block; width:260px; } form .input{ width:120px; float:right; } form label { display:block; width:260px; clear:both; } form textarea { display:block; width:260px; } </style> <script type="text/javascript"> // alert("document loaded 1"); // $(document).ready(function(){ //$("#projectid").html("1"); // alert("document loaded 1"); function userlistgenerate(){ var data = { "operation" : "userlist", "users": [ { "userid" : "usr_id"}, ] // end of sales array } //alert("geldi 2"); //var dataString = JSON.(data); var dataString = $.toJSON(data); //alert("geldi 3"); // alert(dataString); $.post('UserSearchPBT.php', { data: dataString}, userlistResult, "text"); $("#selectedUserName").html(""); // $("selectedUserName").hide("fast"); } function userlistResult(res) { var obj = $.evalJSON(res); //alert(obj.ResultData); //$("#sales1Lastname").html("Lastname of sales[1]: " +obj.sales[0].lastname); $("#userlist").html(obj.ResultData); $("#selectedUserName").html(""); //$("selectedUserName").hide("fast"); } function UserSearchChoose(userid,username ,name,surname,email,phone,mobphone,isactive){ $("#userid").val(userid); $("#username").val(username); $("#name").val(name); $("#surname").val(surname); $("#email").val(email); $("#phone").val(phone); $("#mobphone").val(mobphone); $("#isuseractive").val(isactive); $("#useradd").hide("fast"); } function usersearch() { $("#useradd").show(); var name=$("#name").attr("value"); var surname=$("#surname").attr("value"); var data = { "operation" : "usersearch", "user": [ { "name" : name, "surname" : surname } ] // end of sales array } var dataString = $.toJSON(data); $.post('UserSearchPBT.php', { data: dataString}, usersearchResult, "text"); } function usersearchResult(res) { var obj = $.evalJSON(res); $("#userlist").html(obj.ResultData); } function userdelete() { var useridval = $("#userid").attr("value"); alert (useridval); var data = { "operation" : "teamdelete", "userid" : useridval } var dataString = $.toJSON(data); $.post('UserSearchPBT.php', { data: dataString}, userdeleteResult, "text"); } function userdeleteResult(res) { var obj = $.evalJSON(res); $("#successfailmessage").html(obj.SuccFailMessage); userlistgenerate(); } function useradd() { //alert ("team add a geliyor"); var userId = $("#userid").attr("value"); var username = $("#username").attr("value"); var usersurname = $("#surname").attr("value"); var useremail = $("#useremail").attr("value"); var userphone = $("#userphone").attr("value"); var usermob = $("#usermob").attr("value"); var useractive = $("#useractive").attr("value"); // alert ("--".projectId."-".userId."-".rolId."--"); var data = { "operation" : "useradd", "userId" : userId, "username" : username, "useremail" : useremail, "userphone" : userphone, "usermob" : usermob, "useractive" : useractive, "recuser" : 1 } var dataString = $.toJSON(data); $.post('UserSearchPBT.php', { data: dataString}, userdeleteResult, "text"); alert ("user add a geliyor ajax bitti"); } </script> </head> <body> <form id="iletisim"> <div id="formdiv"> <table><tr> <td><span id="successfailmessage"></span></td> <tr><td><span id="userlist"></span> </td></tr> <tr><td><span id="selectedUserName"></span></td></tr> <tr><td><label for="name">User Name<input class="input" name="username" id="username" type="text" value="" /></label></td></tr> <tr><td><label for="name">Name<input class="input" name="name" id="name" type="text" value="" /></label></td></tr> <tr><td><label for="surname">Surname<input class="input" name="surname" id="surname" type="text" value="" /></label><tr> <tr><td><label for="email">Email<input class="input" name="email" id="email" type="text" value="" /></label><tr> <tr><td><label for="phone">Phone<input class="input" name="phone" id="phone" type="text" value="" /></label><tr> <tr><td><label for="phone">Mobile Phone<input class="input" name="mobphone" id="mobphone" type="text" value="" /></label><tr> <tr><td><label for="phone">Is User Active(Y/N)<input class="input" name="isuseractive" id="isuseractive" type="text" value="" /></label></td></tr> <tr><td><a href='#' onclick="javascript:usersearch();">Search User</a> </td></tr><tr> <tr><td><a href='#' id="useradd" onclick="javascript:useradd();">Add</a> </td></tr><tr> <tr><td><a href='#' id="userdelete" onclick="javascript:userdelete();">Delete</a> </td></tr><tr> <tr><td><a href='#' id="userupdate" onclick="javascript:userupdate();">Update</a> </td></tr><tr> </table> <input type="hidden" id = "userid" value="" name="userid" /> </div> </form> </body> </html>
  18. Ibshas25
    //line starting 115 $sql="insert into user VALUES (null,". $req['userid'].",".$req['username'].",".$req['usersurname'].", ".$req['useremail']" , "$req['userphone']", "$req['usermob']", "$req['useractive']"now(),".$req['recuser'].")"; mysql_query($sql);
  19. Ibshas25
    <b>Parse error</b>: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in <b>/export/SOI-50/students/m2009/abhr428/web/WebIbs/UserSearchPBT.php</b> on line <b>115</b><br /> <?php include("JSON.php"); require_once("connectdb.php"); $req = json_decode(stripslashes($_POST['data']), true); $req["SuccFail"]="fail"; $req["SuccFailMessage"]="Error Occured."; //$logFile = 'logFile'; // error_log("isl=baþladý: ", 3, $logFile); if ($req['operation'] == "usersearch") // select için veri geldi { // error_log("isl==select oluþuyor: ", 3, $logFile); $sql= "select usr_id, usr_username,usr_name,usr_surname,usr_email,usr_mobphone,usr_phone,usr_isuseractive from users"; $sql.=" where (usr_name is null or usr_name like '". $req['user'][0]['name']."%' ) and "; $sql.= "(usr_surname is null or usr_surname like '". $req['user'][0]['surname']."%' ) "; $sql .= " order by usr_name , usr_surname"; // error_log($sql, 3, $logFile); // error_log("sql: ".$sql, 3, $logFile); // error_log("\n", 3, $logFile); $result = mysql_query($sql); $reslist = "<table border='1'><tr><th>User Id</th><th>Username</th><th>Name</th><th>Surname</th><th>Email</th><th>Is Active</th></tr>"; while($row = mysql_fetch_array($result)) { // error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile); $reslist .= "<tr><td><a href='#' onclick='javascript:UserSearchChoose(".$row['usr_id'].", ".chr(34).$row['usr_username'].chr(34).",".chr(34).$row['usr_name'].chr(34).", ".chr(34).$row['usr_surname'].chr(34).",".chr(34).$row['usr_email'].chr(34).", ".chr(34).$row['usr_phone'].chr(34).",".chr(34).$row['usr_mobphone'].chr(34).", ".chr(34).$row['usr_isuseractive'].chr(34).");' >".$row['usr_id']."</a></td><td>".$row['usr_username']."</td><td>".$row['usr_name']."</td><td> ".$row['usr_surname']."</td><td>".$row['usr_email']."</td><td>".$row['usr_isuseractive']."</td></tr>"; } // error_log($reslist, 3, $logFile); // error_log("$reslist: ".$reslist, 3, $logFile); $reslist .= "</table>"; $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully selected."; //alert($reslist); $req["ResultData"]=$reslist; mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } else if ($req['operation'] == "userlist") // select için veri geldi { // error_log("isl==teamslist select oluþuyor: ", 3, $logFile); $sql="select usr.usr_name,usr.usr_surname where usr.usr_id =".$req['user'][0][usr_id]; $sql.=" order by usr.usr_name , usr.usr_surname "; $result = mysql_query($sql); $reslist = "<table border='1'><tr><th>Users Info</th> </tr>"; while($row = mysql_fetch_array($result)) { // error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile); //$user = $row['usr_name']." ".$row['usr_surname']; //$user = $row['usr_name']." ".$row['usr_surname']; $reslist .= "<tr><td><a href='#' onclick='javascript:userListChoose(".$row['usr_name'].chr(34).",".chr(34).$row['usr_surname'].chr(34).");'> </a></td></tr>"; $reslist .= "</table>"; $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully selected."; //alert($reslist); $req["ResultData"]=$reslist; mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } if ($req['operation'] == "userdelete") // teams silmek için geldi. { //error_log("isl==teamdelete: ", 3, $logFile); //$sql="delete from teams where tea_id=".$req['teamid']; mysql_query("delete from users where usr_id=".$req['userid']); //error_log("mysql_affected_rows= ".mysql_affected_rows($con), 3, $logFile); //var $affrows = mysql_affected_rows(); if ( mysql_affected_rows() > 0 ) { $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully deleted."; //error_log("isl==teamdelete:success ", 3, $logFile); } else { $req["SuccFail"]="fail"; //operation success or fail $req["SuccFailMessage"]="error occured ". mysql_error(); // error_log("isl==teamdelete:fail ", 3, $logFile); } mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } else if ($req['operation'] == "useradd") // teams silmek için geldi. { //error_log("isl==teamdelete: ", 3, $logFile); //$sql="delete from teams where tea_id=".$req['teamid']; $sql="insert into user VALUES (null,". $req['userid'].",".$req['username'].",".$req['usersurname'].", ".$req['useremail']" , "$req['userphone']", "$req['usermob']", "$req['useractive']"now(),".$req['recuser'].")"; mysql_query($sql); //error_log($sql, 3, $logFile); //var $affrows = mysql_affected_rows(); if ( mysql_affected_rows() > 0 ) { $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully added."; //error_log("isl==teamdelete:success ", 3, $logFile); } else { $req["SuccFail"]="fail"; //operation success or fail $req["SuccFailMessage"]="error occured ". mysql_error(); // error_log("isl==teamdelete:fail ", 3, $logFile); } mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } ?>
  20. Ibshas25
    The form page works with the validation and doestn gve any errors when submitting, but the server is throwing back these errors hence why its probably not loading the data in the databse... not sure how to go about what u just mentioned.
  21. Ibshas25
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Search User</title> <link href="stylesheet1.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="jquery-1.4.3.js"></script> <script type="text/javascript" src="jquery.json-2.2.js"></script> <style type="text/css"> body { font-size:12px; font-family:Arial, Helvetica, sans-serif; } form { display:block; width:260px; } form .input{ width:120px; float:right; } form label { display:block; width:260px; clear:both; } form textarea { display:block; width:260px; } </style> <script type="text/javascript"> // alert("document loaded 1"); $(document).ready(function(){ //$("#projectid").html("1"); // alert("document loaded 1"); function userlistgenerate(){ var data = { "operation" : "userlist", "teams": [ { "userid" : "usr_id"}, ] // end of sales array } //alert("geldi 2"); //var dataString = JSON.(data); var dataString = $.toJSON(data); //alert("geldi 3"); // alert(dataString); $.post('UserSearchPBT.php', { data: dataString}, userlistResult, "text"); $("#selectedUserName").html(""); // $("selectedUserName").hide("fast"); } function userlistResult(res) { //alert("checkResult"); // $("#userlist").html("Full response: " +res); var obj = $.evalJSON(res); //alert(obj.ResultData); //$("#sales1Lastname").html("Lastname of sales[1]: " +obj.sales[0].lastname); $("#userlist").html(obj.ResultData); $("#selectedUserName").html(""); //$("selectedUserName").hide("fast"); } function usersearch() { //alert(document.getElementById("name").value); //alert(document.getElementById("surname").value); var name=$("#name").attr("value"); var surname=$("#surname").attr("value"); // alert ("user search a geliyor"); //var formdata = 'name' : "'+document.getElementById("name").value+",'surname' : '"+document.getElementById("surname").value" ; var data = { "operation" : "usersearch", "user": [ { "name" : name, "surname" : surname } // { "name" : name+"xx", "surname" : surname+"xx" }, // { "name" : name+"yy", "surname" : surname+"yy" } ] // end of sales array } // alert("geldi 1"); //var dataString = JSON.(data); var dataString = $.toJSON(data); // alert(dataString); //alert("geldi 3"); // alert(dataString); $.post('UserSearchPBT.php', { data: dataString}, usersearchResult, "text"); } function usersearchResult(res) { //alert("checkResult"); // $("#userlist").html("Full response: " +res); var obj = $.evalJSON(res); //alert(obj.ResultData); //$("#sales1Lastname").html("Lastname of sales[1]: " +obj.sales[0].lastname); $("#userlist").html(obj.ResultData); } function UserSearchChoose(userId,userName,userSurName){ //alert(userSurName) $("#userid").val(userId); $("#selectedUserName").html(userName+" "+userSurName); //$("selectedUserName").show("fast"); //$("#selectedUserName").val(userName+" "+userSurName); //$("div").hide(2000); //$("#selectedUserName").show("slow"); } </script> </head> <body> <form id="iletisim"> <div id="formdiv"> <table><tr> <td><span id="successfailmessage"></span></td> <tr><td><span id="userlist"></span> </td></tr> <td> <!-- <a href='#' onclick="javascript:teamsearch();">Team Search</a> --> <a href='#' onclick="javascript:userdelete();">Delete User</a> </td> <tr><td> </td></tr> <tr><td><span id="selectedUserName"></span></td></tr> <tr><td><label for="name">Name<input class="input" name="name" id="name" type="text" value="" /></label></td></tr> <tr><td><label for="surname">Surname<input class="input" name="surname" id="surname" type="text" value="" /></label><tr> <tr><td><a href='#' onclick="javascript:usersearch();">Search User</a> </td></tr> <tr><td><span id="userlist"></span> </td></tr> </table></td></tr> </tr> </div> </form> </body> </html> ?php include("JSON.php"); require_once("connectdb.php"); $req = json_decode(stripslashes($_POST['data']), true); $req["SuccFail"]="fail"; $req["SuccFailMessage"]="Error Occured."; //$logFile = 'logFile'; // error_log("isl=baþladý: ", 3, $logFile); if ($req['operation'] == "usersearch") // select için veri geldi { // error_log("isl==select oluþuyor: ", 3, $logFile); $sql= "select usr_id, usr_username,usr_name,usr_surname,usr_isuseractive from users"; $sql.=" where (usr_name is null or usr_name like '". $req['user'][0]['name']."%' ) and "; $sql.= "(usr_surname is null or usr_surname like '". $req['user'][0]['surname']."%' ) "; $sql .= " order by usr_name , usr_surname"; //error_log($sql, 3, $logFile); //error_log("sql: ".$sql, 3, $logFile); //error_log("\n", 3, $logFile); $result = mysql_query($sql); $reslist = "<table border='1'><tr><th>User Id</th><th>Username</th><th>Name</th><th>Surname</th><th>Is Active</th></tr>"; while($row = mysql_fetch_array($result)) { // error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile); $user = $row['usr_name']." ".$row['usr_surname']; $reslist .= "<tr><td><a href='#' onclick='javascript:UserSearchChoose(".$row['usr_id'].",".chr(34).$row['usr_name'].chr(34).",".chr(34).$row['usr_surname'].chr(34).");'>".$row['usr_id']."</a></td><td>" . $row['usr_username']chr(34) . "</td><td>" . $row['usr_name'] . "</td>"; $reslist .= "<td>" . $row['usr_surname'] . "</td><td>" . $row['usr_isuseractive'] . "</td></tr>"; } // error_log("$reslist: ".$reslist, 3, $logFile); $reslist .= "</table>"; $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully selected."; //alert($reslist); $req["ResultData"]=$reslist; mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } else if ($req['operation'] == "userlist") // select için veri geldi { // error_log("isl==teamslist select oluþuyor: ", 3, $logFile); $sql="select usr.usr_name,usr.usr_surname where usr.usr_id =".$req['user'][0][usr_id]; $sql.=" order by usr.usr_name , usr.usr_surname "; $result = mysql_query($sql); $reslist = "<table border='1'><tr><th>Users Info</th> </tr>"; while($row = mysql_fetch_array($result)) { // error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile); //$user = $row['usr_name']." ".$row['usr_surname']; $reslist = "<tr><td><a href='#' onclick='javascript:usersearchChoose(".$row['usr_id'].",".$row['usr_username'].chr(34).",". $row['usr_name'].chr(34)",".$row['usr_surname'].chr(34).",".chr(34).$row['usr_email'].chr(34).",".chr(34).$row'usr_contact'].chr(34).");'> " . " ==> " . $row['usr_isuseractive'] . "</a></td></tr>"; } // error_log("$reslist: ".$reslist, 3, $logFile); $reslist .= "</table>"; $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully selected."; //alert($reslist); $req["ResultData"]=$reslist; mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } else if ($req['operation'] == "userdelete") // teams silmek için geldi. { //error_log("isl==teamdelete: ", 3, $logFile); //$sql="delete from teams where tea_id=".$req['teamid']; mysql_query("delete from users where usr_id=".$req['usr_id']); //error_log("mysql_affected_rows= ".mysql_affected_rows($con), 3, $logFile); //var $affrows = mysql_affected_rows(); if ( mysql_affected_rows() > 0 ) { $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully deleted."; //error_log("isl==teamdelete:success ", 3, $logFile); } else { $req["SuccFail"]="fail"; //operation success or fail $req["SuccFailMessage"]="error occured ". mysql_error(); // error_log("isl==teamdelete:fail ", 3, $logFile); } mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; }
  22. Ibshas25
    errors shown below cant understand why its not defined???? Notice: Undefined index: username in /export/SOI-50/students/m2009/abhr428/web/WebIbs/userRegProcess.php on line 4 Notice: Undefined index: name in /export/SOI-50/students/m2009/abhr428/web/WebIbs/userRegProcess.php on line 5 Notice: Undefined index: surname in /export/SOI-50/students/m2009/abhr428/web/WebIbs/userRegProcess.php on line 6 Notice: Undefined index: password in /export/SOI-50/students/m2009/abhr428/web/WebIbs/userRegProcess.php on line 7 Notice: Undefined index: email in /export/SOI-50/students/m2009/abhr428/web/WebIbs/userRegProcess.php on line 8 Notice: Undefined index: contact in /export/SOI-50/students/m2009/abhr428/web/WebIbs/userRegProcess.php on line 9 save_failed <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>User Register</title> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <link rel="stylesheet" type="text/css" href="stylesheet1.css"/> <script type="text/javascript" src="jquery-1.4.3.js"></script> <script type="text/javascript" src="jquery.json-2.2.js"></script> <script type="text/javascript" src="forms.js"></script> <script type="text/javascript" src="saveUser1.js"></script> </head> <body> <center> <div style="width:280pt;height:350pt;border:5px solid #FFFFFF;"> <div id= "logo1"><img src="images/FINALlogo.jpg" width="60" height="50" /></div> <form id="user_details" action="userRegProcess.php" method="post"> <h1>User Registration form</h1> <legend> Enter Detail Below</legend> <br /> <table> <fieldset> <tr><td width="241"><label for="name">Username</label> <tr><td><input type="text" name="username"/></tr></td> <tr><td><label for="name">Name </label> <tr><td><input type="text" name="name"/></tr></td> <tr><td><label for="name">Surname</label> <tr><td><input type="text" name="surname" width="200"/></tr></td> <tr><td><label for="name">Enter password</label> <tr><td><input type="text" name="password" width="200"/></tr></td> <tr><td><label for="name">Email Address</label> <tr><td><input type="text" name="email" width="250"/></tr></td> <tr><td><label for="name">Contact</label> <tr><td><input type="text" name="contact" width="250"/></tr></td> <tr><td><button type="button" onclick="processUserDetails();">Submit</button></td></tr> <div style="clear:both;"></div> </fieldset> </table> </form> </div> <?php // Retrieve form data $username = $_POST['username']; $name = $_POST['name']; $surname = $_POST['surname']; $password = $_POST['password']; $email = $_POST['email']; $contact = $_POST['contact']; if (!$username || !$name || !$surname || !$Password || !email || !contact) { echo "save_failed"; return; } $db = array( 'host' => 'vega.soi.city.ac.uk', 'login' => 'abhr428', 'password' => '040010722', 'database' => 'abhr428', ); $link = @mysql_connect($db['host'], $db['login'], $db['password']); if (!$link) { echo "save_failed"; return; } mysql_select_db($db['database']); // Clean variables before performing insert $clean_username = mysql_real_escape_string($username); $clean_name = mysql_real_escape_string($name); $clean_surname = mysql_real_escape_string($surname); $clean_password = mysql_real_escape_string($password); $clean_email = mysql_real_escape_string($email); $clean_contact = mysql_real_escape_string($contact); // Perform insert $sql = "INSERT INTO users (usr_id, usr_name, usr_surname, usr_password, usr_email, usr_contact) VALUES ('{$clean_username}', {$clean_name}, '{$clean_surname}', '{$clean_password}', '{clean_email}', '{clean_contact}')"; if (@mysql_query($sql, $link)) { echo "success"; @mysql_close($link); return; } else { echo "save_failed"; @mysql_close($link); return; } ?>
  23. Ibshas25
    teams.html <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Teams Management</title> <link href="stylesheet1.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="jquery-1.4.3.js"></script> <script type="text/javascript" src="jquery.json-2.2.js"></script> <style type="text/css"> body { font-size:12px; font-family:Arial, Helvetica, sans-serif; } form { display:block; width:260px; } form .input{ width:120px; float:right; } form label { display:block; width:260px; clear:both; } form textarea { display:block; width:260px; } </style> <script type="text/javascript"> // After Document Load Complete $(document).ready(function(){ //$("#projectid").html("1"); // alert("document loaded 1"); var data = { "operation" : "rolesearch", "roles": [ { "rolname" : "%"}, ] // end of sales array } //alert("geldi 2"); //var dataString = JSON.(data); var dataString = $.toJSON(data); //alert("geldi 3"); // alert(dataString); $.post('teams.php', { data: dataString}, rolesearchResult, "text"); }); function rolesearchResult(res) { //alert("checkResult"); // $("#userlist").html("Full response: " +res); var obj = $.evalJSON(res); //alert(obj.ResultData); //$("#sales1Lastname").html("Lastname of sales[1]: " +obj.sales[0].lastname); $("#rollist").html(obj.ResultData); teamslistgenerate(); } function teamslistgenerate(){ var data = { "operation" : "teamslist", "teams": [ { "projectid" : "1"}, ] // end of sales array } //alert("geldi 2"); //var dataString = JSON.(data); var dataString = $.toJSON(data); //alert("geldi 3"); // alert(dataString); $.post('teams.php', { data: dataString}, teamslistResult, "text"); } function teamslistResult(res) { //alert("checkResult"); // $("#userlist").html("Full response: " +res); var obj = $.evalJSON(res); //alert(obj.ResultData); //$("#sales1Lastname").html("Lastname of sales[1]: " +obj.sales[0].lastname); $("#teamlist").html(obj.ResultData); } // TeamListChoose(".$row['tea_id'].",".$row['tea_projectId'].",".row['tea_userId'].",".$row['tea_rolId']."," .chr(34).$row['usr_name'] .chr(34).",".chr(34).$row['usr_surname'].chr(34).") function TeamListChoose(teamid,projectid,userid,rolid,name,surname) { // Delete için teamid , select için diğerleri kullanılacak. seçilen row ekranda düzenlenecek. //$("#teamid").html(teamid); $("#teamid").val(teamid); $("#selectedUserId").html(userid); $("#selectedUserName").html(name+" "+surname); $('#rollist option:selected').removeAttr('selected'); $('#rollist option[value='+rolid+']').attr('selected', true); } function usersearch() { //alert(document.getElementById("name").value); //alert(document.getElementById("surname").value); var name=$("#name").attr("value"); var surname=$("#surname").attr("value"); // alert ("user search a geliyor"); //var formdata = 'name' : "'+document.getElementById("name").value+",'surname' : '"+document.getElementById("surname").value" ; var data = { "operation" : "usersearch", "user": [ { "name" : name, "surname" : surname } // { "name" : name+"xx", "surname" : surname+"xx" }, // { "name" : name+"yy", "surname" : surname+"yy" } ] // end of sales array } // alert("geldi 1"); //var dataString = JSON.(data); var dataString = $.toJSON(data); // alert(dataString); //alert("geldi 3"); // alert(dataString); $.post('teams.php', { data: dataString}, usersearchResult, "text"); } function usersearchResult(res) { //alert("checkResult"); // $("#userlist").html("Full response: " +res); var obj = $.evalJSON(res); //alert(obj.ResultData); //$("#sales1Lastname").html("Lastname of sales[1]: " +obj.sales[0].lastname); $("#userlist").html(obj.ResultData); } function UserSearchChoose(userId,userName,userSurName){ alert(userId); $("#userid").val(userId); $("#selectedUserName").val(userName+ " "+userSurName); } function teamdelete() { var teamidval = $("#teamid").attr("value"); alert (teamidval); var data = { "operation" : "teamdelete", "teamid" : teamidval } var dataString = $.toJSON(data); $.post('teams.php', { data: dataString}, teamdeleteResult, "text"); } function teamdeleteResult(res) { var obj = $.evalJSON(res); $("#successfailmessage").html(obj.SuccFailMessage); teamslistgenerate(); } function teamadd() { //alert ("team add a geliyor"); var projectId = $("#projectid").attr("value"); var userId = $("#userid").attr("value"); var rolId = $("#rollist option:selected").val(); // alert ("--".projectId."-".userId."-".rolId."--"); var data = { "operation" : "teamadd", "projectId" : projectId, "userId" : userId, "rolId" : rolId, "recuser" : 1 } var dataString = $.toJSON(data); $.post('teams.php', { data: dataString}, teamdeleteResult, "text"); alert ("user add a geliyor ajax bitti"); } </script> </head> <body> <center> <div style="width:280pt;height:280pt;border:5px solid #FFFFFF;"> <div id= "logo1"><img src="images/FINALlogo.jpg" width="60" height="50" /></div> <form id="iletisim" method="post" > <span id="successfailmessage"></span> <tr><td> <label for"teamid">Team ID</label> <td><input class="input" name="teamid" id="teamid" type="text" value="" /> </tr></td> <tr><td> <label for"project id">Project ID</label> <td><input class="input" name="projectid" id="projectid" type="text" value="1" /> </tr></td> <tr><td> <label for "userid">User ID</label> <td><input class="input" name="userid" id="userid" type="text" value="" /> </tr></td> <tr><td> <span id="selectedUserName"></span> </tr></td> <tr><td> <label for="name">Name</label> <td><input class="input" name="name" id="name" type="text" value="" /> </tr></td> <tr><td> <label for="surname">Surname</label> <td><input class="input" name="surname" id="surname" type="text" value="" /> </tr></td> <tr><td><a href='#' onclick="javascript:usersearch();">Search User</a> </tr></td> <p> <tr><td><span id="userlist"></span> </tr></td></p> <br> <tr><td><span id="rollist"></span></tr></td> </br> <tr><a href='#' onclick="javascript:teamsearch();">Search</a> </tr> <tr><td> <a href='#' onclick="javascript:teamadd();">Add</a> </tr></td> <a href='#' onclick="javascript:teamdelete();">Delete</a> <span id="teamlist"></span> </form> </div> </center> </body> </html>
  24. Ibshas25
    i have tried this but it hasnt made a difference... is there something im missing?? <form id"" method ="post">
  25. Ibshas25
    <?php include("JSON.php"); require_once("connectdb.php"); /*Connect to your Database $conn = mysql_connect("127.0.0.1", "root", "kasapogluo") or die("Could not connect to MySQL Server: " . mysql_error()); //Select your Database mysql_select_db("test") or die("Could not select database"); */ $req = json_decode(stripslashes($_POST['data']), true); $req["SuccFail"]="fail"; $req["SuccFailMessage"]="Error Occured."; //$logFile = 'logFile'; // error_log("isl=baþladý: ", 3, $logFile); if ($req['operation'] == "usersearch") // select için veri geldi { // error_log("isl==select oluþuyor: ", 3, $logFile); $sql= "select usr_id, usr_username,usr_name,usr_surname,usr_isuseractive from users"; $sql.=" where (usr_name is null or usr_name like '". $req['user'][0]['name']."%' ) and "; $sql.= "(usr_surname is null or usr_surname like '". $req['user'][0]['surname']."%' ) "; $sql .= " order by usr_name , usr_surname"; // error_log($sql, 3, $logFile); //error_log("sql: ".$sql, 3, $logFile); //error_log("\n", 3, $logFile); $result = mysql_query($sql); $reslist = "<table border='1'><tr><th>User Id</th><th>Username</th><th>Name</th><th>Surname</th><th>Is Active</th></tr>"; while($row = mysql_fetch_array($result)) { // error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile); $user = $row['usr_name']." ".$row['usr_surname']; $reslist .= "<tr><td><a href='#' onclick='javascript:UserSearchChoose(".$row['usr_id'].",".chr(34).$row['usr_name'].chr(34).",".chr(34).$row['usr_surname'].chr(34).");'>".$row['usr_id']."</a></td><td>" . $row['usr_username'] . "</td><td>" . $row['usr_name'] . "</td>"; $reslist .= "<td>" . $row['usr_surname'] . "</td><td>" . $row['usr_isuseractive'] . "</td></tr>"; } // error_log("$reslist: ".$reslist, 3, $logFile); $reslist .= "</table>"; // error_log("$reslist: ".$reslist, 3, $logFile); // error_log("\n", 3, $logFile); $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully selected."; //alert($reslist); $req["ResultData"]=$reslist; mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } else if ($req['operation'] == "rolesearch") // select için veri geldi { $sql= "select rol_Id, rol_name from roles order by rol_name"; $result = mysql_query($sql); $reslist = "<select id='roles' name='roles'>"; while($row = mysql_fetch_array($result)) { $reslist .= "<option value='".$row['rol_Id']."' "; if($row['rol_Id']==1) { $reslist .= " selected "; } $reslist .= " >".$row['rol_name']."</option>"; } //error_log("$reslist: ".$reslist, 3, $logFile); //error_log("\n", 3, $logFile); $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully selected."; //alert($reslist); $req["ResultData"]=$reslist; mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } else if ($req['operation'] == "teamslist") // select için veri geldi { // error_log("isl==teamslist select oluþuyor: ", 3, $logFile); $sql="select tea.tea_id,tea.tea_projectId, prj.prj_projectname , tea.tea_userId,usr.usr_name,usr.usr_surname,tea.tea_rolId,rol.rol_name from teams as tea LEFT JOIN projects as prj ON prj .prj_id = tea.tea_projectId LEFT JOIN users as usr ON usr.usr_id = tea.tea_userId LEFT JOIN roles as rol ON rol.rol_Id = tea.tea_rolId where tea.tea_projectId =".$req['teams'][0][projectid]; $sql.=" order by usr.usr_name , usr.usr_surname ,prj.prj_projectname "; /* (usr.usr_name is null or usr.usr_name like 'ib%' ) and (usr.usr_surname is null or usr.usr_surname like '%' ) order by usr.usr_name , usr.usr_surname ,prj.prj_projectname $sql= "select usr_id, usr_username,usr_name,usr_surname,usr_isuseractive from users"; $sql.=" where (usr_name is null or usr_name like '". $req['user'][0]['name']."%' ) and "; $sql.= "(usr_surname is null or usr_surname like '". $req['user'][0]['surname']."%' ) "; $sql .= " order by usr_name , usr_surname"; */ //error_log("sql: ".$sql, 3, $logFile); //error_log("\n", 3, $logFile); $result = mysql_query($sql); $reslist = "<table border='1'><tr><th>Teams Info</th> </tr>"; while($row = mysql_fetch_array($result)) { // error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile); //$user = $row['usr_name']." ".$row['usr_surname']; $reslist .= "<tr><td><a href='#' onclick='javascript:TeamListChoose(".$row['tea_id'].",".$row['tea_projectId'].",".$row['tea_userId'].",".$row['tea_rolId'].",".chr(34).$row['usr_name'].chr(34).",".chr(34).$row['usr_surname'].chr(34).");'> ". $row['rol_name'] . " ==> " . $row['usr_name'] . " ". $row['usr_surname'] . "</a></td></tr>"; } // error_log("$reslist: ".$reslist, 3, $logFile); $reslist .= "</table>"; // error_log("$reslist: ".$reslist, 3, $logFile); // error_log("\n", 3, $logFile); $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully selected."; //alert($reslist); $req["ResultData"]=$reslist; mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } else if ($req['operation'] == "teamdelete") // teams silmek için geldi. { //error_log("isl==teamdelete: ", 3, $logFile); //$sql="delete from teams where tea_id=".$req['teamid']; mysql_query("delete from teams where tea_id=".$req['teamid']); //error_log("mysql_affected_rows= ".mysql_affected_rows($con), 3, $logFile); //var $affrows = mysql_affected_rows(); if ( mysql_affected_rows() > 0 ) { $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully deleted."; //error_log("isl==teamdelete:success ", 3, $logFile); } else { $req["SuccFail"]="fail"; //operation success or fail $req["SuccFailMessage"]="error occured ". mysql_error(); // error_log("isl==teamdelete:fail ", 3, $logFile); } mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } else if ($req['operation'] == "teamadd") // teams silmek için geldi. { //error_log("isl==teamdelete: ", 3, $logFile); //$sql="delete from teams where tea_id=".$req['teamid']; $sql="insert into teams VALUES (null,". $req['projectId'].",".$req['userId'].",".$req['rolId'].",now(),".$req['recuser'].")"; mysql_query($sql); //error_log($sql, 3, $logFile); //var $affrows = mysql_affected_rows(); if ( mysql_affected_rows() > 0 ) { $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully deleted."; //error_log("isl==teamdelete:success ", 3, $logFile); } else { $req["SuccFail"]="fail"; //operation success or fail $req["SuccFailMessage"]="error occured ". mysql_error(); // error_log("isl==teamdelete:fail ", 3, $logFile); } mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } ?>
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.