PHP - Split An Array

I'm pulling 10 records here. How do I split the results in to several echos?

$query = "SELECT statez, COUNT(statez)FROM mylist GROUP BY statez"; 
$results = mysql_query($query);
$returnS="";
while($line = mysql_fetch_array($results))
{
$returnS.= $line['COUNT(statez)'].",,".$line['statez'].",,,";
}
echo $returnS;
mysql_close($link);
?>

I need the code to look like this by showing the (COUNT) number for each state.
$results = mysql_query($query);
while($line = mysql_fetch_array($results))
{
echo $line["number_in_state1"].",,";
echo $line["number_in_state2"].",,";
echo $line["number_in_statee3"].",,";
echo $line["number_in_state4"].",,";
echo $line["number_in_state5"].",,";
echo $line["number_in_state6"].",,";
//etc....
}

Hi all, hopefully just a quickie.

split is deprecated in 5.3, but i have the following to get working..

Code: [Select]
$dest = split(self::__MAIL_DELIMITOR__, $this->_mails);
delimitor is as follows:

Code: [Select]
const __MAIL_DELIMITOR__ = ',';and _mails is just a list of email addresses.

Can anyone suggest a workaround?

Thanks

How do i specify that i want the fgetcsv() to use a ; to separate instead of a ,
p.s.(i have no control over the .csv file so i cant change it from ; to ,)

i have same problem like you, if i open a small file(3 to 5mb), open normal. But, when i try open a dbf file 13mb or more, cause php.exe error; i set Mem in php.ini to 256mb(before 8mb), but doens't work.
Someone have some solution, because i try find some way to clipper program input data on MySQL and dont have sucess too...

I've been trying to figure out how to split up strings such as the following:

A54a1, 23b, FX49s1, R231z, 77

I would like to split them up and add them to individual arrays that are as follows:

index[0] -> alphabetical characters, if any, prior to the first number, if any
index[1] -> numerical characters, as a number, up until the following alphabetical character
index[2] -> alphabetical character(s), if any
index[3] -> numerical characters following the second alphabetical character set, if any

So, for example, the above strings would be separated like this:
A54a1 == ('A', 54, 'a', 1)
23b == (, 23, 'b',,)
FX49s1 == ('FX', 49, 's', 1)
R231z == ('R', 231, 'z',,)
77 == (,77,,)

I've looked into things like strpos(), but I can't figure how to determine whether a character is alphabetic or numeric.  And yes, I am familiar with the function is_numeric().  Just don't know how to throw it all together to accomplish what I need.

How can I split this data and then remove it? I need to split data by ; then split each one of those.
$data = "page=1&data=1:21;2:34;5:57&a=yes";

So I will get:

$category[0] = 1;
$sub_category[0] = 21;
$category[1] = 2;
$sub_category[1] = 34;
$category[2] = 5;
$sub_category[2] = 57;

What's the best string function to use if i want to split a string up affter a specific character?

In this case i have a var with "uploads/thisImage.jpg"    i want to split this so i can create a new var value of "thisImage.jpg"

I need to split a string, but in a very unusual way.

$string1 = "HelloWorld"
$string2 = "AlphaBravo"
$string3 = "BreakMeUp"

I need the following split at each upppercase letter for this output

Hello World
Alpha Bravo
Break Me Up

hi everyone,
i have a string as this one: 45,3455,66,8900,2,49,88,8,909

I need to print it with a new line every 4 numbers, as this one:
45,3455,66,8900,
2,49,88,8,
909

How can i do this?

many thanks

Is it possible to split a variable into 2 variables?


///  I have this sentence
$item = "Below Telegraph Hill, Smallwork Canvas Edition";

/// And I want to be able to do this
$item = "Below Telegraph Hill" ;
$medium = "Smallwork Canvas Edition";


Is it possible to find the comma in a string, and remove the comma & everything before or after it? Any recommendations would be appreciated.

I am trying to split a variable only if it has an integer. Here is what I want to do:

$id = 1234-54678;

should be split into and then placed into two variables:

$id1 = 54678;
$id2 = 1234;

Sometimes the variable may not have a delimiter in which case I would like it to be $id1

example:
$id = 54678;

should go directly to

$id1 = 54678;

I am a php rookie and don't know which way is best to do this (explode, split, etc.) so I would appreciate any help you can give me.

hello guys   i wand to split the 24h of a day to parts and select the time that i wand to start the 24h circle to count!   lets say    i give 2 int variables   $day_starts_to_count_from=00;   $split_day_to_parts=4;     so!   $hours_per_part = 24/$split_day_to_parts;   this gives me $hours_per_part  = 6  (i split the 24h every 6hr)   how to know the part of my current hour?   lets say the system time is 15:35   how to find that im at the 3d part  12:00-18:00 if the 24h circle starts to count from 00:00     thanks in advance        

What's the difference between str_split()  and chunk_split()? They seem to perform the same task?

Hi all,

I am working on the PHP to fetch the data from the database. I would like to fetch the filename only following by:

email1.png
email2.png
email3.png
my_inbox.png

 

When I try this:           

$mailbox_sql = 'SELECT * FROM ' . $mailfolder . ' WHERE email_id = ? AND message_id = ?';
$mailbox = $link->prepare($mailbox_sql);
$mailbox->execute([$id,$message_id]); 

// set the resulting array to associative
$row = $mailbox->fetch(PDO::FETCH_ASSOC);

if (is_array($row)) {
   $attached = $row['attached_files'];
   $attached_files_name = explode('attid: ', $attached);
}

 

 

I am getting this:

0 filename: email1.png
1 filename: email2.png
2 filename: email3.png
3 filename: my_inbox.png

 

 

Here is what I have stored in the database:

 attid: 0 filename: email1.png
 attid: 1 filename: email2.png
 attid: 2 filename: email3.png
 attid: 3 filename: my_inbox.png

 

 

Here is what I want to achieve:

email1.png
email2.png
email3.png
my_inbox.png

 

 

Can you please show me example how I could get the filename when I am fetching the data from the database?

Thanks in advance.

Edited January 18, 2020 by mark107

Hi I am trying to split a form as shown in this simple code. I tried what I thought should work but obviously it is not working.    This submits the first part of the form but does not go to the second part of the form. So First name, Last names and Age are submitted but email and cell are not and it throws a undefined index warning for those.   Can someone please take a look at this and suggest if what I am trying to do can be accomplished using PHP.    Thanks

<?php 
if(isset($_POST['submit']) && $_POST['submit'] == 'Submit')
{
echo"<br> First Name = ".$_POST['fname']."<br>" ;
echo"Last Name = ".$_POST['lname']."<br>" ;
echo"Age = ".$_POST['age']."<br>" ;
echo"Email = ".$_POST['email']."<br>" ;
echo"Cell = ".$_POST['cell']."<br>" ;

}

?>

<html>
<head> <title> WOW </title></head>

<body>
<table>

<form id="form1" action = "splitform.php" method="post">
<th> TEST </th> 
<tr><td>First Name : </td> <td><Input type='text' name = 'fname'></td></tr>
<tr><td>Last Name : </td> <td><Input type='text' name = 'lname'></td></tr>
<tr><td>AGE : </td> <td><Input type='text' name = 'age'></td></tr>
</form>

<form id ="form1" action = "splitform.php" method="post">
<tr><td>Email : </td> <td><Input type='text' name = 'email'></td></tr>
<tr><td>Cell: </td> <td><Input type='text' name = 'cell'></td></tr>
</form>

<tr><td><Input type="submit" name = "submit" value = "Submit" form = "form1"></tr></td>


</table>
</body>

</html>