vb.org Archive - explode()

Page 2 of 3

Show 40 post(s) from this thread on one page

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

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

- - explode() (https://vborg.vbsupport.ru/showthread.php?t=74641)

noppid

01-23-2005 12:42 PM

Well let's forget the query for now, step back one line and use a couple of conditions to sort ot your data first.

You need one of two results it seems.

PHP Code:


		
			
if( $grps == '' )

{

    $query_data = $newvalue;

}

else

{

   $query_data =  concat_ws(' ', $grps, $newvalue)

}

Now, I'm not sure what the data you want to concat is and what that concat_ws function you want is, can you give more details on your intent?

sabret00the

01-23-2005 12:46 PM

the initial query worked perfectly, it's just that i'm trying to undo it.

let me explain

PHP Code:


		
			
// ############################### start making em join the group ###############################

globalize($_POST, array(

    'perpage' => INT,

    'pagenumber' => INT,

    'g' => INT,

    'do' => STR,

    'view' => STR,

    'goto'

));



//$groupid = intval($g);



$groupid = $g = intval($grps_showgroup[groupid]);



if (!$groupid)

{ // make sure it's a number

    $idname = "Group2";

    eval(print_standard_error('error_invalidid'));

}





if ($_POST['do'] == 'dojoingroup')

{

    // Add new data to user table

    $DB_site->query("

        UPDATE " . TABLE_PREFIX . "user

        SET grps = if(grps='', $groupid, concat_ws(' ', grps, $groupid))

        WHERE userid = $bbuserinfo[userid]

    ");



    // Add new data to grps_user table

    $DB_site->query("

        INSERT INTO grps_user(groupid,userid,join_date)

        VALUES ($groupid,$bbuserinfo[userid], " . TIMENOW . ")

    ");



    $url = "groups.php?$session[sessionurl]g=$groupid";

    eval(print_standard_redirect('redirect_joinedthanks'));



}

as you can see Kirby's code makes em join the group fine and that works perfectly, however i'm now trying to work out how to reverse the info if they wanna leave a group.

[high]* sabret00the will BRB as i need to read the mysql page.[/high]

noppid

01-23-2005 12:46 PM

Quote:

Originally Posted by Dean C

concat_ws is a mysql function sabe:

http://dev.mysql.com/doc/mysql/en/string-functions.html

Based on readin this, I'm thinking you want to combine two comma delimited lists and have the comma inserted between the two to keep the list delimited properly?

sabret00the

01-23-2005 12:56 PM

yup that was what i wanted to do there. but now i want to

let say $bbuserinfo[grps] == "10,6,23,897495,34,4789,343" and this $groupid == "6" i want to remove the 6 from $bbuserinfo[grps] so it would then be $bbuserinfo[grps] == "10,23,897495,34,4789,343"

noppid

01-23-2005 12:57 PM

I'm finally seeing what's going on here, I just can't find an example of this syntax on mysql.com, yet.

sabret00the

01-23-2005 01:06 PM

yup reading the mysql functions list i couldn't see anything that'd help :(

Dean C

01-23-2005 01:09 PM

You can't do this in MySQL, you're going to have to do all the work in PHP. Explode the two lists, find your value in the array and unset it and then update :)

sabret00the

01-25-2005 12:32 PM

i thought of a way to do this now i know that while loops can work through arrays

could i do like

PHP Code:


		
			
while ($gettinggroups =$DB_site>fetch_array($queryexistinggroups))
  {
  if ($gettinggroups[groupid] != $groupid)
  {
  $newexistinggroups .= $gettinggroups[groupid] . " ";
  }
  }

although now rereading deans post i seem to be making it overtly complicated?

or am i reading it wrong?

PHP Code:


		
			
while ($gettinggroups =$DB_site>fetch_array($queryexistinggroups))
  {
  if ($gettinggroups[groupid] == $groupid)
  {
  unset($groupid);
  }
  }

ofcourse after each i'd have to then update the database but i won't get time to try it till this evening :(

oooh i just came across something called array_splice have to read up on that.

Dean C

01-25-2005 02:20 PM

An example. say the field 'omgz' in the user table contains a list of id's (e.g. 1,2,3,4):

PHP Code:


		
			
$removalid = 2;

$query = $DB_site->query_first("SELECT omgz FROM user WHERE userid=1");

$ids = explode(',', $query);

foreach($ids AS $id)

{

        if($id != $removalid)

        {

                $ids2[] = $id;

        }

}



$newids = implode(',', $ids2);



$DB_site->query("UPDATE user SET omgz='$ids' WHERE userid=1");

sabret00the

01-25-2005 03:38 PM

i was just about to post that i went with this and look you've done practically the same dean

PHP Code:


		
			
    // remove data to user table

    if (is_array($gprs_ids))

    {

        foreach($gprs_ids AS $index => $value)

        {

            if ($value == $groupid)

            {

                unset($gprs_ids["$index"]);

            }

        }



        $DB_site->query("

            UPDATE " . TABLE_PREFIX . "user

            SET grps = $gprs_ids

            WHERE userid = $bbuserinfo[userid]

        ");

    }

All times are GMT. The time now is 08:47 PM.

Page 2 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01114 seconds Memory Usage 1,765KB 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 (6)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: