Need help with message 'no database selected"

derekburrows

I've created a few php pages in Dreamweaver using a database connection on my local computer. Everything is working fine but being new to this I'm missing some important steps when uploading to a remote server. I've exported my database and imported it to phpmyadmin on the sever and have uploaded to pages to the site but when i try to access the page i get an error, no database selected.

The code on the connections page in dreamweaver is: <?php

FileName="Connection_php_mysql.htm"

Type="MYSQL"

HTTP="true"

$hostname_karen_product = "localhost";
$database_karen_product = "karen";
$username_karen_product = "root";
$password_karen_product = "root";
$karen_product = mysql_pconnect($hostname_karen_product, $username_karen_product, $password_karen_product) or trigger_error(mysql_error(),E_USER_ERROR);
?>

I changed the $username after the mysql_pconnect to the username in the database as well as the hostname and password. I'm not sure if I need to also change other things on this page.

In the source code I have this: mysql_select_db($database_karen_product, $karen_product);
$query_rsProducts = "SELECT product_id, product_type, product_name, price, packaging, materials, serial_number, size, thumbnail FROM karen";
$rsProducts = mysql_query($query_rsProducts, $karen_product) or die(mysql_error());
$row_rsProducts = mysql_fetch_assoc($rsProducts);
$totalRows_rsProducts = mysql_num_rows($rsProducts);
?>

Do I change the database name here as well? I've tried doing this in both the connections code and source code but no luck, the same message.

Thanks for any help

Derek

bradgrafelman

derekburrows wrote:
Do I change the database name here as well?

What database name? You never call [man]mysql_select_db/man and select a database at all?

Also, are you sure you want to use the _pconnect() function? If used or configured improperly, using persistent connections is an easy way to bring a website down.

derekburrows

That was the question. In the connections file the pconnect function is listed. I wasn't sure what to do with that. When I have selected the database in the source code after msql_select_db I get that error. So the first question is what changes should I make to the connections script and what changes to the source?

Thanks

bradgrafelman

derekburrows wrote:
When I have selected the database in the source code after msql_select_db I get that error.

Where do you use mysql_select_db()? I don't see it anywhere in the code you provided above.

derekburrows wrote:
what changes should I make to the connections script

I would say just remove the 'p' and use the regular [man]mysql_connect/man function. I hardly ever see anyone use persistent connections nowadays.

derekburrows

I think I put everything in correctly but now I'm getting this message: Unknown column 'product_id' in 'field list'

Here is the source code followed by the connections script:

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO karen (product_id, product_type, product_name, price, packaging, materials, serial_number, `size`, thumbnail) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['product_id'], "int"),
                       GetSQLValueString($_POST['product_type'], "text"),
                       GetSQLValueString($_POST['product_name'], "text"),
                       GetSQLValueString($_POST['price'], "double"),
                       GetSQLValueString($_POST['materials'], "text"),
                       GetSQLValueString($_POST['materials'], "text"),
                       GetSQLValueString($_POST['serial_number'], "text"),
                       GetSQLValueString($_POST['size'], "text"),
                       GetSQLValueString($_POST['thumbnail'], "text"));

  mysql_select_db("karenke1_products");
  $Result1 = mysql_query($insertSQL, $karen_product) or die(mysql_error());
}

mysql_select_db("karenke1_products");
$query_rsProducts = "SELECT product_id, product_type, product_name, price, packaging, materials, serial_number, `size`, thumbnail FROM karen";
$rsProducts = mysql_query($query_rsProducts, $karen_product) or die(mysql_error());
$row_rsProducts = mysql_fetch_assoc($rsProducts);
$totalRows_rsProducts = mysql_num_rows($rsProducts);

mysql_select_db("karenke1_products");
$query_rsType = "SELECT * FROM type";
$rsType = mysql_query($query_rsType, $karen_product) or die(mysql_error());
$row_rsType = mysql_fetch_assoc($rsType);
$totalRows_rsType = mysql_num_rows($rsType);

mysql_select_db("karenke1_products");
$query_rsAdmin = "SELECT * FROM users";
$rsAdmin = mysql_query($query_rsAdmin, $karen_product) or die(mysql_error());
$row_rsAdmin = mysql_fetch_assoc($rsAdmin);
$totalRows_rsAdmin = mysql_num_rows($rsAdmin);
?>

connections script:

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_karen_product = "localhost";
$database_karen_product = "karenke1_products";
$username_karen_product = "root";
$password_karen_product = "root";
$karen_product = mysql_connect('localhost', 'karenke1_admin', 'password goes here') or trigger_error(mysql_error(),E_USER_ERROR); 
?>

Appreciate your help

bradgrafelman

Forgot to mention this earlier... When posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze. I've edited your post to include these tags.

As for your problem... the error message is quite descriptive. MySQL doesn't see a column named "product_id" in the "karen" table. Are you sure that's the correct spelling/name of the column?