webForumDet fria alternativet
Logga in / Bli medlem

Nyheter med email, länkaroch sökmotor. Allt mot MySQL

PHP

0 svar · 1 387 visningar · startad av kallet

kalletMedlem sedan nov. 20014 inlägg
Frågan#1

Här kommer ett par filer som du kan använda dig av. de är mycket lätta att konfigurera hoppas jag! håll till godo!

------------------------
Skapa följande MySQL tabell (obs du måste först skapa en databas (CREATE DATABASE nyheter;)):
------------------------

CREATE TABLE nyheter (
id int(10) unsigned NOT NULL auto_increment,
datum text NOT NULL,
rb text NOT NULL,
vidarelink text NOT NULL,
filnamn text NOT NULL,
extern text NOT NULL,
text text NOT NULL,
upphov text NOT NULL,
link text NOT NULL,
email text NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) TYPE=MyISAM COMMENT='upphov Kalle Thyselius';

----------------------
//döp denna fil till index.php

<html>
<head>
<title>Nyheter</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="/textdec.css" type="text/css">
<style type="text/css">
<!--
.textdec { font-family: Verdana, Arial, Helvetica, sans-serif; text-decoration: none}
-->
</style>
</head>

<body bgcolor="#FFFFFF" text="#000000">

<table width="500" border="0" cellspacing="0" cellpadding="0">

<?php
$server="min.sqlserver.com";
$user="mitt användarnamn";
$pass="mitt lösenord";

$flashbase="min_databas";
$pil = "URLen till en eventuell bild som kommer stå till vänster om datumet. Ett indrag på 3% görs för hela texten";

// nu behöver du troligtvis inte ändra mer

$bilz_table="nyheter";
$hookup = mysql_connect($server, $user, $pass);

mysql_select_db($flashbase,$hookup);

$result = mysql_query("SELECT * FROM $bilz_table ORDER BY id DESC LIMIT 0,10",$hookup);

echo "
<tr>

		\<td width='65%' valign='top'\>
		\<form name='searchform' method='get' action='http://www.mindomän.se/sokresultat.php'\>
		\<font face='Verdana, Arial, Helvetica, sans-serif' color='#336699' size='1'\>s&ouml;k efter 
		nyhet\<font color='#000000'\>&nbsp;&#0124;&nbsp;\<a href='http://www.mindomän.se/allanyheter.php'\>\<font color='#336699'\>visa alla nyheter\</font\>\</a\> 
		\<input type='text' name='sokfalt'\>
		\<input type='submit' name='sok' value='s&ouml;k'\>
		\</form\>
		
		
		\<td width='60%'\>
		\<font\>&nbsp;\</font\>
		\</td\>
		
\</tr\>\</table\>";

?>

