insert variable into database using php

Question

2000-10-01,2000-12-16,2000-11-17,2001-03-10,2001-09-10,2000-09-02,2000-11-02,2000-12-06,2000-11-02,2000-12-09,2000-12-01,2001-04-16.

Gambardella, Matthew,Ralls, Kim,Corets, Eva,Corets, Eva,Corets, Eva,Randall, Cynthia,Thurman, Paula,Knorr, Stefan,Kress, Peter,O'Brien, Tim,O'Brien, Tim,Galos, Mike

i have this value in variable $date and $author.i want to insert it into database. i have been trying using .

$sql = "insert into book values('','$author','{$date}') ";

i am not able to insert all the data stored into $data and $author variable. — Shiv Kumar Roy
– Shiv Kumar Roy, Commented Feb 18, 2016 at 5:01
Are you getting any error. Like any violation's of constraint — Pரதீப்
– Pரதீப், Commented Feb 18, 2016 at 5:02
you need to explode the string and insert the data into loop i guess. — Amit Shah
– Amit Shah, Commented Feb 18, 2016 at 5:02
@VR46 when i echo this variable it shows - 2000-10-01,2000-12-16,2000-11-17,2001-03-10,2001-09-10,2000-09-02,2000-11-02,2000-12-06,2000-11-02,2000-12-09,2000-12-01,2001-04-16. but when i insert it it shows 0000-00-00 . — Shiv Kumar Roy
– Shiv Kumar Roy, Commented Feb 18, 2016 at 5:04

Amit Shah · Accepted Answer · 2016-02-18 05:08:03Z

1

Assuming, you have are having connection to mysql database.

$date = 
"2000-10-01,2000-12-16,2000-11-17,2001-03-10,2001-09-10,2000-09-02,2000-11-02,2000-12-06,2000-11-02,2000-12-09,2000-12-01,2001-04-16";

$authors="Gambardella,Matthew,Ralls,Kim,Corets,Eva,Corets,Eva,Corets,Eva,Randall,Cynthia,Thurman,Paula,Knorr,Stefan,Kress,Peter,O'Brien,Tim,O'Brien,Tim,Galos,Mike";



 $sql = "insert into book values('','".mysql_real_escape_string($author)."','".mysql_real_escape_string($date)."') ";
 echo mysql_query($sql);

The code above will insert all the data into the database.

Thanks

answered Feb 18, 2016 at 5:08

Amit Shah

1,3801 gold badge10 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

devpro Over a year ago

Mysql_* is deprecated

Amit Shah Over a year ago

@ShivRoy can you please mark it as answer, also you can use mysqli_real_escape_string if you dont want to use deprecated function mysql_real_escape_string.

Amit Shah Over a year ago

Marking correct answer will help our community to easily look at correct answer and take correct action faster.

Jalpa · Accepted Answer · 2016-02-18 05:03:20Z

0

Please try query like below.

$sql = "insert into book values('','".$author."','".$date."') ";

And please echo and exit your query and then run it in databse that's why you identify what is issue.

answered Feb 18, 2016 at 5:03

Jalpa

7203 silver badges13 bronze badges

Comments

GenGen · Accepted Answer · 2016-02-18 05:50:58Z

0

<?php    
    // check on your DB connection
    $connDB = new mysqli ( $db_host, $db_username, $db_pass, $db_name );  

    $date = array("2000-10-01","2000-12-16");
    $author = array("Gambardella","Ralls");
    $count = 0;

foreach ($dates as $date)
{
   $sql_insert = "INSERT into book(something, author, date) values(',','$date','$author[$count]')";
   mysqli_query ( $connDB, $sql_insert );
   $count ++ ;
}
mysqli_close($connDB);
?>

edited Feb 18, 2016 at 5:50

answered Feb 18, 2016 at 5:14

GenGen

811 silver badge13 bronze badges

2 Comments

devpro Over a year ago

Change the order of values

devpro Over a year ago

$date should be $dates

Collectives™ on Stack Overflow

insert variable into database using php

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related