PHP - Problem With Linebreaks When Using Textarea And Mysql

Hi Guys,

I have a textarea on a html page with XXX amount of lines.

How can I in php insert a separate mysqlrow for EACH line on the html textarea?

Thanks
G

has just solved it, can be deleted.

Hia,

I'm having a form, containing an image upload, a textarea and some other fields.

I have a fileupload, where I check if the upload thingy is empty, with
Code: [Select]
if(empty($_POST['image']))
{
    echo "Error";
}
else
{
    //Do the imageUpload here
}

using the empty, isn't working for some reason, it proceed to the else anyway.

Also, I have a textarea with name="productDesc", when I do:
Code: [Select]
<?php
 var_dump($_POST);
?>

It doesn't return the textarea, and I can't see why it doesn't.
Also the textarea proceed to the 'else' in the if else in the following code:

http://codepad.org/wMd6SnoK

Having a lot of questions these days 

Thank you guys!

I have a form that generates html code, and displays it in a textarea with submit button.

I want to submit button to take the data entered in that textarea1 on page 1, and upload to textarea2 on page 2
How can I do this? I have no idea where to start.

This is driving me mad. I've looked in my books and on the Internet but I cannot find the answer.

I have a form with a textarea and I need to retain the linebreaks. Obviously, before I send the data to MySQL, I run it through mysqli_real_escape_string and the result is:
(In form)
"Foo"
Bar
(In phpMyAdmin)
\"Foo\"\r\nBar

When I extract the data from MySQL, I use stripslashes($var) to get the quote back and end up with:
"Foo"rnBar

The problem I am having is changing the \r\n or rn to newlines so that it looks correct in the form. I have tried using nl2br before stripslashes. Even tried using str_replace to change the /r/n to <br /> but I just end up with
"Foo"<br />Bar
in the textarea box.

There must be some simple thing that's causing the problem or people wouldn't be using textareas. Help!

i could connect to the database and i dod nothing but to go through privileges in phpmyadmin by selecting privileges of the data base i design and by using the icon (action) it gave me a page to edit user i selected all check boxes mentioned in the global privileges then pressed go and for resource limits i read a note that said  setting these options to zero removes the limit
i set then to 1
and by using the connection function i could connect to the data base

Code: [Select]
<?php
$connectdb = mysql_connect('localhost','root','') or die("not connected");
$selectdb = mysql_select_db("koora", $connectdb);

if($selectdb)
{

echo "ok you,re now connected to table   ";
}else die("couldn,t connect to the database");
when refreshing my page it showed a message that said 
ok you,re now connected to table

but i got another problem which is by using this form 


<form action="admins.php" method='post'>
<table align="center" valign="center">
<tr>
<td>
Admin,s name: </td>
<td><input type="text" name="adminname" /><br /></td></tr>
<td>Admin,s Password: </td>
<td><input type="password" name="adminpassword" /></td></tr>
<td><input type="submit" value="Add New Admin" /></td></tr>

</form> 
</tr>
</table> to enter user name and password and by using the following code to get the data to the page the form directs to 

$admin = $_POST['adminname'];    
$password = $_POST['adminpassword'];   

