function import() { $app = JFactory::getApplication(); //DB Connection $Config = new JConfig(); $host = $Config->host; $user = $Config->user; $pass = $Config->password; $name = $Config->db; $prefix = $Config->dbprefix; $return = ""; $link = mysql_connect($host, $user, $pass); mysql_select_db($name, $link); if ($_FILES["file"]["error"] > 0) { $str = "Error: " . $_FILES["file"]["error"] . "<br />"; $app->enqueueMessage($str); } else { $str = "<br /><br />Upload: " . $_FILES["file"]["name"] . "<br />"; $str .= "Type: " . $_FILES["file"]["type"] . "<br />"; $str .= "Size: " . $_FILES["file"]["size"] / 1024 . " Kb<br />"; $str .= "Stored in: " . $_FILES["file"]["tmp_name"] . " <br /><br />"; $app->enqueueMessage($str); // let's pretend that connection to server is established // and database chosen... /*$sql = explode(';#%%', file_get_contents ($_FILES["file"]["tmp_name"])); $n = count ($sql) - 1; for ($i = 0; $i < $n; $i++) { $query = $sql[$i]; echo $query."<br>"; $result = mysql_query ($query) or die ('<p>Query: <br><tt>' . $query . '</tt><br>failed. MySQL error: ' . mysql_error()); } */ $file_content = file($_FILES["file"]["tmp_name"]); $cont = 0; foreach ($file_content as $sql_line) { if (trim($sql_line) != "" && strpos($sql_line, "--") == false) { //echo $sql_line.'<br/><br/>'; mysql_query($sql_line); $cont++; } } $app->enqueueMessage(JTEXT::_("IMPORT OK") . ":" . $cont . " SQL"); } // Load the submenu. fieldsattachHelper::addSubmenu(JRequest::getCmd('view', 'fieldsattach')); parent::display(); }