PHP - Submit And Convert Textarea Into Html And Insert Into Sql Table

I'm converting a search feature that currently uses two successive dropdown fields to do the search. The search is initiated when the user selects the option from the dropdown. The resultant (it's always 1 record) is then displayed in detail with a + sign next to it so that the user can add the record he just searched for.

I've replaced it with a single dropdown and type-ahead field that uses javascript. The type ahead replaces the second drop down. I didn't want users have to select amongst hundreds of records in a drop down, by forcing them to start typing the second drop down, I can narrow the results to the exact item the user is looking for.

My problem is that I'm not sure how to get the type ahead result to initiate the search on the user select. I initiate it like this in the old version...

            <table>
                <tr>
                    <td width="130px" valign="top"><form name="nav"><select name="platform" id="platform" onChange="document.location.href=document.nav.platform.options[document.nav.platform.selectedIndex].value">
                        <option>Platform</option>
                        <?
                            $result = mysql_query("SELECT * FROM Platform");
                            while($row = mysql_fetch_array($result)) {
                        ?>
                        <option value="?ptfm_ctrl=1&ptfm_id=<?=$row['id_platform']?>" <? if ($_GET['ptfm_id']==$row['id_platform']) { ?>selected="selected"<? } ?>><?=$row['platform']?></option>
                        <? } ?>
                    </select></form></td>                   
                    <?
                        if (isset($_GET["ptfm_ctrl"])) {
                    ?>
                        <tr>
                  </table>



The new solution generates the type ahead result like this...

   <div>
      <form>
         <div>
            Start typing the name of the product, select the correct title when it appears:
            <br />
            <input type="text" size="30" value="" id="inputString" onkeyup="lookup(this.value);" onblur="fill();" />
         </div>
         
         <div class="suggestionsBox" id="suggestions" style="display: none;">
            <img src="upArrow.png" style="position: relative; top: -12px; left: 30px;" alt="upArrow" />
            <div class="suggestionList" id="autoSuggestionsList">
               &nbsp;
            </div>
         </div>
      </form>
   </div>

How can I initiate the search using the second method?

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 .

Hello, is it possible to insert somehow information from textarea to mysql?
For example i have 3 lines in text area:
John Tacker is a bad guy
Tom Tacker has a big nose
Ted Tacker is the same person as John Tacker
and i want to insert them in table's different rows

Hi,

I am new to php and I desperately need help inserting an image into my php submit form.
The form works perfectly but I have no idea how to get an image to be shown when the recipeint fo the email receive it (would love to have my company logo at the top of the mail just after $message..
Below is my code :

....
// Create Mail Message and Send Mail
                  $to         = 'x@domain.coma';
                  $subject    = "Website Enquiry Received from www.domain.com";
                  
                  $message    =
                  "The following message has been sent from the website."  .
                  

                  
                  "\n" .
                  "\n" .
                  "Date Sent: " . date("j F Y") . "\n" .
                  "Date Sent: " . date("g:i a") . "\n" .
                  "\n" .
                  "From: $contactName $contactSurname" . "\n" .
                  "\n" .
                  "Their Contact & Personal Details" . "\n" .
                  "=====================" . "\n" .
                  "\n" .
                  "Marital Status: $contactStatus" . "\n" .
                  "Email: $contactEmail" . "\n" .
                  "Cellphone Number: $contactNumber" . "\n" .
                  "Address 1: $contactAddress1" . "\n" .
                  "Address 2: $contactAddress2" . "\n" .
                  "Suburb: $contactSuburb" . "\n" .
                  "Postal Code: $contactPostalcode" . "\n" .
                  "\n" .
                  "\n" .
                                    
                  $headers    = "From: $contactName $contactSurname <$contactEmail>" . "\r\n" .
                             'X-Mailer: PHP/' . phpversion();
                  
                  mail($to, $subject, $message, $headers);
                  mail($contactEmail, 'Confirmation of email: "' . $subject . '"', $message, $headers);
               
               // Thank You Message
               header('Refresh: 0; url=/quote_confirm.htm');               
               }
            }
            ?>

I am trying to get this query correct.  I want to insert a record into the database upon form submission but only if the record does not already exist.  If the record exists, then I want it to be updated in the database.    What is happening:  Upon form submit, a new record is entered into the database every time.  Note:  The contact_id column is both primary key and unique in my database.  Here is my code:

