PHP - Csv File Insert Problem

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 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?

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;?>

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

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! 

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 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

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.

Hi

My problem is that I can't insert my information into my database. I was able to insert the information into my database last night but when I tried to use validation it's not working any more.

Here is my code for the sign up
Code: [Select]
<?php
require_once("validation.php");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>yensdesign.com - Validate Forms using PHP and jQuery</title>
<link rel="stylesheet" href="css/general.css" type="text/css" media="screen" />
</head>
<body>
<a id="logo" title="Go to yensdesign.com!" href="http://www.yensdesign.com"><img src="css/images/logo.jpg" alt="yensdesign.com" /></a>
<div id="container">
<h1>Registration process</h1>

<?if( isset($_POST['send']) && (!validateName($_POST['name']) || !validateEmail($_POST['email']) || !validatePasswords($_POST['pass1'], $_POST['pass2']) || !validateMessage($_POST['message']) ) ):?>
<div id="error">
<ul>
<?if(!validateName($_POST['name'])):?>
<li><strong>Invalid Name:</strong> We want names with more than 3 letters!</li>
<?endif?>
<?if(!validateEmail($_POST['email'])):?>
<li><strong>Invalid E-mail:</strong> Stop cowboy! Type a valid e-mail please :P</li>
<?endif?>
<?if(!validatePasswords($_POST['pass1'], $_POST['pass2'])):?>
<li><strong>Passwords are invalid:</strong> Passwords doesn't match or are invalid!</li>
<?endif?>
<?if(!validateMessage($_POST['message'])):?>
<li><strong>Ivalid message:</strong> Type a message with at least with 10 letters</li>
<?endif?>
</ul>
</div>
<?elseif(isset($_POST['send'])):?>
<div id="error" class="valid">
<ul>
<li><strong>Congratulations!</strong> All fields are OK ;)</li>
</ul>
</div>
<?endif?>

<form method="post" id="customForm" action="index.php">
<div>
Name
<input id="name" name="name" type="text" />
<!--<span id="nameInfo">What's your name?</span>-->
</div>
<div>
E-mail
<input id="email" name="email" type="text" />
<!--<span id="emailInfo">Valid E-mail please, you will need it to log in!</span>-->
</div>
<div>
Password
<input id="pass1" name="password" type="password" />
<span id="pass1Info">At least 5 characters: letters, numbers and '_'</span>
</div>
<div>
Confirm Password
<input id="pass2" name="pass2" type="password" />
<span id="pass2Info">Confirm password</span>
</div>
<!--<div>
<label for="message">Message</label>
<textarea id="message" name="message" cols="" rows=""></textarea>
</div>-->
<div>
<input id="send"  type="submit" value="Send" />
</div>
</form>
</div>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="validation.js"></script>
</body>
</html>
<?php

$host="localhost"; // Host name 
$username=""; // Mysql username 
$password=""; // Mysql password 
$db_name="test"; // Database name 
$tbl_name="emails"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// Get values from form 
$name=$_POST['name'];
$email=$_POST['email'];
$password=$_POST['password'];

// Insert data into mysql 
$sql="INSERT INTO $tbl_name(name, email, password)VALUES('$name', '$email', 'password')";
$result=mysql_query($sql);

// if successfully insert data into database, displays message "Successful". 
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='insert.php'>Back to main page</a>";
}

else {
echo "ERROR";
}

// close connection 
mysql_close();
?>

This is the validation.php
Code: [Select]
<?php
function validateName($name){
//if it's NOT valid
if(strlen($name) < 4)
return false;
//if it's valid
else
return true;
}
function validateEmail($email){
return ereg("^[a-zA-Z0-9]+[a-zA-Z0-9_-]+@[a-zA-Z0-9]+[a-zA-Z0-9.-]+[a-zA-Z0-9]+.[a-z]{2,4}$", $email);
}
function validatePasswords($pass1, $pass2) {
//if DOESN'T MATCH
if(strpos($pass1, ' ') !== false)
return false;
//if are valid
return $pass1 == $pass2 && strlen($pass1) > 5;
}
function validateMessage($message){
//if it's NOT valid
if(strlen($message) < 10)
return false;
//if it's valid
else
return true;
}
?>

And this is the validation.js
Code: [Select]
/***************************/
//@Author: Adrian "yEnS" Mato Gondelle & Ivan Guardado Castro
//@website: www.yensdesign.com
//@email: yensamg@gmail.com
//@license: Feel free to use it, but keep this credits please!
/***************************/