<tr>
<td width="3%" height="30"> </td>
<td width="97%" height="30"><font face="Arial, Helvetica, sans-serif" size="2">MOTOCLUB
NEWS </font></td>
</tr>
<?php
echo "<table width='500' border='0' cellspacing='0' cellpadding='0'>";
for ($a=0; $a<mysql_num_rows($result); $a++)
{
$datum = "";
$text = "";
$upphov = "";
$email = "";
$rb = "";
$extern = "";
$vidarelink = "";
$link = "";
$filnamn = "";
$alla = "";

$datum .= "\<b\>" . mysql_result($result, $a, "datum") . "\</b\>";
$email .= mysql_result($result, $a, "email");
$link .= mysql_result($result, $a, "link");
$text .= "\<br\>" . "" . mysql_result($result, $a, "text");
$upphov .= mysql_result($result, $a, "upphov");
$rb .= mysql_result($result, $a, "rb");
$extern .= mysql_result($result, $a, "extern");
$vidarelink .= mysql_result($result, $a, "vidarelink");
$filnamn .= mysql_result($result, $a, "filnamn");

	echo "\<tr\>\<td width='3%'\>\<img src='$pil'\>" . "&nbsp;\</td\>";
	echo "\<td width='97%' valign='bottom'\>\<font face='Arial, Helvetica, sans-serif' color='#336699' size='1'\>$datum\</font\>\</td\>";
	echo "\<tr\>\<td width='3%'valign='top'\>&nbsp;\</td\>\<td width='97%' valign='top'\>\<font face='Arial, Helvetica, sans-serif' size='1'\>$text\</font\>\</td\>\</tr\>";
	echo "\<tr\>\<td width='3%'valign='top'\>&nbsp;\</td\>\<td width='97%' valign='top'\>\<a style='text-decoration: none' href='mailto:$email'\>";
	echo "\<font size='1' face='Arial, Helvetica, sans-serif' color='#336699'\>$upphov\</font\>" . "\</a\>";
 	
			if ($rb == '1')
				{
				echo "\<br\>";
				}
			if ($rb == '2')
				{
				echo "\<font size='1' face='Arial, Helvetica, sans-serif' color='#000000'\>&nbsp;&#0124;&nbsp;\</font\>";
				echo "\<a href ='$extern' style='text-decoration: none' target='\_blank'\>\<font size='1' face='Arial, Helvetica, sans-serif' color='#336699'\>$extern\</font\>\</a\>\<br\>";
				}
			if ($rb == '3')
				{
				echo "\<font size='1' face='Arial' color='#000000'\>&nbsp;&#0124;&nbsp;\</font\>";
				echo "\<a style='text-decoration: none' href=$vidarelink\>\<font size='1' face='Arial, Helvetica, sans-serif' color='#336699'\>\>\>\>\</font\>\</a\>\<br\>";
				}
			if ($rb == '4')
				{
				echo "\<font size='1' family='Verdana, Arial, Helvetica, sans-serif'color='#000000'\>&nbsp;&#0124;&nbsp;\</font\>";
				echo "\<a style='text-decoration: none' href='$filnamn' target='\_blank''\>\<font size='1' face='Arial, Helvetica, sans-serif' color='#336699'\>\>\>\>\</font\>\</a\>\<br\>";
				}
 }

?>

</table>
</body>
</html>

-----------------------------------
// Döp denna fil till sokresultat.php
<html>
<head>
<title>Sökresultat</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="/textdec.css" type="text/css">
<style type="text/css">
<!--
.textdec { font-family: Verdana, Arial, Helvetica, sans-serif; text-decoration: none}
-->
</style>
</head>

<body bgcolor="#FFFFFF" text="#000000">

<table width="500" border="0" cellspacing="0" cellpadding="0">

  \<?php

$server="min.sqlserver.com";
$user="mitt användarnamn";
$pass="mitt lösenord";

$flashbase="min_databas";
$pil = "URLen till en eventuell bild som kommer stå till vänster om datumet. Ett indrag på 3% görs för hela texten";
$hookup = mysql_connect($server, $user, $pass);

mysql_select_db($flashbase,$hookup);

$result = mysql_query("SELECT * FROM $bilz_table WHERE text LIKE '%$sokfalt%' ORDER BY id DESC LIMIT 0,10",$hookup);

\<tr\>
		
		\<td width='65%' valign='top'\>
		\<form name='searchform' method='get' action='http://www.kallet.net/ktm/sokresultat.php'\>
		\<font face='Verdana, Arial, Helvetica, sans-serif' color='#336699' size='1'\>s&ouml;k efter 
		nyhet\<font color='#000000'\>&nbsp;&#0124;&nbsp;\<a href='allanyheter.php'\>\<font color='#336699'\>visa alla nyheter\</font\>\</a\> 
		\<input type='text' name='sokfalt'\>
		\<input type='submit' name='sok' value='s&ouml;k'\>
		\</form\>
		
		
		\<td width='60%'\>
		\<font\>&nbsp;\</font\>
		\</td\>
		
\</tr\>\</table\>";

?>