if($_POST['submit']){
  $con=mysqli_connect("localhost","username","password","database_name");
  // Check connection
  if (mysqli_connect_errno())
    {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
	
	$org = mysql_real_escape_string($_POST['organization']);
  	$namefirst = mysql_real_escape_string($_POST['firstName']);
        $namelast = mysql_real_escape_string($_POST['lastName']);
	$emailaddy = mysql_real_escape_string($_POST['email']);
	$phonenum = mysql_real_escape_string($_POST['phone']);
	$appquestion = mysql_real_escape_string($_POST['appquestion']);
	$banner = mysql_real_escape_string($_POST['banner']);
	$bulletin = mysql_real_escape_string($_POST['bulletin']);
	$giveaway = mysql_real_escape_string($_POST['giveaway']);
	$app = mysql_real_escape_string($_POST['app']);
	$tshirt = mysql_real_escape_string($_POST['tshirt']);
	$tshirtp = mysql_real_escape_string($_POST['tshirtp']);
	$print = mysql_real_escape_string($_POST['print']);
	$party = mysql_real_escape_string($_POST['party']);
	$orgnotes = mysql_real_escape_string($_POST['notes']);
	
 
$sql="INSERT INTO database_name (contact_id, first_name, last_name, email_address, phone_number, org, appquestion, banner, bulletin, giveaway, app, tshirt, promised_tee, print, party, org_notes)
      VALUES
      ('','$namefirst','$namelast','$emailaddy','$phonenum','$churchorg','$appquestion','$banner','$bulletin','$giveaway','$app','$tshirt','$tshirtp','$print','$party','$orgnotes')	
	    
	  ON DUPLICATE KEY UPDATE first_name = '$namefirst', last_name = '$namelast', email_address = '$emailaddy', phone_number = '$phonenum', org = '$org', appquestion = '$appquestion', banner = '$banner', bulletin = '$bulletin', giveaway = '$giveaway', app = '$app', tshirt = '$tshirt', promised_tee = '$tshirtp', print = '$print', party = '$party', org_notes = '$orgnotes'" ;

						

    if (!mysqli_query($con,$sql))
    {
      die('Error: ' . mysqli_error($con));
    }
      echo "1 record added";



  mysqli_close($con);
}

From everything I have read, I need to use ON DUPLICATE KEY UPDATE to replace the old information with new information in the database upon form submission.  While the insert part of my code is working, the portion with ON DUPLICATE KEY UPDATE is not working.   Why might this portion of the code not be working?  Is there a better way to insert else update the information?   Thank you for any help or guidance you can give me!  I've been working on this concept for three days and have read a ton of information about it, but am still not able to get it to work.

Hi I am very new to PHP & Mysql. I am trying to insert values into two tables at the same time. One table will insert a single row and the other table will insert multiple records based on user insertion. Everything is working well, but in my second table, 1st Table ID simply insert one time and rest of the values are inserting from 2nd table itself. Now I want to insert the first table's ID Field value (auto-incrementing) to a specific column in the second table (only all last inserted rows).   Ripon.   Below is my Code:

<?php



$con = mysql_connect("localhost","root","aaa");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db("ccc", $con);


$PI_No = $_POST['PI_No'];
$PO_No = $_POST['PO_No'];


$qry = "INSERT INTO wm_order_entry (
Order_No,
PI_No,
PO_No) 


VALUES(
NULL,
  '$PI_No',
 '$PO_No')";
$result = @mysql_query($qry);




$val1=$_POST['Size'];
$val2=$_POST['Style'];
$val3=$_POST['Colour'];
$val4=$_POST['Season_Code'];
$val5=$_POST['Dept'];
$val6=$_POST['Sub_Item'];
$val7=$_POST['Item_Desc'];
$val8=$_POST['UPC'];
$val9=$_POST['Qty'];
$N = count($val1);
for($i=0; $i < $N; $i++)
{


$profile_query = "INSERT INTO order_entry(Size,
Style,
Colour,
Season_Code,
Dept,
Sub_Item,
Item_Desc,
UPC,
Qty,
Order_No
) VALUES( '$val1[$i]','$val2[$i]','$val3[$i]','$val4[$i]','$val5[$i]','$val6[$i]','$val7[$i]','$val8[$i]','$val9[$i]',LAST_INSERT_ID())";
$t_query=mysql_query($profile_query);
}
header("location: WMView.php");
mysql_close($con);
?>

Output is attached.

Dear All Members

here is my table data..

(4 Columns/1row in mysql table)

id                 order_no               order_date                  miles
310                001                   02-15-2020                MI,108.53
                                                                                     Oh,194.57
                                                                                     PA,182.22
                                                                                     WA,238.57

How to split(miles) single column into (state, miles) two columns and output like following 5 columns /4rows in mysql using php code.

(5 Columns in mysql table)
------------------------------------------------------------------------------------

id                  order_no              order_date              state      miles

310                001                   02-15-2020               MI          108.53

310                001                   02-15-2020              Oh          194.57

310                001                   02-15-2020              PA          182.22

