Very Tricky for Me, Please Help!!

fr600

Hi guys,

SQL:

CREATE TABLE documents (
  id int(10) unsigned NOT NULL auto_increment,
  name varchar(64) NOT NULL default '',
  type varchar(255) NOT NULL default '',
  PRIMARY KEY (id),
  UNIQUE KEY info_hash (id)
) TYPE=MyISAM;
INSERT INTO documents VALUES (1, 'Test-doc abc', 'science');
INSERT INTO documents VALUES (2, 'Test-doc def', 'english');
INSERT INTO documents VALUES (3, 'Test-doc ghi', 'english');
INSERT INTO documents VALUES (4, 'Test-doc jkl', 'history');
INSERT INTO documents VALUES (5, 'Test-doc mno', 'history');
INSERT INTO documents VALUES (6, 'Test-doc pqr', 'english');
INSERT INTO documents VALUES (7, 'Test-doc stu', 'english');
INSERT INTO documents VALUES (8, 'Test-doc vwx', 'history');
INSERT INTO documents VALUES (9, 'Test-doc yza', 'english');
INSERT INTO documents VALUES (10, 'Test-doc bcd', 'science');
INSERT INTO documents VALUES (11, 'Test-doc efg', 'english');
INSERT INTO documents VALUES (12, 'Test-doc hij', 'science');
INSERT INTO documents VALUES (13, 'Test-doc klm', 'history');
INSERT INTO documents VALUES (14, 'Test-doc nop', 'english');
INSERT INTO documents VALUES (15, 'Test-doc qrs', 'english');
INSERT INTO documents VALUES (16, 'Test-doc tuv', 'history');
INSERT INTO documents VALUES (17, 'Test-doc wzy', 'english');
INSERT INTO documents VALUES (18, 'Test-doc zab', 'history');
INSERT INTO documents VALUES (19, 'Test-doc cde', 'science');
INSERT INTO documents VALUES (20, 'Test-doc fgh', 'science');

NOTE:

ID for english: 2,3,6,7,9,11,14,15,17
ID for science: 1,10,12,19,20
ID for history: 4,5,8,13,16,18

Now, the thing is -- I want to select all english and their individual IDs like this:

http://www.example.com/update.php?type=english&id=2&id=3&id=6&id=7&id=9&id=11&id=14&id=15&id=17

Next I want to do the same for science and history. How can I do this?

PS. Sorry, I couldn't explain it properly. I hope you'll understand.

bpat1434

Well, using a comma seperated (or underscore, hyphen, vertical bar (|), or other number) value for id would be better. Otherwise, the value of "id" will be the last number (17).

So your url would look like:

http://www.example.com/update.php?type=english&id=2|3|6|7|9|11|14|15|17

And if you're doing for the query, it would go soemthing like this:

<?php

$query = "SELECT * FROM `documents` WHERE type='english' ORDER BY id ASC";
$rslt = mysql_query($query);

while($id = mysql_fetch_array($rslt)){
    $suffix .= $id.'|';
}
// get rid of last "|"
$suffix = substr($suffix, 0, -1);

$url = 'http://www.domain.com/update.php?type=english&id='.$suffix;

?>

~Brett

fr600

bpat1434

oops... here's the proper code:

<?php

$query = "SELECT * FROM `documents` WHERE type='english' ORDER BY id ASC";
$rslt = mysql_query($query);

while($row = mysql_fetch_array($rslt)){
    $suffix .= $row['id'].'|';
}
// get rid of last "|"
$suffix = substr($suffix, 0, -1);

$url = 'http://www.domain.com/update.php?type=english&id='.$suffix;

?>

THat's what I get for not slowing down to answer questions....

~Brett

fr600

I couldn't solve the problem, don't have enough experience 🙁

Can you please tell me how can I get the url in this way:

$url = "http://www.example.com/update.php?type=science&id=1&type=english&id=2&type=english&id=3&type=history&id=4&type=history&id=5&type=english&id....... and so on";

Now in converturl -- break the url in this way:

function converturl ($url)
{
/*
Things to do to
separately the
url in the following
way so i can send it to
another function separately
*/

$converted_url = "http://www.example.com/update.php?type=english&id=2&id=3&id=6&id=7&id=9&id=11&id=14&id=15&id=17";
anotherfunction($converted_url);

$converted_url = "http://www.example.com/update.php?type=science&id=1&id=10&id=12&id=19&id=20";
anotherfunction($converted_url);

$converted_url = "http://www.example.com/update.php?type=history&id=4&id=5&id=8&id=13&id=16&id=18";
anotherfunction($converted_url);

}

Can you plz tell me how to do all these? Sorry, if I'm asking too much, but I realy need to get this done. Thanks

bpat1434

I gave you how to do it. If you read my first post, or do a simple test, you'd see that you can't do what you want. It's impossible. Not your way. In order to point it out more, do this:

-- Create a php page and save it as "testurl.php"
-- In "testurl.php" put this text:

<?php

foreach($_GET as $var => $val){
    echo "${$var} => ".$val.'<br>';
}

?>

-- Upload that to any server and go to it
-- Use the following url form:
http://www.domain.com/testurl.php?type=english&id=1&id=3&id=8&id=17

What that will output is this:

type => english
id => 17

Now, if you want multiple IDs with the same type, you have to use a comma separated value (csv). That way would look like:
http://www.domain.com/testurl.php?type=english&id=1,3,8,17

If you do it that way, then the ID is a csv, and you can [man]explode/man that csv and get all the IDs. Here's an example:

<?php

$ids = $_GET['id'];

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

foreach($id as $num){
    echo 'id => '.$num.'<br>';
}

?>

Using the second url in this post, the output would be:

id => 1
id => 3
id => 8
id => 17

So by building a query which gets all the information which fulfills the requirements (type == english), and then build the suffix to the url, you can then do what you want with it. This should work:

<?php

$query = "SELECT * FROM `documents` WHERE type='english' ORDER BY id ASC";
$rslt = mysql_query($query);

$suffix = '';

while($row = mysql_fetch_array($rslt)){
    $suffix .= $row['id'].',';
}
// get rid of last ","
$suffix = substr($suffix, 0, -1);

$url = 'http://www.domain.com/update.php?type=english&id='.$suffix;

?>

Now, when you need to use the id numbers, you can get them individually like so:

<?php
//update.php
$ids = explode(',', $_GET['id']);

foreach($ids as $id){
    echo 'id => '.$id.'<br>';
}

?>

Hope that helps.

~Brett