Contributions

Other (Category Index)
Search: 

Run SQL query without phpmyadmin insalled on server

########################################
# 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

Expand All / Collapse All

Run SQL query without phpmyadmin insalled on server 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

Note: Contributions are used at own risk.