Passing Form Data To An Email Address/Excel Sheet On A Local Computer
I am right now learning PHP & want to know if there is a way to send
web form data to an Excel sheet located on a network. My windows xp PC
doesnot have a copy of Excel. Also i am not connected to the internet,
its a local computer.
What i am trying to do is to make a PHP script which will send a simple
form data to an excel sheet (or create a new Excel sheet) on another PC
on a network.
Since i am not connected to the internet, i will not be able to send an
email (anyway, sendmail is not available on Windows OS), nor do i have
any server on windows.
Is it possible to send form data to Excel sheet on local computer? Even
my PC is a local PC. Some one was saying its possible thru Windows
Scheduler.
View Complete Forum Thread with Replies
Related Forum Messages:
Local Excel Sheet
if you know a way to import not all but a majority of the data from a excel sheet into php. The excel sheet is sent to me by mail daily and I then need to go through it and manually change it. I'm getting tired of doing this and hoped I could automate through php to create another excel sheet with the amendments. I'm sure I'll be able to amend the text ect if I could import the excel sheet.
View Replies !
Inserting Excel Sheet Data
I am trying to insert excel sheet data into mysql database. First, I convert that file into comma delimited CSV and then apply this code. $link = mysql_connect("localhost", "user", "pass"); mysql_select_db("db"); $file = $_FILES['excel_file']['name']; @copy($_FILES['excel_file']['tmp_name'], "files/$file"); $query = 'LOAD DATA INFILE /www/trisha/admin/"'.$file.'" INTO TABLE student_info FIELDS TERMINATED BY "," LINES TERMINATED BY " ";' mysql_query($query); @unlink($file);
View Replies !
Saving Email Attachments To Local Computer
I receive a daily email attachment, which is a zipped .csv file. I am trying to write a script that is able to read this csv file. Currently I am using the IMAP function and I am able to access my mailbox and get the name of the attachment, but this is where I've hit a stopping point. Is it possible to save the attachment to my local computer? From there I could use the zip_read function. I have tried file_put_contents, but that doesn't seem to work because of the .zip format.
View Replies !
Use Excel Sheet As DB
does any 1 here know how to use an excel sheet as a DB without converting it just upload the excel to the server and use it direct from php script?
View Replies !
Excel Sheet
I have some excel files on the server that i would like to be opened by the website users. i have echo out an anchor tag with a link to my files, but when the user clicks on the link, the file opens as an excel sheet in Internet Explorer.
View Replies !
Is It Possible To Use An Excel Sheet As A Database
I'm a starting web programmer. I'm making a website for an Irish Pub. Because of the many different activities in the pub I'm searching for a possibility to give away some tasks to other people who don't know anything about webprogramming. For results of tournament etc. I wanna make an excel sheet to fill in the results by poeple who don't know webprogramming. Is it possible to import data from an excelsheet into a php file. In this way I can make my own template with the imported data from the excel sheet.
View Replies !
Open EXCEl Sheet
I have a requirement of opening a empty excel sheet using a PHP code and making updates and publish it back to the website. I need to follow following steps 1. User logs into a website using authentication (This works) 2. Opens a excel file 3. Updates the file 4. Saves/Publishes back into the web Have anybody tried something similar to this.
View Replies !
Excel Sheet Writing
I am trying to creat excel sheet from SQL data base using standard php code.But the problem is when I opened that excel sheet in Open Office Spreed Sheet,it is not showing the data in horizontal and vertical shells or squares.But it's opens properly in Microsoft Excel.
View Replies !
Need Email Address From Submitted Html Email Form
I have an html email that contains a form with questions for the user to fill out. Without asking the user to re-input there email address into the form, is there a way for me to grab the email address its coming from when the user submits the form to the php processing program. I need a way to match the questions to the user when they submit the form.
View Replies !
Block Email Address / Domain From Using Email Form
I keep getting the same person spamming people on my website through my email form. The email address is they keep using is sadlowski_lidia@o2.pl but this sometimes changes to a different name but still from the o2.pl domain How can I block anyone using my email from the domain name o2.pl
View Replies !
Parse PHP On Local Computer
Running Windows XP (Home) and would like to be able to parse PHP locally without having to upload files to my host server and view them there. I know I can install PHP on my PC, but what is the simplest way to set it up as a local server, preferably without needing to install Apache as well?
View Replies !
Check Local Computer Script
I am trying to do is create a script that searches the local computer of the user and if a filename is there, it will upload it to the mysql database. Then, another script that searches for a filename on the database and if it's there, to ask the user if they would like to send it to their local computer. Any suggestions?
View Replies !
How To Upload Website From Local Computer
i have made my website on my local computer. and now i'm trying to upload it into server. but some errors happen, and these errors aren't show up in my local computer. please give me suggestion about making website in local computer and then uploading it.
View Replies !
Form To Excel Then Send As Email Attachment
I am working on a form, basically, that grades people. Now, I got the form made, my outputs are ok. However, there is something I was my form to do, which I think is possible, but is a major road block for me. Currently, my form does a POST in an Excel file, which is saved with the values that I want. But I need this file to be send via email to recipient, CC to the user logged in and the part that I am confuse is to send the XLS file as attachment. Is that possible and if so, can someone guide me on how to get my outputted excel form in an attachment ready to send.
View Replies !
Parsing HTML Files On Local Computer
I would like to be able to open and read HTML files that are on my local (client) computer and then parse them to extract some specific information they contain. I've been looking here and reading my PHP books, but it appears to me that PHP only opens files on the server or URLs. It think that makes sense to me. Is there an alternative?
View Replies !
Web Form To Variable Email Address
have a html web form with a drop-down listbox, and dependent on what is chosen then sends form data to different email address, how do i go about this? the web form seems to have to use the ISP's action script form_to_mail.php, so can't drop my own in, so need to somehow tweak the hidden field 'reciept' value before it gets processed by the ISP php script. is this possible?
View Replies !
Hyperlink From Intranet Web Page To Local Files On My Computer
I'm creating a company intranet, and every employee has certain program we want them to be able to run from it, meaning we want the link to the program to be on the intranet page. For example, Adobe Photoshop resides on all the employees computer under "C:Program FilesAdobePhotoshop 7.0Photoshop.exe" However, when I enter that as a hyperlink on the page, it does not run the program. Is there a way to get a web page to run a program on the local host?
View Replies !
Inserting Different Email Address Into Feedback Form
I have a website which contains "profiles" for around 200 small hostels and tour companies in South America. each profile has a feedback form inserted into it using SSI which allows backpackers to send emails direct to the hostel/company. When the submit button is pressed, it executes a PHP script (which I got off thesitewizard.com) to mail the form back direct to the company. Whilst the actual feedback form itself is one file, inserted into each profile, the PHP that executes is separate for each company - the only reason is because the email address differs for each company. My main aim is to have the bulk of the PHP script as one file and somehow include the email address into the PHP script either using somekind of include() from a separate file or otherwise taking it as a variable in the profile page itself. As I'm rubbish with PHP, I trawled the net and read through about a dozen tutorials regarding PHP include, but the script fails to execute when I do this. The code I am using is: <?php include("file.php"); ?>. The include function definately works as I have tried creating a blank php file with just <?php include("file.php"); ?> (where file.php is the FULL php script) in it and it executes perfectly. However, When I divide the script in two and put the first half in the document and follow it with <?php include("file.php"); ?> eg... <? $mailto = "info@email.com"; <?php include("file.php"); ?> I get an error message stating: Parse error: syntax error, unexpected '<' obviously because it can't handle the <? before the php include. Is there a way in which you can insert plain text (ie an email address perhaps from a text file) into a PHP script?
View Replies !
Simple Email Form - Add Name, Address, City
How do I add name, address, city so they work and are included in email. New to php and everything I try does not get work. < ? $email = $_GET['email'] ; $message = $_GET['message'] ; mail( "yourname@example.com", "Email Subject", $message, "From: $email" ); print "Congratulations your email has been sent"; ?>
View Replies !
Form Validation :: Email / Phone Number / Address
I need to validate the following fields using php. 1. email (needs to be just one e-mail address, and take out stuff like bcc or anything that would be used for e-mail injection vulnerability) 2. Phone number (has to be in the format 555-5555) 3. Phone number area code (has to be limited to 3 characters) 4. Address has to be stripped of all illegal characters like slashes, special characters etc Another thing is I don't want people to be able to leave any of the fields blank. Where does the validation code go? After this statement? if($REQUEST_METHOD=="POST") or before? I have tried a few things, but I am not sure what most people use,
View Replies !
Exporting Data From Mysql Using Php In Excel Form..?
I have a table in mysql wich contain a sim_number field which is 19 digit unsigned number. i have designed a script using php headear command for exporting data as excel. It is working but with the follwoing problem. Since sim_number is 19 digit number when it get exported as .xls file. now when that .xls file is opened, excel automatically detect this sim_number as number and , since excel can store only 15 digit in number format it converts its last 4 digits to zeros. Is there any way to get this sim_number exported as text so that excel store complete 19 digit number in text format. I cannot attach some charctor to this sim_number because of restricion on file format.
View Replies !
Can One Call An Access Database On Computer Using The IP Address?
An old friend of mine recently approached me and said something like: "I've a computer at my office that has an Access database running on it. We've most of our company info in there. We'd like to put a portion of it online as a dynamic site, but we don't want the database to leave our office. Our office is connected to the Internet through a static IP. Can you do it?" I said no, but I also said I'd look into it. Could a PHP script running on a web server make a call to that database to get info? How does that work?
View Replies !
Getting Data From Address Bar Into Form Action.
Here is the problem...i have a game where a users id and encrypted password are stored in the address bar on every page of the game. e.g. main.php?P=bank&uid=15&password=faspmi9r329m2d324sd now i have a problem when trying to link to a page through a form while still keeping these variables in the link to be more specific i have a form for a user to deposit gold into their bank upon entering a value in the input box and clicking either deposit or withdraw the form is to reload the same page where the proper if(isset($_POST command will take over and do the correct job. The only problem is if i use a $_SERVER['PHP_SELF'] as the action for the form when it reads back on its self again it doesnt include the uid or password...it simply is reloading main.php ...my question is.... how do i get these variables sent back through the form button so the page will reload with the users information still there?
View Replies !
Send Data Submitted By User In Form To Address Bar
it's pretty self-explanatory but when I have a form in my PHP scripting I'm trying to figure out a way of sending what the user enters to the end of the address bar in the new page that opens when the form is submitted: echo '<form action="/search.php?result=$result" method="post">'; echo '<a href="/">Home[/url] | '; echo '<a href="/whatsnew.php?startrow=0">What's New[/url] | '; echo '<a href="/newsletter.php">Newsletter[/url] | '; echo 'Search: <input type="text" name="search">'; echo '<input type="submit" value="Go!">'; echo '</form>'; I need $result to equal what the user enters to use the GET_$result code on the search.php page.
View Replies !
Passing Form Data
I have a project that consists of a large quiz that displays multiple questions per page from a database and then saves those answers to another database table. The issue I'm having is with a form that consists of radio buttons and check boxes. The form is only submitting the last checked value for the check boxes rather than all checked values. I'm sure this is an easy fix but my mind is about to explode from a full day's work and a lot of time trying to figure this out, so I was wondering if someone could give me a hand. Code:
View Replies !
Php Form Data Passing
I am working on webGUI for networking application. There are around 30 to 35 network related parameters user would enter by PHP forms. I already have PHP page and I can print all this parameters entered by user in PHP script. I want to process those parameters outside PHP script. It means I have my own networking process (daemon) written in C & C++, which need this user entries so that it can do more massaging and pass it to operating system (giving those parameters to Linux like IP address etc). I would like to know which are the different standard/non standard ways I can use? Is there any open source project, which is doing this kind of thing I could use? Any links or books in this directions?
View Replies !
Need Help Passing Form Data To A New Window.
I have a form that one can enter their nickname for a IRC Java Applet. They enter their nickname and when they submit it should pass the nickname onto the applet. It will work if I use the normal form method="post" action="blah", but I need it in a new window, and it's not working out that way. PHP Code:
View Replies !
Form Data Not Passing To PHP Handler
Using a basic PHP file to handle incoming form data of a single text field, I have determined that the contents of the input is not being passed. The PHP reports the variable as empty... I suspect the reason it is getting "lost" on the way there is that the form is part of an include (header.html) rather than hard coded into the main page. So its link to the PHP handler is not direct. Is that possible? I was using GET method but to eliminate issues such as superglobals being off, I switched over to POST, at least for now and until I get it working...
View Replies !
Passing Form Data Through A Page
I'm in the process of creating a new form that stores customer input into a MySQL database. What i'm attempting to do is allow them to fill out their data, and hit 'next' to go on to a file upload form. Upon completing that form and submitting, all information (including their data from page 1) is posted at the same time (so it's all under the same ID). What would be the easiest way to do this? Right now my submit file (submitquote.php) contains the following data (all on one page). Code:
View Replies !
Passing Form Data Problem
I need to pass form data from page to page and to test how to do it with PHP I've used the following code. Page 2 displays the name and age OK, but page 3 "loses" them and just displays the age. Where am I going wrong? Code for Page1.php <form action="page2.php" method="post"> <input name="name" type="text"> <input name="age" type="text"> <input name="" type="submit"> </form> Code for Page2.php <?php echo $_POST["name"]?> <?php echo $_POST["age"]?> <form action="page3.php" method="post"> <input name="name" type="hidden" value="<? $_POST['name']?>"> <input name="age" type="hidden" value="<? $_POST['age']?>"> <input type="text" name="sex"> ..................
View Replies !
Passing Data To Multi Use Form
I am working on a site where I need to create forms to both add and edit information for a group of products. I would like to use the same form for both adding new and edit data for existing products, while at the same time separating data and presentation functions. So when the user selects the option to add a new product, the form comes up with all drop down lists filled from the database with the options for that field and all other fields blank, and when a product is selected to be edited, I would like the same form to come up, but this time with all the fields filled in, including all drop down lists filled with the appropriate value for that product. Code:
View Replies !
Passing Form Data Back Into The Same Script?
I am looking for a really simple example of passing submitted form data back into the same script. I've found quite a lot of stuff online about it, but none of which mentions the new $_POST globals and stuff. This is all that I want to do... 1. First run into the script, displays form 2. Form data submitted, same script run but check is made on $_POST variables (is isset() the best and safest function to use for this?). If all variables are present, skips to form processing code. Otherwise, reshows form with previously entered fields. I must admit, it's been a while since I've done any PHP and since moving to my new host (running a lot newer version of PHP, with the $_SESSION globals etc...) I'm more than a little confused as to the safest way of going about doing sessions. For form submitted data do I refer to it as $_POST['whatever'] throughout my script or is it acceptable to reassign them to locals at the top of every script? And does the same apply for $_SESSION?
View Replies !
Passing Radio Button Form Data
I am running php as a sapi module on winXP with Apache. I am passing the data from a radio button from one page to another to be processed. For some reason it seems to be passing no data - for example in the 1st page I would have 3 radio buttons in a loop: <input type='radio' name='radio' value="<?php echo $val ?>"> I would then attempt to read the data in page 2 : <?php echo $radio ?> but this comes up empty. I tried using "get" in my form, and although the name/value pair appears in the URL string, it does not pass itself to the $radio variable in the next page. What the??? Does anyone know of any reason why php would NOT allow a radio button (or any other form object) it's data to pass on. I am not using sessions.
View Replies !
Order Form That Needs To Email The Form Data Back
I'm working on an order form that needs to email the form data back to me and a copy to the customer. I've looked all over these forums at other simular posts and I think I have it, I just need to know if I'm on the right track. By way of explaination, my form is dynamically created. The user enters the amount of items they want to order and submit. The next page shows fields for Qty, Part Number and Description. If the user entered 5 on the first page, he'd have 5 rows of fields to fill in. I have the form working where it prints out every thing to the browser. Code:
View Replies !
Syntax For Passing Array Data From Checkboxes In A Form
If I have a list of checkboxes saved in an array,when I submit (POST) the form data, do I need to use $HTTP_POST_VARS in the target document, or can I just use the following code: for ($i = 0; $i < count($selectedmessages); $i++){ $checkbox_value = "$selectedmessages[$i]";} If I need to use $HTTP_POST_VARS, what would the syntax be if my array is called selectedmessages[]?
View Replies !
Trouble Passing Session Data Between 2 Form Pages
Form part 1. Depending on the selection in a field which controls the form action, the user goes to either review-1, or part 2. The review-1 page shows the data from part 1, offers option to return and edit, or submit. All that works fine. Form part 2 (optional) One fills out additional fields, which are all appended to the same session. I know that the session data from part 1 is maintained into form page part 2 because I can display it on that page. However, when one advances to review-2, the part 1 data is gone. That's the problem. Code:
View Replies !
Mysql To Excel And Then Email The Excel Doc
I have a good working code for making a excel doc. on the fly. He send the file to the screen and you can save it directly. But I dont want it to send it to the screen but that he save it on the server and EMAILS it to someone. I'm searching and trying to get it work for 3 days, but no luck. I hope you guys can help me out. This is the code I use the make an excel doc. $select = "SELECT * FROM dagrapport WHERE dagrapportid='$dagrapportid'"; $result = mysql_query($select); $datum = mysql_result($result,0,'datum'); $medewerkernummer = mysql_result($result,0,'medewerkernummer'); $export = mysql_query($select); $fields = mysql_num_fields($export); $kop = ""; $data = ""; for ($i = 0; $i < $fields; $i++) { $kop .= mysql_field_name($export, $i) . " "; } while($row = mysql_fetch_row($export)) { $line = '' foreach($row as $value) { if ((!isset($value)) OR ($value == "")) { $value = " "; } else { $value = str_replace('"', '""', $value); $value = '"' . $value . '"' . " "; } $line .= $value; } $data .= trim($line)." "; } $data = str_replace(" ","",$data); if ($data == "") { $data = " (0) Records Found! "; } header("Content-type: application/x-msexcel"); header("Content-Disposition: attachment; filename=dagrapport-$datum-$medewerkernummer.xls"); header("Pragma: no-cache"); header("Expires: 0"); print "$kop $data";
View Replies !
Dynamically Created Form Rows Not Passing All Data Properly
I use 3 scripts(form, function and process). Developemnt on win2003 server. Final server will be linux Apache,Mysql and PHP is being used. The form displays multiple dynamic rows with chechboxs, input box for units of service, description of the service and each row has its own dropdown list of unit fees that apply. Note The above informaton is coming from a mysql database. When the service is submitted the selected information is displayed to the secreen by the process. Code:
View Replies !
|
TRACKER
