PHP - Where To Insert Wordwrap In Php File

 Thanks ahead of time, I have been working this all week end but get lost....
    a.  I want to insert all the lines from file1.txt into file2.txt .
    b.  I want the all lines in file1.txt to be inserted in file2.txt starting at "<image>"   tag label in file2.txt.
    c. I would like to overwrite all lines that start with the "<image>" tag in file2.txt with the insert (text in file1.txt contains <image> tag also).
 
 file2.txt has lines above  and below the insert point <image>.   The insert text (file1.txt) could be as many as twenty lines (records) all/each beginning with the<image>tag.
Here is what I have done so far.
<?
$key = '<image>';  //a text tag in $file1  and $file2

//copy file 
$file = "file1.txt";
$file2= 'file2.txt";
$newfile = "filetemp.txt";
copy($file, $newfile) or exit("could not copy $file");

//load file array
 $fc = fopen ($file, "r");
 while (!feof ($fc)) 
 {
    $buffer = fgets($fc, 4096);
    $lines[] = $buffer;
 }

fclose ($fc);

//open same file and use "w" to clear file  ,not sure this is needed
$f=fopen($newfile,"w") or die("$file did not open");

/* uncomment to debug
print_r($lines);
print "<br>\n";
*/

//loop through array 'foreach
foreach($lines as $line)
{
       fwrite($f,$line); //rewrite $line in file     
    if (strstr($line,$key)){ //find $key in each line
    fwrite($f,$newline."\n");
    } //rewrite $line in file 
}
fclose($f);

copy($newfile, $file2) or exit("could not copy $newfile");
?>


Again thanks ahead of time,  I just keep losing the flow,  old I guess.

Tom

<?php require_once("../includes/session.php");?>
<?php require_once("../includes/connection.php");?>
<?php require_once("../includes/function.php");?>
<?php confirm_logged_in();?>
<?php require_once("../includes/validation_functions.php");?>

<?php
if(isset($_POST['submit'])){

    //process the form
    // often there are form values in $_POST



        $product_name = mysql_prep($_POST["product_name"]);
        $product_amount = (int) $_POST["product_amount"];
        $visible = (int) $_POST["visible"];
    foreach($_FILES['files']['tmp_name'] as $key => $tmp_name ){
        $file_tmp =$_FILES['files']['tmp_name'][$key];
        $uploaded_dir = "images/"; 
        $filename = $_FILES['files']['name'][$key];
        $path = $uploaded_dir . $filename; 
        move_uploaded_file($file_tmp,"images/".$_FILES['files']['name'][$key]);

        $query  ="INSERT INTO products (";
        $query .=" name, amount, visible";
        $query .=") VALUES (";
        $query .=" '{$product_name}',{$product_amount},{$visible}";
        $query .=")";
        $result = mysqli_query($connection,$query);
        $last_id = mysqli_insert_id($connection);
        $sql.= "('$last_id','$path'),";
        $sql ="INSERT INTO images ( productID, file_name ) VALUES". trim($sql,',');
        $results = mysqli_query($connection,$sql);


        // validations
        $required_fields = array("product_name", "product_amount");
        validate_presences($required_fields);
        $fields_with_max_lenghts = array("product_name" => 30);
        validate_max_lenght($fields_with_max_lenghts);

        if(!empty($errors)){
            $_SESSION["errors"] = $errors;
            redirect_to("new_product.php");
        }
        if($result && $results ){
            // Sucess

            $_SESSION["message"] = "Product inserted.";
            redirect_to("manage_content.php");
        }else{
            // Failure

            $_SESSION["message"] = "Product insertion Failed.";
            redirect_to("new_product.php");
            }
        }
}else{
    // THis is probably a GET request
    redirect_to("new_product.php");
}
?>
<?php
if(isset($connnection)){
mysqli_close($connection);
}
?>

Attached Files  new_product.php   1.35KB   0 downloads  create_product.php   1.99KB   0 downloads

Hi,

I am trying to insert the contents of a csv file into a table, this is my code:


