Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
Ranked #4K
~18.9K People Reached
Favorite Tags
Member Avatar for tapuwa2002

I would like to fill in the empty spaces of a csv column and its in one column using phpexcel I have added a demo for your viewing: The flow check B2 is its not empty go the next B3 if B3 is empty take value from B2. Here is …

Member Avatar for happygeek
0
4K
Member Avatar for tapuwa2002

Hi guys I was hoping you could help I would like to add 10000 records in mysql db.All once with after running a single php script. in one of the fields should generate 10000 rand generated numbers. Any suggests would really help. I was thinking of a for loop. [CODE] …

Member Avatar for cereal
0
3K
Member Avatar for tapuwa2002

I have script that using to ssh2 to log into the firewall. I would like to run the commands from the firewall as if I was in the terminal when I add in the command in my script I get Resource id #5. <?php $connection = ssh2_connect('192.168.2.5', 22); ssh2_auth_password($connection, $user, …

Member Avatar for LastMitch
0
1K
Member Avatar for tapuwa2002

How do you ping an ip addresses in php. and give the the results as if you are on cmd program in windows <?php system(‘ping -c 192.168.0.104’); // Ping IP address. echo “pinged”; ?>

Member Avatar for Lucaci Andrew
0
303
Member Avatar for tapuwa2002

Been trying to loop through worksheets in an excel document. And remove "," in columns. Then save result in same excel document. <?php include'../Classes/PHPExcel.php'; include'../Classes/PHPExcel/IOFactory.php'; $objReader = PHPExcel_IOFactory::createReader('Excel2007'); $objReader->setReadDataOnly(false); //$xlsxfiles=$_SESSION['file']; //echo $xlsxfiles; $objPHPExcel = $objReader->load('../upload/Test_0.xlsx'); $num=$objPHPExcel->getSheetCount() ; $sheetnames=$objPHPExcel->getSheetNames() ; $objWorksheet = $objPHPExcel->getActiveSheet(); $highestRow = $objWorksheet->getHighestRow(); $sheetnum=$num-1; for($sl=0;$sl<$sheetnum;$sl++) { for($cl=0;$cl<$highestRow;$cl++){ $clean= …

Member Avatar for LastMitch
0
4K
Member Avatar for tapuwa2002

I would like to create a loop where it will count down and shift every thing to the right by one postion in the array. for example: array('1a','1b','1c','','','1f') should look like this array('1a','','','1b','1c','1f') Starting from position 5 and counting down.$i--

Member Avatar for diafol
0
180
Member Avatar for tapuwa2002

