mySQL database assistance needed :)

[disturbed]

I'm not very skilled in working with mysql, but i try I would really appreciate anyone willing to help me with this, its not really hard, but i still dont know how to do this....

I have a mysql database I want to print stuff out off - its simply a collection of data - so how would i go about printing this out in a webpage ?

[jay173]

export it to text and print it

[Swimmer]

do you mean make a physical copy or place the data into a webpage?

[disturbed]

just place data into a webpage

[Swimmer]

you are going to have to use a dymanic programming language.. like php, jsp, asp...  that will allow you to pull real time from the database and display it on the net.. you might want to check out the help section for website/programming

[disturbed]

yeah....im aware of that .... i was trying to use a php serverside script - the script goes something like the following

<?php

header("Content-type: text/xml");

$host = "localhost";

$user = "edited";

$pass = "edited";

$database = "edited";

$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host.");

mysql_select_db($database, $linkID) or die("Could not find database.");

$query = "SELECT * FROM `formNo1` WHERE 1";

$resultID = mysql_query($query, $linkID) or die("Data not found.");

$xml_output = "<?xml version="1.0"?>n";

$xml_output .= "<entries>n";

for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){

    $row = mysql_fetch_assoc($resultID);

    $xml_output .= "t<entry>n";

    $xml_output .= "tt<date>" . $row['date'] . "</date>n";

        // Escaping illegal characters

        $row['text'] = str_replace("&", "&", $row['text']);

        $row['text'] = str_replace("<", "<", $row['text']);

        $row['text'] = str_replace(">", ">", $row['text']);

        $row['text'] = str_replace(""", """, $row['text']);

    $xml_output .= "tt<text>" . $row['text'] . "</text>n";

    $xml_output .= "t</entry>n";

}

$xml_output .= "</entries>";

echo $xml_output;

?>

[disturbed]

In theory this should work .... shouldnt it ? - but no, all it does is just display a blank white page...

[php]

just change this section

    $xml_output .= "tt<date>" . $row['date'] . "</date>n";

        // Escaping illegal characters

        $row['text'] = str_replace("&", "&amp;", $row['text']);

        $row['text'] = str_replace("<", "&lt;", $row['text']);

        $row['text'] = str_replace(">", "&gt;", $row['text']);

    $xml_output .= "tt<text>" . $row['text'] . "</text>n";

[/php]

[disturbed]

ill give it a try right now

[disturbed]

no....doesn't seem to be working

[disturbed]

any idea ?

[Swimmer]

I dont know php i only jsp.. and that isnt very useful..

[php]

It worked on my server... could you paste the script you're using again?

also, you do have entries in the database, right?

[disturbed]

well after playing with it....i have gotten it to work to some extent - although now im having troubles organizing everything in tables ...... well, at least i have gotten past the mysql problems

[php]

you must be doing something different than I did... it's quite simple (or so I thought)

[disturbed]

what kind of tags does php take ? im having troubles organizing the data ?

[php]

maybe it's just that I'm tired, but I don't quite understand... are you having problems storing or retrieving the data? also... what this is being used for might help (if you don't mind mentioning)

[TriRan]

hrm i use this to store / retrieve a Team event list

BTW if you see some code in here thats not standard php its because im using this as a postnuke module

DBINFO

<?PHP

$db_host = 'localhost';

$db_name = 'edit';

$db_user = 'edit';

$db_pass = 'edit';

?>

[/code]


Index

[code]

mysql_connect($db_host,$db_user,$db_pass);

@mysql_select_db($db_name) or die( "Unable to select database");

$query="SELECT * FROM events";

$result=mysql_query($query);


$num=mysql_numrows($result);


mysql_close();