public function InsertCSVFileToDB(){

$has_title_row = true;
$not_done = array();

        if(is_uploaded_file($_FILES['csvfile']['tmp_name'])){
            $filename = basename($_FILES['csvfile']['name']);

            if(substr($filename, -3) == 'csv'){
                $tmpfile = $_FILES['csvfile']['tmp_name'];
                if (($fh = fopen($tmpfile, "r")) !== FALSE) {
                    $i = 0;
                    while (($items = fgetcsv($fh, 10000, ",")) !== FALSE) {

                        if($has_title_row === true && $i == 0){ // skip the first row if there is a tile row in CSV file
                            $i++;
                            continue;
                        }

                        $sql = "INSERT INTO ConfPaper SET
                                CPRid = ".$items[0].",
                                Pid = ".$items[1].",
                                CPtitle = '".mysql_real_escape_string($items[2])."',
                                CPabstract = '".mysql_real_escape_string($items[3])."',
                                CPspage = ".mysql_real_escape_string($items[4]).",
                                CPepage = ".mysql_real_escape_string($items[5]).",
                                CPlastesited = now()";
                        if(!mysql_query($sql)){
                            $not_done[] = $items;
                        }
                        $i++;
                    }
                }
                // if there are any not done records found:
                if(!empty($not_done)){
                    echo "<strong>There are some records could not be inserted</strong><br />";
                    print_r($not_done);
                }
            }
            else{
                die('Invalid file format uploaded. Please upload CSV.');
            }
        }
        else{
            die('Please upload a CSV file.');
        }
    }


This is the csv file:

http://www.prima.cse.salford.ac.uk:8080/~ibrarhussain/ConfPaper.csv

But i keep getting this:

Quote

Array ( => Array ( => 9 [1] => 1 [2] => CSV1 [3] => 4 [4] => 4 [5] => 01625 584412 ) [1] => Array ( => 9 [1] => 1 [2] => CSV2 [3] => 14 [4] => 24 [5] => 01625 584412 ) )

Any ideas what the problem might be?

Hope someone can help..

Thanks

Hello,
i have this php code. Its for sms insertion of links in to table
<table border="1">
<?PHP

$db_user = 'user';
$db_pass = 'pass';
$db_name = 'name';
$db_host = 'localhost';
if(mysql_connect($db_host,$db_user,$db_pass)) {

mysql_select_db($db_name);

mysql_query("CREATE TABLE IF NOT EXISTS smsads(id bigint unsigned primary key auto_increment, link varchar(255), fromnum varchar(60))");

$res = mysql_query("SELECT * FROM smsads ORDER BY id DESC LIMIT 10");

while($row = mysql_fetch_object($res)) {

$http_link = $row->link;

if(strstr($http_link, 'http') === FALSE) $http_link = 'http://'.$http_link;

echo "<tr><td><a href=\"{$http_link}\" target=\"_blank\">{$row->link}</a></td></tr>";

}
}
?>
</table>

The problem is that i use tpl files for the visual part and all my other tables are in tpl. How can i insert the table above in my tpl file, whitout loosing its functions?

I set up a Twilio number so a client could have a SMS keyword response setup... but I don't know how to get the contents of a file to be returned as the response. I am using the php functions..

I setup a system so that my client could change the responses to different keywords. Basicly it uses a webform to change the contents of a file which gets returned as a response.

What I need to know is how to read in the contents of the file into this function:

BTW... this works fine and will return "READ_FILE_CONTENTS_INTO_HERE"

function app(){
$response = new Services_Twilio_Twiml();
$response->sms("READ_FILE_CONTENTS_INTO_HERE");
echo $response;
}

I tried this but it stopped the script dead:

function app(){
$response = new Services_Twilio_Twiml();
$response->sms("<?php include 'file.txt'; ?>");
echo $response;
}

Any ideas?

Thanks

BTW... below is the entire php script:


