Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: Newst pobierają query z bazy danych Error
Forum PHP.pl > Forum > PHP
bagukan223
26.07.2012, 08:02:01
Witam to moja pierwsza wiadmość na tym forum...
potrzebowałem skrypt na newsy z mysql...
aż wkącu znalazłem ...
Ale te skrypty wywalają błąd ...

[PHP] pobierz, plaintext 
  1. Deprecated: Function mysql_db_query() is deprecated in /home/ahujciet/public_html/2/bb_news.php3 on line 47
  2.  
  3. Deprecated: mysql_db_query() [function.mysql-db-query]: This function is deprecated; use mysql_query() instead in /home/ahujciet/public_html/2/bb_news.php3 on line 47
  4. 07/26/2012 12:00 AM by ja haha.gif 
  5. chyba tytul 
  6.  ddsssaaserwrwerwer 
  7. Link
[PHP] pobierz, plaintext


nie wiem co jest ...
Newsy niby pokazuje...

Skrypty

bb_news_config.inc

[PHP] pobierz, plaintext 
  1. <?
  2.  
  3.  
  4. $bb_news_hostname = "xxx";
  5.  
  6. $bb_news_mysqluser = "xxx";
  7.  
  8. $bb_news_mysqlpassword = "xxx";
  9.  
  10. $bb_news_db = "xxx";
  11.  
  12. $bb_news_date_fn = "#FF3333";  		// Date #FF3333 = Red
  13. $bb_news_author_fn = "#FF3333";		// Author #FF3333 = Red
  14. $bb_news_subject_fn = "#0000FF";	// Subject #0000FF = Blue
  15. $bb_news_text_fn = "#000000";		// Text #000000 = Black
  16.  
  17.  
  18. $max_hits = 3;
  19. ?>
[PHP] pobierz, plaintext


bb_news.php3

[PHP] pobierz, plaintext 
  1. <?
  2.  
  3. require ("bb_news_config.inc");
  4. mysql_connect($bb_news_hostname,$bb_news_mysqluser,$bb_news_mysqlpassword)
  5.                or die("Unable to connect to SQL server");  // We do this to handle the errors
  6.  
  7.  
  8. $query = "select id, subject, news,  date_format(date, '%m/%d/%Y %h:%i %p') as date, author, link from news
  9.     order by id desc limit 5";   
  10.  
  11. $news =  mysql_db_query($bb_news_db, $query) or die("Select Failed!");
  12.  
  13. while ($row = mysql_fetch_array($news)) {
  14.  
  15.  
  16.  
  17. ?>
  18.  
  19. <font face="Arial, Helvetica, sans-serif" size="2">
  20. <font color="<? echo $bb_news_date_fn; ?> "><? echo $row['date']; ?></font> by <font color="<? echo $bb_news_author_fn; ?>"><? echo $row['author']; ?></font><br>
  21.                             <b><font color="<? echo $bb_news_subject_fn; ?>"><? echo $row['subject']; ?></font></b><br>
  22.                             <font color="<? echo $bb_news_text_fn; ?>">
  23. 							<? echo $row['news']; ?><br></font>
  24.                             <a href="<? echo $row['link']; ?>"><? echo $row['link']; ?></a></font> 
  25.                           </font></div><font face="Arial, Helvetica, sans-serif" size="2">
  26.                           <hr>
  27.  
  28. <?
  29.  
  30. // require ("bb_news.php3");
  31.  
  32.  } ?>
[PHP] pobierz, plaintext


z góry dzięki za pomoc smile.gif
Pozdrawiam

a zapomniał bym error admin/bb_news_admin.php3



Skrypt

admin/bb_news_admin.php3

[PHP] pobierz, plaintext 
  1. <?php
  2.  
  3. if ($action== "add"){ 
  4.  
  5.  
  6. 	require ("../bb_news_config.inc");
  7.  
  8.  
  9. 	$author = addslashes($author);
  10. 	$news = addslashes($news);
  11. 	$link = addslashes($link);
  12. 	$subject = addslashes($subject);
  13.  
  14. 	mysql_connect($bb_news_hostname,$bb_news_mysqluser,$bb_news_mysqlpassword)
  15. 	or die ("Problem connecting to DataBase");
  16.  
  17. 	$query = "insert into news values ('$id','$subject','$news',now(),'$author','$link')";
  18. 	$result = mysql_db_query($bb_news_db, $query); 
  19.  
  20. 	print "query result: \n <pre>$result</pre>\n";
  21. 	if($result != "1")
  22. 	{
  23. 	  $error = mysql_errno().": ".mysql_error();
  24. 	  print "There was an error inserting the data: <pre>$error</pre>\n";
  25. 	  print "use your back button and try again.\n";
  26. 	}
  27. 	else
  28. 	{
  29. 	  echo "Data inserted. new table:<br>";
  30. 	  ?><a href="bb_news_admin.php3">Press here to go back to the input page</a>"<?
  31. 	}
  32. }
  33. else if($action == "del")
  34. {
  35.   if($id == "")
  36.   {
  37.   	?>
  38. 			<h1>error</h1>
  39. 			Invlid ID
  40. 		<?
  41. 		exit;
  42.   }
  43.  
  44. 	require ("../bb_news_config.inc");
  45.  
  46. 	mysql_connect($bb_news_hostname,$bb_news_mysqluser,$bb_news_mysqlpassword)
  47. 		or die("Unable to connect to SQL server");  // We do this to handle the errors
  48. 	$query = "delete from news where id = '$id'";   
  49. 	$news =  mysql_db_query($bb_news_db, $query) or die("Delete Failed!");
  50. 	print "news item $id deleted\n";
  51. }
  52. else if($action == "view")
  53. {
  54.   if($id == "")
  55.   {
  56.   	?>
[PHP] pobierz, plaintext 


[PHP] pobierz, plaintext 
  1. 			<h1>error</h1>
  2. 			Invlid ID
  3. 		<?
  4. 		exit;
  5.   }
  6.  
  7. 	require ("../bb_news_config.inc");
  8.  
  9. 	mysql_connect($bb_news_hostname,$bb_news_mysqluser,$bb_news_mysqlpassword)
  10. 		or die("Unable to connect to SQL server");  // We do this to handle the errors
  11. 	$query = "select id, subject, news,  date_format(date, '%Y/%m/%d') as date, author, link from news
  12. 	where id = '$id'";   
  13. 	$news =  mysql_db_query($bb_news_db, $query) or die("Select Failed!");
  14. 	$row = mysql_fetch_array($news);
  15. ?>
  16. <font face="Arial, Helvetica, sans-serif" size="2">
  17. <font color="<? echo $bb_news_date_fn; ?> "><? echo $row['date']; ?></font> by <font color="<? echo $bb_news_author_fn; ?>"><? echo $row['author']; ?></font><br>
  18.   <b><font color="<? echo $bb_news_subject_fn; ?>"><? echo $row['subject']; ?></font></b><br>
  19.     <font color="<? echo $bb_news_text_fn; ?>">
  20.     <? echo $row['news']; ?><br></font>
  21.     <a href="<? echo $row['link']; ?>"><? echo $row['link']; ?></a></font> 
  22.     </font><font face="Arial, Helvetica, sans-serif" size="2">
  23. <hr>
  24. <?
  25. }
  26. else if($action == "viewedit")
  27. {
  28.  
  29.   require ("../bb_news_config.inc");
  30.  
  31.   mysql_connect($bb_news_hostname,$bb_news_mysqluser,$bb_news_mysqlpassword)
  32.     or die("Unable to connect to SQL server");  // We do this to handle the errors
  33.   $query = "select id, subject, news,  date_format(date, '%Y/%m/%d') as date, author, link from news
  34.   where id = '$id'";   
  35.   $news =  mysql_db_query($bb_news_db, $query) or die("Select Failed!");
  36.   $row = mysql_fetch_array($news);
  37.  
  38.   $subject = htmlentities($row['subject']);
  39.   $news = htmlentities($row['news']);
  40.   $author = htmlentities($row['author']);
  41.   $link = htmlentities($row['link']);
  42.  
  43.   ?>
  44.     <font face="Arial, Helvetica, sans-serif" size="4"><b><font color="#0066FF">
  45.     News Edit Form</font></b></font></p>
  46.  
  47. 	<form method="post" name="form1" action="bb_news_admin.php3">
  48. 		<INPUT NAME="id" TYPE=Hidden Value="<? echo $id ?>" Size="">
  49. 		<INPUT NAME="date" TYPE=Hidden Value=" " Size="">
  50. 		<INPUT NAME="action" TYPE=Hidden Value="edit" Size="">
  51. 		<font face="Arial, Helvetica, sans-serif">Subject: 
  52. 		<input type="text" name="subject" value="<? echo $subject ?>">
  53.          by: 
  54.         <input type="text" name="author" value="<? echo $author ?>"><br>
  55.          News:<br>
  56.         <textarea name="news" rows=30 cols=85><? echo $news ?></textarea><br>
  57.          Link 
  58.         <input type="text" name="link" size="30" value="<? echo $link ?>"></font><br>
  59.         <input type="submit" name="Submit" value="Submit">
  60.         <input type="reset" name="Submit2" value="Reset">
  61.         </form><P>
  62.   <?
  63.  
  64. }
  65. else if($action == "edit")
  66. {
  67.  
  68.   require ("../bb_news_config.inc");
  69.  
  70.   mysql_connect($bb_news_hostname,$bb_news_mysqluser,$bb_news_mysqlpassword)
  71.     or die ("Problem connecting to DataBase");
  72.  
  73.   // protect sql syntax
  74.   $subject = addslashes($subject);
  75.   $news = addslashes($news);
  76.   $author = addslashes($author);
  77.   $link = addslashes($link);
  78.  
  79.   $query = "update news set subject = '$subject', news = '$news', author = '$author',
  80.             link = '$link' where id = '$id'";
  81.   $result = mysql_db_query($bb_news_db, $query); 
  82.  
  83.   print "query result: \n <pre>$result</pre>\n";
  84.  
  85.   echo "Data updated. new table:<br>";
  86.   ?><a href="bb_news_admin.php3">Press here to go back to the input page</a>"<?
  87. }
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
  1.  
  2.  
  3. else
  4. { 
  5.   echo ' 
  6.   <font face="Arial, Helvetica, sans-serif" size="4"><b><font color="#0066FF">
  7. News Entry Form</font></b></font>
  8.  
  9. 	<form method="post" name="form1" action="bb_news_admin.php3">
  10. 		<INPUT NAME="id" TYPE=Hidden Value="0000" Size="">
  11. 		<INPUT NAME="date" TYPE=Hidden Value=" " Size="">
  12. 		<INPUT NAME="action" TYPE=Hidden Value="add" Size="">
  13. 		<font face="Arial, Helvetica, sans-serif">Subject: 
  14. 		<input type="text" name="subject">
  15.          by: 
  16.         <input type="text" name="author"><br>
  17.          News:<br>
  18.         <textarea name="news" rows=5 cols=75></textarea><br>
  19.          Link 
  20.         <input type="text" name="link" size="30" ></font><br>
  21.         <input type="submit" name="Submit" value="Submit">
  22.         <input type="reset" name="Submit2" value="Reset">
  23.         </form><P>
  24.   '; 
  25.  
  26. 	// calculate the page offset
  27. 	if($page_number == "") { $page_number = 0; }
  28. 	$page_offset = $page_number * $max_hits;
  29. 	$prev_page_number = $page_number - 1;
  30. 	$next_page_number = $page_number + 1;
  31.  
  32. 	require ("../bb_news_config.inc");
  33. 	mysql_connect($bb_news_hostname,$bb_news_mysqluser,$bb_news_mysqlpassword)
  34. 		or die("Unable to connect to SQL server");  // We do this to handle the errors
  35.  
  36. 	$query = "select id, subject, news, date_format(date, '%Y/%m/%d') as date, author, link from news
  37. 		order by id desc limit $page_offset,$max_hits";   
  38.  
  39. 	$news =  mysql_db_query($bb_news_db, $query) or die("Select Failed!");
  40.  
  41. 	$human_pnum = $page_number + 1;
  42. 	print "Page $human_pnum of News<br>\n";
  43. 	echo "<hr>\n";
  44.  
  45. 	while ($row = mysql_fetch_array($news)) {
  46. 	?>
  47.  
  48. 		<font face="Arial, Helvetica, sans-serif" size="2">
  49. 		<font color="<? echo $bb_news_date_fn; ?> ">
  50. 		<? echo $row['date']; ?></font> by <font color="<? echo $bb_news_author_fn; ?>">
  51. 		<? echo $row['author']; ?></font><br>
  52. 			<b><font color="<? echo $bb_news_subject_fn; ?>"><? echo $row['subject']; ?></font></b><br>
  53. 				<a href=bb_news_admin.php3?action=view&id=<? echo $row['id'] ?>>view</a>
  54. 				<a href=bb_news_admin.php3?action=viewedit&id=<? echo $row['id'] ?>>edit</a>
  55. 				&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=bb_news_admin.php3?action=del&id=<? echo $row['id'] ?>>delete</a></font>
  56. 				<font face="Arial, Helvetica, sans-serif" size="2">
  57. 		<hr>
  58.  
  59. 	<?
  60. 	} 
  61.  
  62. 	print "<font size=+1>\n";
  63. 	$qs = ereg_replace('\&page_number=[^&]*', '', $QUERY_STRING);
  64. 	if($prev_page_number > -1)
  65. 	{
  66. 	  print "<a href=\"$SCRIPT_NAME?$qs&page_number=$prev_page_number\">prev</a> \n";
  67. 	}
  68. 	else
  69. 	{
  70. 	  print "prev\n";
  71. 	}
  72. 	if(mysql_num_rows($news) == $max_hits)
  73. 	{
  74. 	  print "<a href=\"$SCRIPT_NAME?$qs&page_number=$next_page_number\">next</a> \n";
  75. 	}
  76. 	else
  77. 	{
  78. 	  print "next\n";
  79. 	}
  80. 	print "</font>\n";
  81.  
  82. 	?>
  83. 	<p>
  84. 	view the real <a href=../>news</a> page
  85. 	</p>
  86. 	<?
  87. } 
  88.  
  89. ?> 
[PHP] pobierz, plaintext


te all php są razem w jedym pliku musiałem tak zrobic bo mi forum error wywalało ze pobiera query czy coś w tym stylu
jacobson
26.07.2012, 08:13:24
a probowales skorzystac z mysql_query ? (tylko pamietaj zeby wczesniej wybrac baze danych)
bagukan223
26.07.2012, 08:16:46
powiem ci szczerze ze troszku rozumiem php / mysql ale tylko takie podstawy ..... jak pisałem ściągnołem ten skrypt z neta...
emkej
26.07.2012, 10:14:49 
[PHP] pobierz, plaintext 
  1. error_reporting(0);
[PHP] pobierz, plaintext
erix
26.07.2012, 10:16:41
~emkej, a czy gdy rozbije Ci się wazon, to zamiatasz szczątki pod dywan, czy robisz porządki?
palmall
26.07.2012, 14:17:18
Tutaj masz rozwiązanie:

http://php.net/manual/pl/function.mysql-db-query.php


generalnie to pozamieniaj sobie mysql-db-query na mysql_query, albo faktycznie wyłącz error_reporting biggrin.gif
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.