|
php parse error
I am getting a parse error on line 1 unexpected $ and Have looked and looked and my blinders are up. Any suggestions
<?php
include_once('config.php');
global $db_list;
$db_list['db_name']=$weightlo['SQL_DB'];
$db_list['article']="asb_articles";
$db_list['tags']="asb_sourcetags";
$db_list['search']="asb_search";
$db_list['cat_articlecity']="asb_cat_articlecity";
$db_list['cat_ezinearticles']="asb_cat_ezinearticles";
$db_list['cat_goarticles']="asb_cat_goarticles";
function aconnect(){
global $db_list;
global $USER_VAR;
//$password="test123";
// Connect with the mySQL database
if (!$link = mysql_connect($USER_VAR['SQL_HOST'], $USER_VAR['SQL_USER'], $USER_VAR['SQL_PASS']))
{ echo mysql_error()."<br>";
die ("Could not connect");
return 0;
}
////print ("Connected successfully");
if (!mysql_select_db ($USER_VAR['SQL_DB']))
{echo mysql_error()."<br>";
die ("Could not select database");
return 0;
}
//echo "Connected!<br>";
return 1;
}
// Put search info into DB
function put_search_info($info)
{global $db_list;
//print_r($info);
$query = "INSERT INTO `".$db_list['search']."` (`total`, `output_dir`, `cat_ac`, `cat_ga`, `article_temp`, `index_temp`, `index_size`, `link_size`, `filter`) VALUES ('".$info['total']."', '".$info['output_dir']."', '".$info['cat_ac']."', '".$info['cat_ga']."', '".$info['article_temp']."', '".$info['index_temp']."', '".$info['index_size']."', '".$info['link_size']."', '".$info['filter']."')";
if (!doQuery($query))
{echo "Data not inserted into ".$db_list['search'].".<br>";//".$query."<br>";
return 0;
}
else return 1;
}//END put search info
function get_templates()
{aconnect();
global $db_list;
$query = "SELECT `article_temp`,`index_temp` FROM `".$db_list['search']."` LIMIT 0,100000";
doQuery($query);
global $result;
if (mysql_num_rows ($result)=="0"){return FALSE;}
while($res=mysql_fetch_array($result))
{//print_r($res);
//echo $res[0]."<br>";
$art[].=$res[0];
//echo $res[1]."<br>";
$ind[].=$res[1];
}
$full=array($art,$ind);
return $full;
}
// Write article info to the 'article' DB.
function put_article ($article_info)
{
// An array of the DB names
global $db_list;
//FIRST LOOK FOR URL in DB:
$query="SELECT `url` FROM `".$db_list['article']."` WHERE `url` = '".addslashes($article_info['url'])."'";
doQuery($query);
global $result;
$res=mysql_fetch_array($result);
if ($res[0]==addslashes($article_info['url'])){return;}
else {
$query = "INSERT INTO `".$db_list['article']."` (`url` , `title` , `author` , `article` , `resource_box`)
VALUES (
'".addslashes($article_info['url'])."', '".addslashes($article_info['title'])."', '".addslashes($article_info['author'])."', '".addslashes($article_info['text'])."', '".addslashes($article_info['resource_box'])."'
);";
if (!doQuery($query))
{echo "Data not inserted into ".$db_list['article'].".<br>";//".$query."<br>";
return 0;
}
else return 1;
}
}// END put_article
function get_sql ($query)
{//echo $query;
if (!$sql_res = mysql_query($query))
{echo "There was an error: <br>".mysql_error()."<br>";
return false;}
else return $sql_res;
}
function doQuery($query)
{
global $result;
////print"<br>++++++<br>".$query."<br>++++++<br>";
if (!$result = mysql_query($query))
{//echo ("doquery");
echo mysql_error().'<br><b>'.$query.'</b>';
return 0;
}
return 1;
}
function getRow($id)
{
aconnect();
$query=" SELECT *
FROM aa
WHERE id='$id'";
//echo $query;
if (!$result = mysql_query($query))
{
echo mysql_error().'<br>';
return 0;
}
return mysql_fetch_assoc($result);
}
?>
|