<?php
/* Include twilio-php, the official Twilio PHP Helper Library,
* which can be found at
* http://www.twilio.com/docs/libraries
*/
include('Services/Twilio.php');
/* Controller: Match the keyword with the customized SMS reply. */
function index(){
$response = new Services_Twilio_Twiml();
$response->sms("Thank You For Contacting SweetLeafAZ.com - Reply with one of the following keywords:
APP = Make Appt, CS = Current Strains, DP = Delivery Prices, SP = Current Specials.");
echo $response;
}
function app(){
$response = new Services_Twilio_Twiml();
$response->sms("http://www.vcita.com...01f2c7d/home");
echo $response;
}


function cs(){
$response = new Services_Twilio_Twiml();
$response->sms("http://mobile.dudamo...sweetleafaz2");
echo $response;
}


function dp(){
$response = new Services_Twilio_Twiml();
$response->sms("As of Sept 26 2014, Our Delivery Rates are $2 per mile during the hours of 9am to 6pm. No deliveries will be made after 6pm.");
echo $response;
}

function sp(){
$response = new Services_Twilio_Twiml();
$response->sms("We are currently offering FREE delivery within 10 miles for orders over $100.");
echo $response;
}



/* Read the contents of the 'Body' field of the Request. */
$body = $_REQUEST['Body'];
/* Remove formatting from $body until it is just lowercase
characters without punctuation or spaces. */
$result = preg_replace("/[^A-Za-z0-9]/u", " ", $body);
$result = trim($result);
$result = strtolower($result);
/* Router: Match the ‘Body’ field with index of keywords */
switch ($result) {
case 'app’':
app();
break;
case 'cs':
cs();
break;
case 'dp':
dp();
break;
case 'sp':
sp();
break;
/* Optional: Add new routing logic above this line. */
default:
index();
}

im doing smting basically wrong

Code: [Select]
<form action="" method="post">
<?php  
$x=1;
$images = $_GET['images'];
for( $i=0; $i<$images; $i++ )
{
   echo '<input name="ID" type="hidden" value="1234" />
<br>
<input name="ImageURL['.$i.']" type="file"  value=""/><br><br>';
}

?>
 
<input name="submit" type="submit" />




<?php
$con = mysql_connect("localhost","root","root");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_query("SET NAMES 'utf8'");
mysql_select_db("international", $con);

if (isset($_POST['submit']))
for( $i=0; $i<$images; $i++ )
{
$query=mysql_query("INSERT INTO images (ID,ImageURL) VALUES ('$_POST[ID]','$_POST[ImageURL]')");

exit;



mysql_close($con);
 } 
 
 ?></form>

Hello,

I'm having some frustrations right now. I have built an application form where an applicant inputs their info and then uploads their resume. Even though the resume gets uploaded to a directory on the server i would also like the file name of the resume to get inserted into the mysql database so that I can easily see which resume matches which applicant...if that makes sense. At any rate I'm able to get everything else to work, the applicant's info gets inserted into the database, the resume gets uploaded to the directory, i just can't seem to get the resume file name to also insert into the database.

Most of the info i have found on this subject through googleing and the like has been a little over my head and/or a little more complex than what i'm looking for. Here is an extremely simplified version of what I have right now. I have excluded the 'connect to database' code since it's working fine and really doesn't have anything to do with this issue:
Code: [Select]
<?php 
$target_path = "docs/";
$target_path = $target_path . basename( $_FILES['resume']['name']);
$first_name=$_POST['first_name'];  
$last_name=$_POST['last_name'];  
$middle_init=$_POST['middle_init'];
$resume=$_POST['resume']; 

mysql_query("INSERT INTO `intern` VALUES ('$first_name', '$last_name', '$middle_init',  '$resume')") ;

if (move_uploaded_file($_FILES['resume']['tmp_name'], $target_path));

?>
HTML begins after that.

At any rate, any info, help, etc. you could provide would be GREATLY appreciated!

Thanks! 

Code I'm using


if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 20000))
  {
  if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
    }
  else
    {
    echo "Successfully uploaded image!";
    if (file_exists("img/" . $_FILES["file"]["name"]))
      {
      echo $_FILES["file"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "img/" . $_FILES["file"]["name"]);
      
      echo "<a href='img/$filename'>Your File</a>;
      }
    }
  }
else
  {
  echo "Invalid file";
  }
mysql_query("INSERT INTO $tbl (body, name, subject, ip, timestamp, img) VALUES ('$body', '$name', '$subject', '$ip', '$timestamp', '$imglink')");
mysql_query("INSERT INTO total (ip, subject, name, board) VALUES ('$ip','$subject','$name','$dfg')");
echo "<font color='red'><font size='15'><strong><center>Successfully posted to /$tbl/";
//print("<meta http-equiv='REFRESH' content='0;url=index.php?board=$tbl'>");

If I have the query on the top it runs, and the upload img doesn't
&& vice versa

im working on my website and im trying to insert text from a file into the webpage.

the webpage is
index.php

the .txt file is
indexbody.txt

at the point of where the code is i would like to insert the contents of the text file into the html document so the person viewing the site can read it as if it was directly in that webpage.
i hope you understand what im asking

