Jump to content

cleary1981

Members
 View Profile  See their activity

  • Posts

    210

  • Joined

  • Last visited

 Content Type 

Everything posted by cleary1981

  1. cleary1981
    yeah that works
  2. cleary1981
    heres a full listing <?php if ($_COOKIE["auth"] == "1") { } else { //redirect back to login form if not authorised header ("Location: loginform.html"); exit; } ?> <html> <head> <title>TES - Pricing System</title> <style type="text/css"> #canvas { padding:0px; position: absolute; background-color:grey; border:dashed gray 1px; top: 5px; padding:0px; width:100%; height:470px; float:left; font-size: 8px; font-family:Arial, Helvetica, sans-serif; overflow: scroll; } #controls { margin:auto; padding:10px; position: absolute; width:100%; top:475px; background: grey; border:dashed gray 1px; height: 100px; } .clear { clear:both; } label { width:30px; height:32px; margin-top:3px; margin-right:2px; padding-top:1px; padding-left:6px; float:left; display: block; font-family:Arial, Helvetica, sans-serif; font-size: 115%; letter-spacing: -1px; font-weight: normal; line-height: 1.1; color:#666; } fieldset { border:0; } #temp { position:absolute; top:110px; left:189px; }#fbutton { position:absolute; top:50px; left:690px; width:600px; } #fmodel { position:absolute; top:10px; left:400px; } #ftype { position:absolute; top:10px; left:10px; } #fsubtype { position:absolute; top:10px; left:180px } #fname { position:absolute; top:10px; left:568px; } #frender { position:absolute; top:50px; left:500; } #createModule { position:absolute; top:50px; left:570; } #fdescription { position:absolute; top:50px; left:10px; width:100%; } #newObject { position: absolute; background-color:green; border:solid gray 1px; width:50px; height:50px; zIndex:1; overflow: hidden; cursor:pointer; font-size: 12px; font-family:Arial, Helvetica, sans-serif; } </style> <script language="javascript" src="list.php"></script> <script type="text/javascript" src="text-utils.js"> </script> <script type="text/javascript" src="request.js"> </script> <script type = "text/javascript"> var g_objName, ss; window.onload = function() { fillCategory(); init(); } function get_description() { var model = document.getElementById("model").value; var url = "lookupdescription.php?model=" + escape(model); request.open("GET", url, true); request.onreadystatechange = updatePage; request.send(null); } function updatePage() { if (request.readyState ==4) { var modeldescription = request.responseText; var x = document.getElementById("description"); replaceText(x, modeldescription); document.getElementById("objName").value = " "; } } function createObject() { var g_model = document.getElementById("model").value; g_objName = document.getElementById("objName").value; var url = "create_object.php?g_model=" + escape(g_model) + "&g_objName=" + escape(g_objName); request.open("GET", url, true); request.onreadystatechange = showObject; request.send(null); } function showObject (){ if (request.readyState == 4) { var returned = request.responseText; var splitResult = returned.split(" "); var h = splitResult[0]; var w = splitResult[1]; // the dimensions must be set to a scale as they are to big for the screen. 25px represents 100mm h = h/5; w = w/5; cv = document.getElementById("canvas"); var newObject = document.createElement('div'); newObject.Class = g_objName; newObject.id = "newObject"; newObject.innerHTML = g_objName; newObject.alt = g_objName; newObject.style.height = h; newObject.style.width = w; newObject.onmousedown=function(){grab(this);} cv.appendChild(newObject); } } function render () { var ww = document.getElementById("newObject").value; alert(ww); } var mousex = 0; var mousey = 0; var grabx = 0; var graby = 0; var orix = 0; var oriy = 0; var elex = 0; var eley = 0; var algor = 0; var dragobj = null; function falsefunc() { return false; } // used to block cascading events function init() { document.onmousemove = update; // update(event) implied on NS, update(null) implied on IE update(); } function getMouseXY(e) // works on IE6,FF,Moz,Opera7 { if (!e) e = window.event; // works on IE, but not NS (we rely on NS passing us the event) if (e) { if (e.pageX || e.pageY) { // this doesn't work on IE6!! (works on FF,Moz,Opera7) mousex = e.pageX; mousey = e.pageY; algor = '[e.pageX]'; if (e.clientX || e.clientY) algor += ' [e.clientX] ' } else if (e.clientX || e.clientY) { // works on IE6,FF,Moz,Opera7 mousex = e.clientX + document.body.scrollLeft; mousey = e.clientY + document.body.scrollTop; algor = '[e.clientX]'; if (e.pageX || e.pageY) algor += ' [e.pageX] ' } } } function update(e) { getMouseXY(e); // NS is passing (event), while IE is passing (null) document.getElementById('xpos').value = elex; document.getElementById('ypos').value = eley; document.getElementById('object').value = ss; } function grab(context, mod_name) { document.onmousedown = falsefunc; // in NS this prevents cascading of events, thus disabling text selection dragobj = context; ss = context.Class; dragobj.style.zIndex = 10; // move it to the top document.onmousemove = drag; document.onmouseup = drop; grabx = mousex; graby = mousey; elex = orix = dragobj.offsetLeft; eley = oriy = dragobj.offsetTop; update(); } function dragITT(e) // suggested solution doesnt work { w = parseInt(e.style.width); h = parseInt(e.style.height); self.document.onmousemove=function() { e.style.left = Math.floor((event.clientX)/w)*w; e.style.top = Math.floor((event.clientY)/h)*h; return false; } self.document.onmouseup=function() { self.document.onmousemove=null; } } function drag(e) // parameter passing is important for NS family { if (dragobj) { elex = orix + (mousex-grabx); eley = oriy + (mousey-graby); dragobj.style.position = "absolute"; dragobj.style.left = (elex).toString(10) + 'px'; dragobj.style.top = (eley).toString(10) + 'px'; } update(e); return false; // in IE this prevents cascading of events, thus text selection is disabled } function drop() { if (dragobj) { dragobj.style.zIndex = 0; dragobj = null; } update(); document.onmousemove = update; document.onmouseup = null; document.onmousedown = null; // re-enables text selection on NS } </script> </head> <body> <div id = "canvas"> </div> <div id = "controls"> <FORM name="drop_list"> <fieldset id="ftype"> <label for="type">Type</label> <div class="div_texbox"> <SELECT id="Category" NAME="Category" onChange="SelectSubmenu();" > <Option value="">Select Type</option> </SELECT> </div> </fieldset> <fieldset id="fmodel"> <label for="mod_named">Model</label> <div class="div_texbox"> <SELECT id="model" NAME="model" onChange="get_description();"> <Option value="">Select Model</option> </SELECT> </div> </fieldset> <fieldset id="fsubtype"> <label for="subtype">sub</label> <div class="div_texbox"> <SELECT id="submenu" NAME="submenu" onChange="SelectModel();"> <Option value="">Select</option> </SELECT> </div> </fieldset> <fieldset id="fname"> <label for="mod_name">Name</label> <div class="div_texbox"> <input name="objName" type="text" id="objName" value="" /> </div> </fieldset> <fieldset id="fbutton"> <div class="button_div"> <input type = "button" value = "Generate" onClick = "createObject()"> <input type = "text" value = "" name = "xpos" id = "xpos"> <input type = "text" value = "" name = "ypos" id = "ypos"> <input type = "text" value = "" name = "object" id = "object"> </div> </fieldset> <fieldset id="fdescription"> <legend>Description</legend> <span id="description">description goes here</span> </fieldset> </form> <fieldset id="createModule"> <input type = "button" value = "New Module" onClick = "window.open('createModule.php', 'NewModule', 'width=700, height=400, statusbar=yes')"> </fieldset> <fieldset id="frender"> <input type = "button" value = "Render" onClick = "render ()"> </fieldset> <fieldset id ="temp"> </fieldset> </div> </body> </html> and a bit of php for show object <?php require "config.php"; $g_model = $_GET['g_model']; $g_objName = $_GET['g_objName']; mysql_query("INSERT INTO object (module_name, object_name, xpos, ypos) VALUES ('".$g_model."', '".$g_objName."', '10', '10')"); $sql = "SELECT height, width FROM module WHERE module_name='$g_model'"; $result = mysql_query($sql) or trigger_error(mysql_error()); $row = mysql_fetch_assoc($result); $return = $row['height']." ". $row['width']; echo $return; ?>
  3. cleary1981
    <body> <div id = "canvas"> </div> <div id = "controls"> <FORM name="drop_list"> <fieldset id="ftype"> <label for="type">Type</label> <div class="div_texbox"> <SELECT id="Category" NAME="Category" onChange="SelectSubmenu();" > <Option value="">Select Type</option> </SELECT> </div> </fieldset> <fieldset id="fmodel"> <label for="mod_named">Model</label> <div class="div_texbox"> <SELECT id="model" NAME="model" onChange="get_description();"> <Option value="">Select Model</option> </SELECT> </div> </fieldset> <fieldset id="fsubtype"> <label for="subtype">sub</label> <div class="div_texbox"> <SELECT id="submenu" NAME="submenu" onChange="SelectModel();"> <Option value="">Select</option> </SELECT> </div> </fieldset> <fieldset id="fname"> <label for="mod_name">Name</label> <div class="div_texbox"> <input name="objName" type="text" id="objName" value="" /> </div> </fieldset> <fieldset id="fbutton"> <div class="button_div"> <input type = "button" value = "Generate" onClick = "createObject()"> <input type = "text" value = "" name = "xpos" id = "xpos"> <input type = "text" value = "" name = "ypos" id = "ypos"> <input type = "text" value = "" name = "object" id = "object"> </div> </fieldset> <fieldset id="fdescription"> <legend>Description</legend> <span id="description">description goes here</span> </fieldset> </form> <fieldset id="createModule"> <input type = "button" value = "New Module" onClick = "window.open('createModule.php', 'NewModule', 'width=700, height=400, statusbar=yes')"> </fieldset> <fieldset id="frender"> <input type = "button" value = "Render" onClick = "render ()"> </fieldset> <fieldset id ="temp"> </fieldset> </div> </body> </html>
  4. cleary1981
    Hi, I have written a function that creates a new object, the problem I am having is trying to refer to these objects in another function. When using getElemenntById I get a value "undefined". Does anyone know where im going wrong? function showObject (){ if (request.readyState == 4) { var returned = request.responseText; var splitResult = returned.split(" "); var h = splitResult[0]; var w = splitResult[1]; // the dimensions must be set to a scale as they are to big for the screen. 25px represents 100mm h = h/5; w = w/5; cv = document.getElementById("canvas"); var newObject = document.createElement('div'); newObject.Class = g_objName; newObject.id = "newObject"; newObject.innerHTML = g_objName; newObject.alt = g_objName; newObject.style.height = h; newObject.style.width = w; newObject.onmousedown=function(){grab(this);} cv.appendChild(newObject); } } function render () { var ww = document.getElementById("newObject").value; alert(ww); }
  5. cleary1981

    Error

    cleary1981 replied to iceblox's topic in PHP Coding Help

    if you are using phpmyadmin you can repair your table easily. just check the table a select repair table
  6. cleary1981
    lol... i changed from a from submit to a javascript function. lol
  7. cleary1981
    Why does this not work? What I trying to do is if part_no already exists in part execute result 1, else execute result 2 and 3. the code doesn't seem to do anything to either table <?php if (isset($_POST['submit'])) { require "config.php"; // database connection details //convert all the posts to variables: $mod_name = $_REQUEST['mid']; $pno = $_REQUEST['part_no']; $des = $_REQUEST['description']; $price = $_REQUEST['price']; $qty = $_REQUEST['quantity']; $disc = $_REQUEST['discount']; $sup = $_REQUEST['supplier']; // if $part_no != part_no add it to part table if(mysql_num_rows(mysql_query("SELECT part_no FROM part WHERE part_no = '$pno'"))){ $result1=MYSQL_QUERY("INSERT INTO component (c_id, module_name, part_no, quantity) VALUES ('', '$mod_name', '$pno', '$qty')") or die (mysql_error()); } else { $result2=MYSQL_QUERY("INSERT INTO part (part_no, price, discount, supplier_name, description) VALUES ('$pno', '$des', '$price', '$disc', '$sup')") or die (mysql_error()); //Add new part to component list $result3=MYSQL_QUERY("INSERT INTO component (c_id, module_name, part_no, quantity) VALUES ('', '$mod_name', '$pno', '$qty')") or die (mysql_error()); } } ?>
  8. cleary1981
    Would any of you be kind enough to show me how to implement this into the code I posted? Im confused
  9. cleary1981
    Sorry I meant to say the links all point to one page addComponents.php. Your code works great cheers but just one last question. In the new page how do i reference id?
  10. cleary1981
    what i want is for all the links to open the same page but be specific to that record. How would you go about that?
  11. cleary1981
    Hi I have the following code that displays the name and descriptions for each record in my table. The trouble is i want the name to be a clickable link. Can this be done? heres my code <?php if ($_COOKIE["cost"] == "1") { } else { //redirect back to login form if not authorised header ("Location: loginform.html"); exit; } require "config.php"; $sql="select module_name, mod_desc from module where confirmed=0"; $result = mysql_query($sql) or trigger_error(mysql_error()); ?> <table border="6" cellspacing="2" cellpadding="2"> <tr> <th>Name</th> <th>Description</th> </tr> <?php while($nt=mysql_fetch_array($result)){ echo "<tr><td>$nt[module_name]</td><td> $nt[mod_desc]</td></tr>"; // name class and mark will be printed with one line break at the end } ?>
  12. cleary1981
    D'oh!! thanks
  13. cleary1981
    what is wrong with this code? the error i am getting is <br /> <b>Fatal error</b>: Cannot use object of type stdClass as array in <b>C:\wamp\www\listModules.php</b> on line <b>8</b><br /> heres my php <?php require "config.php"; // database connection details $sql="select module_name, mod_desc from module where confirmed='0'"; $result = mysql_query($sql) or trigger_error(mysql_error()); $row = mysql_fetch_object($result); $return = $row['module_name']."%". $row['mod_desc']; echo $return; ?>
  14. cleary1981
    Hi all, I am using the drag function below which is from http://dunnbypaul.net/js_mouse/ I don't quite understand the code but was wondering if anyone knows how you would alter this code to so that objects being moved move a specified amount of pixels each time. Really the same functionality as snap in the scriptalicious drag drop function. heres the drag function snippet. function drag(e) // parameter passing is important for NS family { if (dragobj) { elex = orix + (mousex-grabx); eley = oriy + (mousey-graby); dragobj.style.position = "absolute"; dragobj.style.left = (elex).toString(10) + 'px'; dragobj.style.top = (eley).toString(10) + 'px'; } update(e); return false; // in IE this prevents cascading of events, thus text selection is disabled }
  15. cleary1981
    i will still have the problem that the new window shows from the middle of the screen and half is out of view. would probably need to set position to 0,0 aswell
  16. cleary1981
    I would have thought this would have been a relatively simple task but from searching the web I can't find any simple answer. Can anyone advise? just to clarify i have the follwing line <input type="button" value="Design Mode" onClick = "window.open('designmode.php', '', 'chrome=yes, resizable=yes')"> I want this new window to appear so the user does not have to make any adjustments
  17. cleary1981
    it is in date format. Is it easier to store as varchar?
  18. cleary1981
    Hi, I know how to format a date that I have read out of my db using date('d-m-Y',strtotime($row['deadline'])) but when im adding a date value what do I need to do?
  19. cleary1981
    Hi all, I am trying to update my db passing variables from javascript to php that updates my database. There is a problem with my javascript somewhere but im not sure where. When I enter dummy values into the php the db updates fine. Is there anything wrong with my POST? heres the function that passes the variables. function updateProjectDetails() { var uproj_id = document.getElementById("proj_id_edit").value; var uaccess = document.getElementById("access_edit").value; var ucable = document.getElementById("cable_edit").value; var uip = document.getElementById("ip_edit").value; var ufault = document.getElementById("fault_edit").value; var uform = document.getElementById("iform_edit").value; var upman = document.getElementById("pman_edit").value; var udl = document.getElementById("deadline_edit").value; var url = "updateProjectDetails.php"; request.open("POST", url, true); request.onreadystatechange = showConfirmation; request.send("uproj_id=" + escape(uproj_id) + "&uaccess=" + escape(uaccess) + "&ucable=" + escape(ucable) + "&uip=" + escape(uip) + "&ufault=" + escape(ufault) + "&uform=" + escape(uform) + "&upman=" + escape(upman) + "&udl=" + escape(udl)); } function showConfirmation () { } heres the HTML code where they originate <table width=100% border=0> <tr> <td><label for="proj_id_edit">Project ID</label> <input type = "text" value = "" name = "proj_id_edit" id = "proj_id_edit"></td> <td><label for="projName_edit">Project Name</label> <input type = "text" value = "" disabled name = "projName_edit" id = "projName_edit"></td></tr> <tr><td><label for="comp_edit">Company Name</label> <input type = "text" value = "" disabled name = "comp_edit" id = "comp_edit"></td> <td><label for="access_edit">Access</label> <input type = "text" value = "" name = "access_edit" id = "access_edit"></td></tr> <tr><td><label for="cable_edit">Cable Entry</label> <input type = "text" value = "" name = "cable_edit" id = "cable_edit"></td> <td><label for="ip_edit">IP Rating</label> <input type = "text" value = "" name = "ip_edit" id = "ip_edit"></td></tr> <tr><td><label for="fault_edit">Fault Rating</label> <input type = "text" value = "" name = "fault_edit" id = "fault_edit"><span>KW/sec</span></td> <td><label for="iform_edit">Form</label> <input type = "text" value = "" name = "iform_edit" id = "iform_edit"></td></tr> <tr><td><label for="pman_edit">Project Manager</label> <input type = "text" value = "" name = "pman_edit" id = "pman_edit"></td> <td><label for="deadline_edit">Tender Deadline</label> <input type = "text" value = "" name = "deadline_edit" id = "deadline_edit"></td> </tr> <tr><td><input type="button" value="Update" name="update" onClick="updateProjectDetails()"> heres my php <?php require "config.php"; $proj_id = $_REQUEST['uproj_id']; $access = $_REQUEST['uaccess']; $cable = $_REQUEST['ucable']; $ip = $_REQUEST['uip']; $fault = $_REQUEST['ufault']; $form = $_REQUEST['uform']; $pman = $_REQUEST['upman']; $dl = $_REQUEST['udl']; $q = mysql_query("update project set form='$form', access='$access', cable_entry='$cable', ip_rating='$ip', fault_rating='$fault', proj_manager='$pman', deadline='$dl' where proj_id= '$proj_id'"); ?>
  20. cleary1981
    I changed the php so it didnt take inputs from my javascript and it worked fine. The bug is somewhere else. Thanks anyhow
  21. cleary1981
    Hi I have passed variables to php in the javascript below function updateProjectDetails() { var ud_proj_id = document.company1.proj_id_edit.value; var ud_access = document.company1.access_edit.value; var ud_cable = document.company1.cable_edit.value; var ud_ip = document.company1.ip_edit.value; var ud_fault = document.company1.fault_edit.value; var ud_form = document.company1.form_edit.value; var ud_pman = document.company1.pman_edit.value; var ud_dl = document.company1.deadline_edit.value; var url = "updateProjectDetails.php"; request.open("POST", url, true); request.onreadystatechange = showConfirmation; request.setRequestHeader("Content-Type", "application/x-www-form-urlencoded"); request.send("ud_proj_id" + escape(ud_proj_id) + "ud_access=" + escape(ud_access) + "ud_cable=" + escape(ud_cable) + "ud_ip=" + escape(ud_ip) + "ud_fault=" + escape(ud_fault) + "ud_form=" + escape(ud_form) + "ud_pman=" + escape(ud_pman) + "ud_dl=" + escape(ud_dl)); } heres my php with a few different options i have tried commented out. None of them will update the db. Can anyone see where im going wrong? <?php require "config.php"; $ud_proj_id = $_REQUEST['ud_proj_id']; $ud_access = $_REQUEST['ud_access']; $ud_cable = $_REQUEST['ud_cable']; /$ud_ip = $_REQUEST['ud_ip']; $ud_fault = $_REQUEST['ud_fault']; $ud_form = $_REQUEST['ud_form']; $ud_pman = $_REQUEST['ud_pman']; $ud_dl = $_REQUEST['ud_dl']; // find project with the relevant project id // insert new values into that project // $query = mysql_query("UPDATE project SET form = '$ud_form', access = '$ud_access', cable_entry = '$ud_cable', ip_rating = '$ud_ip', fault_rating = '$ud_fault', proj_manager = '$ud_pman', deadline = '$ud_dl' [WHERE proj_id = '$ud_proj_id']"); //$query="UPDATE project SET fault_rating = 1000 WHERE proj_id = '.$ud_proj_id.'"; //mysql_query("update project set fault_rating='$ud_fault' where proj_id='$ud_proj_id'"); $sqlUpdate = "UPDATE project SET (form = '$ud_form', access = '$ud_access', cable_entry = '$ud_cable', ip_rating = '$ud_ip', fault_rating = '$ud_fault', proj_manager = '$ud_pman', deadline = '$ud_dl') WHERE proj_id =" . $_REQUEST['ud_proj_id']; echo "Record successfully updated!"; ?>
  22. cleary1981
    Im not quite sure how I would implement this. Heres the code I have <?php require "config.php"; $proj = $_REQUEST['proj']; $sql = "SELECT * FROM project WHERE project_name='$proj'"; $result = mysql_query($sql) or trigger_error(mysql_error()); $row = mysql_fetch_assoc($result); $return = $row['proj_id']."%". $row['project_name']."%". $row['form']."%". $row['access']."%". $row['cable_entry']."%". $row['ip_rating']."%". $row['fault_rating']."%". $row['company_name']."%". $row['proj_manager']."%". $row['deadline']; echo $return; ?> $row['deadline'] contains the date that I want to format.
  23. cleary1981
    Hi Im having a problem with the date format mysql has returned. It returns dates in the format yyyy-mm-dd. I want to diplay this as dd-mm-yyyy. Has anyone got an easy method for converting this in php?
  24. cleary1981
    Hi, I have a form where I need to display the specified record. How do I use php to display the proper values in fields? For example if i want proj_id to be displayed in text field document.company1.proj_id.value. function get_project() { <?php // using project.value display the details of that record $sql222=mysql_query("SELECT * FROM project WHERE project_name = document.company1.project.value"); ?> }
  25. cleary1981
    yeah that worked had left " out of the code.
×
×
  • 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.