<tr>
<td width="3%" height="30"> </td>
<td width="97%" height="30"><font face="Arial, Helvetica, sans-serif" size="2">SÖKRESULTAT FÖR <b><?php echo $sokfalt; ?></b> </font></td>
</tr>
<?php
echo "<table width='500' border='0' cellspacing='0' cellpadding='0'>";
for ($a=0; $a<mysql_num_rows($result); $a++)
{
$datum = "";
$text = "";
$upphov = "";
$email = "";
$rb = "";
$extern = "";
$vidarelink = "";
$link = "";
$filnamn = "";
$alla = "";

$datum .= "\<b\>" . mysql_result($result, $a, "datum") . "\</b\>";
$email .= mysql_result($result, $a, "email");
$link .= mysql_result($result, $a, "link");
$text .= "\<br\>" . "" . mysql_result($result, $a, "text");
$upphov .= mysql_result($result, $a, "upphov");
$rb .= mysql_result($result, $a, "rb");
$extern .= mysql_result($result, $a, "extern");
$vidarelink .= mysql_result($result, $a, "vidarelink");
$filnamn .= mysql_result($result, $a, "filnamn");

	echo "\<tr\>\<td width='3%'\>\<img src='$pil'\>" . "&nbsp;\</td\>";
	echo "\<td width='97%' valign='bottom'\>\<font face='Arial, Helvetica, sans-serif' color='#336699' size='1'\>$datum\</font\>\</td\>";
	echo "\<tr\>\<td width='3%'valign='top'\>&nbsp;\</td\>\<td width='97%' valign='top'\>\<font face='Arial, Helvetica, sans-serif' size='1'\>$text\</font\>\</td\>\</tr\>";
	echo "\<tr\>\<td width='3%'valign='top'\>&nbsp;\</td\>\<td width='97%' valign='top'\>\<a style='text-decoration: none' href='mailto:$email'\>";
	echo "\<font size='1' face='Arial, Helvetica, sans-serif' color='#336699'\>$upphov\</font\>" . "\</a\>";
 	
			if ($rb == '1')
				{
				echo "\<br\>";
				}
			if ($rb == '2')
				{
				echo "\<font size='1' face='Arial, Helvetica, sans-serif' color='#000000'\>&nbsp;&#0124;&nbsp;\</font\>";
				echo "\<a href ='$extern' style='text-decoration: none' target='\_blank'\>\<font size='1' face='Arial, Helvetica, sans-serif' color='#336699'\>$extern\</font\>\</a\>\<br\>";
				}
			if ($rb == '3')
				{
				echo "\<font size='1' face='Arial' color='#000000'\>&nbsp;&#0124;&nbsp;\</font\>";
				echo "\<a style='text-decoration: none' href=$vidarelink\>\<font size='1' face='Arial, Helvetica, sans-serif' color='#336699'\>\>\>\>\</font\>\</a\>\<br\>";
				}
			if ($rb == '4')
				{
				echo "\<font size='1' family='Verdana, Arial, Helvetica, sans-serif'color='#000000'\>&nbsp;&#0124;&nbsp;\</font\>";
				echo "\<a style='text-decoration: none' href='$filnamn' target='\_blank''\>\<font size='1' face='Arial, Helvetica, sans-serif' color='#336699'\>\>\>\>\</font\>\</a\>\<br\>";
				}
 }

?>

</table>
</body>
</html>

--------------------------
//döp denna fil till allanyheter.php

<html>
<head>
<title>alla nyheter</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="/textdec.css" type="text/css">
<style type="text/css">
<!--
.textdec { font-family: Verdana, Arial, Helvetica, sans-serif; text-decoration: none}
-->
</style>
</head>

<body bgcolor="#FFFFFF" text="#000000">

<table width="500" border="0" cellspacing="0" cellpadding="0">

  \<?php

$server="min.sqlserver.com";
$user="mitt användarnamn";
$pass="mitt lösenord";

$flashbase="min_databas";
$pil = "URLen till en eventuell bild som kommer stå till vänster om datumet. Ett indrag på 3% görs för hela texten";
$hookup = mysql_connect($server, $user, $pass);

mysql_select_db($flashbase,$hookup);

$result = mysql_query("SELECT * FROM $bilz_table ORDER BY id DESC",$hookup);