the current not working code is:
<?php $myFile = "indexbody.txt";
$fh = fopen($myFile, 'r');
$theData = fread($fh, 5);
fclose($fh);
echo $theData;?>

I'm trying to create a INSERT query statement that makes use of the content of 'include' files. When I call up the include it simply echos it to the screen but I can't seem to capture the text string and actually make it function as part of the query. I've tried setting the include as a variable but again it only outputs to the screen. Help please! Here's a portion of the code...

if (($_POST['sched_templates']) == "sched_TestingOnly.htm") {
   $query = include 'sched_TestingOnlyQuery1.htm';   
   }
      if (@mysql_query ($query)) {
         mysql_close(); // End adding Registration to the database
         header ('Location: redirectfile.htm');
         exit();
      } else {
      print "<p><b>Sorry, your entry could not be entered.
      }

Hi..,
My code is like:
Code: [Select]
<?php
$filename ="excelreport.xls";
print "<table border=1>";
print "<tr ><td valign=bottom><img src=http://abc/images/big.png ></img></td>
<td valign=bottom><img src=http://abc/images/small.png ></img></td>
</tr>";
print "</table>";

header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename='.$filename);

?>when I open the excel file, the images alignment is from top to bottom(equal from top of image).
what i want is from bottom to top(equal from bottom of image).

i did try using valign in td property, but still the images equal from top of image

thanks for any reply/ help

i need to upload files to a different folder dependint on option in form, make thumbnails, and store title and src for image and thumb in database table dependant on category. i think i'm pretty close, but there's still something wrong.

Here is my upload form :

Code: [Select]
<form enctype="multipart/form-data" action="upload.php" method="POST">
 Photo: <input type="file" name="photo"><br>
 Category: <select name="cat">
<option value="weddings">Weddings</option>
<option value="music">Music</option>
<option value="portraits">Portraits</option></select>
Title: <input type="text" name="title"><br>
 <input type="submit" value="Upload photo">
 </form>
form processed by upload.php :
Code: [Select]
<?php 
 
 require "db.php";
 
 //Get form info 
 $name=$_POST['name']; 
 $title=$_POST['title']; 
 $category=$_POST['cat']; 
 $pic=($_FILES['photo']['name']); 
 //set target dir source file width height
 $target = $cat."/"; 
 $src = $target . basename( $_FILES['photo']['name']); 
 $destination = $cat."/thumbs";
 $thumbsrc = $destination . basename( $_FILES['photo']['name']); 
 $width = 200;
 $height = 200;
    header("content-type: image/jpeg");
    $src_img = imagecreatefromjpeg("$src");
    $srcsize = getimagesize("$dest");
    $dst_img = imagecreatetruecolor($width, $height);

    imagecopyresampled($dst_img, $src_img, 0, 0, 0, 0, $width, $height, $srcsize[0], $srcsize[1]);
    imagejpeg($dst_img);
    
 //Unstert into db
 mysql_query("INSERT INTO `$category` VALUES ('$name', 'Stitle', '$src, $thumbsrc')") ; 
 
 //move photo 
 if(move_uploaded_file($_FILES['photo']['tmp_name'], $fulltarget)) 
 { 
 //Ok 
 echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; 
 } 
 else { 
 
 //not ok 
 echo "Sorry, there was a problem uploading your file."; 
 } 
 ?>

call a script from main page
Code: [Select]
<div class="gallery">
 <?php include "weddings/get.php" ?>
 </div>
 <div class="gallery">
 <?php include "music/get.php" ?>
 </div>

get.php displays links

Code: [Select]
<?php
include "db.php"; 
$cat = weddings;
$q = "SELECT id, title, src, thumbsrc FROM $cat";

$result = $mysqli->query($q) or die(mysqli_error($mysqli));

if ($result) {
    
    echo "<ul id='photos'> \n";
    
    while ($row = $result->fetch_object()) {
   
        $title = $row->title;
        $src = $row->src;
        $thsrc = $row->thumbsrc;
        $id = $row->id;
        
        echo "<a href='$src' class="lightbox" rel="$cat" title="$name - $title"><img src='$thsrc' id='$id'      alt='$name' /></a>":
        }    
        
        echo "</ul>";
    

    
}



?>   
I think i'm going along the right sort of path, but i'm not sure.

