Html code in Mysql

_vlada_ Peon

Messages:: 743

Likes Received:: 57

Best Answers:: 0

Trophy Points:: 0

#1

Hello!

Trying to import text file in database with html codes in some fields and I need them to be displayed as html again.

example: digital point

but, I always get displayed only digital point, without 

I checked database and I see html codes but, they wont be rendered.
When I open page source in web browser html codes are not available.

Do I need to import in another way, or I need editing of some php file regarding pulling information from database to html code be displayed?

_vlada_, Nov 10, 2009 IP

krishmk Well-Known Member

Messages:: 1,376

Likes Received:: 40

Best Answers:: 0

Trophy Points:: 185

#2

You say that you can see the "html tags" stored in your database table.
Maybe the script which pulls out the data from your database is stripping html tags.
Did you check that file?

If you can post the source code of the file that grabs data and outputs to browser - you can get better response.

krishmk, Nov 10, 2009 IP

_vlada_ Peon

Messages:: 743

Likes Received:: 57

Best Answers:: 0

Trophy Points:: 0

#3

thanks krishmk for response. Yes I can see code as I see it in simply html page: <li> etc....

there are bunch of php files, but since I do not have a clue about php I think it is in "common.php" file. Here it is:

<?php

function get_file_list($directory)
{

$files = array();

$fp = opendir($directory);
while ($filename = readdir($fp))
{
if (is_dir("$directory/$filename")) continue;

if ($filename != "." && $filename != "..")
{
$tmp['filename'] = $filename;
$tmp['last_modified'] = filemtime("$directory/$filename");
$files[] = $tmp;
}
}
closedir($fp);

return ($files);

}

function print_z($array)
{

$x = print_r($array, TRUE);
$lines = explode(chr(10),$x);
foreach ($lines as $line)
{
echo "$line \n";
}

}

//--------------------------------------------//
// function custom_get($get_var, $default="") //
//--------------------------------------------//

function custom_get($get_var, $default="")
{

$value = $default;

if (!get_magic_quotes_gpc()) {
if (isset($_GET["$get_var"])) {$value = addslashes($_GET["$get_var"]);}
} else {
if (isset($_GET["$get_var"])) {$value = $_GET["$get_var"];}
}

return($value);

}

//---------------------------------------------//
// function custom_post($get_var, $default="") //
//---------------------------------------------//

function custom_post($get_var, $default="")
{

$value = $default;

if (!get_magic_quotes_gpc()) {
if (isset($_POST["$get_var"])) {$value = addslashes($_POST["$get_var"]);}
} else {
if (isset($_POST["$get_var"])) {$value = $_POST["$get_var"];}
}

return($value);

}

class Template {

var $vars;

function Template($file = null) {
$this->file = $file;
}

function set($name, $value) {
$this->vars[$name] = is_object($value) ? $value->fetch() : $value;
}

function fetch($file = null) {
if(!$file) $file = $this->file;

extract($this->vars);
ob_start();
include($file);
$contents = ob_get_contents();
ob_end_clean();
return $contents;
}
}

//--------------------------------------------//
// function database_inquiry ($query, &$rows) //
//--------------------------------------------//

function database_inquiry ($query, &$rows)
{
global $cfg;

$mydb = @mysql_connect($cfg['hostname'], $cfg['username'], $cfg['password']) or die("Unable to connect to database ".mysql_error());
mysql_select_db($cfg['database'], $mydb);
$result = mysql_query($query) or die ("There is a problem with the database ".mysql_error().$query);

$rows = array();

while($row = mysql_fetch_assoc($result))
{
$rows[] = $row;
}

return mysql_num_rows($result);
}

//------------------------------------------------//
// function database_update ($query, &$insert_id) //
//------------------------------------------------//

function database_update ($query, &$insert_id)
{
global $cfg;

if ($cfg['demo'] == 1) return (array());

$mydb = @mysql_connect($cfg['hostname'], $cfg['username'], $cfg['password']) or die("Unable to connect to database ".mysql_error());
mysql_select_db($cfg['database'], $mydb);
$result = mysql_query($query) or die ("There is a problem with the database ".mysql_error().$query);
$insert_id = mysql_insert_id();
return mysql_affected_rows();

}
?>
Click to expand...

_vlada_, Nov 10, 2009 IP

mwasif Active Member

Messages:: 816

Likes Received:: 23

Best Answers:: 1

Trophy Points:: 70

#4

Can you post the code of the page where you are facing the problem?

mwasif, Nov 10, 2009 IP

dhaval300 Peon

Messages:: 32

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#5

"There is a problem with the database "....u have to add like

"There is a problem with the database"." "." "

dhaval300, Nov 18, 2009 IP

Log in or Sign up

Html code in Mysql

_vlada_ Peon

krishmk Well-Known Member

_vlada_ Peon

mwasif Active Member

dhaval300 Peon

Useful Searches