I would to add row values in an array each column will be an array value. echo '<table>' . "\n"; for ($row = 1; $row <= $highestRow; ++$row) { echo '<tr>' . "\n"; for ($col = 0; $col <= $highestColumnIndex; ++$col) { $values = '<td>' . $objWorksheet->getCellByColumnAndRow($col, $row)->getValue() . '</td>' …

Member Avatar for LastMitch
0
170
Member Avatar for tapuwa2002

I would like to add data from 2 worksheets in the same document and have them combined in one worksheet. Am using PHPExcel could you guys kindly help. -worksheet 1 and worksheet 2 = worksheet 3(combined worksheet1+worksheet2) Thanks

Member Avatar for tapuwa2002
0
183
Member Avatar for tapuwa2002

Am running a script that checks every line in a foreach loop. I would like help in how to tackle this each execution needs to be written to a log file which will show how log it went to process the each line at a time and if there is …

Member Avatar for pritaeas
0
306
Member Avatar for tapuwa2002

My file function doesnt seem to want to open my file in a folder. $lines = file('/download/test.xls');

Member Avatar for pritaeas
0
66
Member Avatar for tapuwa2002

I would like to find a method where i can find a character position in reverse.For example last "e" starting count in reverse. From example $string="Kelley"; $strposition=(strpos,'e'); it will give me position 1.

Member Avatar for adam.adamski.96155
0
214
Member Avatar for tapuwa2002

I have a csv file with data I would like the data to be filled in the empty spaces. then export to excel file or into a database for example. I would like the first column to copy the first Product A to fill the other spaces For example Type …

Member Avatar for LastMitch
0
922
Member Avatar for tapuwa2002

Am trying to get my script to read in a directory and search for a a file, if the file doesnt exist it should print"that it doesn't exist" then add Notinfolder in an array. Please assist <?php $connection = ftp_connect($server); $login = ftp_login($connection, $ftp_user_name, $ftp_user_pass); if (!$connection || !$login) { …

Member Avatar for tapuwa2002
0
1K
Member Avatar for tapuwa2002

I have a form field that should contain a number only. How can validate so that is doesn't take letters. For example I dont want it s accept aydhasdsiFGGS when I submit the form. <CFIF (find([A-Z],Telephone)) gte "1"> <CFLOCATION URL="error.cfm?PassedError=Possible%Spam."> <CFABORT> </CFIF> Please help

Member Avatar for arrgh
0
95
Member Avatar for tapuwa2002

Hi Guys I have a number and I only want to display the first 3 digits could you please help. Thanks <cfset mytour=885879><cfoutput>#Left(#mytour#, 3)#</cfoutput> How can I make the result into a global variable to use later. Forgive me am a noob to coldfusion

Member Avatar for arrgh
0
106
Member Avatar for tapuwa2002

Hi Please could you assist I have made a validaion. But when the correct field is not entered properly. Validation works but the javascript pop does show please see code below. <CFIF email IS (find("@",address)) neq 1> <CFLOCATION URL="error.cfm?PassedError=Please%20Supply us email address."> <CFABORT> <script type="text/javascript"> alert('Please Check Your Email'); </script> …

Member Avatar for arrgh
0
273
Member Avatar for tapuwa2002

I made page with a jquery plugin and a css dropdown menu. I had to z-index the rotator so that the menu drop down could go over it. but now the plugin nav buttons are not clicking please help guys. Been going round in circles. scratch scratch

Member Avatar for ansaripk
0
117
Member Avatar for tapuwa2002

Could you guys help Is there a script or way you can use to check if a page has been view before with the users browsers with using the a:visited then change color on like any page you land on it will tell you which urls were visted hence changing …

Member Avatar for JorgeM
0
440
Member Avatar for tapuwa2002

I have made a select statement with a date condition seems like its not reading the date condition please check the code below [CODE] Select * From tbltest WHERE (((Validity.ToDate)<><cfqueryPARAM value = "#31/8/2011#" CFSQLType = 'CF_SQL_DATE'>) [/CODE] Please help I don't want dates that are equal to 31/08/2011 its getting …

Member Avatar for arrgh
0
251
Member Avatar for tapuwa2002

I would like to hide a value in cfoutput and have the browser not show it but the value is needed. I have tried styling to have white text but it no working please help [CODE] <cfsetting enablecfoutputonly="true"> <cfparam name="q" default="" /> <cfquery name="qryGetCountry" datasource="dbtest"> select * from Cities Where …

Member Avatar for arrgh
0
146
Member Avatar for tapuwa2002

Downloaded autocomplete plugin. its not bring out results am using an access db. When I type in text it does the search but with no proposed results display in the drop down. Is there something missing? [CODE] <cfsetting enablecfoutputonly="true"> <cfparam name="q" default="" /> <cfquery name="qryGetCountry" datasource="dbtest"> SELECT DISTINCT Cities.RegionCity FROM …

Member Avatar for tapuwa2002
0
197
Member Avatar for tapuwa2002

I have created form where the values are taken from the form. I still get and an error when I put my form value in the statement. But when I run the statement separately it works but now when I combine it doesn't. [CODE] <cfif not isdefined("Form.frmpricerange")> <cfset Form.frmpricerange = …

Member Avatar for arrgh
0
101
Member Avatar for tapuwa2002

Hi guys Is there a way, where i can get two values from a option tag. I have form that needs to have values for it to display e.g My form looks like the following. [CODE] <form method="post" name="frmone" action="Result.cfm" enctype="multipart/form-data"> <select name="selvalues" id="selvalues" class="input_style-1" id="selvalues" style="height:19px"> <option value="1">Select Result</option> …

Member Avatar for tapuwa2002
0
150
Member Avatar for tapuwa2002

Hi guys Hoping you can help me I have designed a form when you click on Attach it opens a pop up window with the upload script, uploading is not a problem but returning the value from the pop up text field to the main form is not working. Main …

Member Avatar for sv3tli0
0
124
Member Avatar for rpv_sen

Hi i want to generate barcode for each bill. any one can help me. barcode will be alphanumeric(dynamic).

Member Avatar for rpv_sen
0
300
Member Avatar for miles.fuentes

So I have this code: [code]<html> <head> <style type="text/css"> <!-- a:link {color: #000000; text-decoration: underline; } a:active {color: #0000ff; text-decoration: underline; } a:visited {color: #000000; text-decoration: underline; } a:hover {color: white; text-decoration: none; } --> </style></head> <body background="img/bg3 .jpg"> <font face=Verdana size=2> <b>Login</b><br><br> <form action="plogin.php" method="GET"> Username:<input type="text" name="cust_uname"><br><br> Password:<input …

Member Avatar for Timroden
-1
147
Member Avatar for tapuwa2002

Hi Guys Am designing a database that will cater for a point of sale system.If you know any links or relative fields that can be added to the database that would be helpful. [B] Inventory table[/B] Inventoryid Productfkid Brandfkid Stock Barcode

Member Avatar for jbennet
0
66
Member Avatar for tapuwa2002

Hey Am new to PHP need help, if I want to create a list, and only want to add an item one below the other what would be the best method in using Sessions. If there any examples that would really help. Thanks

Member Avatar for diafol
0
121
Member Avatar for tapuwa2002

Hey guys I was hoping you help, I have a ms access database on my webserver. I want to select all the records with a certain date. But it seems not to work. [CODE] <CFQUERY NAME="qStuff" DATASOURCE="MyDb" maxrows="20"> SELECT * FROM Stuff; WHERE (((Stuff.RegDate)=#5/1/2004#)); </CFQUERY> [/CODE] When I do this …

Member Avatar for tapuwa2002
0
215
Member Avatar for tapuwa2002

Please help, I have designed a form, that contains an upload button. The form can only take file upto the size of 1mb. Every time I press the submitbutton I get: [B]Notice: Undefined index: myfile in F:\wamp\www\Site\CRUD\Upload\insertscript.php on line 9 Invalid file type [/B] this is my form and below …

Member Avatar for whiteyoh
0
1K