PHP - Write Each Textarea Line As A New Row In Database

Hi guys,

I have a trouble of updating the data in the database by input the data at the end of the url. It have not been added in the table.


Here it is updated:


<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myusername');
    define('DB_PASSWORD', 'mypassword');
    define('DB_DATABASE', 'mydatabasename');

    $errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {
  die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }

    $login = clean($_GET['user']);
    $password = clean($_GET['pass']);
    $firstname = clean($_GET['firstname']);
    if($login == '') {
  $errmsg_arr[] = 'Login ID missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD ID missing';
  $errflag = true;
    }
    if($value == '') {
  $errmsg_arr[] = 'THE first name IS missing';
  $errflag = true;
    }
    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
  $qry="SELECT * FROM members WHERE login='$login' AND passwd='$password'";

  $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());

if(mysql_num_rows($result) > 0) {

  $row = mysql_fetch_row($result);
    echo $row[0];
    }
else {

echo 'Username, Password or first name is not found.';
close;

$sql="INSERT INTO members (firstname, lastname)
VALUES
('$_POST[firstname]','$_POST[lastname]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "first name have been updated";
}
?>


It have only login in the database but did not doing any update when I have input the data at the end of the url to get the database update.

Do you know why I can't update the data in the database by input the data in the url like this?

http://www.mysite.com/updatemysql.php?user=test&pass=test&firstname=shitorwhateveriwanttoinputandgetitupdate

Do you have any idea and maybe if I have miss something?

Hi

I have a text area, that I want to display info pulled from a database.

I can get the data to show, But can get each entry of the table
to display on it's own line.

Example:
ob1ob2ob3ob4ob5

Should be:
ob1
ob2
ob3
ob4
ob5


CODE:
Code: [Select]
<textarea id="interest" onfocus="clearInterest()" class="textareacss" style="height:212px;overflow:auto;"><?PHP
$newInterestSub = Admin_interests_sub::find_by_cat_id($id);
foreach($newInterestSub as $newInterestSubs){
echo $newInterestSubs->interest_sub.'\n';
}
?></textarea>


Any help would be great.

Not sure where to post this question. I have a MySQL database and add records with a PHP form to the tables.

I have 2 fields (char) in one table. When the fields contain the character '  it wont write the record to the table! For example...if I enter. " John's house" it wont accept the record since ' appears in John's name!

How do I work around this?

Thanks

Good morning to all.

Recently I just read a post here , it's about how to insert different lines from <textarea> to different mysql rows .
http://www.phpfreaks.com/forums/index.php?topic=325239.0

Thanks to AbraCadaver , his code works well.

Quote

$lines = array_map('mysql_real_escape_string', explode("\n", $_POST['textarea']));
$values = "VALUES ('" . implode("'), ('", $lines) . "')";

$query = "INSERT INTO table_name (column_name) $values";


But now if have more than one textarea , such as area1,area2 and area3 , how should change the code so that all data can be inserted into database simultaneously?

Such as data of area1 is for column 1, row 1,
data for area2 is for column2 , row 1,
and data of area3 is for column 3 ,row 1.

Is it possible to make this works?

Thanks for every reply .

I have a table that has a cell that I've made editable:

echo "<td contenteditable='true'>" . $row['Comments'] . "</td>";

Which is cool I guess, but it doesn't go anywhere from there.  I'd like to make it so that upon changing, it links back to an SQL UPDATE query that I define.  Is this possible through some sort of onChange function?

I have a MySQL database with each record of a person who has registered for an event, I am displaying the information on a web page for a user, but he wants to be able to print out all the records in alphabetical order by last name, first name later on so he will have a hard copy of each person who has registered at the table when they arrive.  How can I write each record to a Txt file that he can print out later that will be formated with the record contents along with each fields definition (Ex. Last Name - Smith, First Name - John, etc)?

I am a complete newbie. I have installed xampp. I created a database and the tables but that is all. I need to create all my relationships and test my database. to do this, do I now need to write the php code to view the results in a browser or... do I do it in MySQL. If so, Can someone just point me in the direction I need to go for my next step.   Thanks

Or something like that... I am not sure how to put this..

Anyway, I'll just get started with explaining my problem.

I have an admin-page in which you can delete the comments given on blogs, using checkboxes and clicking on a button with the value 'verwijderenSubmit'. The deletion part works just fine, nothing wrong.

However, I also want to be able to EDIT the comments with an other button called 'bewerkenSubmit', using the same checkboxes that I use for deletion.
Selecting the right CID (CommentID) is no problem, because that works the same as the deletion-part, but selecting the right textarea to update into the database is the problem...

I uploaded a file here with the whole code: http://dhost.info/ddfs/myproblem.html
I escaped the textarea within with square brackets, because otherwise the whole textarea would screw up..
I also added <!-- RELEVANT CODE --> to select the parts that I need to change.

Well, I hope you understand my problem and can help.

help me please, my code is :   $table = tov;
$hal = $_GET[hal];
if(!isset($_GET['hal'])){
$page = 1;
} else {
$page = $_GET['hal'];
}
$max_results = 2;

$from = (($page * $max_results) - $max_results);
$sql = mysql_query("SELECT * FROM $table ORDER BY id_berita DESC LIMIT $from, $max_results");
while($hs_show = mysql_fetch_array($sql)){
$urut++;
?>
<marquee scrollamount="4" align="left" behavior="scroll" direction="left" class="text" onmouseover="this.stop()" onmouseout="this.start()">
<?php echo "$hs_show[judul]"; ?>
</marquee>
<?php
}
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM $table"),0);
$total_pages = ceil($total_results / $max_results);     i want the results to be in 1 line and one after the other ,thanks     

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.

what im trying to do is take a youtube embed code find the URL code for that video and remove all other parts of the code keeping only the URL of the video
after i get the URL by it self then replace the http://www.youtube.com/ part of the URL with http://i2.ytimg.com/vi/

to do this i know that i need something like this to get the URL of the video
http://www.youtube.com/((?:v|cp)/[A-Za-z0-9\-_=]+)
but how to only return just the URL is something idk how to do

then use str_replace http://www.youtube.com/(?:v|cp)/" with  http://i2.ytimg.com/vi/

so in the end im asking if anyone know how to remove all other codes i dont want  and only keep the URL


this may have to be done using "regex" im not sure as i dont know to much about regex and what it can do but does sound like it would help lol

i have to read a single line from a csv,  its a really big file and i only need one column. i need the response to be a string ,i made a search and found the following code but i dont have any idea how to get a single line from a single string per run .

<?php
$row = 1;
//open the file
if (($handle = fopen("file.csv", "r")) !== FALSE)
{
    while (($data = fgetcsv($handle, 0, ",")) !== FALSE)
    {
        $num = count($data);
        echo "<p> $num fields in line $row: <br /></p>\n";
        $row++;
        for ($c=0; $c < $num; $c++)
        {
            echo $data[$c] . "<br />\n";
        }
    }
    fclose($handle);
}
?>

Edited by bores_escalovsk, 16 May 2014 - 06:38 PM.

Hi.

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) 

Dear All

           Good Day, i am new to PHP (a beautiful server side scripting language). i want to send a mail with line by line message i tried with different types like by placing the things in table and using  <br /> but the thing is the tags are also visible in the message of the mail.

Here is my code:

$message1  = "Name       :".  $_REQUEST['name']."<br />";
$message1 .= "Surname    :".  $_REQUEST['surname']."<br />";
$message1 .= "Cellphone  :".  $_REQUEST['mobileno']."<br />";
$message1 .= "Telephone  :".  $_REQUEST['landno']."<br />";
$message1 .= "Fax        :".  $_REQUEST['fax']."<br />";
$message1 .= "Company    :".  $_REQUEST['company']."<br />";
$message1 .= "Email      :".  $_REQUEST['email']."<br />";
$message1 .= "Country    :".  $_REQUEST['country']."<br />";
$message1 .= "Enquity    :".  $_REQUEST['enquiry']."<br />";
$message1 .= "Date&Time  :".  $date."<br />";

For this code if try to print/echo it it is working fine it is displaying line by line, but using this variable ($message1) in the mail these <br /> are also visible.
Can any one guide me to resolve(to remove these tags from the message part) this issue.
Thanks in Advance. :confused: