No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
30 Posted Topics
 | 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 …  |
| | 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] …  |
| | 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, … |
| | 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”; ?>  |
| | 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= … |
| | 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-- |
| | 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>' … |
| | 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 |
| | 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 …  |
| | My file function doesnt seem to want to open my file in a folder. $lines = file('/download/test.xls'); |
| | 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. |
| | 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 … |
| | 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) { … |
| | 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 |
| | 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 |
| | 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> … |
| | 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  |
| | 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 …  |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 = … |
| | 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> … |
| | 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 …  |
| | You can find a random generator function that uses both letters and numbers and the length of the final string.If you still struggling just post. |
| | Please post the "plogin.php" code that will help, for us to see whats not working. |
| | 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 |
| | 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 |
| | 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 … |
| | 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 …  |
The End.