Community Add-Ons

Maintainers: web-project
Add file to this package
Top » Other

Run SQL query without phpmyadmin insalled on server
for osCommerce Online Merchant v2.2

########################################
# Developed by Alexander Dimelow
# Website: www.web-project.co.uk
########################################

simply create any-name.php file in the /shop/ directory with the following code:

<?php
require_once("includes/configure.php");

mysql_connect(DB_SERVER,DB_SERVER_USERNAME,DB_SERVER_PASSWORD);
@mysql_select_db(DB_DATABASE) or die( "Unable to select database");

$query = "############SQL query here;##################";
mysql_query($query);

mysql_close();
echo "Your database has been updated";
?>

run once, point your browser to http://your-domain-name.com/shop/any-name.php

Legend:  Download   Report
Expand All / Collapse All
Run SQL query without phpmyadmin insalled on server web-project 17 Sep 2007  

########################################
# Developed by Alexander Dimelow
# Website: www.web-project.co.uk
########################################

simply create any-name.php file in the /shop/ directory with the following code:

<?php
require_once("includes/configure.php");

mysql_connect(DB_SERVER,DB_SERVER_USERNAME,DB_SERVER_PASSWORD);
@mysql_select_db(DB_DATABASE) or die( "Unable to select database");

$query = "############SQL query here;##################";
mysql_query($query);

mysql_close();
echo "Your database has been updated";
?>

run once, point your browser to http://your-domain-name.com/shop/any-name.php