Execute SQL statement?

[jasone]

Hi!

 

I know how to modify phpcode =D But I don?t know how to execute a SQL statement...

 

Anyone with a tip how to execute this SQL statement:

INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Quicksearch searches in description', 'QUICKSEARCH_IN_DESCRIPTION', 'false', 'If set to TRUE the customer can search in descriptions otherwise the search is limited to the product title', 1, 113, '2004-06-10 16:54:12', '2004-06-10 16:42:11', NULL, 'tep_cfg_select_option(array('true', 'false'),');

 

This is needed for a contribution I plan on using...

 

Thx!

[RyanSmith]

Hi!

 

I know how to modify phpcode =D But I don?t know how to execute a SQL statement...

 

Anyone with a tip how to execute this SQL statement:

INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Quicksearch searches in description', 'QUICKSEARCH_IN_DESCRIPTION', 'false', 'If set to TRUE the customer can search in descriptions otherwise the search is limited to the product title', 1, 113, '2004-06-10 16:54:12', '2004-06-10 16:42:11', NULL, 'tep_cfg_select_option(array('true', 'false'),');

 

This is needed for a contribution I plan on using...

 

Thx!

<{POST_SNAPBACK}>

 

From osCommerce you can just run the code:

 

 

tep_db_query("INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Quicksearch searches in description', 'QUICKSEARCH_IN_DESCRIPTION', 'false', 'If set to TRUE the customer can search in descriptions otherwise the search is limited to the product title', 1, 113, '2004-06-10 16:54:12', '2004-06-10 16:42:11', NULL, 'tep_cfg_select_option(array('true', 'false'),')");

 

That should execute the query against the database

[jasone]

From osCommerce you can just run the code

 

Sorry if I?m lame but how do I run code in oscommerce? Somewhere in admin tool?

 

Thanks for the answer by the way!

[Rob123]

You can use a mysql connector like phpmyadmin (free) or sqlyog (not free but my favorite).

HTH,

Robert

[RyanSmith]

You can use a mysql connector like phpmyadmin (free) or sqlyog (not free but my favorite).

HTH,

Robert

<{POST_SNAPBACK}>

 

If your just looking to run an SQL statement against the database, I would just use the mySQL command line prompt. It should be located in the bin directory of your mySQL install.

[Rob123]

You can use a mysql connector like phpmyadmin (free) or sqlyog (not free but my favorite).

HTH,

Robert

<{POST_SNAPBACK}>

 

Hehe, I'm replying to my own post. phpMyAdmin and sqlyog are third party applications (software) that allow you to modify mySQL databases.

The first is free and likely included with your hosting package. The second reminds me a lot of Micro$oft's Query Analyser.

 

HTH a little more,

Robert

[jasone]

Hehe, I'm replying to my own post.  phpMyAdmin and sqlyog are third party applications (software) that allow you to modify mySQL databases.

The first is free and likely included with your hosting package.  The second reminds me a lot of Micro$oft's Query Analyser.

 

HTH a little more,

Robert

<{POST_SNAPBACK}>

 

Thanks man!

 

I?ve just tried phpadmin... Did not work but I wont give up! Do you know wich database I should update? Ive tried mysql, oscommerce and central_user_db...

 

Im trying this contribution by the way:

http://www.oscommerce.com/community/contri...ch,search+words

 

I need to have the possibility to search for products using the products info page...

[arod]

Sorry if I?m lame but how do I run code in oscommerce? Somewhere in admin tool?

 

Thanks for the answer by the way!

<{POST_SNAPBACK}>

 

 

Q&D:

you create a file named quick_and_dirty.php

 

the contents of the file looks something like:

<?php

echo "going to run some code<br>";
the_php_code_you_want_to_run();
echo "ok, the code ran";

/* if you want to call tep_xxx() function make sure to "require" the appropriate file */

?>

 

you upload the file to your admin/ directory.

you point your browser to the file:

 

http://your.domain.org/catalog/admin/quick_and_dirty.php

 

it is advised to put the file in your admin directory and not elsewhere, 'cause i assume your admin directory is secured.

 

also, note that there are no links to this file: you have to point at it directly.

 

hope it helps,

arod.

[Rob123]

Do you know wich database I should update?  Ive tried mysql, oscommerce and central_user_db...

<{POST_SNAPBACK}>

 

Look in your catalog/includes/configure.php file for your database info.

Slide down to the bottom, and you'll find something like the following:

define('DB_SERVER', 'YourDatabaseServerName'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', 'YourDatabaseUserName');
define('DB_SERVER_PASSWORD', 'YourDatabasePassword');
define('DB_DATABASE', 'TheDatabaseName');

 

Obviously, in the example above TheDatabaseName is the name of the database.

Let us know if you need further info,

Robert

[Guest]

Hehe, I'm replying to my own post.  phpMyAdmin and sqlyog are third party applications (software) that allow you to modify mySQL databases.

The first is free and likely included with your hosting package.  The second reminds me a lot of Micro$oft's Query Analyser.

 

HTH a little more,

Robert

<{POST_SNAPBACK}>

 

There is now a free version of SQLyog. Limited features, but still pretty powerful.

 

Live long and prosper, lol. :thumbsup: