Home > Article > Backend Development > MySQL universal query program implemented by merry lonely christmas php

MySQL universal query program implemented by merry lonely christmas php

WBOYOriginal: 2016-07-29 08:36:291067browse

if(get_magic_quotes_gpc()==1){
?>

MySQL Universal Query Program

Pay attention to this The program needs to set magic_quotes_gpc
in the PHP configuration file (php3.ini for PHP3, php.ini for PHP4) to Off or 0. Please restart Apache after modification.

< ;?
exit();
}
set_magic_quotes_runtime(0);
$host = 'localhost';
$db = 'test';
$user = 'test';
$pass = '';
// [ php/inc/str2url.php ] cvs 1.2
function str2url($path){
return eregi_replace("%2f","/",urlencode($path));
}
?>

MySQL Universal Query Program

Please enter the SQL statement:

<?echo $sql;?></textarea> ;<br> <br><input type="submit" name="cmd" value="Query"> <br><input type="submit" name="cmd" value="Execute"> <br>< /form> <br><? <BR>if($cmd){ <BR> $con = mysql_pconnect($host,$user,$pass) or die('Unable to connect'.$host.'server'); <BR> mysql_select_db($db ,$con) or die('Unable to connect'.$db.'database'); <BR> $rst = mysql_query($sql,$con) or die($sql.'Error'); <BR> if($cmd== ')') {$ Num_fields = MySQL_NUM_FIELDS ($ RST); <BR> echo '& lt; hr & gt;'; <BR> echo '& lt; table border = "1" cellspacing = "0" cellspacing = "0" & gt; '; <BR> echo '<caption align="center">'.$sql.'</option>'; <br> echo '<tr>'; <br> for($i=0;$i<$num_fields;$i++ ) echo '<th> '.mysql_field_name($rst,$i).'</th>'; <br> ; echo '</tr>'; <br> while($row=mysql_fetch_row($rst)){ echo '<tr>'; <br> for($i=0;$i<$num_fields;$i++) echo '<td> '.$row[$i].'</td>'; <br> echo '& lt;/troc & gt;';}} <br> echo '& lt;/table & gt;'; <br> mysql_free_result ($ rst); <br>} <br> echo 'has'. Mysql_Affected_ROWS ($ CON) . 'The line was affected'; <br>} <br>?> <br></body> <br></html> <br>
                
                
                <br>
                    The above introduces the MySQL universal query program implemented by merry lonely christmas php, including the content of merry lonely christmas. I hope it will be helpful to friends who are interested in PHP tutorials. <br>
                <br>
                    </p>
<p></p></div><div class="nphpQianMsg"><div class="clear"></div></div><div class="nphpQianSheng"><span>Statement：</span><div>The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn</div></div></div><div class="nphpSytBox"><span>Previous article：<a class="dBlack" title="android studio uses php to reimplement the PHP script engine built-in functions" href="http://m.php.cn/faq/321467.html">android studio uses php to reimplement the PHP script engine built-in functions</a></span><span>Next article：<a class="dBlack" title="android studio uses php to reimplement the PHP script engine built-in functions" href="http://m.php.cn/faq/321472.html">android studio uses php to reimplement the PHP script engine built-in functions</a></span></div><div class="nphpSytBox2"><div class="nphpZbktTitle"><h2>Related articles</h2><em><a href="http://m.php.cn/article.html" class="bBlack"><i>See more</i><b></b></a></em><div class="clear"></div></div><ins class="adsbygoogle"
     style="display:block"
     data-ad-format="fluid"
     data-ad-layout-key="-6t+ed+2i-1n-4w"
     data-ad-client="ca-pub-5902227090019525"
     data-ad-slot="8966999616"></ins><script>     (adsbygoogle = window.adsbygoogle || []).push({});
</script><ul class="nphpXgwzList"><li><b></b><a href="http://m.php.cn/faq/1.html" title="How to use cURL to implement Get and Post requests in PHP" class="aBlack">How to use cURL to implement Get and Post requests in PHP</a><div class="clear"></div></li><li><b></b><a href="http://m.php.cn/faq/1.html" title="How to use cURL to implement Get and Post requests in PHP" class="aBlack">How to use cURL to implement Get and Post requests in PHP</a><div class="clear"></div></li><li><b></b><a href="http://m.php.cn/faq/1.html" title="How to use cURL to implement Get and Post requests in PHP" class="aBlack">How to use cURL to implement Get and Post requests in PHP</a><div class="clear"></div></li><li><b></b><a href="http://m.php.cn/faq/1.html" title="How to use cURL to implement Get and Post requests in PHP" class="aBlack">How to use cURL to implement Get and Post requests in PHP</a><div class="clear"></div></li><li><b></b><a href="http://m.php.cn/faq/2.html" title="All expression symbols in regular expressions (summary)" class="aBlack">All expression symbols in regular expressions (summary)</a><div class="clear"></div></li></ul></div></div><ins class="adsbygoogle"
     style="display:block"
     data-ad-format="autorelaxed"
     data-ad-client="ca-pub-5902227090019525"
     data-ad-slot="5027754603"></ins><script>     (adsbygoogle = window.adsbygoogle || []).push({});
</script><footer><div class="footer"><div class="footertop"><img src="/static/imghwm/logo.png" alt=""><p>Public welfare online PHP training，Help PHP learners grow quickly！</p></div><div class="footermid"><a href="http://m.php.cn/about/us.html">About us</a><a href="http://m.php.cn/about/disclaimer.html">Disclaimer</a><a href="http://m.php.cn/update/article_0_1.html">Sitemap</a></div><div class="footerbottom"><p>                © php.cn All rights reserved
            </p></div></div></footer><script>isLogin = 0;</script><script type="text/javascript" src="/static/layui/layui.js"></script><script type="text/javascript" src="/static/js/global.js?4.9.47"></script></div><script src="https://vdse.bdstatic.com//search-video.v1.min.js"></script><link rel='stylesheet' id='_main-css' href='/static/css/viewer.min.css' type='text/css' media='all'/><script type='text/javascript' src='/static/js/viewer.min.js?1'></script><script type='text/javascript' src='/static/js/jquery-viewer.min.js'></script><script>jQuery.fn.wait = function (func, times, interval) {
    var _times = times || -1, //100次
    _interval = interval || 20, //20毫秒每次
    _self = this,
    _selector = this.selector, //选择器
    _iIntervalID; //定时器id
    if( this.length ){ //如果已经获取到了，就直接执行函数
        func && func.call(this);
    } else {
        _iIntervalID = setInterval(function() {
            if(!_times) { //是0就退出
                clearInterval(_iIntervalID);
            }
            _times <= 0 || _times--; //如果是正数就 --

_self = $(_selector); //再次选择
            if( _self.length ) { //判断是否取到
                func && func.call(_self);
                clearInterval(_iIntervalID);
            }
        }, _interval);
    }
    return this;
}
$("table.syntaxhighlighter").wait(function() {
    $('table.syntaxhighlighter').append("<p class='cnblogs_code_footer'><span class='cnblogs_code_footer_icon'></span></p>");
});
$(document).on("click", ".cnblogs_code_footer",function(){
      $(this).parents('table.syntaxhighlighter').css('display','inline-table');$(this).hide();
});
$('.nphpQianCont').viewer({navbar:true,title:false,toolbar:false,movable:false,viewed:function(){$('img').click(function(){$('.viewer-close').trigger('click');});}});
</script></body></html>