CMS made simple: using mysql_select_db($dbname); messes up everything

Question

hi im fairly new to cms made simple and ive stumbled upon a problem thats beyond me, my coad is

<?php

$dbh = 'localhost';
$dbu = 'root';
$dbp = '';

$connect = mysql_connect($dbh, $dbu, $dbp) or die ('Error connecting to mysql');

$yatzi = 'myposts';
mysql_select_db($yatzi);

echo "hello";
?>

and im using this through a user defined tag to import a php file, the proble is that everytime i load this page an error pops up saying:

string(61) "Smarty error: unable to read resource: "globalcontent:footer"" string(61) "Smarty error: unable to read resource: "globalcontent:footer""

and everything gets messedup, i seriously have no idead what is going on, can anybody please help me,, thnks...

does everything work if you remove this code? Where is this code located (typically you cant just throw it in a Smarty tpl)? — prodigitalson, Apr 07 '11 at 07:43
Are you sure "myposts" is your databasename? Because it sounds more like a table name. — Gerben Jacobs, Apr 07 '11 at 08:02

prodigitalson · Accepted Answer · 2011-04-07T07:57:23.647

If this connection is to the same db server the issue could be that youre overwriting the connection resource and thus your CMS cant pull anything form the db.

This would be because by default PHP will detect that you already have a connection open and return that one if they share the same parameters. You can override this behavior by forcing a new connection:

$connect = mysql_connect($dbh, $dbu, $dbp, true);

Then when using this server you need to make sure you always specify which link to use:

mysql_select_db($yatzi, $connect);

mysql_query($query, $connect);
// etc...

Ohter possible issues might be that you have the code in the worng place (like directly in a Smarty template file without the special php escape tags surrounding it), or that the problem isnt related to your code at all and something is up with your CMS installation or customization.

score -2 · Answer 2 · answered Apr 07 '11 at 07:37

-2

<?php

$dbh = 'localhost';
$dbu = 'root';
$dbp = '';
$yatzi = 'myposts';

$connect = mysqli_connect($dbh, $dbu, $dbp,$yatzi) or die ('Error connecting to mysql');

echo "hello";
?>

answered Apr 07 '11 at 07:37

Sourav

17,065
35
101
159

CMS made simple: using mysql_select_db($dbname); messes up everything

2 Answers2