vb.org Archive - Table update function

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

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Table update function (https://vborg.vbsupport.ru/showthread.php?t=168031)

Mythotical

01-17-2008 06:27 PM

Table update function

Ok I have this function:

PHP Code:


		
			
function saveSettings()

{

  global $db;

  

    $xsdl_active = $_REQUEST['xsdl_active'];

      $server_path = $_REQUEST['server_path'];

      $xsdl_closed = $_REQUEST['xsdl_closed'];

      $nav_active = $_REQUEST['nav_active'];

    $xsdl_file_name = $_REQUEST['xsdl_file_name'];

    

    $db->query_write("

        UPDATE `" . TABLE_PREFIX . "xsdl_settings`

        SET set_value= array('$xsdl_closed', '$server_path', '$xsdl_active', '$nav_active', '$xsdl_file_name') WHERE varname = array('xsdl_closed', 'server_path', 'xsdl_active', 'nav_active', 'xsdl_file_name')

    ");

                      

  return $db->insert_id();

}

I'm not sure how I should use array so it will run as I show above. I tried that but it failed, gonna keep trying while I wait for a reply here but could anyone give me the proper way to handle array's like above?

Thanks
Steve

Opserty

01-17-2008 08:14 PM

Is this using vBulletin back-end? If so make sure you read this: Using the vBulletin Input Cleaner, before you go any further in reading my post.

To store an array in a database row you need to serialize it in a string. See the PHP manual for information on serialize() and unserialize().

An example:

PHP Code:


		
			
$arrayone = array('bla', 'bla', 'bla');
$arrayone = serialize($arrayone);
// $db->query_write("UPDATE....SET somecol = ". $arrayone ."...

//=================================

// $db->query_read("SELECT * FROM....
// $row = $db->fetch_array...
$data = unserialize($data['somecol']);

Adrian Schneider

01-17-2008 08:23 PM

What you want is a CASE statement.

[sql]UPDATE table
SET set_value =
CASE
WHEN set_varname = 'X'
THEN $value_for_x

WHEN set_varname = 'Y'
THEN $value_for_y
END
WHERE set_varname IN ('X', 'Y')[/sql]

Opserty

01-17-2008 08:30 PM

Oh whoops I didn't see all of your query Steve M. My apologies. :erm:

All times are GMT. The time now is 08:45 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02082 seconds Memory Usage 1,725KB 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 (2)bbcode_php_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: