Search found 64 matches

by stephenrodrics
Tue Mar 17, 2015 4:44 am
Forum: PHP coding => General
Topic: How do i Read/import excel XLSM files in PHP & MySQL db
Replies: 1
Views: 1449

How do i Read/import excel XLSM files in PHP & MySQL db

Hi all,

i want to read Excel.XLSM file in my application, currently i am using Spreadsheet_Excel_Reader and I am able to import XLS files.

but how do i deal with xlsm files in php.

Regards,
Stephen
by stephenrodrics
Fri Jan 16, 2015 4:29 am
Forum: PHP coding => General
Topic: Unable to get file full path in Firefox using file browse dialog
Replies: 6
Views: 1171

Re: Unable to get file full path in Firefox using file browse dialog

thanks also I noticed that the if the excel is in client machine and he does a browse operation.

system is searching file on server machine how to avoid this
by stephenrodrics
Wed Jan 07, 2015 11:10 pm
Forum: PHP coding => General
Topic: Unable to get file full path in Firefox using file browse dialog
Replies: 6
Views: 1171

Re: Unable to get file full path in Firefox using file browse dialog

I browse the excel file which I want to import in one PHP page with PHP browse function below is the code <FORM name="f" method="post" enctype=”multipart/form-data” action="ExcelImportPMS.php" class="form"> <INPUT TYPE="file" name="file" id="file" class='dec' accept=".xls"><BR><BR> <BUTTON name="Imp...
by stephenrodrics
Thu Dec 25, 2014 7:29 am
Forum: PHP coding => General
Topic: date field coming as integer with phpExcelReader
Replies: 0
Views: 457

date field coming as integer with phpExcelReader

hi all, I am using phpExcelReader to import date from xls file to my database,all the fields are coming correctly except date field. date field data is being read as integer example 421588, if I convert this to date back i get 1970-01-01. any clue why date coming as integer and 1970-01-01. thanks,. ...
by stephenrodrics
Fri Nov 28, 2014 4:37 am
Forum: PHP coding => General
Topic: Unable to get file full path in Firefox using file browse dialog
Replies: 6
Views: 1171

Re: Unable to get file full path in Firefox using file browse dialog

Thanks for the info.

Currently my operation is very simple, I want to allow user to browse excel file and I am simply sending excel file path to my next page.

I am only getting file name, I want full file path and not able to get it.

any solution in ur mind
by stephenrodrics
Thu Nov 27, 2014 5:37 am
Forum: PHP coding => General
Topic: Unable to get file full path in Firefox using file browse dialog
Replies: 6
Views: 1171

Unable to get file full path in Firefox using file browse dialog