I am very new to PHP and haven't wriiten an update program except in the class I took about 4 years ago using MYSQL. The company I work for is using PDO so I am having a little bit of a learning curve.   I have a table with a checkbox at the end and I want to insert the records from the table into a new file I created called OPPSHEDT SHEDORD           Order Number         14 Char SHEDBORD         BackOrder Number   2 Char SHEDPKD            Picked Cases            9,0 Decimal SHEDSHP            Shipped Cases          9,0 Decimal    I'm just not sure how to write the update program to read the array of records and run through the loop and insert the items checked. I saw some other examples on here and all over the internet but they were using mysql. I have a copy of the code to create my table below.   I'd appreciate the help if you can.   Thanks.    ShipEstimate.php   6.41KB   4 downloads

Can anyone tell me why this is not INSERTing? My array data is coming out just fine.. I've tried everything I can think of and cannot get anything to insert.. Ahhhh!

<?php
  $query = "SELECT RegionID, City FROM geo_cities WHERE RegionID='135'";
  $results = mysqli_query($cxn, $query);
  $row_cnt = mysqli_num_rows($results);
  echo $row_cnt . " Total Records in Query.<br /><br />";
  if (mysqli_num_rows($results)) {
      while ($row = mysqli_fetch_array($results)) {
          $insert_city_query = "INSERT INTO all_illinois SET state_id=$row[RegionID], city_name=$row[City] WHERE id = null" or mysqli_error();
          $insert = mysqli_query($cxn, $insert_city_query);
          if (!$insert) {
              echo "INSERT is NOT working!";
              exit();
          }
          
          echo $row['City'] . "<br />";
          
          echo "<pre>";
          echo print_r($row);
          echo "</pre>";
      }
      //while ($rows = mysqli_fetch_array($results))
      
      } //if (mysqli_num_rows($results))
      
      else {
          echo "No results to get!";
      }
?>

Here is my all_illinois INSERT table structu

CREATE TABLE IF NOT EXISTS `all_illinois` (
  `state_id` varchar(255) NOT NULL,
  `city_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Here is my source table geo_cities structu

CREATE TABLE IF NOT EXISTS `1` (
  `CityId` varchar(255) NOT NULL,
  `CountryID` varchar(255) NOT NULL,
  `RegionID` varchar(255) NOT NULL,
  `City` varchar(255) NOT NULL,
  `Latitude` varchar(255) NOT NULL,
  `Longitude` varchar(255) NOT NULL,
  `TimeZone` varchar(255) NOT NULL,
  `DmaId` varchar(255) NOT NULL,
  `Code` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

I'm missing something here. I have a form, and when the submit is pressed, the relevant post data inserts into table one, then I want the last insert id to insert along with other form data into a second table. The first table's still inserting fine, but I can't get that second one to do anything. It leapfrogs over the query and doesn't give an error. EDIT: I forgot to add an error: I get: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'usage, why VALUES ('14', '', '123', '','1234', '', '')' at line 1

query:INSERT INTO tbl_donar (donar_fname, donar_name, donar_address, donar_address2, donar_city, donar_state, donar_zip, donar_email, donar_phone, donar_fax, donar_company) VALUES ('test 14', 'asdfa', 'asdf', 'adf','asdf', '', '', '', '123', '', '')


Code: [Select]
if (empty($errors)) {

require_once ('dbconnectionfile.php');

$query = "INSERT INTO tbl_donar (donar_fname, donar_name, donar_address, donar_address2, donar_city, donar_state, donar_zip, donar_email, donar_phone, donar_fax, donar_company)
 VALUES ('$description12', '$sn', '$description4', '$cne','$description5', '$description6', '$description7', '$description8',
'$description9', '$description10', '$description11')";

$result = @mysql_query ($query);


if ($result) {

$who_donated=mysql_insert_id();

$query2 = "INSERT INTO tbl_donation (donor_id, donor_expyear, donor_cvv, donor_cardtype, donor_authorization, amount, usage, why)
 VALUES ('$who_donated', '$donate2', '$donate3', '$donate4','$donate5', '$donate6', '$donate7')";
$result2 = @mysql_query ($query2);

if ($result2) {echo "Info was added to both tables! yay!";}

echo "table one filled. Table two was not.";
echo $who_donated;

//header ("Location: http://www.twigzy.com/add_plant.php?var1=$plant_id");

exit();
} else {
echo 'system error. No donation added';