vb.org Archive - vbulletin mysqli_real_escape

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - vbulletin mysqli_real_escape_string (https://vborg.vbsupport.ru/showthread.php?t=298045)

ljianyih

05-11-2013 12:32 PM

vbulletin mysqli_real_escape_string

Hi,

What should I pass in the param1 for this function i.e.
$escapedString = mysqli_real_escape_string($param1, $escapedString);

Also, how does vbulletin escape all the strings using which functions? Thanks for the help.

nerbert

05-11-2013 12:55 PM

Here's some info:

http://us2.php.net/manual/en/mysqli....ape-string.php

Maybe you want to do it some other way so you don't need the link identifier

ljianyih

05-12-2013 03:30 AM

If using the other way, I would still need to define:

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

Does vBulletin has any pre-defined mysqli so that I can call $mysqli->real_escape_string($escapeString)?

nerbert

05-12-2013 03:57 AM

As I was looking around in includes/class_core.php looking for the variable name for the 1st parameter I found this, which is in the methods for mysqli

Code:

        /**

        * Escapes a string to make it safe to be inserted into an SQL query

        *

        * @param        string        The string to be escaped

        *

        * @return        string

        */

        function escape_string($string)

        {

                return $this->functions['real_escape_string']($this->connection_master, $string);

        }

so just use $vbulletin->db->escape_string(), it should work for mysqli

All times are GMT. The time now is 05:27 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01088 seconds Memory Usage 1,713KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: