MySQL Forums
Forum List  »  PHP

SQL query not working
Posted by: saurabh munjal
Date: May 30, 2014 04:22PM

I am trying to insert some data using sql query in mysql. GHowever something is going wrong and data is not being inserted.

I tried a lot, but i am unable to find the mistake.Please help.Following is the code-

<?php
$server = 'localhost';
$login='event';
$pass='A1B1';
$db='eventcar';
$conndb=mysqli_connect($server,$login,$pass,$db) or die ("DB connection failed because:" . mysqli_error($conndb));

mysqli_query($conndb,"INSERT INTO `tbl_event` (`event_id`, `paypal_charges`, `tax`, `convences_charges`, `mem_id`, `category_id`, `category_links`, `event_name`, `event_friendly_url`, `event_date_start`, `event_time_start`, `event_date_end`, `event_time_end`, `event_type`, `country`, `city`, `address`, `url`, `event_listing`, `email_ids`, `event_ticketed`, `doing_ticket_through_us`, `ticket_type`, `ticket_url`, `total_tickets`, `min_tickets`, `maxt_tickets`, `ticket_price`, `name_of_account`, `account_number`, `account_type`, `bank_name`, `bank_address`, `ifsc_code`, `event_logo`, `event_details`, `organizer_name`, `organizer_logo`, `organizer_details`, `event_viewed`, `zipcode`, `event_url`, `facebook_url`, `youtube_url`, `twitter_url`, `status`, `post_date`, `most_popular`, `event_approval_status`) VALUES (NULL, '0', '0', '0', '0', '16', '16', 'Suraj Jagan live in Concert', 'suraj-jagan-live-in-concert', '2014-06-08', '7:30 PM', '2014-06-08', '9:30 PM', 'Offline', 'India', 'Ahmedabad', 'At B J Medical college, Civil Hospital, Ahmedabad, Gujarat, India.', '', 'Public', NULL, 'Yes', 'No', NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'description', '', NULL, NULL, '0', NULL, 'http://abc/xyz';, '', '', '', '1', '2014-05-30', '0', '1');");
echo mysqli_insert_id();

?>

Options: ReplyQuote


Subject
Written By
Posted
SQL query not working
May 30, 2014 04:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.