popmotsy

hi,, I write a code to download file in the excel format. I want to save this file automatically to the specific folder I want. I dont want that it always ask for save the file.. Can any body know how can I do it. thanks. <?php ob_start(); // Edit the $Host, $User $Password, $DBName and $TableName vars only! // $Host = "localhost"; $User = "xxx"; $Password = "xxx"; $DBName = "xxx"; //$TableName = "xxx"; // DO NOT EDIT BELOW HERE // $link = mysql_connect ($Host, $User, $Password) or die('Could not connect: ' . mysql_error()); mysql_select_db($DBName) or die('Could not select database');?> <?php if(isset($_POST['submit'])) { $select = "SELECT a.podno, a.barcodeno, a.recievedby, a.relation, a.delievaryboy, a.delievarydate, a.remark, b. * FROM main_feedback AS a INNER JOIN pod_dump AS b ON a.barcodeno = b.Acc order by a.podno"; //print_r($select); $export = mysql_query($select); $fields = mysql_num_fields($export); for ($i = 0; $i < $fields; $i++) { $csv_output .= mysql_field_name($export, $i) . "\t"; } while($row = mysql_fetch_row($export)) { $line = ''; foreach($row as $value) { if ((!isset($value)) OR ($value == "")) { $value = "\t"; } else { $value = str_replace('"', '""', $value); $value = '"' . $value . '"' . "\t"; } $line .= $value; } $data .= trim($line)."\n"; } $data = str_replace("\r","",$data); header("Content-Type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=Matched_Report_Final.".date('D-F-d-Y').".xls"); header("Pragma: no-cache"); header("Expires: 0"); print $csv_output."\n".$data; exit; } ?>

ok fine... you are right , i just want to copy or delete data up to the selected textboxes.. first select using shift+arrow key and just paste the data.

hi,, If Any one else know about the solution or any tricks,,,,, please please,,giv me reply.

hi mjdamato, first sory, i am not asking the whole problame. Actually I have data entry page,on which my client wants to enable shift+arrow keys for multiple selections, like excel sheets. Hope this was done through css tables. Well thanks for your help and replying me..

hi,,,thanks for replying me.... Now I got it,,,, but still i hav a problame, i want shift +arrow keys are just work similar as they are working in EXCEL SHEETS, on my web page. In excel sheet those keys are used for multiple selection of text boxes. Do you hav any idea how to write code for this, thanks.

hi to all,,,, I want to enable shift+arrow keys in my html table i am using the code below,,but doesnt works here i write code for shift+down arrow key... var isshift = false; $(document).keyup(function (e) { if(e.which == 16) isshift=false; }).keydown(function (e) { if(e.which == 16) isshift=true; if(e.which == 40 && isshift == true) { return false; } }); So please help me if any one know abt that,,,please send me a code for this,,,,thanks

hi guys... I want to retrive table fields using chechkboxes,,,Here chechkbox values same as the Table fields Name. I want user select checkbox,, and selected checkbox data retrieve from database,viewd in the form of table. My code for checkbox is: <?php require_once("include/connection.php");?> <?php include("include/header.php"); ?> <?php require_once("include/top.php"); ?> <?php require_once("include/left.php"); ?> <?php require_once("include/left.php"); ?> <table border="0" width="990"> <tr> <TD> <table align="center" border="1" style="font-size:12"> <form name="frmTest" method="post" " > Select Fields To Make A Report</br></br> <input type="checkbox" id="chk1" name="answer[]" value="sbi_id" onclick="checkCheckBoxes(id);"/>Id </br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk2" name="answer_1" value="billcycle"/> Billcycle </br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk3" name="answer_2" value="prioritydelievary"/> Priority Delievary </br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk4" name="answer_3" value="sbi_barcodeno"/> Barcode1 </br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk5" name="answer_4" value="podno"/> POD No </br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk6" name="answer_5" value="recievedby"/> Recieved By</br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk7" name="answer_6" value="relation"/>Relation</br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk8" name="answer_7" value="remark"/> Remark</br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk9" name="answer_8" value="bcode"/> Barcode2</br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk10" name="answer_9" value="ldate"/>Letter date</br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk11" name="answer_10" value="acno"/> Account No</br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk12" name="answer_11" value="customername"/> Customername</br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk13" name="answer_12" value="compname"/> CompanyName</br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk14" name="answer_13" value="address"/> Address</br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk15" name="answer_14" value="rphone"/> Resi Phone</br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk16" name="answer_15" value="ophone"/> Office Phone</br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk17" name="answer_16" value="cityid"/> City</br> <input type="checkbox" onclick="checkCheckBoxes(id);" id="chk18" name="answer_17" value="pcode"/> PinCode</br> <input type="submit" name="submit" value="submit"/> </form>

