Splitting strings through php to query mysql

Question

I need to split a string in two so I can do a SELECT query in my DB. For example, I have the number '0801'. I need to split that number into '08' and '01'. How do I manage to do that?

What determines the split? Position? (I.e always the first 2 etc.c) Value? your question is vague. — Kisaragi
– Kisaragi, Commented Dec 17, 2015 at 16:10
The first 2 numbers. It's allways a 4 digit number and I allways need to split it in 2 two digit numbers, — picaluga
– picaluga, Commented Dec 17, 2015 at 16:11

TwoStraws · Accepted Answer · 2015-12-17 16:14:03Z

1

This is easy to do using the substr() function, which lets you pull out parts of a string. Given your comment that you always have a four-digit number and want it split into two two-digit numbers, you want this:

$input = "0801";

$left = substr($input, 0, 2);
$right = substr($input, 2);

echo "Left is $left and right is $right\n";

answered Dec 17, 2015 at 16:14

TwoStraws

13.2k3 gold badges60 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

picaluga Over a year ago

Wow the other guys just showed me this fucntion but you really went balls deep explaining it. Well done now I trully understand. Thank you a lot. Both of you.

TwoStraws Over a year ago

You're welcome! As the answer helped you, please take the time to mark it as correct so others can benefit too. Google brings a lot of people to Stack Overflow :)

Alexander Dyachkov · Accepted Answer · 2015-12-17 16:16:14Z

1

According to your comment

The first 2 numbers. It's allways a 4 digit number and I allways need to split it in 2 two digit numbers

You can simply use

$value = '0801';
$split = str_split($value, 2);
var_dump($split[0]);
var_dump($split[1]);

Just keep in mind $value variable should always be of a string type, not int.

answered Dec 17, 2015 at 16:16

Alexander Dyachkov

3381 silver badge9 bronze badges

Comments

Community · Accepted Answer · 2023-11-17 20:42:18Z

1

you can use str_split and list

$str = '0801';
list($first,$second) = str_split($str,2);

echo $first;
// 08
echo $second;
// 01

edited Nov 17, 2023 at 20:42

CommunityBot

11 silver badge

answered Dec 17, 2015 at 16:16

danjam

1,0629 silver badges13 bronze badges

Comments

I wrestled a bear once. · Accepted Answer · 2015-12-17 16:19:46Z

1

No one gave a MySQL answer yet...

If you're selecting that number..

SELECT 
    SUBSTR(colname, 0, 2) as firstpart, 
    SUBSTR(colname, 2, 2) as secondpart 
FROM table

answered Dec 17, 2015 at 16:19

I wrestled a bear once.

23.5k20 gold badges74 silver badges122 bronze badges

Collectives™ on Stack Overflow

Splitting strings through php to query mysql

4 Answers 4

2 Comments

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Related