Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How to include a semicolon in an sql query?


eldridge

Recommended Posts

I have this php script that generate an sql query. However, it needs a semicolon inside the sql statement and because of that, the sql query doesn't work.

 

The problem is that, the value bm_shopping_cart.php;bm_categories.php doesn't stored in the database that suppose to be inserted by that query. When I removed ;bm_categories.php the valuebm_shopping_cart.php is inserted on the database. So the problem resides on having the semicolon. I also tried using \ but the problem still there. I really need the semicolon included on the value. Any ideas?

 

VALUES ('Installed Modules', 'MODULE_BOXES_INSTALLED', 'bm_shopping_cart.php;bm_categories.php', 'This is automatically updated. No need to edit.', '6', '0', now())

 

 

It is included in this function.

function insert_configuration6_table($table_name9, $type) {
 global $wpdb;

 if (!empty ($wpdb->charset))
 $charset_collate = "DEFAULT CHARACTER SET {$wpdb->charset}";
 if (!empty ($wpdb->collate))
 $charset_collate .= " COLLATE {$wpdb->collate}";

$sql = "INSERT INTO {$table_name9} (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Installed Modules', 'MODULE_BOXES_INSTALLED', 'bm_shopping_cart.php;bm_categories.php', 'This is automatically updated. No need to edit.', '6', '0', now()),('Installed Template Block Groups', 'TEMPLATE_BLOCK_GROUPS', 'boxes', 'This is automatically updated. No need to edit.', '6', '0', now());";

 require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
 dbDelta($sql);
}

 

I have searched a lot for this however, I can't find a solution that work.

 

How can I make an sql query that includes a semicolon in the values?

 

Thanks.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...