if($admin&&$password){
   
mysql_query("INSERT INTO 'admin'('','admin','password')
VALUES('','$admin','$password');");
echo "admin was added";
}else
die("not added");

every time i enter a name and password to the text box and press enter it shows the message that admin was added and by checking the table which data are entered and stored i find nothing was added and the table is empty
i guess that this problem is because of something wrong with the database may be something with settings or some like that
i need your help with this problem
Thanks in advance

I creating a  members only web for my wife's 45th reunion. Everything went great untill I tackled something I never did before. PHP!

From the home page I'm having the user enter a username and password. I created the db using phpmyadmin and populated the table with two users.

I checked the include and it is attempting to open the db and proper table. however, the php loginck.php, goes to the programed error message.

Can I get a little assistance, it would be greatly appreciated.

The form calls loginck,pfp and it gets there OK.


<div class="art-blockcontent">
                                        <div class="art-blockcontent-body">
                                            <!-- block-content -->
                                            <div style="border: medium ridge blue;padding:15px; font-size:.8em;">
To assist in maintaining contact with our alumni, please register.
<br>
Already registered, sign in.
<br><br>
<form action="loginck.php" method="POST">
<label>Username: </label><input type="varchar" style="height: 1em;" size="15" name="passWord" required>
<br>
<label>Password: </label><input type="password" style="height: 1em;" size="15" name="passWord" required>
<br><br>
<center><input type="submit" value="Sign In">
<input type="reset" value="Clear"></center>
</form>
<br><br>
<a href="register.html">Register</a>
<br>
<hr>
<br>
This site best viewed using Google Chrome, FireFox, or Opera browsers.
</form>
</div>
                                          <!-- /block-content -->


I attached loginck.php  and the inserted a called file 'z_db.php' for your review.  I know if I can get this figured out I can do the others I need to do.

Sorry, if ther's too many typos, I'm relegated to typing with one finger (Stroke) and in a wheel chair.

this is probably going to be really simple to fix but i cant figure it out :/ on one page i have a form which uses php to populate a dropdown box, now this form will allow the user to add 1 to the person which was selected in the dropdown box.

The code for this looks like this..


<form action="addpoint.php" method="post">
<select>

<?php
$sql="SELECT id,name FROM man";
$result =mysql_query($sql);
while ($data=mysql_fetch_assoc($result)){
?>
<option value ="<?php echo $data['id'] ?>" ><?php echo $data['name'] ?></option>
<?php } ?>
</select>
<input type="submit" value="Add Point"/>

</form>

the php to process this form looks like this..

<?php

$sql="UPDATE man SET points = (points + 1) WHERE name =
('$_POST[name]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "$_POST[name] has been added";

mysql_close($con)
?>


The problem i have is that i dont think its pulling the name from the form so therefore it wont effect the database, ive tried the sql like this..

UPDATE man SET points = (points + 1) WHERE name = 'joe'

and it works fine, any help would be gratefully received

Owen

Hi all.  I'm not sure if this post belongs here or in the MySQL forum because I'm not entirely sure where the problem is.  I have a script that takes data from a form and puts it into a database.  There are several tables that were hand built and the script works fine with those.  There are several tables that were converted from M$ Access to MySQL and the script does not work with those.  All tables are InnoDB (if that matters).  My inkling is that the converted tables that have weird field names, some containing "%","#", and "-" characters, are interfering with the MySQL statement to do the insert.  Any thoughts on this?  Would those odd characters for field names in fact affect the MySQL statement to enter data?

P.S.  I don't have access to the code at the moment.  Can post it later unless the solution to this problem is simple (i.e. weird characters are the problem).  Thanks in advance!

HI - I am dynamically populating a drop down form list from the table 'hotels', and the 'est_town' column. It is supposed to only list each town once, but several towns appear multiple times. Am I using the DISTINCT command correctly and if so, what can i do to stop multiple appearances of towns?


Code: [Select]
$query_hotels_select = "SELECT DISTINCT est_town FROM hotels ORDER BY est_town ASC";
$hotels_select = mysql_query($query_hotels_select, $contractors) or die(mysql_error());
$row_hotels_select = mysql_fetch_assoc($hotels_select);
$totalRows_hotels_select = mysql_num_rows($hotels_select);
FORM BIT

Code: [Select]
<select name="digs" id="digs">
<?php
do {  
?>
<option value="<?php echo $row_hotels_select['est_town']?>"<?php if (!(strcmp($row_hotels_select['est_town'], $row_hotels_select['est_town']))) {echo "selected=\"selected\"";} ?>><?php echo ucwords(strtolower($row_hotels_select['est_town']))?></option>
           <?php 
} while ($row_hotels_select = mysql_fetch_assoc($hotels_select));
  $rows = mysql_num_rows($hotels_select);
  if($rows > 0) {
      mysql_data_seek($hotels_select, 0);
  $row_hotels_select = mysql_fetch_assoc($hotels_select);
  }
?>
           
        </select>

Hello All,
I Develop a small e-shop and i am facing a problem with invoice number
I attach to an order the invoice number after client has successfully paid the order through Paypal, so i use the function below to retrieve the next inv num

function GET_NEXT_INV_NUM() {

$query= "SELECT MAX(inv_num) AS max_inv_num FROM orders";
$rs_query = mysql_query($query, $db) or die(mysql_error());
$row_query = mysql_fetch_assoc($rs_ws_mod_tvg_program_rec);

$Next_inv_num = $row_query['max_inv_num']+1;

return $Next_inv_num;
}

all looked to work fine but one day i realised that i have some invoice numbers that are missing, because in some cases instead of next inv to increase by one, is increased by two

for example:

INV NUMBERS:
============
101
102
103 --->PROBLEM HERE (MISSING 104)
105
106
107
108
109
110 --->PROBLEM HERE (MISSING 111)
112
113
114
115
116
...

I check all of my code 3-4 times and all looks ok
Can anyone help me please???

Thanks in advance
(i apologise for my english)

This is my code it always returns null i know that there is info in the table but it never works

$sql = 'SELECT * FROM $user WHERE ticker = "$ticker"';
		$resultsql = mysqli_query($conp,$sql);
		$row = mysqli_fetch_array($resultsql);
		echo $row[ticker];
		var_dump($row);
		echo '<br>';

So i started on a project and not within long, i hit a wicked wall. The upper part works fine, i get the correct $pilotcorpid, however it doesnt seem to query the 2nd time, it just uses the variable from the first time.

I have the information in the database, i just need to pick em out right.

Code: [Select]
<?php
include 'config.php'; //database config
include 'opendb.php'; //connect database

$search = @$_GET['q'] ; //getting a name from a form

$result = mysql_query("SELECT * FROM kb3_pilots WHERE plt_name='$search'")or die(mysql_error()); //here i choose to check in the kb3_pilots table, the plt_name column for the name written in the form earlier.
$pilotcorpid=mysql_result($result,"plt_crp_id"); //since i found the guy in the query, i need info from that column, the plt_crp_id.

$resultcorp = mysql_query("SELECT * FROM kb3_corps WHERE crp_id='$pilotcorpid'")or die(mysql_error());  //now we query the kb3_corps table to check if the corp exists.
$pilotcorpname=mysql_result($resultcorp,"crp_name"); //Because it did, i will now pull out the name

echo "TEST: Pilot Id: $pilotcorpid and corp name: $pilotcorpname";

include 'closedb.php';
?>
If somebody also have a big php/mysql ebook which explains commands great, that would be awesome.


Best regards,
Mumlebumle

Well im using paypal IPN im trying to get it to update something out of my database.

Heres the code

I think this is all you need

Quote

<?php
include('config.php')
?>
<?php
function updatePayments($data){   
    global $link;
   if(is_array($data)){            
        $sql = mysql_query("INSERT INTO `serverb` WHERE name = 'Official' (gold)
 VALUES ('yes')");
    }
}
?>



How do i get it to work?

Hi guys,

Im just after a little help here because i cant seem to get my script to work correctly. Basically i have a table full of data and i want to be able to extract a months worth of data but split that data into weeks from within the month.

This is my database structu
Code: [Select]
-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 13, 2011 at 09:13 AM
-- Server version: 5.5.16
-- PHP Version: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `time_man`
--

-- --------------------------------------------------------

--
-- Table structure for table `clock_status`
--

CREATE TABLE IF NOT EXISTS `clock_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(24) NOT NULL DEFAULT '0',
  `location` int(4) NOT NULL DEFAULT '0',
  `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `amend_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `hours_worked` varchar(25) NOT NULL DEFAULT '',
  `lunch` int(11) NOT NULL DEFAULT '0',
  `break` int(11) NOT NULL DEFAULT '0',
  `sick` char(3) NOT NULL DEFAULT 'NO',
  `holiday` char(3) NOT NULL DEFAULT 'NO',
  `comments` text NOT NULL,
  `auth` tinyint(1) NOT NULL DEFAULT '0',
  `auth_date` date NOT NULL,
  `paid` tinyint(1) NOT NULL DEFAULT '0',
  `pay_rate` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=734 ;

--
-- Dumping data for table `clock_status`
--

INSERT INTO `clock_status` (`id`, `user_id`, `location`, `date_time`, `status`, `amend_time`, `hours_worked`, `lunch`, `break`, `sick`, `holiday`, `comments`, `auth`, `auth_date`, `paid`, `pay_rate`) VALUES
(720, '653467435', 3301, '2011-10-12 04:00:00', 0, '2011-10-12 06:35:00', '9300', 0, 0, 'NO', 'NO', '', 1, '2011-10-13', 0, 'L'),
(721, '653467435', 3301, '2011-10-12 06:30:00', 0, '2011-10-12 11:25:00', '17700', 0, 0, 'NO', 'NO', '', 1, '2011-10-13', 0, 'L'),
(722, '5030341511007', 3301, '2011-10-13 17:45:00', 0, '2011-10-30 22:10:00', '15900', 0, 0, 'NO', 'NO', '', 1, '2011-10-13', 0, 'H'),
(723, '653467435', 3301, '2011-10-13 01:15:00', 0, '2011-10-13 07:15:00', '21600', 0, 0, 'NO', 'NO', '', 1, '2011-10-13', 0, 'L'),
(724, '653467435', 3301, '2011-10-13 03:15:00', 0, '2011-10-13 05:15:00', '7200', 0, 0, 'NO', 'NO', '', 1, '2011-10-13', 0, 'L'),
(725, '653467435', 3301, '2011-11-11 05:45:00', 0, '2011-11-11 13:20:00', '27300', 0, 0, 'NO', 'NO', '', 1, '2011-11-11', 0, 'L'),
(726, '653467435', 3301, '2011-11-11 01:15:00', 0, '2011-11-11 08:25:00', '3663', 0, 0, 'NO', 'NO', '', 1, '2011-11-22', 0, 'L'),
(727, '12345678954565456', 3301, '2011-11-11 05:45:00', 0, '2011-11-11 16:25:00', '3662', 0, 0, 'NO', 'NO', '', 1, '2011-11-22', 0, 'L'),
(728, '50226900', 3301, '2011-11-21 09:30:00', 0, '2011-11-21 17:00:00', '27000', 0, 0, 'NO', 'NO', '', 1, '2011-11-22', 0, 'H'),
(729, '5030341511007', 3301, '2011-11-22 09:30:00', 0, '2011-11-11 15:30:00', '21600', 0, 0, 'NO', 'NO', '', 1, '2011-11-22', 0, 'H'),
(730, '5030341511007', 3301, '2011-11-22 06:00:00', 0, '2011-11-17 09:20:00', '12000', 0, 0, 'NO', 'NO', '', 1, '2011-11-22', 0, 'H'),
(731, '653467435', 3301, '2011-11-22 06:45:00', 0, '2011-11-22 12:30:00', '20700', 0, 0, 'NO', 'NO', '', 1, '0000-00-00', 0, 'L'),
(732, '5030341511007', 3301, '2011-11-22 07:45:00', 0, '2011-11-22 15:15:00', '3661', 0, 0, 'NO', 'NO', '', 1, '0000-00-00', 0, 'H'),
(733, '653467435', 3301, '2011-11-22 04:45:00', 0, '2011-11-22 14:05:00', '33600', 0, 0, 'NO', 'NO', '', 1, '0000-00-00', 0, 'L');

-- --------------------------------------------------------


--
-- Table structure for table `staff`
--

CREATE TABLE IF NOT EXISTS `staff` (
  `person_id` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '',
  `staff_number` varchar(20) NOT NULL DEFAULT '0',
  `dob` date NOT NULL DEFAULT '0000-00-00',
  `pay_rate` char(1) NOT NULL DEFAULT '',
  `date_amended` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `expiry` text NOT NULL,
  PRIMARY KEY (`person_id`),
  UNIQUE KEY `staff_number` (`staff_number`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` (`person_id`, `name`, `staff_number`, `dob`, `pay_rate`, `date_amended`, `expiry`) VALUES
(16, 'Person Two', '3456', '1990-06-23', 'H', '2011-06-23 07:40:38', ''),
(17, 'Person Three', '5678', '1986-05-29', 'H', '2011-01-24 12:18:03', ''),
(15, 'Person One', '1234', '1995-11-29', 'L', '2011-01-18 16:59:53', ''),
(47, 'Person four', '50226900', '1980-04-23', 'H', '2011-06-17 10:50:50', ''),
(48, 'Person Two', '653467435', '1980-01-13', 'L', '0000-00-00 00:00:00', '01/02/1982'),
(50, 'Person One', '5030341511007', '1983-07-13', 'H', '0000-00-00 00:00:00', ''),
(52, 'Person Three', '12345678954565456', '2000-02-01', 'L', '0000-00-00 00:00:00', '01/03/2019');

-- --------------------------------------------------------


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
This is the script so far...

Code: [Select]
<?php require_once("../includes/connection.php"); ?>
<?php 
$date1 = '2011-10-28';
$date2 = '2011-11-27'; 
$ident = '3301';

$sql10 = "SELECT WEEK(date_time) as Week, staff.name, clock_status.user_id, sum( clock_status.hours_worked ) AS sum_hours, clock_status.hours_worked, clock_status.amend_time
FROM clock_status, staff
WHERE amend_time >= '$date1' AND amend_time < '$date2' AND clock_status.auth =1
AND clock_status.user_id = staff.staff_number
AND clock_status.location = '3301'
GROUP BY user_id
ORDER BY Week, user_id";  
$query10 = mysql_query($sql10) or die(mysql_error());

?>
<table style="border: 1 solid black;">
<tr>
<th>Staff No</th>
<th>Name</th>
<th>Sum hours</th>
<th>Week 1</th>
<th>Week 2</th>
<th>Week 3</th>
<th>Week 4</th>
<th>Week 5</th>
</tr>
<?php while ($row = mysql_fetch_assoc($query10)) { ?>
<tr>
<td><?php echo $row['user_id'] ;?></td>
<td><?php echo $row['name'] ;?></td>
<td><?php echo $row['sum_hours'] ;?></td>
<td>Week 1 hours here</td>
<td>Week 2 hours here</td>
<td>Week 3 hours here</td>
<td>Week 4 hours here</td>
<td>Week 5 hours here</td>
</tr>
<?php } ?>
</table>
<?php require("../includes/footer.php"); ?>The table should list each person once, with the total hours, then the amount of hours in each week in a different column. As represented in my table.

If someone could help me on this issue i would be eternally grateful...


thanks in advance.