inserting information from another file as HTML

Dev Shed Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

September 17th, 2003, 03:47 PM

OoTOAoO

Junior Member

Join Date: Sep 2003

Posts: 4

Time spent in forums: < 1 sec
Reputation Power: 0

inserting information from another file as HTML

In php you would use the command:

PHP Code:


		
			
<?php

        $lines = file ('links.txt');

        foreach ($lines as $line_num => $line) {

            echo ($line);

        }

    ?>

and this would allow me to insert the links.txt file in my current html file. Any suggestions on how to do this in ASP? Also any suggestions on how I could get this:

PHP Code:


		
			
<?php

       /* Connecting, selecting database */

        $link = mysql_connect("192.168.0.1", "root", "")

            or die("Could not connect : " . mysql_error());

        print "Warcraft 3: Frozen Throne Levels Loaded Successfully<br><br>";

        mysql_select_db("amx") or die("Could not select database");



        /* Performing SQL query */

        $query = "SELECT * FROM war3users";

        $result = mysql_query($query) or die("Query failed : " . mysql_error());



        /* Printing results in HTML */

        print "<table>\n";

        while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

           print "\t<tr>\n";

           foreach ($line as $col_value) {

               print "\t\t<td>$col_value</td>\n";

           }

           print "\t</tr>\n";

        }

        print "</table>\n";



        /* Free resultset */

        mysql_free_result($result);



        /* Closing connection */

        mysql_close($link);

    ?>

to work with asp? I installed Windows 2003 and to my knowledge it is not possible to get php to work yet.. and i need a solution.. so i'm turning to you guys.

Thanks,
Josh

September 17th, 2003, 04:01 PM

unatratnag

Average Intelligence

Join Date: Apr 2003

Location: Ohio/Chicago

Posts: 678

Time spent in forums: 10 m 22 sec
Reputation Power: 6

IIS is a webserver, PHP is application, you won't have any prohibitions to using PHP on IIS.

yes, i can rewrite all this code in asp, do you need that still when you can just run php?

September 17th, 2003, 04:16 PM

OoTOAoO

Junior Member

Join Date: Sep 2003

Posts: 4

Time spent in forums: < 1 sec
Reputation Power: 0

Yes could you please? Or at least the first, the mysql isn't as important...

September 17th, 2003, 04:53 PM

unatratnag

Average Intelligence

Join Date: Apr 2003

Location: Ohio/Chicago

Posts: 678

Time spent in forums: 10 m 22 sec
Reputation Power: 6

Dim fso, ts, s
Const ForReading = 1
Set fso = CreateObject("Scripting.FileSystemObject")
Set ts = fso.OpenTextFile("c:\testfile.txt", ForReading)
s = ts.Readall
Response.Write "File contents = '" & s & "'"
ts.Close

you can go line by line if you want, that's just .readline instead of .readall... pretty simple

You can use FSO to do other things too like write but just look stuff up on google if you have anyquestions on using it.

September 17th, 2003, 04:55 PM

unatratnag

Average Intelligence

Join Date: Apr 2003

Location: Ohio/Chicago

Posts: 678

Time spent in forums: 10 m 22 sec
Reputation Power: 6

database (i'm sure you can pick up on what's goin here, you'll obviously need to customize what you need to print in the loop and the sqlselect line):

dim strSQL, rs
Set con = server.createobject ("ADODB.Connection")
con.Open "odbc","login","password"
strSQL = "select * from actors"
set rs = con.Execute (strSQL)

while not rs.EOF
response.write RS("actor")
rs.MoveNext
Wend
rs.Close
con.close

September 17th, 2003, 08:11 PM

OoTOAoO

Junior Member

Join Date: Sep 2003

Posts: 4

Time spent in forums: < 1 sec
Reputation Power: 0

Something I just noticed.. I don't know if I should post here or not, but I am. I just installed windows 2003 standard. I then installed IIS 6.0 and ASP .NET. I then went to web services (under IIS manager) and allowed asp pages... but now i cannot load them. URL I get a 500 internal error... anyone familiar with this?

September 17th, 2003, 08:25 PM

unatratnag

Average Intelligence

Join Date: Apr 2003

Location: Ohio/Chicago

Posts: 678

Time spent in forums: 10 m 22 sec
Reputation Power: 6

PHP Code:


		
			
 Microsoft VBScript runtime error '800a0035' 



File not found 



/test.asp, line 8

that's your real error. Go to tool->internet options->advanced tab, and disable "how friendly error messages".

September 17th, 2003, 09:56 PM

OoTOAoO

Junior Member

Join Date: Sep 2003

Posts: 4

Time spent in forums: < 1 sec
Reputation Power: 0

Try to go there again.. it doesn't work for me.. it worked for like a split second...

September 17th, 2003, 10:54 PM

unatratnag

Average Intelligence

Join Date: Apr 2003

Location: Ohio/Chicago

Posts: 678

Time spent in forums: 10 m 22 sec
Reputation Power: 6

Microsoft VBScript runtime error '800a0035'

File not found

/test.asp, line 8

same thing, are you including a file or something and it's not there?

well in anycase, that's all i do is change the browser settings and i can see the error messages....

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: