Jump to content

needs_upgrade

Members
  • Posts

    126
  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

needs_upgrade's Achievements

Regular Member

Regular Member (3/5)

0

Reputation

  1. Hello guys! What if i have a form for adding new product. One of the fields of the TableProducts is 'CategoryId'. So the most common way to enter the CategoryId is by a dropdownbox. What if the category does not exist yet? So you have to add the new category from another page and refresh the "add product" form to load the newly inserted category. Can anyone guide me how to make a pop up page where i can add the category and upon submitting the new category, the categoryid of the "add product" form will have the new inserted categoryid. Thank you so much guys.
  2. If it is not too much ask mac_gyver, how would you access/catch the input of each textbox? I should be able to insert the input in each box into the database, like this: $sql = "INSERT INTO attendace(att_date, emp_id, work_hrs) VALUES('DateHere', 'EmpIDHere', 'TextboxValueHere')"; Thanks!
  3. Hello guys, I would like to make a form for employees' attendance from a start_date to an end_date. The name of the employees are listed from top to bottom and the dates will be listed from left to right of the names of the employees. My problem is that I don't know how to name my textboxes so the system would know that a particular textbox is for employee 'A' and for a particular date between the start_date and end_date. The expected datatype to be entered into the textboxes is an integer or decimal number like 1 or 0.5. Here is what I've done so far: $sql = "SELECT DATE_FORMAT(sp_start, '%b %e, %Y'), DATE_FORMAT(sp_end, '%b %e, %Y'), TO_DAYS(sp_start), TO_DAYS(sp_end) FROM salary_periods WHERE sp_id = '$sp_id'"; $sres = mysql_query($sql); $srow = mysql_fetch_array($sres); ?> <form action="somepage.php" method="post"> <table> <tr><td colspan="4" align="center">Salary Period</td></tr> <tr class="even"> <td width="100" align="right">Start Date</td> <td width="250" align="left"><?PHP echo $srow[0] ?></td> <td width="100" align="right">End Date</td> <td width="250" align="left"><?PHP echo $srow[1] ?></td> </tr> </table><br /> <table> <tr> <td width="150" align="center">Employee</td> <td width="550" align="center" colspan="<?PHP echo $srow[3] - $srow[2] + 1; ?>">Dates</td> </tr> <tr> <td> </td> <?PHP for ($j=$srow[2]; $j<=$srow[3]; $j++) { $sql = "SELECT DATE_FORMAT(FROM_DAYS($j), '%m/%d')"; $tres = mysql_query($sql); $trow = mysql_fetch_array($tres); ?><td align="center"><?PHP echo $trow[0] ?></td><?PHP } ?> </tr> <?PHP $i = 1; $sql = "SELECT emp_id, CONCAT(lname,', ',fname) FROM employees WHERE active = 1"; $res = mysql_query($sql); while ($row = mysql_fetch_array($res)) { $m = fmod($i, 2); if ($m == 0) { // $i is EVEN ?><tr class="even"><?PHP } else { // $i is ODD ?><tr class="odd"><?PHP } ?> <input type="hidden" name="emp_id<?PHP $i ?>" value="<?PHP echo $row[0] ?>"> <td align="left"><?PHP echo $row[1] ?></td> <?PHP for ($j=$srow[2]; $j<=$srow[3]; $j++) { $sql = "SELECT DATE_FORMAT(FROM_DAYS($j), '%m/%d')"; $tres = mysql_query($sql); $trow = mysql_fetch_array($tres); ?><td><input type="text" name="TextboxNameHere" size="2" style="text-align:right;"></td><?PHP } ?> </tr> <?PHP $i++; } ?> </table> </form> <?PHP How should I name my textboxes so that each textbox will be assigned to a particular employee and a particular date?
  4. I have downloaded this nice autosuggest script here: http://www.brandspankingnew.net/download.php?file=autosuggest_v2.1.3.zip. It works fine but i need more fields. Here is what i have so far: Its output in the price textbox is "undefined". Pls help. Thanks so much. AutoSuggest.html <html> <head> <title>Ajax auto-suggest / auto-complete | BrandSpankingNew</title> <script type="text/javascript" src="js/bsn.AutoSuggest_2.1.3.js" charset="utf-8"></script> <link rel="stylesheet" href="css/autosuggest_inquisitor.css" type="text/css" media="screen" charset="utf-8" /> <style type="text/css"> body { font-family: Lucida Grande, Arial, sans-serif; font-size: 10px; text-align: center; margin: 0; padding: 0; } #wrapper { width: 600px; margin: 10px auto; text-align: left; } #content { font-size: 1.2em; line-height: 1.8em; } #content h3 { font-size: 1.1em; margin-top: 3em; } small { color: #999; } label { font-weight: bold; } .asholder { position: relative; } </style> </head> <body> <div id="wrapper"> <div id="content"> <h3>Example (JSON)</h3> <div> <form method="get" action="" class="asholder"> <small style="float:right"> Product ID: <input type="text" id="product_id1" value="" style="font-size: 10px; width: 20px;" disabled="disabled" /> Price: <input type="text" id="price1" value="" style="font-size: 10px; width: 50px;" disabled="disabled" /> </small> <label for="testinput1">Product 1</label> <input style="width: 300px" type="text" id="testinput1" value="" /><br /> <!-- <small style="float:right"> Product ID: <input type="text" id="product_id2" value="" style="font-size: 10px; width: 20px;" disabled="disabled" /> Brand ID: <input type="text" id="brand_id2" value="" style="font-size: 10px; width: 20px;" disabled="disabled" /> </small> <label for="testinput2">Product 2</label> <input style="width: 300px" type="text" id="testinput2" value="" /><br /> --> </form> </div> </div> </div> <script type="text/javascript"> var options1 = { script:"test.php?json=true&limit=100&", varname:"input", json:true, shownoresults:false, maxresults:100, callback: function (obj) { document.getElementById('product_id1').value = obj.id; document.getElementById('price1').value = obj.bid; } }; var as_json1 = new bsn.AutoSuggest('testinput1', options1); /* var options2 = { script:"test.php?json=true&limit=100&", varname:"input", json:true, shownoresults:false, maxresults:100, callback: function (obj) { document.getElementById('testid2').value = obj.id; }}; var as_json2 = new bsn.AutoSuggest('testinput2', options2); */ </script> </body> test.php <?PHP $db_host = 'db_host'; $db_user = 'db_user'; $db_password = 'db_password'; $db_name = 'db_name'; $db = new mysqli($db_host , $db_user ,$db_password, $db_name); if(!$db) { // If there is an error, show this message. echo 'There was a problem connecting to the database'; } else { $input = strtolower( $_GET['input'] ); $aId = array(); $aPrice = array(); $aProducts = array(); $aCategory = array(); $query = $db->query("SELECT p.product_id AS id, p.product_name AS product, c.category_name AS category, p.sell_price AS price FROM products p INNER JOIN categories c ON p.category_id = c.category_id WHERE p.product_name LIKE '%$input%' ORDER BY p.product_id"); // limits our results list to 10. while ($result = $query ->fetch_object()) { array_push($aId, $result->id); array_push($aPrice, $result->price); array_push($aProducts, $result->product); array_push($aCategory, $result->category); } $input = strtolower( $_GET['input'] ); $len = strlen($input); $limit = isset($_GET['limit']) ? (int) $_GET['limit'] : 0; $aResults = array(); $count = 0; if ($len) { for ($i=0;$i<count($aProducts);$i++) { // had to use utf_decode, here // not necessary if the results are coming from mysql // if (strtolower(substr($aProducts[$i], 0, $len)) == $input) { $count++; $aResults[] = array( "id"=>($aId[$i]), "value"=>htmlspecialchars($aProducts[$i]), "info"=>htmlspecialchars($aCategory[$i]), "price"=>($aPrice[$i]) ); } if ($limit && $count==$limit) break; } } header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified header ("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1 header ("Pragma: no-cache"); // HTTP/1.0 header("Content-Type: application/json"); echo "{\"results\": ["; $arr = array(); for ($i=0;$i<count($aResults);$i++) { $arr[] = "{\"id\": \"".$aResults[$i]['id']."\", \"value\": \"".$aResults[$i]['value']."\", \"info\": \"".$aResults[$i]['info']."\", \"price\": \"".$aResults[$i]['price']."\"}"; } echo implode(", ", $arr); echo "]}"; } ?> bsn.AutoSuggest_2.1.3.js - I DIDN'T EDIT THIS /** * author: Timothy Groves - http://www.brandspankingnew.net * version: 1.2 - 2006-11-17 * 1.3 - 2006-12-04 * 2.0 - 2007-02-07 * 2.1.1 - 2007-04-13 * 2.1.2 - 2007-07-07 * 2.1.3 - 2007-07-19 * */ if (typeof(bsn) == "undefined") _b = bsn = {}; if (typeof(_b.Autosuggest) == "undefined") _b.Autosuggest = {}; else alert("Autosuggest is already set!"); _b.AutoSuggest = function (id, param) { // no DOM - give up! // if (!document.getElementById) return 0; // get field via DOM // this.fld = _b.DOM.gE(id); if (!this.fld) return 0; // init variables // this.sInp = ""; this.nInpC = 0; this.aSug = []; this.iHigh = 0; // parameters object // this.oP = param ? param : {}; // defaults // var k, def = {minchars:1, meth:"get", varname:"input", className:"autosuggest", timeout:2500, delay:500, offsety:-5, shownoresults: true, noresults: "No results!", maxheight: 250, cache: true, maxentries: 25}; for (k in def) { if (typeof(this.oP[k]) != typeof(def[k])) this.oP[k] = def[k]; } // set keyup handler for field // and prevent autocomplete from client // var p = this; // NOTE: not using addEventListener because UpArrow fired twice in Safari //_b.DOM.addEvent( this.fld, 'keyup', function(ev){ return pointer.onKeyPress(ev); } ); this.fld.onkeypress = function(ev){ return p.onKeyPress(ev); }; this.fld.onkeyup = function(ev){ return p.onKeyUp(ev); }; this.fld.setAttribute("autocomplete","off"); }; _b.AutoSuggest.prototype.onKeyPress = function(ev) { var key = (window.event) ? window.event.keyCode : ev.keyCode; // set responses to keydown events in the field // this allows the user to use the arrow keys to scroll through the results // ESCAPE clears the list // TAB sets the current highlighted value // var RETURN = 13; var TAB = 9; var ESC = 27; var bubble = 1; switch(key) { case RETURN: this.setHighlightedValue(); bubble = 0; break; case ESC: this.clearSuggestions(); break; } return bubble; }; _b.AutoSuggest.prototype.onKeyUp = function(ev) { var key = (window.event) ? window.event.keyCode : ev.keyCode; // set responses to keydown events in the field // this allows the user to use the arrow keys to scroll through the results // ESCAPE clears the list // TAB sets the current highlighted value // var ARRUP = 38; var ARRDN = 40; var bubble = 1; switch(key) { case ARRUP: this.changeHighlight(key); bubble = 0; break; case ARRDN: this.changeHighlight(key); bubble = 0; break; default: this.getSuggestions(this.fld.value); } return bubble; }; _b.AutoSuggest.prototype.getSuggestions = function (val) { // if input stays the same, do nothing // if (val == this.sInp) return 0; // kill list // _b.DOM.remE(this.idAs); this.sInp = val; // input length is less than the min required to trigger a request // do nothing // if (val.length < this.oP.minchars) { this.aSug = []; this.nInpC = val.length; return 0; } var ol = this.nInpC; // old length this.nInpC = val.length ? val.length : 0; // if caching enabled, and user is typing (ie. length of input is increasing) // filter results out of aSuggestions from last request // var l = this.aSug.length; if (this.nInpC > ol && l && l<this.oP.maxentries && this.oP.cache) { var arr = []; for (var i=0;i<l;i++) { if (this.aSug[i].value.substr(0,val.length).toLowerCase() == val.toLowerCase()) arr.push( this.aSug[i] ); } this.aSug = arr; this.createList(this.aSug); return false; } else // do new request // { var pointer = this; var input = this.sInp; clearTimeout(this.ajID); this.ajID = setTimeout( function() { pointer.doAjaxRequest(input) }, this.oP.delay ); } return false; }; _b.AutoSuggest.prototype.doAjaxRequest = function (input) { // check that saved input is still the value of the field // if (input != this.fld.value) return false; var pointer = this; // create ajax request // if (typeof(this.oP.script) == "function") var url = this.oP.script(encodeURIComponent(this.sInp)); else var url = this.oP.script+this.oP.varname+"="+encodeURIComponent(this.sInp); if (!url) return false; var meth = this.oP.meth; var input = this.sInp; var onSuccessFunc = function (req) { pointer.setSuggestions(req, input) }; var onErrorFunc = function (status) { alert("AJAX error: "+status); }; var myAjax = new _b.Ajax(); myAjax.makeRequest( url, meth, onSuccessFunc, onErrorFunc ); }; _b.AutoSuggest.prototype.setSuggestions = function (req, input) { // if field input no longer matches what was passed to the request // don't show the suggestions // if (input != this.fld.value) return false; this.aSug = []; if (this.oP.json) { var jsondata = eval('(' + req.responseText + ')'); for (var i=0;i<jsondata.results.length;i++) { this.aSug.push( { 'id':jsondata.results[i].id, 'value':jsondata.results[i].value, 'info':jsondata.results[i].info } ); } } else { var xml = req.responseXML; // traverse xml // var results = xml.getElementsByTagName('results')[0].childNodes; for (var i=0;i<results.length;i++) { if (results[i].hasChildNodes()) this.aSug.push( { 'id':results[i].getAttribute('id'), 'value':results[i].childNodes[0].nodeValue, 'info':results[i].getAttribute('info') } ); } } this.idAs = "as_"+this.fld.id; this.createList(this.aSug); }; _b.AutoSuggest.prototype.createList = function(arr) { var pointer = this; // get rid of old list // and clear the list removal timeout // _b.DOM.remE(this.idAs); this.killTimeout(); // if no results, and shownoresults is false, do nothing // if (arr.length == 0 && !this.oP.shownoresults) return false; // create holding div // var div = _b.DOM.cE("div", {id:this.idAs, className:this.oP.className}); var hcorner = _b.DOM.cE("div", {className:"as_corner"}); var hbar = _b.DOM.cE("div", {className:"as_bar"}); var header = _b.DOM.cE("div", {className:"as_header"}); header.appendChild(hcorner); header.appendChild(hbar); div.appendChild(header); // create and populate ul // var ul = _b.DOM.cE("ul", {id:"as_ul"}); // loop throught arr of suggestions // creating an LI element for each suggestion // for (var i=0;i<arr.length;i++) { // format output with the input enclosed in a EM element // (as HTML, not DOM) // var val = arr[i].value; var st = val.toLowerCase().indexOf( this.sInp.toLowerCase() ); var output = val.substring(0,st) + "<em>" + val.substring(st, st+this.sInp.length) + "</em>" + val.substring(st+this.sInp.length); var span = _b.DOM.cE("span", {}, output, true); if (arr[i].info != "") { var br = _b.DOM.cE("br", {}); span.appendChild(br); var small = _b.DOM.cE("small", {}, arr[i].info); span.appendChild(small); } var a = _b.DOM.cE("a", { href:"#" }); var tl = _b.DOM.cE("span", {className:"tl"}, " "); var tr = _b.DOM.cE("span", {className:"tr"}, " "); a.appendChild(tl); a.appendChild(tr); a.appendChild(span); a.name = i+1; a.onclick = function () { pointer.setHighlightedValue(); return false; }; a.onmouseover = function () { pointer.setHighlight(this.name); }; var li = _b.DOM.cE( "li", {}, a ); ul.appendChild( li ); } // no results // if (arr.length == 0 && this.oP.shownoresults) { var li = _b.DOM.cE( "li", {className:"as_warning"}, this.oP.noresults ); ul.appendChild( li ); } div.appendChild( ul ); var fcorner = _b.DOM.cE("div", {className:"as_corner"}); var fbar = _b.DOM.cE("div", {className:"as_bar"}); var footer = _b.DOM.cE("div", {className:"as_footer"}); footer.appendChild(fcorner); footer.appendChild(fbar); div.appendChild(footer); // get position of target textfield // position holding div below it // set width of holding div to width of field // var pos = _b.DOM.getPos(this.fld); div.style.left = pos.x + "px"; div.style.top = ( pos.y + this.fld.offsetHeight + this.oP.offsety ) + "px"; div.style.width = this.fld.offsetWidth + "px"; // set mouseover functions for div // when mouse pointer leaves div, set a timeout to remove the list after an interval // when mouse enters div, kill the timeout so the list won't be removed // div.onmouseover = function(){ pointer.killTimeout() }; div.onmouseout = function(){ pointer.resetTimeout() }; // add DIV to document // document.getElementsByTagName("body")[0].appendChild(div); // currently no item is highlighted // this.iHigh = 0; // remove list after an interval // var pointer = this; this.toID = setTimeout(function () { pointer.clearSuggestions() }, this.oP.timeout); }; _b.AutoSuggest.prototype.changeHighlight = function(key) { var list = _b.DOM.gE("as_ul"); if (!list) return false; var n; if (key == 40) n = this.iHigh + 1; else if (key == 38) n = this.iHigh - 1; if (n > list.childNodes.length) n = list.childNodes.length; if (n < 1) n = 1; this.setHighlight(n); }; _b.AutoSuggest.prototype.setHighlight = function(n) { var list = _b.DOM.gE("as_ul"); if (!list) return false; if (this.iHigh > 0) this.clearHighlight(); this.iHigh = Number(n); list.childNodes[this.iHigh-1].className = "as_highlight"; this.killTimeout(); }; _b.AutoSuggest.prototype.clearHighlight = function() { var list = _b.DOM.gE("as_ul"); if (!list) return false; if (this.iHigh > 0) { list.childNodes[this.iHigh-1].className = ""; this.iHigh = 0; } }; _b.AutoSuggest.prototype.setHighlightedValue = function () { if (this.iHigh) { this.sInp = this.fld.value = this.aSug[ this.iHigh-1 ].value; // move cursor to end of input (safari) // this.fld.focus(); if (this.fld.selectionStart) this.fld.setSelectionRange(this.sInp.length, this.sInp.length); this.clearSuggestions(); // pass selected object to callback function, if exists // if (typeof(this.oP.callback) == "function") this.oP.callback( this.aSug[this.iHigh-1] ); } }; _b.AutoSuggest.prototype.killTimeout = function() { clearTimeout(this.toID); }; _b.AutoSuggest.prototype.resetTimeout = function() { clearTimeout(this.toID); var pointer = this; this.toID = setTimeout(function () { pointer.clearSuggestions() }, 1000); }; _b.AutoSuggest.prototype.clearSuggestions = function () { this.killTimeout(); var ele = _b.DOM.gE(this.idAs); var pointer = this; if (ele) { var fade = new _b.Fader(ele,1,0,250,function () { _b.DOM.remE(pointer.idAs) }); } }; // AJAX PROTOTYPE _____________________________________________ if (typeof(_b.Ajax) == "undefined") _b.Ajax = {}; _b.Ajax = function () { this.req = {}; this.isIE = false; }; _b.Ajax.prototype.makeRequest = function (url, meth, onComp, onErr) { if (meth != "POST") meth = "GET"; this.onComplete = onComp; this.onError = onErr; var pointer = this; // branch for native XMLHttpRequest object if (window.XMLHttpRequest) { this.req = new XMLHttpRequest(); this.req.onreadystatechange = function () { pointer.processReqChange() }; this.req.open("GET", url, true); // this.req.send(null); // branch for IE/Windows ActiveX version } else if (window.ActiveXObject) { this.req = new ActiveXObject("Microsoft.XMLHTTP"); if (this.req) { this.req.onreadystatechange = function () { pointer.processReqChange() }; this.req.open(meth, url, true); this.req.send(); } } }; _b.Ajax.prototype.processReqChange = function() { // only if req shows "loaded" if (this.req.readyState == 4) { // only if "OK" if (this.req.status == 200) { this.onComplete( this.req ); } else { this.onError( this.req.status ); } } }; // DOM PROTOTYPE _____________________________________________ if (typeof(_b.DOM) == "undefined") _b.DOM = {}; /* create element */ _b.DOM.cE = function ( type, attr, cont, html ) { var ne = document.createElement( type ); if (!ne) return 0; for (var a in attr) ne[a] = attr[a]; var t = typeof(cont); if (t == "string" && !html) ne.appendChild( document.createTextNode(cont) ); else if (t == "string" && html) ne.innerHTML = cont; else if (t == "object") ne.appendChild( cont ); return ne; }; /* get element */ _b.DOM.gE = function ( e ) { var t=typeof(e); if (t == "undefined") return 0; else if (t == "string") { var re = document.getElementById( e ); if (!re) return 0; else if (typeof(re.appendChild) != "undefined" ) return re; else return 0; } else if (typeof(e.appendChild) != "undefined") return e; else return 0; }; /* remove element */ _b.DOM.remE = function ( ele ) { var e = this.gE(ele); if (!e) return 0; else if (e.parentNode.removeChild(e)) return true; else return 0; }; /* get position */ _b.DOM.getPos = function ( e ) { var e = this.gE(e); var obj = e; var curleft = 0; if (obj.offsetParent) { while (obj.offsetParent) { curleft += obj.offsetLeft; obj = obj.offsetParent; } } else if (obj.x) curleft += obj.x; var obj = e; var curtop = 0; if (obj.offsetParent) { while (obj.offsetParent) { curtop += obj.offsetTop; obj = obj.offsetParent; } } else if (obj.y) curtop += obj.y; return {x:curleft, y:curtop}; }; // FADER PROTOTYPE _____________________________________________ if (typeof(_b.Fader) == "undefined") _b.Fader = {}; _b.Fader = function (ele, from, to, fadetime, callback) { if (!ele) return 0; this.e = ele; this.from = from; this.to = to; this.cb = callback; this.nDur = fadetime; this.nInt = 50; this.nTime = 0; var p = this; this.nID = setInterval(function() { p._fade() }, this.nInt); }; _b.Fader.prototype._fade = function() { this.nTime += this.nInt; var ieop = Math.round( this._tween(this.nTime, this.from, this.to, this.nDur) * 100 ); var op = ieop / 100; if (this.e.filters) // internet explorer { try { this.e.filters.item("DXImageTransform.Microsoft.Alpha").opacity = ieop; } catch (e) { // If it is not set initially, the browser will throw an error. This will set it if it is not set yet. this.e.style.filter = 'progid:DXImageTransform.Microsoft.Alpha(opacity='+ieop+')'; } } else // other browsers { this.e.style.opacity = op; } if (this.nTime == this.nDur) { clearInterval( this.nID ); if (this.cb != undefined) this.cb(); } }; _b.Fader.prototype._tween = function(t,b,c,d) { return b + ( (c-b) * (t/d) ); }; Its output in the price textbox is "undefined". Pls help. Thanks so much.
  5. Thanks for your reply guys. I'm just updating the number of children/grand children on both sides of the root node. Every time a left or right child is being added to a parent, the grand parent and the fore parents' left and right child should be updated to.
  6. Hello guys. How can I shorten this code? // get the parent1 of bin_id and its details $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$bin_id' OR right_id = '$bin_id'"; $res1 = mysql_query($sql); $num1 = mysql_num_rows($res1); if ($num1 > 0) { $row1 = mysql_fetch_array($res1); if ($row1[1] == $bin_id) { // bin_id is left child of $row1[0] $sql = "UPDATE binaries SET left_num = $row1[2] + 1 WHERE bin_id = '$row1[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row1[3] == $bin_id) { // bin_id is right child of $row1[0] $sql = "UPDATE binaries SET right_num = $row1[4] + 1 WHERE bin_id = '$row1[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 2 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row1[0]' OR right_id = '$row1[0]'"; $res2 = mysql_query($sql); $num2 = mysql_num_rows($res2); if ($num2 > 0) { $row2 = mysql_fetch_array($res2); if ($row2[1] == $row1[0]) { // bin_id is left child of $row2[0] $sql = "UPDATE binaries SET left_num = $row2[2] + 1 WHERE bin_id = '$row2[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row2[3] == $row1[0]) { // bin_id is right child of $row2[0] $sql = "UPDATE binaries SET right_num = $row2[4] + 1 WHERE bin_id = '$row2[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 3 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row2[0]' OR right_id = '$row2[0]'"; $res3 = mysql_query($sql); $num3 = mysql_num_rows($res3); if ($num3 > 0) { $row3 = mysql_fetch_array($res3); if ($row3[1] == $row2[0]) { // bin_id is left child of $row3[0] $sql = "UPDATE binaries SET left_num = $row3[2] + 1 WHERE bin_id = '$row3[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row3[3] == $row2[0]) { // bin_id is right child of $row3[0] $sql = "UPDATE binaries SET right_num = $row3[4] + 1 WHERE bin_id = '$row3[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 4 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row3[0]' OR right_id = '$row3[0]'"; $res4 = mysql_query($sql); $num3 = mysql_num_rows($res3); if ($num4 > 0) { $row4 = mysql_fetch_array($res4); if ($row4[1] == $row3[0]) { // bin_id is left child of $row4[0] $sql = "UPDATE binaries SET left_num = $row4[2] + 1 WHERE bin_id = '$row4[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row4[3] == $row3[0]) { // bin_id is right child of $row4[0] $sql = "UPDATE binaries SET right_num = $row4[4] + 1 WHERE bin_id = '$row4[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 5 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row4[0]' OR right_id = '$row4[0]'"; $res5 = mysql_query($sql); $num5 = mysql_num_rows($res5); if ($num5 > 0) { $row5 = mysql_fetch_array($res5); if ($row5[1] == $row4[0]) { // bin_id is left child of $row5[0] $sql = "UPDATE binaries SET left_num = $row5[2] + 1 WHERE bin_id = '$row5[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row5[3] == $row4[0]) { // bin_id is right child of $row5[0] $sql = "UPDATE binaries SET right_num = $row5[4] + 1 WHERE bin_id = '$row5[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 6 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row5[0]' OR right_id = '$row5[0]'"; $res6 = mysql_query($sql); $num6 = mysql_num_rows($res6); if ($num6 > 0) { $row6 = mysql_fetch_array($res6); if ($row6[1] == $row5[0]) { // bin_id is left child of $row6[0] $sql = "UPDATE binaries SET left_num = $row6[2] + 1 WHERE bin_id = '$row6[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row6[3] == $row5[0]) { // bin_id is right child of $row6[0] $sql = "UPDATE binaries SET right_num = $row6[4] + 1 WHERE bin_id = '$row6[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 7 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row6[0]' OR right_id = '$row6[0]'"; $res7 = mysql_query($sql); $num7 = mysql_num_rows($res7); if ($num7 > 0) { $row7 = mysql_fetch_array($res7); if ($row7[1] == $row6[0]) { // bin_id is left child of $row7[0] $sql = "UPDATE binaries SET left_num = $row7[2] + 1 WHERE bin_id = '$row7[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row7[3] == $row6[0]) { // bin_id is right child of $row7[0] $sql = "UPDATE binaries SET right_num = $row7[4] + 1 WHERE bin_id = '$row7[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 8 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row7[0]' OR right_id = '$row7[0]'"; $res8 = mysql_query($sql); $num8 = mysql_num_rows($res8); if ($num8 > 0) { $row8 = mysql_fetch_array($res8); if ($row8[1] == $row7[0]) { // bin_id is left child of $row8[0] $sql = "UPDATE binaries SET left_num = $row8[2] + 1 WHERE bin_id = '$row8[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row8[3] == $row7[0]) { // bin_id is right child of $row8[0] $sql = "UPDATE binaries SET right_num = $row8[4] + 1 WHERE bin_id = '$row8[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 9 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row8[0]' OR right_id = '$row8[0]'"; $res9 = mysql_query($sql); $num9 = mysql_num_rows($res9); if ($num9 > 0) { $row9 = mysql_fetch_array($res9); if ($row9[1] == $row8[0]) { // bin_id is left child of $row9[0] $sql = "UPDATE binaries SET left_num = $row9[2] + 1 WHERE bin_id = '$row9[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row9[3] == $row8[0]) { // bin_id is right child of $row9[0] $sql = "UPDATE binaries SET right_num = $row9[4] + 1 WHERE bin_id = '$row9[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 10 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row9[0]' OR right_id = '$row9[0]'"; $res10 = mysql_query($sql); $num10 = mysql_num_rows($res10); if ($num10 > 0) { $row10 = mysql_fetch_array($res10); if ($row10[1] == $row9[0]) { // bin_id is left child of $row10[0] $sql = "UPDATE binaries SET left_num = $row10[2] + 1 WHERE bin_id = '$row10[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row10[3] == $row9[0]) { // bin_id is right child of $row10[0] $sql = "UPDATE binaries SET right_num = $row10[4] + 1 WHERE bin_id = '$row10[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 11 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row10[0]' OR right_id = '$row10[0]'"; $res11 = mysql_query($sql); $num11 = mysql_num_rows($res11); if ($num11 > 0) { $row11 = mysql_fetch_array($res11); if ($row11[1] == $row10[0]) { // bin_id is left child of $row11[0] $sql = "UPDATE binaries SET left_num = $row11[2] + 1 WHERE bin_id = '$row11[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row11[3] == $row10[0]) { // bin_id is right child of $row11[0] $sql = "UPDATE binaries SET right_num = $row11[4] + 1 WHERE bin_id = '$row11[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 12 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row11[0]' OR right_id = '$row11[0]'"; $res12 = mysql_query($sql); $num12 = mysql_num_rows($res12); if ($num12 > 0) { $row12 = mysql_fetch_array($res12); if ($row12[1] == $row11[0]) { // bin_id is left child of $row12[0] $sql = "UPDATE binaries SET left_num = $row12[2] + 1 WHERE bin_id = '$row12[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row12[3] == $row11[0]) { // bin_id is right child of $row12[0] $sql = "UPDATE binaries SET right_num = $row12[4] + 1 WHERE bin_id = '$row12[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 13 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row12[0]' OR right_id = '$row12[0]'"; $res13 = mysql_query($sql); $num13 = mysql_num_rows($res13); if ($num13 > 0) { $row13 = mysql_fetch_array($res13); if ($row13[1] == $row12[0]) { // bin_id is left child of $row13[0] $sql = "UPDATE binaries SET left_num = $row13[2] + 1 WHERE bin_id = '$row13[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row13[3] == $row12[0]) { // bin_id is right child of $row13[0] $sql = "UPDATE binaries SET right_num = $row13[4] + 1 WHERE bin_id = '$row13[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 14 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row13[0]' OR right_id = '$row13[0]'"; $res14 = mysql_query($sql); $num14 = mysql_num_rows($res14); if ($num14 > 0) { $row14 = mysql_fetch_array($res14); if ($row14[1] == $row13[0]) { // bin_id is left child of $row14[0] $sql = "UPDATE binaries SET left_num = $row14[2] + 1 WHERE bin_id = '$row14[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row14[3] == $row13[0]) { // bin_id is right child of $row14[0] $sql = "UPDATE binaries SET right_num = $row14[4] + 1 WHERE bin_id = '$row14[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 15 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row14[0]' OR right_id = '$row14[0]'"; $res15 = mysql_query($sql); $num15 = mysql_num_rows($res15); if ($num15 > 0) { $row15 = mysql_fetch_array($res15); if ($row15[1] == $row14[0]) { // bin_id is left child of $row15[0] $sql = "UPDATE binaries SET left_num = $row15[2] + 1 WHERE bin_id = '$row15[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row15[3] == $row14[0]) { // bin_id is right child of $row15[0] $sql = "UPDATE binaries SET right_num = $row15[4] + 1 WHERE bin_id = '$row15[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 16 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row15[0]' OR right_id = '$row15[0]'"; $res16 = mysql_query($sql); $num16 = mysql_num_rows($res16); if ($num16 > 0) { $row16 = mysql_fetch_array($res16); if ($row16[1] == $row15[0]) { // bin_id is left child of $row16[0] $sql = "UPDATE binaries SET left_num = $row16[2] + 1 WHERE bin_id = '$row16[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row16[3] == $row15[0]) { // bin_id is right child of $row16[0] $sql = "UPDATE binaries SET right_num = $row16[4] + 1 WHERE bin_id = '$row16[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 17 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row16[0]' OR right_id = '$row16[0]'"; $res17 = mysql_query($sql); $num17 = mysql_num_rows($res17); if ($num17 > 0) { $row17 = mysql_fetch_array($res17); if ($row17[1] == $row16[0]) { // bin_id is left child of $row17[0] $sql = "UPDATE binaries SET left_num = $row17[2] + 1 WHERE bin_id = '$row17[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row17[3] == $row16[0]) { // bin_id is right child of $row17[0] $sql = "UPDATE binaries SET right_num = $row17[4] + 1 WHERE bin_id = '$row17[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 18 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row17[0]' OR right_id = '$row17[0]'"; $res18 = mysql_query($sql); $num18 = mysql_num_rows($res18); if ($num18 > 0) { $row18 = mysql_fetch_array($res18); if ($row18[1] == $row17[0]) { // bin_id is left child of $row18[0] $sql = "UPDATE binaries SET left_num = $row18[2] + 1 WHERE bin_id = '$row18[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row18[3] == $row17[0]) { // bin_id is right child of $row18[0] $sql = "UPDATE binaries SET right_num = $row18[4] + 1 WHERE bin_id = '$row18[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 19 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row18[0]' OR right_id = '$row18[0]'"; $res19 = mysql_query($sql); $num19 = mysql_num_rows($res19); if ($num19 > 0) { $row19 = mysql_fetch_array($res19); if ($row19[1] == $row18[0]) { // bin_id is left child of $row19[0] $sql = "UPDATE binaries SET left_num = $row19[2] + 1 WHERE bin_id = '$row19[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row19[3] == $row18[0]) { // bin_id is right child of $row19[0] $sql = "UPDATE binaries SET right_num = $row19[4] + 1 WHERE bin_id = '$row19[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 20 $sql = "SELECT bin_id, left_id, left_num, right_id, right_num FROM binaries WHERE left_id = '$row19[0]' OR right_id = '$row19[0]'"; $res20 = mysql_query($sql); $num20 = mysql_num_rows($res20); if ($num20 > 0) { $row20 = mysql_fetch_array($res20); if ($row20[1] == $row19[0]) { // bin_id is left child of $row20[0] $sql = "UPDATE binaries SET left_num = $row20[2] + 1 WHERE bin_id = '$row20[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } elseif ($row20[3] == $row19[0]) { // bin_id is right child of $row20[0] $sql = "UPDATE binaries SET right_num = $row20[4] + 1 WHERE bin_id = '$row20[0]' LIMIT 1"; mysql_query($sql) or die(mysql_error()); } // level 21 } } } } } } } } } } } } } } } } } } } }
  7. Hello guys. How can i make 50,000 unique string characters? What i have in mind is to md5() numbers 1-50,000. But my client wants those strings to be 10 characters in length only. Where should i start? Thanks guys!
  8. Hello guys. How can i make 50,000 unique string characters? What i have in mind is to md5() numbers 1-50,000. But my client wants those strings to be 10 characters in length only. Where should i start? Thanks guys!
  9. @jessica: I am adding an image made from php gd inside html.
  10. Hello guys. I'm making a website for a networking group. They follow a binary system - a parent can only have two (2) children at most. So I should have circles and straight lines in a page to show the root and its children and so on. My problem is that when i place a PHP GD sample code inside an html <div>, and error happens: Warning: Cannot modify header information - headers already sent. Even this simple code from the php manual that i'm trying wont work: <html> <head> </head> <body> <?php $img = imagecreatetruecolor(450, 450); $white = imagecolorallocate($img, 255, 255, 255); $red = imagecolorallocate($img, 255, 0, 0); $black = imagecolorallocate($img, 0, 0, 0); $grey = imagecolorallocate($img, 211, 211, 211); imagefill($img, 0, 0, $white); imagearc($img, 224, 224, 400, 400, 0, 0, $black); imagefilledarc($img, 224, 224, 15, 15, 0, 0, $black, IMG_ARC_PIE); for ($zz = 0; $zz < 60; $zz++) { $digitCoords['x'][] = 175 * cos(deg2rad(($zz-10) * (360/60))) + 224; $digitCoords['y'][] = 175 * sin(deg2rad(($zz-10) * (360/60))) + 224; } for ($zz = 0; $zz < 60; $zz++) { if ($zz % 5 == 0) imagestring($img, 5, $digitCoords['x'][$zz] - 4, $digitCoords['y'][$zz] - 6, ($zz/5) + 1, $black); else imagefilledarc($img, $digitCoords['x'][$zz], $digitCoords['y'][$zz], 3, 3, 0, 0, $grey, IMG_ARC_PIE); } $seconds = date('s'); $minutes = date('i') + ($seconds/60); $hours = date('h') + ($minutes/60); $r_sec = 175; $r_min = 175; $r_hr = 125; $x_sec = $r_sec * cos(deg2rad(($seconds-15) * (360/60))) + 224; $y_sec = $r_sec * sin(deg2rad(($seconds-15) * (360/60))) + 224; $x_min = $r_min * cos(deg2rad(($minutes-15) * (360/60))) + 224; $y_min = $r_min * sin(deg2rad(($minutes-15) * (360/60))) + 224; $x_hr = $r_hr * cos(deg2rad(($hours-3) * (360/12))) + 224; $y_hr = $r_hr * sin(deg2rad(($hours-3) * (360/12))) + 224; imageline($img, 224, 224, $x_sec, $y_sec, $red); imagesetthickness($img, 3); imageline($img, 224, 224, $x_min, $y_min, $black); imagesetthickness($img, 5); imageline($img, 224, 224, $x_hr, $y_hr, $black); header("Content-type: image/png"); imagepng($img); imagedestroy($img); ?> </body> </html> Where should I start? Would you be kind to refer me to existing similar codes if there are? Thanks so much.
  11. How can we detect desktop activity remotely? I want to know if certain employees are visiting facebook or playing games instead of working. Is it possible using the browser? Thanks guys!
  12. Good day to you guys! I wanted to add a feature to my patient-records system. Be able to directly edit a template image (digestive system, respiratory, etc) and attach it to a transaction/consultation. The doctor should be able to make red/white circles in the template image, add labels for additional information then upload to a folder. Would you be kind to give me insights? thank you very much.
  13. How can i shorten this code? var quantity1 = +document.AddPO.quantity1.value; var quantity2 = +document.AddPO.quantity2.value; var quantity3 = +document.AddPO.quantity3.value; var quantity4 = +document.AddPO.quantity4.value; var quantity5 = +document.AddPO.quantity5.value; var quantity6 = +document.AddPO.quantity6.value; var quantity7 = +document.AddPO.quantity7.value; var quantity8 = +document.AddPO.quantity8.value; var quantity9 = +document.AddPO.quantity9.value; var quantity10 = +document.AddPO.quantity10.value; var quantity11 = +document.AddPO.quantity11.value; var quantity12 = +document.AddPO.quantity12.value; var quantity13 = +document.AddPO.quantity13.value; var quantity14 = +document.AddPO.quantity14.value; var quantity15 = +document.AddPO.quantity15.value; var quantity16 = +document.AddPO.quantity16.value; var quantity17 = +document.AddPO.quantity17.value; var quantity18 = +document.AddPO.quantity18.value; var quantity19 = +document.AddPO.quantity19.value; var quantity20 = +document.AddPO.quantity20.value; will this work? for (var i=1; i<21; i++) { var quantity[i] = +document.AddPO.quantity[i].value; } thanks a lot.
×
×
  • 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.