310                001                   02-15-2020             WA          238.57
 

------------------my php code -----------

 

<?php
//invoice.php  
include('../includes/config.php');

if(isset($_POST["add"]))
{
$order_no=$_GET['order_no'];
$order_date=$_GET['order_date'];
$miles=$_POST['miles'];

$miles = explode("\r\n", $_POST["miles"]);
$newdata = "'" . implode("','", $_POST["miles"]) . "'";
$sql ="INSERT INTO tble_states_miles(order_no,order_date, miles) VALUES(:order_no, :order_date, :newdata)";

$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);
$query-> bindParam(':order_date', $order_date, PDO::PARAM_STR);
$query-> bindParam(':miles', $newdata, PDO::PARAM_STR);

$lastInsertId = $dbh->lastInsertId();
if($lastInsertId)
{
echo "<script type='text/javascript'>alert('Added Sucessfull!');</script>";
echo "<script type='text/javascript'> document.location = 'ifta_miles_calculationlist_added.php'; </script>";
}
else 
{
$error="Something went wrong. Please try again";
}

if($query->execute()) {

$sql = "update tis_invoice set flag='1' where order_no=:order_no";
$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);

$query->execute();

}
}
?>

----------------- my form code ------------------

 

 <?php
                   $order_no=$_GET['order_no'];
        $sql = "SELECT * from tis_invoice where order_no = :order_no";
        $query = $dbh -> prepare($sql);
        $query->execute(
  array(
   ':order_no'       =>  $_GET["order_no"]
  )
 );
        $result = $query->fetchAll();
        foreach($result as $row)
?>
    
                    <form method="post">
                        <table align="center" style="width: 55%">
                        <tr><td>Invoice Number</td></tr>
                        <tr><td><input type="text" name="order_no" value="<?php echo $row["order_no"]; ?>" readonly=""></td></tr>
                        <tr><td>Invoice Date</td></tr>
                        <tr><td><input type="text" name="order_no" value="<?php echo $row["order_date"]; ?>" readonly=""></td></tr>
                        <tr><td>
                               <textarea name="miles" class="form-control" rows="10" placeholder="" required></textarea>
                           </td></tr>
                           <tr><td>
                         
                            <input type="submit" name="add" class="btn btn-primary" value="Add" />
                       </td></tr></table>
                    </form>

-- Can any one help how to correct my code..present nothing inserted on table

 

Thank You

Edited February 8, 2020 by karthicbabu

I use PHPMyAdmin. I have to convert an InnoDB table to a MyISAM table. I then have to add a FULLTEXT index to two of the table's columns.   Is this how I should proceed?   1) Backup table by exporting its contents. 2) Go to "Relation view" and drop foreign key constraints. 3) ALTER TABLE `table_name` ENGINE = MyISAM; 4) ALTER TABLE `table_name` ADD FULLTEXT index_name (col1,col2);   Is that it? Is it safe?   Note that the table contains approximately 3,500 rows.

Hi

I have members DOB stored in a mysql table field called birthday in the following format YYYY-MM-DD

I can't seem to convert the time stamp into the members age

I need to be able to feed $birthday which is the field in mysql table that is in the above format and then use php code to convert to members age

Everything I try doesn't seem to work

Hi,
  I want to place the following HTML statement inside an echo statement, i.e. in PHP I want to output an image that is also a link.
        <a href="#"><img src="Somefolder/animage.jpg" width="125" height="156" alt="some image" /></a>

  All ideas will be greatly appreciated.

hello guys..

i want help from u . i am displaying a table of 5 rows and 5 columns . i want to get a pdf copy of it dynamically.
i want to re-use it again for my invoice also . covert in into pdf and then print that file.
can u provide a sample code of how to covert it into pdf . (same as exporting into excel)

This is a bit of a long shot, but hopefully somebody can point me in the right direction.

I have a wordpress website that has a 'Wine List' page, in which it lists over 100 'custom posts' detailing each wine. I have tried out several plugins to convert the wine list into a PDF but none work in the way that I require.

So now I'm thinking to just do it outside of wordpress and find a PHP script that may help me.

I imagine it would be impossible to simply execute a script at the bottom of a page for it to convert whatever HTML has been generated into a PDF?

Or is there anything that would allow me to specify what records from the database to add to the PDF? E.g. for me to type a PHP script with a MySQL command and for that to be converted into a PDF?

Thanks if anybody has any ideas what action I should take!

I am having a rtf file, now i want to convert that rtf file to html version with same alignment, to be display in the web page. Kindly give some example in php.

I am trying to find out how to convert HTML code to ePub format dynamically, i know it can be done, but i was wondering if anyone had a tutorial i could follow or something, Thanks.