Contraté un hosting de pago , muy barato, porque le estoy montando una pagina de anuncios a una amiga. El caso es que uso el script "almondsoft" version lite. Estoy harto de instalar ese script en mi sitio propio y en otros sitios gratuitos y funciona, la conexión a la base de datos siempre ha funcionado porque es , digamos , "estandar".
El sitio del que os hablo dice que la conexión a las bases de datos es asi:
######### este codigo es el que dice el hosting que hay quue usar ##############
# $dbh=mysql_connect ("localhost", "nombre de la base","clave del usuario")
# or die('Cannot connect to the database because: ' . mysql_error());
# mysql_select_db ("nombre de la base de datos");
######### este codigo es el que dice el hosting que hay quue usar ##############
y los dos archivos donde hay MYSQL_CONNECT tienen este codigo:
ARCHIVO 1.
CREA LA TABLA
Código PHP:
<?
require("config.php");
require("funcs1.php");
if ($md=="logout") { logout();}
connect_to_db();
if ($md=="print_menu")
{
if($admpassw1 != $adm_passw){
$inc_passw="incorrect password !";
printpasswordform($inc_passw);
exit;
}
setcookie("admcookpassw", $admpassw1);
print_menu();
exit;
}
if($admcookpassw != $adm_passw){
if ($admcookpassw != ""){
$inc_passw= "Incorrect password or cookies does not work";
}
printpasswordform($inc_passw);
exit;
}
if ($md=="") print_menu();
if ($md=="create_db") create_db();
if ($md=="create_tb") create_tb();
if ($md=="sql_tb") print_sql_tb();
function logout()
{
setcookie("admcookpassw", "0");
printpasswordform($inc_passw);
exit;
}
function print_menu()
{
global $html_header, $html_footer, $db_name, $table_ads, $table_logs,
$moderating, $categories;
echo $html_header;
echo "
# AQUI SE ELIJE COMO CREAR LA TABLA #
Create database table for classifieds
Create table '$table_ads'
SQL for creating table '$table_ads'
Log Out from admin. interface
";
echo $html_footer;
exit;
}
function print_sql_tb()
{
global $html_header, $html_footer;
echo $html_header;
echo sql_create_tb();
echo $html_footer;
exit;
}
function create_db()
{
global $host_name, $db_user,$db_password, $html_header,
$html_footer, $db_name, $table_ads;
######### por aqui esta el error #######################
mysql_connect("$host_name","$db_user","$db_password");
mysql_create_db("$db_name");
echo $html_header;
echo "Database '$db_name' was created";
echo $html_footer;
exit;
}
######### por aqui esta el error #######################
function create_tb()
{
global $host_name, $db_user,$db_password, $table_logs,
$html_header, $html_footer, $db_name, $table_ads;
######### por aqui esta el error #######################
$sql_query1=sql_create_tb();
if (!(@mysql_connect("$host_name","$db_user","$db_password")))
######### por aqui esta el error #######################
{echo $html_header;
echo "
Error in connecting to your MySQL server.
";
echo $html_footer;
exit;
}
if (!(@mysql_select_db("$db_name")))
{echo $html_header;
echo "
Error in connecting to your MySQL database '$db_name'
";
echo $html_footer;
exit;
}
$result1 = mysql_list_tables ($db_name);
$i = 0;
while ($i < mysql_num_rows ($result1)) {
$tb_names1 = mysql_tablename ($result1, $i);
if ($tb_names1==$table_ads){mysql_query("DROP TABLE $table_ads;"); }
$i++;
}
$sql_rs1=mysql_query("$sql_query1");
if (!($sql_rs1)){
echo $html_header;
echo "
Error in creating MySQL table '$table_ads'. <br> Check errors
in variable \$ads_fields (config.php file) for ads fields settings
";
echo $html_footer;
exit;
}
if ( $sql_rs1)
{
$message="
### ESTE MENSAJE SALE CUANDO LA TABLA HA SIDO CREADA BIEN ##
Table '$table_ads' was created successfully</b>
";
}
admin_message1($message);
exit;
}
function sql_create_tb()
{
global $ads_fields, $table_ads,$oldvrsn;
$table_name=$table_ads;
$db_t_fields['idnum']="integer not NULL primary key";
$db_t_fields['time']="integer";
$db_t_fields['exptime']="integer";
$db_t_fields['catname']="text";
$db_t_fields['visible']="integer";
$db_t_fields['adphotos']="char(5)";
$db_t_fields['login']="text";
$db_t_fields['adrate']="integer";
$db_t_fields['ipaddr1']="char(20)";
$db_t_fields['cntemll']="integer";
$db_t_fields['cntvstr']="integer";
$db_t_fields['ratevtcn']="integer";
$db_t_fields['ratevtrt']="real";
$db_t_fields['replyid']="integer";
$db_t_fields['replcnts']="integer";
$db_t_fields['adcommkey']="integer";
foreach ($ads_fields as $key => $value)
{
$db_t_fields[$key]=$ads_fields[$key][6];
}
$create_string="";
foreach ($db_t_fields as $db_key => $value)
{
$create_string=$create_string.$db_key." ".$db_t_fields[$db_key].", ";
}
$create_string=corr_sqlstring($create_string);
$sql="create table $table_name ( $create_string ) ";
return $sql;
}
function admin_message1($message)
{
global $cat_fields, $photos_count, $html_header, $html_footer, $id,
$ct, $categories, $ad_second_width, $left_width_sp, $exp_period;
echo $html_header;
echo "
$message
";
echo $html_footer;
exit;
}
function printpasswordform($inc_passw)
{
global $html_header, $html_footer;
echo $html_header;
echo "
########### AQUI PONEN EL FORUMUARIO DE ACCESO DE ADMIN ##############
########### PARA INSTALAR LA TABLA ##############
";
echo $html_footer;
exit;
}
?>
-----------------------------------------------
EL ARCHIVO 2 es el que gestiona el sistema de anuncios:
<?
function get_short_date($time1)
{ global $months_short;
$months=$months_short;
$d=getdate($time1);
$d2=$d['mon'];
$date_string=$months[$d2-1]." ".$d['mday'];
return $date_string;
}
function get_ads_count()
{
global $cat_fields, $table_ads, $ct, $page, $adsonpage, $html_header,
$html_footer;
$where_string=get_where_string();
$sql_query="select count(idnum) from $table_ads where
$where_string ";
if( !($sql_res=@mysql_query("$sql_query")))
{echo $html_header;
echo "
Error in connecting to ads MySQL table '$table_ads'
Seems, this table is not created,
click here to create this table.
";
echo $html_footer;
exit;
}
$row=mysql_fetch_row($sql_res);
$count=$row[0];
return $count;
}
(AQUI HAY MAS CODIGO BLA BLA BLA )
function start()
{
global $ct,$ads_fields,$categories, $ads_count, $cat_fields,$fields_sets,$allcatfields;
connect_to_db();
$c_res1=0;
foreach ($categories as $key => $value)
{
if ($key == $ct ){$c_res1=1;}
}
if ($c_res1==0){
if ($ct !=""){
echo $html_header;
echo " Incorrect Category ";
echo $html_footer;
exit;
}
}
getfldlst();
$ads_count=get_ads_count();
}
function getfldlst()
{
global $ct,$ads_fields,$categories, $ads_count, $cat_fields,$fields_sets,$allcatfields;
if ($ct!="")
{
$a1=$categories[$ct][1];
$a2=$fields_sets[$a1];
}
else
{$a2=$allcatfields;}
foreach ($a2 as $a2_value)
{
$cat_fields[$a2_value]=$ads_fields[$a2_value];
}
}
function corr_sqlstring($string1)
{
$string1=$string1."fdspkdsnbf";
$db_dcf=", fdspkdsnbf";
$string1=ereg_replace($db_dcf,"",$string1);
return $string1;
}
function connect_to_db()
{
global $host_name, $db_user,$db_password, $html_header,
$html_footer, $db_name, $table_ads;
######### por aqui esta el error #######################
if (!(@mysql_connect("$host_name","$db_user","$db_password")))
{echo $html_header;
echo "
Error in connecting to your MySQL server.
";
echo $html_footer;
exit;
}
if (!(@mysql_select_db("$db_name")))
{echo $html_header;
echo "
Error in connecting to your MySQL database <font color='#000099'>'$db_name'</font>.
";
echo $html_footer;
exit;
}
}
?> 
