zszucs
-
Posts
27 -
Joined
-
Last visited
zszucs's Achievements
Member (2/5)
0
Reputation
-
not among my non-technical users
-
are there any good front ends to mysql tables similar to ms access grid views for tables? it can be web based or desktop. MS access as a front end to the mysql linked tables is too slow when using ctrl-f so I have to find an alternative (other than than that it's ok). It needs to be fast, allow the user to edit the record, allow fast use of ctrl-f,user friendly to non-technical users and preferred if I can set it up pretty quickly (there's lots of tables). Suggestions appreciated
-
my bad document.form1.cur_code.value = req.responseText; actually works in a way. there was a large amount of space and then code and then the actual response that i wanted. with the large amount of space, i just assumed there was no output here's what was outputted in the text box <!-- //javascript functions, then php functions --><script>function preparehtml(whichdiv){//alert("preparing");//alert("preparing" + whichdiv);document.all("htmlfromdiv").value=document.all(whichdiv).innerHTML;document.all("prepared").value=whichdiv;}function preparetextarea(whichdiv){//alert("preparing");alert("preparing" + whichdiv);document.all("htmlfromdiv").value=document.all(whichdiv).value;document.all("prepared").value=whichdiv;}</script><SCRIPT LANGUAGE='JAVASCRIPT' TYPE='TEXT/JAVASCRIPT'> <!--/**************************************************** AUTHOR: WWW.CGISCRIPT.NET, LLC URL: http://www.cgiscript.net Use the code for FREE but leave this message intact. Download your FREE CGI/Perl Scripts today! ( http://www.cgiscript.net/scripts.htm )****************************************************/var win=null;//MO 2004/02/16 Modified function to take additional variables for scrollbarsfunction NewWindow(mypage,myname,w,h,pos,infocus,sbars){if(pos=="random"){myleft=(screen.width)?Math.floor(Math.random()*(screen.width-w)):100;mytop=(screen.height)?Math.floor(Math.random()*((screen.height-h)-75)):100;}if(pos=="center"){myleft=(screen.width)?(screen.width-w)/2:100;mytop=(screen.height)?(screen.height-h)/2:100;}else if((pos!='center' && pos!="random") || pos==null){myleft=0;mytop=20}settings="width=" + w + ",height=" + h + ",top=" + mytop + ",left=" + myleft + ",scrollbars=" + sbars + ",location=no,directories=no,status=no,menubar=no,toolbar=no,resizable=no,titlebar=no";win=window.open(mypage,myname,settings);win.focus();}//MOfunction NewWindowdebug(mypage,myname,w,h,pos,infocus){if(pos=="random"){myleft=(screen.width)?Math.floor(Math.random()*(screen.width-w)):100;mytop=(screen.height)?Math.floor(Math.random()*((screen.height-h)-75)):100;}if(pos=="center"){myleft=(screen.width)?(screen.width-w)/2:100;mytop=(screen.height)?(screen.height-h)/2:100;}else if((pos!='center' && pos!="random") || pos==null){myleft=0;mytop=20}settings="width=" + w + ",height=" + h + ",top=" + mytop + ",left=" + myleft + ",scrollbars=yes,location=no,directories=no,status=yes,menubar=no,toolbar=yes,resizable=yes,titlebar=yes";win=window.open(mypage,myname,settings);win.focus();}//MO 2004/02/16 Modified function to take additional variables for window sizefunction CMS_PopUp(msgid, typeid){if (typeid==null) { NewWindow('/site/cms_popup.php?msgid='+msgid,'cms_popupwindow','390','220','null','front','no');}else if (typeid==1) { NewWindow('/site/cms_popup.php?msgid='+msgid,'cms_popupwindow','400','400','null','front','no');}else if (typeid==2) { NewWindow('/site/cms_popup.php?msgid='+msgid,'cms_popupwindow','500','500','null','front','yes');}}//MO// --></script>11749 111 the only thing i want is right at the end after </script> - 11749 111. is there a way I can just get that?
-
thanks but that doesn't work
-
so i'm using prototype to do an autopopulate. select from a drop list and then a textbox is supposed to get filled. it works fine if it's going into a div but it doesn't work for a text box for some reason. the code is a little flaky but it does work for a div file 1 <html> <head> <title>Changing textbox value based on dropdown list using Ajax and PHP</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script src="ajax.js"></script> <script src="prototype.js"></script> <script> function sendRequest() { new Ajax.Request("ajax.php", { method: 'post', postBody: 'id='+ $F('id'), onComplete: showResponse }); } function showResponse(req){ $('fadeBlock').innerHTML= req.responseText; //document.form1.cur_code.value = 'asdfad'; document.form1.cur_code.value = eval(req.responseText); //document.getElementById('cur_code').value=req.responseText; //$F('cur_code').value = 'asdf'; } </script> </head> <body style="font: 12px Verdana, Arial, Helvetica, sans-serif;"> <div id="fadeBlock"></div> <?php $sql = "SELECT * FROM product WHERE productid =11749"; $result = mysql_query($sql); ?> <form style="text-align:center" method="post" action="" name="form1" id="form1"> <p style="color:#000099 ">When you change the dropdown list, the respective currency code of the country will be displayed in the textbox which is fetched from PHP using Ajax. </p> <p>Country : <select name="id" onChange="sendRequest()" id="id"> <option value="">Select Country</option> <?php while($row = mysql_fetch_array($result)) { echo "<option value=\"$row[productid]\">$row[prodname]</option>\n"; } ?> </select><br/><br/> Currency : <input type="text" name="cur_code" id="cur_code" ></p> </form> </body> </html> ajax file getting called <?php include_once('functions.php'); $sql = "SELECT * FROM product WHERE id =11749"; $result = mysql_query($sql); $row = mysql_fetch_array($result); echo $row[productid]; ?> insights are appreciated
-
this is the relevant code from the form: <?php session_start(); include('functions.php') if($_POST) { //print_r($_POST); $msg = ''; $fund_weight_total = 0.00; $policy_weight_total = 0.00; $at_least_one_fund = 0; $at_least_one_policy = 0; for($i = 1; $i < 7; $i++) { $fund = 'fund' . $i; $fundwgt = 'fund' . $i . 'wgt'; $policy_weight = 'policy' . $i . 'wgt'; $policy = 'policy' . $i; $benchmark_policy = 'benchmark_policy' . $i; if(!empty($_POST["$fund"])) { $at_least_one_fund = 1; if($_POST["$fundwgt"] == 0) { $msg .= 'You must enter a value for fund weight ' . $i . '<br>'; } else { $fund_weight_total += $_POST["$fundwgt"]; } // if(empty($_POST["$policy"])) // { // $msg .= 'You must select a policy for fund weight ' . $i .'<br>'; // } } //validate for at least one policy if(!empty($_POST["$policy"])) { $at_least_one_policy = 1; if($_POST["$policy_weight"] == 0) { $msg .= 'You must enter a value for policy weight ' . $i . '<br>'; } else { $policy_weight_total += $_POST["$policy_weight"]; } if(empty($_POST["$benchmark_policy"])) { $msg .= 'You must select a benchmark for fund weight ' . $i .'<br>'; } } else { if(!empty($_POST["$benchmark_policy"])) { $msg .= 'You must select a policy for benchmark ' . $i .'<br>'; } } } if(!$at_least_one_fund) { $msg .= 'You must select at least one fund.<br>'; } if(!$at_least_one_policy) { $msg .= 'You must select at least one policy.<br>'; } if($fund_weight_total != 100) { $msg .= 'Fund weight must total 100%<br>'; } if($policy_weight_total != 100) { $msg .= 'Policy weight must total 100%<br>'; } if(empty($msg)) { $funds = array(); $benchmarks = array(); foreach($_POST as $k => $v) { //echo "$k => $v<br>"; if(ereg("^fund[0-9]$", $k)) { $sql = "SELECT reguniverse, assetclass FROM product WHERE productid = $v"; $result = mysql_query($sql); $row = mysql_fetch_array($result); if($v) { $funds[] = array('id' => $v, 'reguniverse' => $row['reguniverse'], 'assetclass' => $row['assetclass'], 'name' => $k); } } if(ereg("^benchmark_policy[0-9]$", $k)) { $sql = "SELECT reguniverse, assetclass FROM product WHERE productid = $v"; $result = mysql_query($sql); $row = mysql_fetch_array($result); if($v) { $benchmarks[] = array('id' => $v, 'reguniverse' => $row['reguniverse'], 'assetclass' => $row['assetclass'], 'name' => $k); } } } //print_r($funds); //die; $products = array_merge($funds, $benchmarks); usort($products, 'compare_reguniverse_assetclass'); //print_r($products); $first = 0; $compare = array(); $count = 0; //$_SESSION = array();//undo session vars here if(count($_SESSION) > 0) { $_SESSION = array();//undo session vars here } // $_SESSION['aquart'] = array(); // $_SESSION['val'][] = array(); foreach($products as $a => $b) { $current_pair = array(); foreach($b as $c => $d) { if($c == 'reguniverse') { $current_pair[] = $d; } if($c == 'assetclass') { $current_pair[] = $d; } } $months=12; $enddateoffset=0; $lsuniverse='stdunv'; $riskmetric='ROR'; $charttype='quartile'; if(!$first) { $first++; $arisk = getriskuniverse($current_pair[0], $current_pair[1], $asatdate, $months, $enddateoffset, $lsuniverse, $riskmetric, $charttype); $aquart = getquartuniverse($arisk, $asatdate, $months, $enddateoffset); $compare[0] = $current_pair[0]; $compare[1] = $current_pair[1]; } else { $compare_string = $compare[0] . $compare[1]; $current_string = $current_pair[0] . $current_pair[1]; if($compare_string != $current_string) { //if($compare[0] != $current_pair[0] || $compare[1] != $current_pair[1]) { //echo "$current_pair[0], $current_pair[1] else<br>"; $compare[0] = $current_pair[0]; $compare[1] = $current_pair[1]; $arisk = getriskuniverse($current_pair[0], $current_pair[1], $asatdate, $months, $enddateoffset, $lsuniverse, $riskmetric, $charttype); $aquart = getquartuniverse($arisk, $asatdate, $months, $enddateoffset); } } //get the $aquart array in the right order and add additional values needed for the spreedsheet array_shift($aquart);//get rid of end date for now $temp = array(); $temp['productid'] = ''; $temp['begindate'] = begin_date($asatdate, 12); $temp['enddate'] = $asatdate; $temp['exporttype'] = $riskmetric; $temp['datatype'] = ''; $aquart = array_merge($temp, $aquart); $aquart['rank'] = ''; //now get $val array in the right order and add additional values needed for the spreedsheet $val = riskandrankuniverse($products[$a]['id'], $arisk, $asatdate, $months, $enddateoffset, $riskmetric); $val = array_slice($val, 4); $temp = array(); $temp['productid'] = $products[$a]['id']; $temp['begindate'] = begin_date($asatdate, 12); $temp['enddate'] = $asatdate; $temp['exporttype'] = $riskmetric; if(ereg("^fund[0-9]$", $products[$a]['name'])) { $temp['datatype'] = 'VAL'; } else { $temp['datatype'] = 'BMK'; } $temp['reguniverse'] = $current_pair[0]; $temp['assetclass'] = $current_pair[1]; $temp['value'] = $val['prodrisk']; $temp['rank'] = $val['rank']; $val = array(); $val = $temp; $_SESSION['aquart'][] = $aquart; $_SESSION['val'][] = $val; $_SESSION['count'] = $count;//loop control var $count++; } //include('excel.php'); echo "<a href=\"excel.php\" target=\"_blank\">Click here</a>"; } } ?> from the dowload file excel.php <?php session_start(); ini_set("memory_limit","256M"); require_once "ExcelExport.php"; $xls = new ExcelExport(); //titles //$xls->addRow(Array("ProductID","Last Name","Website","ID")); $per_labels = array('P0','P5','P10','P20','P25','P30','P40','P50','P60','P70','P75','P80','P90','P95','P100'); $count = $_SESSION['count']; for($i = 0; $i <= $count; $i++) { $row1 = array(); $row2 = array(); foreach ($_SESSION['aquart'][$i] as $k => $v) { if($k != 'qerror' && $k != 'minpointlimit' && $k != 'numrows') { if($k == 'datatype') { foreach($per_labels as $v) { $row1[] = $v; } } else { $row1[] = $v; } //echo "$k => $v<br>"; } } foreach ($_SESSION['val'][$i] as $k => $v) { if($k != 'qerror' && $k != 'minpointlimit' && $k != 'numrows') { $row2[] = $v; //echo "$k => $v<br>"; } } $row = array_merge($row1, $row2); $xls->addRow($row); } print_r($_SESSION); //$xls->download("spreadsheet.xls");
-
i have a file that will produce a link to an xls download once the information is validated. i notice that i need to refresh the browser on the originating page to get the session vars to appear on the download page once the link is clicked which is a seperate file. I have session_start() start at the top both of the pages. i tried using a header refresh after the link but it didn't work. any suggestions?
-
this is a full html/php page so there's content there. by the sounds of it i can't do it. i tried to redirect to the download and then back to the form but when it comes back to the form, that page never finishes rendering
-
I'd like to see if there's a better way of doing this. Right now, i have a form that has some selection criteria and posts to it itself to validate. If it's good, a link to a forced download that consists of an xls file that has the processed details is presented. what i would like is to have it post to itself, validate and just force the download if it's good data all there on the same form. The problem seems to be that there can't be code above the header calls that force the download or the data will just be sent to the browser thus ruining the download. Is there any way around this to acheive what I'm looking for which is a little more user friendly?
-
not sure if this is a php app per se (hope so, that would make it easier for me). i need to get a live feed from a warehouse and display it on the website. something like this http://71.130.119.83/view/index2.shtml?newstyle=One&cam=2 . any suggestions?
-
the framework that I was using - kohana - was stripping the meta tags out. if I used ajax outside of the framework i could save it. If i included the framework, meta tags disappeared even with ajax
-
trying to save meta tags in a mysql db. the client just wants to paste the full tags into a text area. unfortunately it the post data after it submits indicates its gone. nothing in view source either. other tags seem to save fine. is it even possible to save meta tags like this? if it's possible, what's the right way of going about it?
-
total noob at jquery so not suprised that i ran into a problem. what im trying to do is an image swap when clicking on a group of images which works fine. The problem is that i need the image swap only to occur when only one particular item is selected from a drop list. this is what i have so far (probably could be more effiecient but i'm new at this): <script type="text/javascript"> <?php $sql = "SELECT * FROM images WHERE image_category_id=2"; $result = mysql_query($sql); if (!$result) { die('Invalid query: ' . mysql_error()); } if(mysql_num_rows($result) > 0) { ?> $(document).ready(function(){ <?php while($row = mysql_fetch_array($result)) { ?> //if ($("#office_loc")[0].selectedIndex == 1) { $('#action_card<?=$row['id']?>').toggle( //function(){ alert($("#office_loc")[0].selectedIndex) }, function() { $('#action_card<?=$row['id']?>').show('slow'); $('#main_image').attr('src','images/<?=$row['image']?>'); }, function() { $('#main_image').show('slow'); $('#main_image').attr('src','images/<?=$row['image']?>'); }); //} <?php } ?> }); <?php } ?> </script> i tried putting the conditional if ($("#office_loc")[0].selectedIndex == 1) { outside and inside of $('#action_card<?=$row['id']?>').toggle to no avail. I also tried if ( $("#office_loc").val() != 'whatever') ) { which also didn't work. Need some help here ...
-
if you delete a product, wouldn't that leave the history table with orphans?
-
anyone?