but this code workin If i use checkbox instead of textboxex.... I want selected value insert into database....

hi ignace.. this code works...fine....thanks for ur help... thanks

hi,,, I want on submit button all textbox values insert into Table1, row wise. but I dont understand how i write code for this,can anyone help. please see the code. <?php ob_start();?> <?php include("include/connection.php"); ?> <?php include("include/header.php"); ?> <script type="text/javascript" > function handleKeyPress(e,fldobj,nbox) { var key=e.keyCode || e.which; if (key==13) { event.cancelBubble = true; //Both lines stops auto submistion event.returnValue = false; // by pressing ENTER (submit) button //alert (nbox); var next=fldobj.tabIndex; // this will grap the tabindex of the object passed to variable 'next' //alert (next); //alert (next); var nN='cid'; // 'nN' is a placeholder for storing the lable of first field 'cid' nN=nN+next; // now both var concatinates for the creation of final text box name like 'cid0' 'cid1' //alert (nN); document.myform.elements[nN].focus(); // it will rotet the focus to the next element (textbox) } } </SCRIPT> <?php require_once("include/top.php"); ?> <?php require_once("include/left.php"); ?> <table align="center"><th align="center"> POD Entries</th></table> <table border="0" width="100%"> <TR> <TD width="100%" align="center"> <form name="myform" method="post" action="validpod.php" > <table align="center" border="1" style="font-size:12"> <TR> <th align="center" >Barcode No</th> </TR> <tr> <td width="16%" ><input type="text" name="cid0" size="16" tabindex="1" onkeypress="handleKeyPress(event,this,id);" ></td> </tr> <tr> <td width="16%"><input type="text" name="cid1" size="16" tabindex="2" onkeypress="handleKeyPress(event,this,id);" ></td> </tr> <tr> <td width="16%"><input type="text" name="cid2" size="16" tabindex="3" onkeypress="handleKeyPress(event,this,id);" ></td> </tr> <tr> <td width="16%"><input type="text" name="cid3" size="16" tabindex="4" onkeypress="handleKeyPress(event,this,id);" ></td> </tr> <tr> <td width="16%"><input type="text" name="cid4" size="16" tabindex="5" onkeypress="handleKeyPress(event,this,id);" ></td> </tr> <tr> <td width="16%"><input type="text" name="cid5" size="16" tabindex="6" onkeypress="handleKeyPress(event,this,id);" ></td> </tr> <tr> <td width="16%"><input type="text" name="cid6" size="16" tabindex="7" onkeypress="handleKeyPress(event,this,id);" ></td> </tr> </TABLE> <input type="submit" value="Submit"> </form> </td> </tr> </table> <?php require_once("include/right.php"); ?> <?php require_once("include/footer.php"); ?>

hi,, i'll explain again. I am taking input thru barcode scanner, after scanning curser automatically move to next textbox,,right. Now , when i am takin array of textbox, after takin input,, cursor doesn't move to next textbox,, thats my problam,,

hi guys,, first see my code,, I m takin input in textbox ("cid0,cid1,cid2...cid50..name of texbox") using barcode scanner,,after scanning,cursor moves to next textbox now if i change name of textbox mak them array,that means cid[],cid[],cid[]....and so on,,then cursor doesnot move. but here i hav to make them array,,and how can i mov cursor to next field...plz help... <script type="text/javascript" > function handleKeyPress(e,fldobj,nbox) { var key=e.keyCode || e.which; if (key==13) { event.cancelBubble = true; //Both lines stops auto submistion event.returnValue = false; // by pressing ENTER (submit) button //alert (nbox); var next=fldobj.tabIndex; // this will grap the tabindex of the object passed to variable 'next' //alert (next); //alert (next); var nN='cid'; // 'nN' is a placeholder for storing the lable of first field 'cid' nN=nN+next; // now both var concatinates for the creation of final text box name like 'cid0' 'cid1' //alert (nN); document.myform.elements[nN].focus(); // it will rotet the focus to the next element (textbox) } } </SCRIPT> <?php require_once("include/top.php"); ?> <?php require_once("include/left.php"); ?> <table align="center"><th align="center"> POD Entries</th></table> <table border="0" width="100%"> <TR> <TD width="100%" align="center"> <form name="myform" method="post" action="validpod.php" > <table align="center" border="1" style="font-size:12"> <TR> <th align="center" >Barcode No</th> <th align="center" >POD No.</th> </TR> <tr> <td width="16%" ><input type="text" name="cid0" size="16" tabindex="1" onkeypress="handleKeyPress(event,this,id);" ></td> <td width="17%"><input type="text" name="podno[]" tabindex="50" size="17"></td> </tr> <tr> <td width="16%"><input type="text" name="cid1" size="16" tabindex="2" onkeypress="handleKeyPress(event,this,id);" ></td> <td width="17%"><input type="text" name="podno[]" tabindex="51" size="17"></td> </tr> <tr> <td width="16%"><input type="text" name="cid2" size="16" tabindex="3" onkeypress="handleKeyPress(event,this,id);" ></td> <td width="17%"><input type="text" name="podno[]" tabindex="52" size="17"></td> </tr>

Hii to all, I make a data entry page in which user can enter 50 records at a time, I want ,on submit, records insert into table row wise, but I dont know how to write code for this, here is code for making data entry page,, <?php ob_start();?> <?php include("include/connection.php"); ?> <?php include("include/header.php"); ?> <script type="text/javascript" > function handleKeyPress(e,fldobj,nbox) { var key=e.keyCode || e.which; if (key==13) { event.cancelBubble = true; //Both lines stops auto submistion event.returnValue = false; // by pressing ENTER (submit) button //alert (nbox); var next=fldobj.tabIndex; // this will grap the tabindex of the object passed to variable 'next' //alert (next); //alert (next); var nN='cid'; // 'nN' is a placeholder for storing the lable of first field 'cid' nN=nN+next; // now both var concatinates for the creation of final text box name like 'cid0' 'cid1' //alert (nN); document.myform.elements[nN].focus(); // it will rotet the focus to the next element (textbox) } } </SCRIPT> <?php require_once("include/top.php"); ?> <?php require_once("include/left.php"); ?> <table align="center"><th align="center"> POD Entries</th></table> <table border="0" width="100%"> <TR> <TD width="100%" align="center"> <form name="myform" method="post" action="validpod.php" > <table align="center" border="1" style="font-size:12"> <TR> <th align="center" >Barcode No</th> <th align="center" >POD No.</th> <th align="center" >Received By</th> <th align="center" >Relation </th> <th align="center" >Delivery Boy</th> <th align="center" ><b>Delivery Date</th> <th>Executive Code</th> <th>Remark</th> </TR> <TR> <TD > </TD> <TD > </TD> <TD > </TD> <TD > </TD> <TD > </TD> <TD > </TD> <TD > </TD> <TD > </TD> </TR> <tr> <td width="16%" ><input type="text" name="cid0" size="16" tabindex="1" onkeypress="handleKeyPress(event,this,id);" ></td> <td width="17%"><input type="text" name="podno0" value="218" tabindex="50" size="17"></td> <td width="17%"><input type="text" name="recdby0" tabindex="100" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="relation0" tabindex="150" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="delvryboy0" tabindex="200" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="deliverydate0" tabindex="250" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="execode0" tabindex="300" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="remark0" tabindex="350" size="17" autocomplete="array:autodata"></td> </tr> <tr> <td width="16%"><input type="text" name="cid1" size="16" tabindex="2" onkeypress="handleKeyPress(event,this,id);" ></td> <td width="17%"><input type="text" name="podno1" value="219" tabindex="51" size="17"></td> <td width="17%"><input type="text" name="recdby1" tabindex="101" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="relation1" tabindex="151" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="delvryboy1" tabindex="201" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="deliverydate1" tabindex="251" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="execode1" tabindex="301" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="remark1" tabindex="351" size="17" autocomplete="array:autodata"></td> </tr> <tr> <td width="16%"><input type="text" name="cid2" size="16" tabindex="3" onkeypress="handleKeyPress(event,this,id);" ></td> <td width="17%"><input type="text" name="podno2" value="220" tabindex="52" size="17"></td> <td width="17%"><input type="text" name="recdby2" tabindex="102" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="relation2" tabindex="152" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="delvryboy2" tabindex="202" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="deliverydate2" tabindex="252" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="execode2" tabindex="302" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="remark2" tabindex="352" size="17" autocomplete="array:autodata"></td> </tr> <tr> <td width="16%"><input type="text" name="cid3" size="16" tabindex="4" onkeypress="handleKeyPress(event,this,id);" ></td> <td width="17%"><input type="text" name="podno3" value="221" tabindex="53" size="17"></td> <td width="17%"><input type="text" name="recdby3" tabindex="103" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="relation3" tabindex="153" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="delvryboy3" tabindex="203" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="deliverydate3" tabindex="253" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="execode3" tabindex="303" size="17" autocomplete="array:autodata"></td> <td width="17%"><input type="text" name="remark3" tabindex="353" size="17" autocomplete="array:autodata"></td> </tr> ''' ' ' ' ' ' ' ''' ' ' up to 50 <tr> <td width="20%"><input type="text" name="total_inputs" value="50" size="20"></td> </tr> </TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE> <input type="submit" value="Submit"> </form> </td> </tr> </table> <?php require_once("include/right.php"); ?> <?php require_once("include/footer.php"); ?> how I can insert in to database.. here "podno" is auotincrement,

Thanks beyzad,,, That code working, but in future i have to use dynamic checkboxes in that situation how can i do this.

for now they are static .

use ob_start(); at the top of your page.... and at the end of page ob_flush();

HIii To all,, In my project ,,, I want to extract data using checkbox,,,that means,, there is some checkbox whose value same as the table feilds. Now user can select the checkbox, and on submit only selected data comes out. I make array of checkboxes. I have write a code for this,,,plz chechk it <?php require_once("include/left.php"); ?> <table border="0" width="990"> <tr> <TD> <table align="center" border="1" style="font-size:12"> <form name="frm354" method="post" > Select Fields To Make A Report</br></br> <input type="checkbox" name="answer[]" value="sbi_id"/>Id </br> <input type="checkbox" name="answer[]" value="billcycle"/> Billcycle </br> <input type="checkbox" name="answer[]" value="prioritydelievary"/> Priority Delievary </br> <input type="checkbox" name="answer[]" value="sbi_barcodeno"/> Barcode1 </br> <input type="checkbox" name="answer[]" value="podno"/> POD No </br> <input type="checkbox" name="answer[]" value="recievedby"/> Recieved By</br> <input type="checkbox" name="answer[]" value="relation"/>Relation</br> <input type="checkbox" name="answer[]" value="remark"/> Remark</br> <input type="checkbox" name="answer[]" value="bcode"/> Barcode2</br> <input type="checkbox" name="answer[]" value="ldate"/>Letter date</br> <input type="checkbox" name="answer[]" value="acno"/> Account No</br> <input type="checkbox" name="answer[]" value="customername"/> Customername</br> <input type="checkbox" name="answer[]" value="compname"/> CompanyName</br> <input type="checkbox" name="answer[]" value="address"/> Address</br> <input type="checkbox" name="answer[]" value="rphone"/> Resi Phone</br> <input type="checkbox" name="answer[]" value="ophone"/> Office Phone</br> <input type="checkbox" name="answer[]" value="cityid"/> City</br> <input type="checkbox" name="answer[]" value="pcode"/> PinCode</br> <input type="submit" name="submit" value="submit"/> </form> </table> </form> <?php if(isset($_POST['submit'])) { for($i=0;$i<count($_POST['answer']);$i++) { $ans=$_POST['answer']; // // echo $ans1; $sql="select * from xsbi_feedback "; // print($sql); $result=mysql_query($sql); while($data=mysql_fetch_array($result)) { //HOW CAN i GET VALUES.. } } } ?> plz help,,,thanks..

Hii MadTechie.. Ok well I explain the problam I hav 2 fields in table pod_id = 1338000 pod_no = 1338000 What I want to do is to insert another 1000 records incremmenting both the current field content so the result would be pod_id,pod_no 1338000,1338000 1338001,1338001 1338002,1338002 1338003,1338003 and so on. I am not sure which is the best way to do this.

hii to all, ??? ??? I want to make two fields AUTO Increment in the same table. Is that possible, is there any way to do this. Please if anyone know how to do this, please send me.. THANKS<<<waiting for reply<<<

hii thanks for replying..... well i never used com object in php,,,,but may be this is helpful,,,i m trying for that,,,thanks....

hii to all,,,, i got a very new problam ,,, i have a table on my web page,,,i want to take input through BARCODE SCANNER,,,,how tht was paossible,,,,is there any socket programing required,,,plzzzzzz help me..... thanks,,,,,

hiii,,,,,to all I want to insert a row with some condition,,is that possible... I am inserting multiple rows in a table,,,but i want that on submit button only those rows inserted in which the outcome(name of field in the table) is not blank....thanks... please suggest methe solution...

hii to all... i want to perform 2 queries on a single submit button...can i do it,,,please help,,,

ok.thanks for replying...let me explain ..first i insert the values,, foreach ($_POST['mobileno'] as $row=>$name) { $mobileno= mysql_real_escape_string($name); $occupation=$_POST['occupation'][$row]; $ifowned=$_POST['ifowned'][$row]; $sql="insert into table(mobileno,occupationid,ifownedid,) values ('$mob','$occupation',''$ifowned')" ; } then by this query i show the sum:: SELECT cp. * , sum( ifo.score + oc.score ) AS score FROM tablename AS cp, if_owned AS ifo, occupation AS oc WHERE cp.occupationid = oc.name AND cp.ifownedid = ifo.name GROUP BY cp.mobileno show the value of sum in textbox,,,, now again i want to insert sums into column score ,,i try this query if(isset($_POST['submit'])) { foreach ($_POST['score']as $row=>$name) { $sc=mysql_real_escape_string($name); $sql="insert into table set score='$sc'"; $res=mysql_query($sql)or die(mysql_error()); } } but at this point i got a notice that Invalid argument supplied for foreach() so now what is the mistake,,,,

hii to all...i have some problam with insert with sum.... consider a table...contains fields mobileno::ifowned::occupation:score... here ifowned and occupation are combobox ,, user can select combobox option according to that some value can selected ,,now i show the sum of selected fields on a page in a input box,,,, now i want to enter that inputbox value of sum into "score" column of same table,,, can any one suggest me query,, also the table contain multiple records ...so here we insert thru making array,,thru foreach statement...here also i got an error "Invalid argument supplied for foreach() " thanks,,, ??? ??? ??? ???