webForumDet fria alternativet

ASP till PHP

3 svar · 202 visningar · startad av Squid

SquidMedlem sedan aug. 200228 inlägg
#1

kan någon hjälpa mig med att få den är att bli i php kod den ska arbeta med mysql databas.

<%

IF Request.Querystring("kat") = "" then
kat = "index"
ELSE
kat = Request.Querystring("kat")
END IF

If kat = "index" Then
SQL = "Select TOP 10 * From pc ORDER BY ID DESC"
ElseIf kat = "a" Then
SQL = "Select * From pc Where kat= 'a' ORDER BY fusk_namn asc"
ElseIf kat = "b" Then
SQL = "Select * From pc Where kat= 'b' ORDER BY fusk_namn asc"
ElseIf kat = "c" Then
SQL = "Select * From pc Where kat= 'c' ORDER BY fusk_namn asc"
ElseIf kat = "d" Then
SQL = "Select * From pc Where kat= 'd' ORDER BY fusk_namn asc"
ElseIf kat = "e" Then
SQL = "Select * From pc Where kat= 'e' ORDER BY fusk_namn asc"
ElseIf kat = "f" Then
SQL = "Select * From pc Where kat= 'f' ORDER BY fusk_namn asc"
ElseIf kat = "g" Then
SQL = "Select * From pc Where kat= 'g' ORDER BY fusk_namn asc"
ElseIf kat = "h" Then
SQL = "Select * From pc Where kat= 'h' ORDER BY fusk_namn asc"
ElseIf kat = "i" Then
SQL = "Select * From pc Where kat= 'i' ORDER BY fusk_namn asc"
ElseIf kat = "j" Then
SQL = "Select * From pc Where kat= 'j' ORDER BY fusk_namn asc"
ElseIf kat = "k" Then
SQL = "Select * From pc Where kat= 'k' ORDER BY fusk_namn asc"
ElseIf kat = "l" Then
SQL = "Select * From pc Where kat= 'l' ORDER BY fusk_namn asc"
ElseIf kat = "m" Then
SQL = "Select * From pc Where kat= 'm' ORDER BY fusk_namn asc"
ElseIf kat = "n" Then
SQL = "Select * From pc Where kat= 'n' ORDER BY fusk_namn asc"
ElseIf kat = "o" Then
SQL = "Select * From pc Where kat= 'o' ORDER BY fusk_namn asc"
ElseIf kat = "p" Then
SQL = "Select * From pc Where kat= 'p' ORDER BY fusk_namn asc"
ElseIf kat = "q" Then
SQL = "Select * From pc Where kat= 'q' ORDER BY fusk_namn asc"
ElseIf kat = "r" Then
SQL = "Select * From pc Where kat= 'r' ORDER BY fusk_namn asc"
ElseIf kat = "s" Then
SQL = "Select * From pc Where kat= 's' ORDER BY fusk_namn asc"
ElseIf kat = "t" Then
SQL = "Select * From pc Where kat= 't' ORDER BY fusk_namn asc"
ElseIf kat = "u" Then
SQL = "Select * From pc Where kat= 'u' ORDER BY fusk_namn asc"
ElseIf kat = "v" Then
SQL = "Select * From pc Where kat= 'v' ORDER BY fusk_namn asc"
ElseIf kat = "w" Then
SQL = "Select * From pc Where kat= 'w' ORDER BY fusk_namn asc"
ElseIf kat = "x" Then
SQL = "Select * From pc Where kat= 'x' ORDER BY fusk_namn asc"
ElseIf kat = "y" Then
SQL = "Select * From pc Where kat= 'y' ORDER BY fusk_namn asc"
ElseIf kat = "z" Then
SQL = "Select * From pc Where kat= 'z' ORDER BY fusk_namn asc"
ElseIf kat = "å" Then
SQL = "Select * From pc Where kat= 'å' ORDER BY fusk_namn asc"
ElseIf kat = "ä" Then
SQL = "Select * From pc Where kat= 'ä' ORDER BY fusk_namn asc"
ElseIf kat = "ö" Then
SQL = "Select * From pc Where kat= 'ö' ORDER BY fusk_namn asc"
End If

Set rs= Conn.execute(SQL)
If not rs.eof Then
Do until rs.eof
%>
<a href="pc_consol_fusk_read.asp?ID=<%= rs("ID") %>"><%= rs("fusk_namn") %></a><br>
<%
rs.movenext
Loop
rs.Close
Set rs = Nothing
end if
%>

UlfTMedlem sedan maj 20016 050 inlägg
#2

Jag kan inte hjälpa dig med det du frågar efter, men jag kunde inte låta bli att notera hela harangen av "elseif" som du använder för att bygga upp din sql-sats. Skriv istället:

If kat="index" Then
  SQL = "Select TOP 10 * From pc ORDER BY ID DESC"
Else
  SQL = "Select * From pc Where kat='" & kat & "' ORDER BY fusk_namn asc"
End If
Fredde MannenMedlem sedan nov. 20013 498 inlägg
#3

Mamma mia va mycke If satser!!! =)

Hmm... ska väl kunna hjälpa dig lite granna!!! :e

<%
IF Request.Querystring("kat") = "" then
kat = "index"
ELSE
kat = Request.Querystring("kat")
END IF
%>

<?php
// Då kör vi!!!
If($HTTP_GET_VARS["kat"] == "") {
$kat = "index";
} else {
$kat = $HTTP_GET_VARS["kat"];
}
?>