$(document).ready(function(){
//global vars
var form = $("#customForm");
var name = $("#name");
var nameInfo = $("#nameInfo");
var email = $("#email");
var emailInfo = $("#emailInfo");
var pass1 = $("#pass1");
var pass1Info = $("#pass1Info");
var pass2 = $("#pass2");
var pass2Info = $("#pass2Info");
var message = $("#message");

//On blur
name.blur(validateName);
email.blur(validateEmail);
pass1.blur(validatePass1);
pass2.blur(validatePass2);
//On key press
name.keyup(validateName);
pass1.keyup(validatePass1);
pass2.keyup(validatePass2);
message.keyup(validateMessage);
//On Submitting
form.submit(function(){
if(validateName() & validateEmail() & validatePass1() & validatePass2() & validateMessage())
return true
else
return false;
});

//validation functions
function validateEmail(){
//testing regular expression
var a = $("#email").val();
var filter = /^[a-zA-Z0-9]+[a-zA-Z0-9_.-]+[a-zA-Z0-9_-]+@[a-zA-Z0-9]+[a-zA-Z0-9.-]+[a-zA-Z0-9]+.[a-z]{2,4}$/;
//if it's valid email
if(filter.test(a)){
email.removeClass("error");
emailInfo.text("Valid E-mail please, you will need it to log in!");
emailInfo.removeClass("error");
return true;
}
//if it's NOT valid
else{
email.addClass("error");
emailInfo.text("Stop cowboy! Type a valid e-mail please :P");
emailInfo.addClass("error");
return false;
}
}
function validateName(){
//if it's NOT valid
if(name.val().length < 4){
name.addClass("error");
nameInfo.text("We want names with more than 3 letters!");
nameInfo.addClass("error");
return false;
}
//if it's valid
else{
name.removeClass("error");
nameInfo.text("What's your name?");
nameInfo.removeClass("error");
return true;
}
}
function validatePass1(){
var a = $("#password1");
var b = $("#password2");

//it's NOT valid
if(pass1.val().length <5){
pass1.addClass("error");
pass1Info.text("Ey! Remember: At least 5 characters: letters, numbers and '_'");
pass1Info.addClass("error");
return false;
}
//it's valid
else{
pass1.removeClass("error");
pass1Info.text("At least 5 characters: letters, numbers and '_'");
pass1Info.removeClass("error");
validatePass2();
return true;
}
}
function validatePass2(){
var a = $("#password1");
var b = $("#password2");
//are NOT valid
if( pass1.val() != pass2.val() ){
pass2.addClass("error");
pass2Info.text("Passwords doesn't match!");
pass2Info.addClass("error");
return false;
}
//are valid
else{
pass2.removeClass("error");
pass2Info.text("Confirm password");
pass2Info.removeClass("error");
return true;
}
}
function validateMessage(){
//it's NOT valid
if(message.val().length < 10){
message.addClass("error");
return false;
}
//it's valid
else{
message.removeClass("error");
return true;
}
}
});

I also get that the name, email and password is undefined

I have an old site written for PHP 5.4 and under and trying (very trying) to get it to work with PHP 7x without much luck. Due to all the changes in 7 my code is one big error message, but one thing at a time. I cannot get the follow code to work at all, even though it worked in PHP 5.

Error:

QUERY ERROR: 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 'viewuser.php?u=666' id='member'>THE PREDATOR [666] was added to the hit' at line 1
The Query was INSERT INTO gangevents VALUES('','20', UNIX_TIMESTAMP(),'THE  PREDATOR [666] was added to the hit list.')

I have tried at least 20+ different ways of doing this but just can't get the right syntax to get it inserted into MySQL, the code below is just the latest version.  If I echo the a href line out, it works perfect. 

I am sure it is something ridiculously simple, but I have been 4 hours and counting on this now.

Thanks

gangevent_add_2($gangdata['gangID'], "<a href='viewuser.php?u=".$r['userid']."' ".$csscode[$r['userlevel']-1].">".$r['username']."</a> [".$r['userid']."] was added to your hitlist");

function gangevent_add_2($gang, $text) { 
	global $db; $csscode; 
	$db->query("UPDATE users SET gangevent = gangevent + 1 WHERE gang={$gang}");
	$db->query("INSERT INTO gangevents VALUES('','$gang', UNIX_TIMESTAMP(),'$text')");
}

 

This php file cant echo in the 2nd php code, can anyone help me about this?
1st php code to connect into the 2nd php code
Code: [Select]
<?php
$Total = $Total + $Amount;
}
?>

</tr>
<tr>
    <td colspan="3" align="Right">Total</td>
    <td align ="Center"><?php echo number_format($Total,2);?></td>
</tr>
2nd php code
Code: [Select]
<?php
$db = mysql_connect("localhost", "root", "");
mysql_select_db("vinnex",$db);
$TransNo = $_POST['TransNo'];
$Username = $_POST['Username'];
$Date = $_POST['Date'];
$Total = $_GET['Total'];
echo $Total;
$sqltransaction = " INSERT INTO transaction (TransNo, Username, Date, Total)
VALUES ('$TransNo', '$Username', '$Date', '$Total')";
$resulttransaction = mysql_query($sqltransaction);
?>

Hey guys for some reason this code is not working i can't see a problem myself could someone please have a look and point the issue out to me. what i mean by it not working is it won't insert into the database or show a mysql_error.

thanks in advance

Code: [Select]
$guestip = $_SERVER['REMOTE_ADDR'];
$time = date('G:i');
$date = date("y-m-d");

$query = mysql_query("SELECT * FROM IP_Address") or die(mysql_error());
while($row = mysql_fetch_assoc($query)){
   
    if($guestip != $row['ip']){
        //insert into db.
        mysql_query("INSERT INTO IP_Address(id, ip, date, time) VALUES(NULL,'$questip','$date','$time')") or die(mysql_error());
        echo "inserted in to database"; echo mysql_error();
    }else{
        // add hit count and update time and date.
        echo "already in db";
    }
}