I have a file browse dialog page, I am able to get the filename, but fails to get full file path in Firefox, this code works fine in IE. can anyone tell what is the solution in Firefox script type="text/javascript"> function performClick(elemId) { var elem = document.getElementById(elemId); alert(el...
by stephenrodrics
Thu Sep 04, 2014 12:01 am
Forum: PHP coding => General
Topic: How do i open a popup window inside PHP code
Replies: 2
Views: 758

Re: How do i open a popup window inside PHP code

Here is my code in PHP which opens a New window instead of Popup window <?php for($i = 0; $i<$numRows; $i++) { print "\t <table width =100% border = 1 bgcolor=#FFFFFF table-layout:fixed;> <tr> <th> </th> </tr> <tr> <td width = 17%> <a align = 'left 'href=\"EditComments.php \" \"onclick=\" 'window.op...
by stephenrodrics
Wed Aug 27, 2014 7:09 am
Forum: PHP coding => General
Topic: How do i open a popup window inside PHP code
Replies: 2
Views: 758

How do i open a popup window inside PHP code

How do i open a popup window inside PHP code current I use the below code , but it opens a new full size window, can anyone tell where I went wrong. <td width = 18%><a align = 'left 'href=\"EditComments.php \" target='popup' id = \" hrefsidd \ \" onclick = \" 'window.open('EditComments.php','non_Pop...
by stephenrodrics
Wed Aug 27, 2014 6:41 am
Forum: PHP coding => General
Topic: How do I create a table with columns inside PHP code
Replies: 1
Views: 592

How do I create a table with columns inside PHP code

How do I create a table with columns inside PHP code
by stephenrodrics
Wed Aug 27, 2014 6:23 am
Forum: PHP coding => General
Topic: How to Assign Fixed Width to my Table columns
Replies: 2
Views: 774

How to Assign Fixed Width to my Table columns

How to Assign Fixed Width to my Table columns

currently I am using


<td width = 5% align = 'left'> "test" </td> but still my header and rows column width is not corect
by stephenrodrics
Thu Aug 07, 2014 5:16 am
Forum: PHP coding => General
Topic: How do i pass 2 Arrays inside a Checkbox Value
Replies: 1
Views: 541

How do i pass 2 Arrays inside a Checkbox Value

I have a table inside that I want to pass empid and week array inside Value data I am able to get the proper data, but week should come in single Quotes how do i do that <td width = 7%> <input type ='checkbox' id = 'Approve' value = '$json_empid[$i] and week = $json_week[$i]' name = 'Music' onclick=...
by stephenrodrics
Fri Feb 14, 2014 2:26 am
Forum: PHP coding => Mail
Topic: How do I trigger daily mails to a group using php mailer
Replies: 0
Views: 877

How do I trigger daily mails to a group using php mailer

How do I trigger daily mails to a group using php mailer class

I also want to run a select query to my table to get the details, how can I do so
by stephenrodrics
Thu Jan 02, 2014 5:43 am
Forum: PHP coding => General
Topic: How can we store the Table Sort Field name when page load
Replies: 0
Views: 597

How can we store the Table Sort Field name when page load

Hi I have a HTML php table where I have sort fields like employee id , name and date I have a check box attached to every Row when I check any employee name I submit my form and form loads again. When it loads again my form is again sorted on default order, is there any way I save the last sort fiel...
by stephenrodrics
Mon Dec 09, 2013 6:35 am
Forum: PHP coding => General
Topic: How can I select those fields/records which are Greater than
Replies: 0
Views: 858

How can I select those fields/records which are Greater than

How can I select those fields/records which are Greater than zero The below query fetch records those records also which are Greater than Zero or Zero, I simply want to avoid zero records SELECT EMPID, LEGALNAME, SUM( TTK) AS TTK, SUM( MW ) AS MW, SUM( AL ) AS AL FROM weeklytable WHERE week BETWEEN ...
by stephenrodrics
Tue Aug 27, 2013 3:37 am
Forum: PHP coding => General
Topic: Any validation fucntion which returns True/False or 0 or 1 ?
Replies: 2
Views: 1106

Any validation fucntion which returns True/False or 0 or 1 ?

can we use mysql_query to validate whether any record with week = '2013-04-20' already exist or not ? if not can anyone tell any validation function which returns true or false if we pass query to it $returnval = mysql_query("select * from emp where week='2013-04-20') if(! $returnval) { echo "no rec...
by stephenrodrics
Mon Aug 26, 2013 5:26 am
Forum: PHP coding => Mail
Topic: how to write Auto Mail script in php
Replies: 3
Views: 1608

how to write Auto Mail script in php

Hi,

I want to send a Reminder mail to a people group(mailing list) I am using php mailer classes to send mail.

how can i write a program to send Automatic Reminder mails every friday.

Thanks
by stephenrodrics
Sat Aug 24, 2013 2:07 am
Forum: PHP coding => General
Topic: How to get the delimiter count in a For Loop in PHP
Replies: 5
Views: 1613

Re: How to get the delimiter count in a For Loop in PHP

try this $str = "2,7,10"; $delimiter = ","; $str_arr = explode($delimiter, $str); $cnt = count($str_arr) - 1; may this work for you thanks for the explanation it really works, now my 2nd step is to pass this no in empid field I am using a foreach loop to update database with query here is the code ...
by stephenrodrics
Fri Aug 23, 2013 5:35 am
Forum: PHP coding => General
Topic: How to get the delimiter count in a For Loop in PHP
Replies: 5
Views: 1613

How to get the delimiter count in a For Loop in PHP

Hi,

I have a string in PHP I want to know the count of delimiter used in the string, is there any function in PHP to get this count in a For loop

2,7,10

I want to know the count of , used in the above string
by stephenrodrics
Fri Aug 23, 2013 3:16 am
Forum: PHP coding => General
Topic: How to get the selected Checkbox Index or value in PHP/Javas
Replies: 1
Views: 1084

How to get the selected Checkbox Index or value in PHP/Javas

How to get the selected Checkbox Index or value in PHP/Javascript

Below is my UI table

the page where checkbox are created that is submitted to a Form
by stephenrodrics
Mon Aug 19, 2013 8:33 am
Forum: PHP coding => General
Topic: how to get the duplicate records from mysql query
Replies: 6
Views: 1964

Re: how to get the duplicate records from mysql query

Dear stephenrodrics, The MySQL is more important for php developerswithout mysql knowledge you can't developed a effective website. For finding duplicate contents use the following sql query. mysql> SELECT *, count(*) as n -> FROM employee12 -> group by empid -> HAVING n>1; or by Using the having k...
by stephenrodrics
Mon Aug 19, 2013 4:29 am
Forum: PHP coding => General
Topic: How to Implement search option in PHP
Replies: 1
Views: 932

How to Implement search option in PHP

How to Implement search option in PHP

I want to load employee details once his employee ID is entered in Textbox and user press Enter key, how can I implement such a thing in PHP
by stephenrodrics
Mon Aug 19, 2013 2:42 am
Forum: PHP coding => General
Topic: how to get the duplicate records from mysql query
Replies: 6
Views: 1964

Re: how to get the duplicate records from mysql query

this does not fetch any record SELECT DISTINCT a.empid FROM `employee` a LEFT JOIN `employee` b ON a.empid = b.empid WHERE a.empid != b.empid; by the way I need emplyee IDS who are having duplicate entries example I have duplicate entry for employee 202 EID 202 Week 2013-08-13 EID 202 Week 2013-08-1...