Reply to thread

Message

<blockquote data-quote="Unidentified" data-source="post: 299645" data-attributes="member: 18502">I would like to show you that MySQL_Result is not really needed, you can use it better by doing the folliwing..Basic MySQL you can make a function :This is a Single Function. Output it by putting in your code&nbsp; &nbsp;&nbsp; echo Stats('cloudflare_resolved');[CODE]&lt;?php&nbsp; &nbsp; function Stats($Retrieve){&nbsp; &nbsp; &nbsp; &nbsp; $Query = MySQL_Query(&quot;SELECT * FROM `stats`&quot;);&nbsp; &nbsp; &nbsp; &nbsp; WHILE($Result = MySQL_Fetch_Assoc($Query){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Return(Mysql_Real_Escape_String($Result[$Retrieve]));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }?&gt;[/CODE]You Should really have a Sanitize Function...[CODE]&lt;?php&nbsp; &nbsp; function Sanitize($Data){&nbsp; &nbsp; &nbsp; &nbsp; return(mysql_real_escape_string($Data));&nbsp; &nbsp; }&nbsp; &nbsp; function Stats($Retrieve){&nbsp; &nbsp; &nbsp; &nbsp; $Query = MySQL_Query(&quot;SELECT * FROM `stats`&quot;);&nbsp; &nbsp; &nbsp; &nbsp; WHILE($Result = MySQL_Fetch_Assoc($Query){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Return(Sanitize($Result[$Retrieve]));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }?&gt;[/CODE]For a MySQLi use..[CODE]&lt;?php&nbsp; &nbsp; Class DB{&nbsp; &nbsp; &nbsp; &nbsp; Private Static $Connect;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Public Function __construct($Localhost, $Username, $Password, $Database)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; self::$Connect = new Mysqli($Localhost, $Username, $Password, $Database);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(self::$Connect-&gt;connect_errno){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Couldn't connect to Database&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; Public Static Function Query($Query)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return(mysqli_query(self::$Connect, $Query));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Public Static Function Sanitize($Data)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return(self::$Connect-&gt;real_escape_string($Data));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Public Static Function Stats($Retrieve){&nbsp; &nbsp; &nbsp; &nbsp; global $Mysqli;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $Query = $Mysqli::Query(&quot;SELECT * FROM `stats`&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHILE($Result = mysqli_fetch_assoc($Query)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Return($Mysqli::Sanitize($Result[$Retrieve]));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; } $Mysqli = new DB(&quot;Localhost&quot;, &quot;root&quot;, &quot;Password&quot;, &quot;Database&quot;);?&gt;[/CODE]To Output this you write in your code echo $Mysqli::Stats('cloudflare_resolved');</blockquote>

[QUOTE="Unidentified, post: 299645, member: 18502"] I would like to show you that MySQL_Result is not really needed, you can use it better by doing the folliwing.. Basic MySQL you can make a function : [I]This is a Single Function. Output it by putting in your code echo Stats('cloudflare_resolved');[/I] [CODE]<?php function Stats($Retrieve){ $Query = MySQL_Query("SELECT * FROM `stats`"); WHILE($Result = MySQL_Fetch_Assoc($Query){ Return(Mysql_Real_Escape_String($Result[$Retrieve])); } } ?>[/CODE] You Should really have a Sanitize Function... [CODE]<?php function Sanitize($Data){ return(mysql_real_escape_string($Data)); } function Stats($Retrieve){ $Query = MySQL_Query("SELECT * FROM `stats`"); WHILE($Result = MySQL_Fetch_Assoc($Query){ Return(Sanitize($Result[$Retrieve])); } } ?>[/CODE] For a MySQLi use.. [CODE]<?php Class DB{ Private Static $Connect; Public Function __construct($Localhost, $Username, $Password, $Database) { self::$Connect = new Mysqli($Localhost, $Username, $Password, $Database); if(self::$Connect->connect_errno){ echo" Couldn't connect to Database "; } } Public Static Function Query($Query) { return(mysqli_query(self::$Connect, $Query)); } Public Static Function Sanitize($Data) { return(self::$Connect->real_escape_string($Data)); } Public Static Function Stats($Retrieve){ global $Mysqli; $Query = $Mysqli::Query("SELECT * FROM `stats`"); WHILE($Result = mysqli_fetch_assoc($Query)){ Return($Mysqli::Sanitize($Result[$Retrieve])); } } } $Mysqli = new DB("Localhost", "root", "Password", "Database"); ?>[/CODE] [I]To Output this you write in your code echo $Mysqli::Stats('[I]cloudflare_resolved');[/I][/I] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members