In PHP, how to achieve the same purpose like StringTokenizer in Java?

Question

Say I have a String 030512 Jack 25 Male\n030513 David 23 Male\n030514 ..., how to extract the info from this String as a two dimensional table in PHP?

In Java, I can use StringTokenizer, like:

StringTokenizer lineTokenizer = new StringTokenizer("030512 Jack ...", "\n");
List<Student> students = new ArrayList<Student>();

while(lineTokenizer.hasMoreTokens()) {
    String line = lineTokenizer.nextToken();
    StringTokenizer itemTokenizer = new StringTokenizer(line, " ");
    String id = itemTokenizer.nextToken();
    String name = itemTokenizer.nextToken();
    String age = itemTokenizer.nextToken();
    String sext = itemTokenizer.nextToken();
    students.add(new Student(id, name, age, sex));
}

Actually, my final goal is extracting this "table-like" info and store them into a Mysql database.

I am not familiar with PHP, could you show me how to do this in PHP, or what is a good practice to implement this two-dimensional data insertion into a Mysql database?

score 2 · Answer 1 · answered Feb 16 '13 at 00:25

2

You can use the explode or split functions. E.g.

$records = explode("\n", $raw_data);
foreach($record in $records) {
    $fields = explode(" ", $record);
    $id = fields[0];
    $name = fields[1];
    ///....
}

answered Feb 16 '13 at 00:25

kufudo

2,803
17
19

FtDRbwLXw6 · Answer 2 · 2013-02-16T00:41:45.813

1

You can use explode() coupled with list():

foreach (explode("\n", $yourString) as $line) {
    list($id, $name, $age, $sex) = explode(' ', $line);
    // ...
}

Edit:

Updated the solution to correct a misunderstanding of the original data structure.

edited Feb 16 '13 at 00:41

answered Feb 16 '13 at 00:24

FtDRbwLXw6

27,774
13
70
107

It would only work in this way if he had exactly 3 elements. Based on the `...` in the string he provided prior to the code, I'd suspect he has an indeterminate amount. – Cat Feb 16 '13 at 00:27
@Eric: Look at the code closer. There are a finite number of elements (four of them - `id`, `name`, `age`, and `sex`), which are fed into a constructor. – FtDRbwLXw6 Feb 16 '13 at 00:38
Well, yes, after you modified your answer to include the initial `explode()`, it works. – Cat Feb 16 '13 at 01:07

Daniel Figueroa · Accepted Answer · 2013-02-16T00:50:53.213

Not fancy but easier to understand in my opinion (requires that the string doesn't end with newline though, and that the information is always correctly formatted):

$students = array();

//no newline at the end, or you'll have to add a check for that in the loop.
$str = "030512 Jack 25 Male\n030513 David 23 Male";

foreach(explode("\n", $str) as $student_str) {
    list($id, $name, $age, $sex) = explode(" ", $student_str);
    array_push($students, array(":id"=>$id,":name"=>$name, ":age"=>$age, ":sex"=>$sex));
}

//For the DB part which has been quite absent.
$conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);
$query = "INSERT INTO students (id, name, age, sex) VALUES (:id, :name, :age, :sex)";
$prepared_query = $conn->prepare($query);

foreach($students as $student) {
    $prepared_query->execute($student);
}

You could of course execute the queries in the first loop instead if thats what you want.

score 0 · Answer 4 · answered Feb 16 '13 at 00:27

0

You could do like this

$string = "030512 Jack 25 Male\n030513 David 23 Male\n030514";

$array = array_map(function($v) {
    return explode(' ', $v);
}, explode("\n", $string));

answered Feb 16 '13 at 00:27

Rob

12,659
4
39
56

In PHP, how to achieve the same purpose like StringTokenizer in Java?

4 Answers4