$pil = "http://www.kallet.net/ktm/pil.gif";
echo "
<tr>

		\<td width='65%' valign='top'\>
		\<form name='searchform' method='get' action='http://www.mindomän.se/sokresultat.php'\>
		\<font face='Verdana, Arial, Helvetica, sans-serif' color='#336699' size='1'\>s&ouml;k efter 
		nyhet\<font color='#000000'\>&nbsp;&#0124;&nbsp;\<a href='http://www.mindomän.se/allanyheter.php'\>\<font color='#336699'\>visa alla nyheter\</font\>\</a\> 
		\<input type='text' name='sokfalt'\>
		\<input type='submit' name='sok' value='s&ouml;k'\>
		\</form\>
		
		
		\<td width='60%'\>
		\<font\>&nbsp;\</font\>
		\</td\>
		
\</tr\>\</table\>";

?>

<tr>
<td width="3%" height="30"> </td>
<td width="97%" height="30"><font face="Arial, Helvetica, sans-serif" size="2">MOTOCLUB
NEWS </font></td>
</tr>
<?php
echo "<table width='500' border='0' cellspacing='0' cellpadding='0'>";
for ($a=0; $a<mysql_num_rows($result); $a++)
{
$datum = "";
$text = "";
$upphov = "";
$email = "";
$rb = "";
$extern = "";
$vidarelink = "";
$link = "";
$filnamn = "";
$alla = "";

$datum .= "\<b\>" . mysql_result($result, $a, "datum") . "\</b\>";
$email .= mysql_result($result, $a, "email");
$link .= mysql_result($result, $a, "link");
$text .= "\<br\>" . "" . mysql_result($result, $a, "text");
$upphov .= mysql_result($result, $a, "upphov");
$rb .= mysql_result($result, $a, "rb");
$extern .= mysql_result($result, $a, "extern");
$vidarelink .= mysql_result($result, $a, "vidarelink");
$filnamn .= mysql_result($result, $a, "filnamn");

	echo "\<tr\>\<td width='3%'\>\<img src='$pil'\>" . "&nbsp;\</td\>";
	echo "\<td width='97%' valign='bottom'\>\<font face='Arial, Helvetica, sans-serif' color='#336699' size='1'\>$datum\</font\>\</td\>";
	echo "\<tr\>\<td width='3%'valign='top'\>&nbsp;\</td\>\<td width='97%' valign='top'\>\<font face='Arial, Helvetica, sans-serif' size='1'\>$text\</font\>\</td\>\</tr\>";
	echo "\<tr\>\<td width='3%'valign='top'\>&nbsp;\</td\>\<td width='97%' valign='top'\>\<a style='text-decoration: none' href='mailto:$email'\>";
	echo "\<font size='1' face='Arial, Helvetica, sans-serif' color='#336699'\>$upphov\</font\>" . "\</a\>";
 	
			if ($rb == '1')
				{
				echo "\<br\>";
				}
			if ($rb == '2')
				{
				echo "\<font size='1' face='Arial, Helvetica, sans-serif' color='#000000'\>&nbsp;&#0124;&nbsp;\</font\>";
				echo "\<a href ='$extern' style='text-decoration: none' target='\_blank'\>\<font size='1' face='Arial, Helvetica, sans-serif' color='#336699'\>$extern\</font\>\</a\>\<br\>";
				}
			if ($rb == '3')
				{
				echo "\<font size='1' face='Arial' color='#000000'\>&nbsp;&#0124;&nbsp;\</font\>";
				echo "\<a style='text-decoration: none' href=$vidarelink\>\<font size='1' face='Arial, Helvetica, sans-serif' color='#336699'\>\>\>\>\</font\>\</a\>\<br\>";
				}
			if ($rb == '4')
				{
				echo "\<font size='1' family='Verdana, Arial, Helvetica, sans-serif'color='#000000'\>&nbsp;&#0124;&nbsp;\</font\>";
				echo "\<a style='text-decoration: none' href='$filnamn' target='\_blank''\>\<font size='1' face='Arial, Helvetica, sans-serif' color='#336699'\>\>\>\>\</font\>\</a\>\<br\>";
				}
 }

?>

</table>
</body>
</html>

-------------------------
Det borde göra det! Du måste ändra alla http://www.mindomän.se/....php till din sökväg.

------------------
//kalle//

281 ms totalt · 4 externa anrop · v20260731065814-full.a51de22e
133 ms — deklarationer (db)
0 ms — hämta statistik (cache)
145 ms — hämta tråd, inlägg och bilagor (db)
133 ms — ändringar (db)