Jump to content

mcatalf0221

Members
 View Profile  See their activity

  • Posts

    11

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by mcatalf0221

  1. mcatalf0221
    I have a script to upload single files to a mySQL database. Files are assigned consecutive ID numbers, able to be accessed through a respective URL. The use for this script is a page on my website with five links, each of which opens up a file submission window (where one selects which file to submit, hits submit, and the file is added to the database, assigned the next ID number). In addition to the file submission script, I have on a page previous to the file submission one a web form connected to a PHP script that submit results to me via e-mail. My goal is to have the five file URLs (meaning the appropriate IDs based on this "session's" submission) sent out in the same e-mail as my form data. Below are the scripts which I currently have. I am not sure how to go about integrating their two different functions in order to have sent to me a single e-mail with all the form data and file URLs. Form Data Submission PHP - brings you to the file submission page when complete <? session_save_path(http://cindtronix.com/cgi-bin/tmp); session_start(); if ($_POST["vercode"] != $_SESSION["vercode"] OR $_SESSION["vercode"]=='') { echo '<strong>Incorrect verification code. Go back and try again. </strong><br>'; } else { $name=$_POST['name']; $street_address=$_POST['street_address']; $city=$_POST['city']; $state=$_POST['state']; $zip=$_POST['zip']; $email=$_POST['email']; $home_phone=$_POST['home_phone']; $cell_phone=$_POST['cell_phone']; $additional_contact=$_POST['additional_contact']; $dob=$_POST['dob']; $parent=$_POST['parent']; $parent_phone=$_POST['parent_phone']; $emerg_name=$_POST['emerg_name']; $emerg_prim_phone=$_POST['emerg_prim_phone']; $emerg_street_address=$_POST['emerg_street_address']; $emerg_city=$_POST['emerg_city']; $emerg_state=$_POST['emerg_state']; $emerg_zip=$_POST['emerg_zip']; $emerg_additional=$_POST['emerg_additional']; $course=$_POST['course']; $waiver=$_POST['waiver']; $suspension=$_POST['suspension']; $accident=$_POST['accident']; $insurance=$_POST['insurance']; $guilty=$_POST['guilty']; $drivers=$_POST['drivers']; $drugs=$_POST['drugs']; $felony=$_POST['felony']; $certified=$_POST['certified']; $to="EMAILREMOVED"; $message="This is an automated Cindtronix Student Application Submission. ------PERSONAL DATA----- A. NAME $name B. ADDRESS $street_address C. CITY $city D. STATE $state E. ZIP $zip F. E-MAIL $email G. HOME PHONE $home_phone H. CELL PHONE $cell_phone I. ADDITIONAL CONTACT $additional_contact J. DOB $dob -----PARENTS/EMERGENCY CONTACTS----- K. PARENT NAME $parent L. PARENT PHONE $parent_phone M. EMERG NAME $emerg_name N. EMERG PHONE $emerg_prim_phone O. EMERG ADDRESS $emerg_street_address P. EMERG CITY $emerg_city Q. EMERG STATE $emerg_state R. EMERG ZIP $emerg_zip S. EMERG ADDITIONAL $emerg_additional -----COURSE INFORMATION----- T. COURSE SELECTION $course U. OTHER INFO $other V. WAIVER ($waiver) SUSPENSION($suspension) ACCIDENT($accident) INSURANCE($insurance) GUILTY($guilty) DRIVERS($drivers) DRUGS($drugs) FELONY($felony) ---------------------------- *** CONFIRMATION of ACCURACY: $certified FILE SUBMISSIONS 1) COVER LETTER http://www.cindtronix.com/getpicture.php?fid=0 2) EDUCATIONAL TRANSCRIPTS http://www.cindtronix.com/getpicture.php?fid=1 3) PHOTO(S) http://www.cindtronix.com/getpicture.php?fid=2 4) PASSPORT http://www.cindtronix.com/getpicture.php?fid=3 5) FINANCIAL SUPPORT http://www.cindtronix.com/getpicture.php?fid=4 6) OPTIONAL SUPPLEMENTS http://www.cindtronix.com/getpicture.php?fid=5 *** IMPORTANT *** After files have been successfully downloaded, please use the following links to delete them from the database! http://www.cindtronix.com/remove.php?fid=0 http://www.cindtronix.com/remove.php?fid=1 http://www.cindtronix.com/remove.php?fid=2 http://www.cindtronix.com/remove.php?fid=3 http://www.cindtronix.com/remove.php?fid=4 http://www.cindtronix.com/remove.php?fid=5 --- END OF APPLICATION ---"; if(mail($to,"CINDTRONIX ELECTRONIC STUDENT APPLICATION SUBMISSION",$message,"From:$email\n")){ echo(" <html> <head> <title>Cindtronix Aviation - Online Student Application Document Submission</title> <link rel=\"stylesheet\" type=\"text/css\" href=\"style.css\"> <link rel=\"stylesheet\" type=\"text/css\" href=\"spiffy.css\"> <link rel=\"stylesheet\" type=\"text/css\" href=\"menu.css\"> <script type=\"text/javascript\" src=\"js/animatedcollapse.js\"></script> <script type=\"text/javascript\" src=\"js/slide1.js\"></script> <script type=\"text/javascript\" src=\"drop_down.js\"></script> <SCRIPT LANGUAGE=\"JavaScript\"> <!-- Begin function popUp(URL) { day = new Date(); id = day.getTime(); eval(\"page\" + id + \" = window.open(URL, '\" + id + \"', 'toolbar=0,scrollbars=0,loc ation=0,statusbar=0,menubar=0,resizable=0,width=500,height=500');\"); } // End --> </script> </head> <body> <div id=\"logo\"> <img src=\"logo.jpg\" width=\"898\"> </div> <table class=\"table_middle\" cellspacing=\"0\" cellpadding=\"0\"> <tr> <td width=\"153\" bgcolor=\"#9E9E9E\" valign=\"top\"> <!--Filler--> </td> <td bgcolor=\"#9E9E9E\" width=\"40\"> <!--Filler--> </td> <td class=\"login\" width=\"728\" bgcolor=\"#9E9E9E\"> <p align=\"right\"> <a href=\"http://s08.myfbo.com/link.asp?fbo=cina\"><font color=\"#000000\">Student Login</font></a>&nbsp </p> </td> </tr> </table> <div id=\"container\"><div id=\"menu\"> <ul id=\"nav\"> <li><a href=\"index.php\">Home</a></li> <li><a href=\"news.html\">What's New?</a></li> <li><a href=\"discover.html\">Discover Flying!</a></li> <li><a href=\"flight_training.html\">Flight Training</a> <ul> <li><a href=\"discover.html\">Discovery Flights</a></li> <li><a href=\"cpc.html\">Why Cindtronix?</a></li> <li><a href=\"cbi.html\">Computer Based Instruction (CBI)</a></li> <li><a href=\"ppl.html\">Private Pilot License</a></li> <li><a href=\"advanced.html\">Advanced Ratings</a></li> <li><a href=\"accir.html\">12 Day Instrument Rating Course</a></li> <li><a href=\"faq.html\">Frequently Asked Questions</a></li> <li><a href=\"financing.html\">Financing Options</a></li> </ul> </li> <li><a href=\"fleet.html\">Aircraft</a> <ul> <li><a href=\"fleet.html\">The Cindtronix Fleet</a></li> <li><a href=\"g1000.html\">G1000 Equipped</a></li> <li><a href=\"http://skyhawksp.cessna.com/\">Cessna Skyhawk (C172)</a></li> <li><a href=\"http://skylane.cessna.com/\">Cessna Skylane (C182)</a></li> <li><a href=\"http://www.cessnaskycatcher.com/\">Cessna Skycatcher (C162)</a></li> <li><a href=\"http://www.newpiper.com/aircraft/arrow/\">Piper Arrow (PA-28RR)</a></li> <li><a href=\"http://www.newpiper.com/aircraft/seminole/\">Piper Seminole (PA-44)</a></li> </ul> </li> <li><a href=\"services.html\">Other Services</a></li> <li><a href=\"team.html\">Our Team</a></li> <li><a href=\"oqu.html\">Quonset Airport</a></li> <li><a href=\"rentals.html\">Aircraft Rentals</a></li> <li><a href=\"degree.html\">Degree Program</a></li> <li><a href=\"pilots.php\">Online Pilot Center</a></li> <li><a href=\"shop.html\">Pilot Shop</a></li> <li><a href=\"giftcert.html\">Gift Certificates</a></li> <li><a href=\"http://s08.myfbo.com/link.asp?fbo=cina\">Online Scheduling</a></li> <li><a href=\"contact.html\">Contact Us</a></li> </ul> </div> <div id=\"address\"> <center><font size=\"1\"> 210 Airport Street<br> N. Kingstown, RI 02852<br> <b>(401) 667-7580<br> (401) 644-6610</b> </font> </center> </div> <div id=\"table_main_subpage\"> <h1>Online Student Application</h1> <h2 class=\"discover\">Part II - Document Submission</h2> <div id=\"text\"> Please upload each of the following documents in .DOC, .TXT, .PDF, or .JPG format. If you are unable to scan/submit the required documents, please call to notify us and mail them to the following address: <i>210 Airport Street, North Kingstown, RI 02852</i> <table class=\"table_text\"> <tr> <td>A cover letter explaining why you want to become a pilot:</td> <td> <a href=\"javascript:popUp('upload.html')\">Upload</a><br> </td> </tr> <tr> <td>Scans of your educational transcripts:</td> <td> <a href=\"javascript:popUp('upload.html')\">Upload</a><br> </td> </tr> <tr> <td>Color photo of yourself:</td> <td> <a href=\"javascript:popUp('upload.html')\">Upload</a><br> </td> </tr> <tr> <td>Relevant pages of your passport:</td> <td> <a href=\"javascript:popUp('upload.html')\">Upload</a><br> </td> </tr> <tr> <td>Evidence of your financial support:</td> <td> <a href=\"javascript:popUp('upload.html')\">Upload</a><br> </td> </tr> <tr> <td>Supplementary material (optional):</td> <td> <a href=\"javascript:popUp('upload.html')\">Upload</a><br> </td> </tr> </table> </div> <div id=\"text\">Once you have finished uploading all files, you may exit this page. We will begin reviewing your application immediately and we will be in contact with you soon!</div> <div id=\"copyright1\"> <center> <b>&#169 2008 - Cindtronix Aviation</b><br> 210 Airport Street &#124; N. Kingstown, RI 02852 &#124; (401) 667-7580 </center> </div> </div> <script src=\"http://www.google-analytics.com/urchin.js\" type=\"text/javascript\"> </script> <script type=\"text/javascript\"> _uacct = \"UA-3281044-1\"; urchinTracker(); </script> </div></body> </html> "); }else{ echo "There was a problem sending the form. Please go back to check that you filled it in completely and correctly."; } }; ?> File Upload Script <?php // if something was posted, start the process... if(isset($_POST['upload'])) { // define the posted file into variables $name = $_FILES['picture']['name']; $tmp_name = $_FILES['picture']['tmp_name']; $type = $_FILES['picture']['type']; $size = $_FILES['picture']['size']; // get the width & height of the file (we don't need the other stuff) list($width, $height, $typeb, $attr) = getimagesize($tmp_name); // if the mime type is anything other than what we specify below, kill it if(!( $type=='application/pdf' || $type=='text/plain' || $type=='application/msword' || $type=='image/jpeg' || $type=='image/png' || $type=='image/gif' )) { echo $type . " is not an acceptable format."; echo ?> <a href="form.html">Click here</a> to try again. <? ; die(); } // if the file size is larger than 350 KB, kill it if($size>'350000') { echo $name . " is over 350KB. Please make it smaller."; echo ?> <a href="form.html">Click here</a> to try again. <? ; die(); } // if your server has magic quotes turned off, add slashes manually if(!get_magic_quotes_gpc()){ $name = addslashes($name); } // open up the file and extract the data/content from it $extract = fopen($tmp_name, 'r'); $content = fread($extract, $size); $content = addslashes($content); fclose($extract); // connect to the database include "connect.php"; // the query that will add this to the database $addfile = "INSERT INTO files (name, size, type, content ) ". "VALUES ('$name', '$size', '$type', '$content')"; mysql_query($addfile) or die(mysql_error()); // get the last inserted ID if we're going to display this image next $inserted_fid = mysql_insert_id(); mysql_close(); echo "Successfully uploaded your file!"; // we still have to close the original IF statement. If there was nothing posted, kill the page. }else{die("No uploaded file present"); } ?> Picture Retrieval PHP <? if(isset($_GET['fid'])) { // connect to the database include "connect.php"; // query the server for the picture $fid = $_GET['fid']; $query = "SELECT * FROM files WHERE fid = '$fid'"; $result = mysql_query($query) or die(mysql_error()); // define results into variables $name=mysql_result($result,0,"name"); $size=mysql_result($result,0,"size"); $type=mysql_result($result,0,"type"); $content=mysql_result($result,0,"content"); // give our picture the proper headers...otherwise our page will be confused header("Content-Disposition: attachment; filename=$name"); header("Content-length: $size"); header("Content-type: $type"); echo $content; mysql_close(); }else{ die("No file ID given..."); } ?> If it sounds like I'm going about this in the wrong way, please let me know. It's simply my intent to create a type of "application" form that allows for submission of scanned documents, and notifies the company of a new submission and allows for a way to access the data. Thank you! - mcatalf0221
  2. mcatalf0221
    Line 19: $metar .= ' ' . trim($line); Yes, that second line is exactly what I'm looking for.
  3. mcatalf0221
    Awesome! Looks like I'm getting closer. Here's what I have now: Notice: Undefined variable: metar in /hermes/web09/b870/as.cindtron/public_html/metar.php on line 19 KOQU 301750Z 08003KT 6SM BR BKN005 OVC015 23/ A3005
  4. mcatalf0221
    My page now says "cURL enabled!" only.
  5. mcatalf0221
    Thanks DarkWater. How should I use this cURL on my server? I'm completely unfamiliar with the term.
  6. mcatalf0221
    Thanks PFMaBiSmAd ... here are the errors: I'm not sure how to interpret these. Any diagnosis would be much appreciated.
  7. mcatalf0221
    Done. Not seeing any error reporting on my page, however.
  8. mcatalf0221
    Hello, Some months ago you guys assisted me in a PHP script that would take a text file, trim up the formatting, and echo it on my page. The following is the code: <?php $station = 'KOQU'; $metar = get_metar($station); function get_metar($station) { $fileName = "http://weather.noaa.gov/pub/data/observations/metar/stations/$station.TXT"; $metar = ''; $fileData = @file($fileName); // or die('Data not available'); if ($fileData != false) { list($i, $date) = each($fileData); $utc = strtotime(trim($date)); while (list($i, $line) = each($fileData)) { $metar .= ' ' . trim($line); } $metar = trim(str_replace(' ', ' ', $metar)); } return $metar; } ?> <html> <body> <?php echo $metar; ?> </body> </html> The problem is that the script works on local servers (Abyss, etc.), but when I upload it to my website, the output of the weather report is blank (i.e. http://cindtronix.com/metar.php). I've researched this via search and have tried checking the character encoding, PHP version, etc. -- without luck. Is a problem with the code itself causing this to occur? Thank you! mcatalf0221
  9. mcatalf0221
    Thanks Ken, but no luck on that one. I tried the following: Not sure if that's correct, but the metar is a variable itself because it is taken from that NOAA site which is updated frequently. So, I tried equating the $metar with your $str. Any ideas?
  10. mcatalf0221
    Actually, looking at the URL where the original data comes from, it appears there are already line breaks (see http://weather.noaa.gov/pub/data/forecasts/taf/stations/KPVD.TXT). Is there something in my code that is not recognizing this? Thanks for any help, I'm very new to PHP for this type of application.
  11. mcatalf0221
    I am using PHP to import a long string of data. The output of this PHP is as follows: I need to insert a line break before any "FM####" or "TEMPO" occurrence. What code can be used to accomplish this? Thank you! mcatalf0221
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.