=================================
Den andra delen var det så mycke if-satser!!! :e
Kan väl göras så här på ett förkortat sätt!!!

<?php
If($kat == "index") {
$SQL = "SELECT TOP10 * FROM pc ORDER BY ID DESC";
} else {
$SQL = "SELECT * From pc WHERE kat='$kat' ORDER BY fusk_namn asc";
}
?>

Nästa del....
<%
Set rs= Conn.execute(SQL)
If not rs.eof Then
Do until rs.eof
%>
<a href="pc_consol_fusk_read.asp?ID=<%= rs("ID") %>"><%= rs("fusk_namn") %></a><br>
<%
rs.movenext
Loop
rs.Close
Set rs = Nothing
end if
%>

<?php
$result=mysql_query( $SQL );
While( $rad=mysql_fetch_array( $result ) ) {

$ID=rad["ID"];
$fusk_namn=rad["fusk_namn"];

echo "<a href=\"pc_consol_fusk_read.php?ID=".$ID."\">".$fusk_namn."</a></ br>";

}

?>

Kan hända att jag missat något då.. men men... :birp

==============================
If kat = "index" Then
SQL = "Select TOP 10 * From pc ORDER BY ID DESC"
ElseIf kat = "a" Then
SQL = "Select * From pc Where kat= 'a' ORDER BY fusk_namn asc"
ElseIf kat = "b" Then
SQL = "Select * From pc Where kat= 'b' ORDER BY fusk_namn asc"
ElseIf kat = "c" Then
SQL = "Select * From pc Where kat= 'c' ORDER BY fusk_namn asc"
ElseIf kat = "d" Then
SQL = "Select * From pc Where kat= 'd' ORDER BY fusk_namn asc"
ElseIf kat = "e" Then
SQL = "Select * From pc Where kat= 'e' ORDER BY fusk_namn asc"
ElseIf kat = "f" Then
SQL = "Select * From pc Where kat= 'f' ORDER BY fusk_namn asc"
ElseIf kat = "g" Then
SQL = "Select * From pc Where kat= 'g' ORDER BY fusk_namn asc"
ElseIf kat = "h" Then
SQL = "Select * From pc Where kat= 'h' ORDER BY fusk_namn asc"
ElseIf kat = "i" Then
SQL = "Select * From pc Where kat= 'i' ORDER BY fusk_namn asc"
ElseIf kat = "j" Then
SQL = "Select * From pc Where kat= 'j' ORDER BY fusk_namn asc"
ElseIf kat = "k" Then
SQL = "Select * From pc Where kat= 'k' ORDER BY fusk_namn asc"
ElseIf kat = "l" Then
SQL = "Select * From pc Where kat= 'l' ORDER BY fusk_namn asc"
ElseIf kat = "m" Then
SQL = "Select * From pc Where kat= 'm' ORDER BY fusk_namn asc"
ElseIf kat = "n" Then
SQL = "Select * From pc Where kat= 'n' ORDER BY fusk_namn asc"
ElseIf kat = "o" Then
SQL = "Select * From pc Where kat= 'o' ORDER BY fusk_namn asc"
ElseIf kat = "p" Then
SQL = "Select * From pc Where kat= 'p' ORDER BY fusk_namn asc"
ElseIf kat = "q" Then
SQL = "Select * From pc Where kat= 'q' ORDER BY fusk_namn asc"
ElseIf kat = "r" Then
SQL = "Select * From pc Where kat= 'r' ORDER BY fusk_namn asc"
ElseIf kat = "s" Then
SQL = "Select * From pc Where kat= 's' ORDER BY fusk_namn asc"
ElseIf kat = "t" Then
SQL = "Select * From pc Where kat= 't' ORDER BY fusk_namn asc"
ElseIf kat = "u" Then
SQL = "Select * From pc Where kat= 'u' ORDER BY fusk_namn asc"
ElseIf kat = "v" Then
SQL = "Select * From pc Where kat= 'v' ORDER BY fusk_namn asc"
ElseIf kat = "w" Then
SQL = "Select * From pc Where kat= 'w' ORDER BY fusk_namn asc"
ElseIf kat = "x" Then
SQL = "Select * From pc Where kat= 'x' ORDER BY fusk_namn asc"
ElseIf kat = "y" Then
SQL = "Select * From pc Where kat= 'y' ORDER BY fusk_namn asc"
ElseIf kat = "z" Then
SQL = "Select * From pc Where kat= 'z' ORDER BY fusk_namn asc"
ElseIf kat = "å" Then
SQL = "Select * From pc Where kat= 'å' ORDER BY fusk_namn asc"
ElseIf kat = "ä" Then
SQL = "Select * From pc Where kat= 'ä' ORDER BY fusk_namn asc"
ElseIf kat = "ö" Then
SQL = "Select * From pc Where kat= 'ö' ORDER BY fusk_namn asc"
End If

Set rs= Conn.execute(SQL)
If not rs.eof Then
Do until rs.eof
%>
<a href="pc_consol_fusk_read.asp?ID=<%= rs("ID") %>"><%= rs("fusk_namn") %></a><br>
<%
rs.movenext
Loop
rs.Close
Set rs = Nothing
end if
%>

Fredde MannenMedlem sedan nov. 20013 498 inlägg
#4

just det... kan ju vara bra att veta hur man kopplar upp sig mot Mysql-databasen!! =)

<?php
@mysql_connect("localhost", "användarnamn","lösenord");
mysql_select_db("dbnamn");
?>

ti hi!!! :OO

Genererad på 506 ms · cache AV · v20260730165559-full.f96bc7eb