PHP - Convert All Keys To Lowercase Using

Is it possible to create a PHP array that contains only keys?

	array
	1
	3
	5
	6
	7
	

 

I have a query that returns row ID's that I want to put into an array to do some work.  There is no real concept of a "value" - I just need to store a list of the database table rows that i want and that's it!

 

Edited February 16 by SaranacLake

Hello,

I posted here as although it's in regards to mysql the thing i want to ask is in regards to php itself.

I have two tables below as follows:

Code: [Select]
    CREATE TABLE `users` (
    `uid` int(11) NOT NULL AUTO_INCREMENT,
    `status` char(10) NOT NULL,
    `username` varchar(15) NOT NULL,
    `email` varchar(50) NOT NULL,
    `password` char(32) NOT NULL,
    `reg_date` int(11) NOT NULL,
    `ip` varchar(39) DEFAULT NULL,
    PRIMARY KEY (`uid`),
    UNIQUE KEY `username` (`username`,`email`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
     
     
    CREATE TABLE `users_profiles` (
    `uid` int(11) NOT NULL,
    `first_name` varchar(40) DEFAULT NULL,
    `last_name` varchar(50) DEFAULT NULL,
    `gender` char(6) DEFAULT NULL,
    `website` varchar(100) DEFAULT NULL,
    `msn` varchar(60) DEFAULT NULL,
    `aim` varchar(60) DEFAULT NULL,
    `yim` varchar(60) DEFAULT NULL,
    `twitter` varchar(15) DEFAULT NULL,
    UNIQUE KEY `uid` (`uid`),
    CONSTRAINT `users_profiles_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

From the above you can see the uid in the users_profiles table is a foreign key and references the uid in the users table to link both tables together.

My scenario is this:

A user fills out a registration form that asks for username, email and a password. After validating the form data etc it is inserted into the users table.

Now at this stage they have no profile in the users_profiles table as they only just signed up. They login and xxx data is stored in a session along with there uid from users table. They now visit there profile, they fill in the profile form fields and submit the form.

Now can someone tell me if what i think i should be doing is correct, if not please tell me what i should do or a better way:

After validating the data that was submitted on profile form etc i could do something like a simple if else statement which will first check to see if the uid in session which is from users table matched a uid in the users_profiles table. If there's no match which in this case it won't be as they are a new user and don't have a profile record in users_profiles table then do an INSERT query into users_profiles table which would insert the submitted values from the form and the uid from session, on success that would now link the user from users table to there newly created profile in the users_profiles table. But if the uid in session matched a uid in user_profiles then obviously this means the user already has a profile ie.. submitted profile info previously so do an UPDATE query instead.

Am i rite in thinking this is how i would do it?

example below, note it's not valid code just to try an illustrate what i am saying; Hopefully!

Code: [Select]
<?php
    if($_SESSION['uid'] == user_profiles.uid)
    {
     /* If the uid in session which is the uid from users table
      * (we got it on successful login)
      * matches a users uid in user_profiles table then profile already exists
      * for user so do an UPDATE query here
      */
    } else {
     /* $_SESSION['uid'] does not match a uid in users_profiles table
      * so instead do a INSERT QUERY here. This means no profile exists for user.
      * The uid from session is inserted into users_profiles table (column uid)
      * which links the profile to user.
      */
    }
?>

I know if i delete a user it will also delete there profile if they have one like it should do to obviously not leave redundant data in the database and to ensure data intergity (sorry i think that's what it's called)

Thanks for any help.

PHPFAN

How can you print an individual key in the $_POST array?

I've tried...
Code: [Select]
echo $_POST[0];But with no luck.  There is data in the array, not all keys have values.

I have an array of type
Code: [Select]
Array ( [2] => Array ( [name] => Shelby Baptist Medical Ctr [city] => Alabaster ) [1] => Array ( [name] => Andalusia Regional Hospital [city] => Andalusia ) [0] => Array ( [name] => Long Term Hospital of Anniston [city] => Anniston ))
How can sort the keys of an array but there content remains the same so that they are like
Code: [Select]
Array ( [0] => Array ( [name] => Shelby Baptist Medical Ctr [city] => Alabaster ) [1] => Array ( [name] => Andalusia Regional Hospital [city] => Andalusia ) [2] => Array ( [name] => Long Term Hospital of Anniston [city] => Anniston ))
Can someone please point me if there is any func. for this

hey guys im trying to result an array key and value if it has one...the code and results are below if anyone can help with this simple problem...thanks alot

Code: [Select]
<?php

$columns = array('news_id' => 'id', 'news');

foreach ($columns as $column => $column_alias)
{
echo $column . ' ' . $column_alias;
}
?>
the result im getting is:

news_id  id
0 news

but im just after the result of just result the column name and alias (if it has one)
so im looking for the result

news_id  id
news

is there a way to reset the array keys? to 0,1,2,3,...

also for example that i have something like this:

$array['dog']='dog';
$array['mouse']='mouse';
$array['cat']='cat';

and i want it like this:

$array[0]='dog';
$array[1]='mouse';
$array[2]='cat';

is there a function for that already in php?

Hello

I am having some trouble with array_keys

I have an array for which I want to return all the keys based on value X

This is my code:

Code: [Select]

$depth = array_keys(X', $Array);

echo print_r ($depth,1);



I have checked the content of my array $Array and it contains at least 1 instance of 'X' but I am getting nothing when I do the print_r

Any suggestions would be appreciated

Thanks

Hi ..
i have an array format like (mysql result array)
$new_array=Array ( [0] => Array ( [quantity] => 5 )  [1] => Array ( [quantity] => 25 )  [2] => Array ( [quantity] => 20 ) )

I have to convert this array into the following format
$new_array['quantity'][0]=5
$new_array['quantity'][1]=25
$new_array['quantity'][2]=20


How to convert this array format using any standard array method.

This:
Code: [Select]
echo "<pre>";
print_r($torrent->content());
echo "</pre>";
Returns:
Code: [Select]
Array
(
    [Eureka.S05E01.HDTV.XviD-ASAP\Eureka.S05E01.HDTV.XviD-ASAP.avi] => 367011826
    [Eureka.S05E01.HDTV.XviD-ASAP\eureka.s05e01.hdtv.xvid-asap.nfo] => 4798
    [Eureka.S05E01.HDTV.XviD-ASAP\Sample\eureka.s05e01.hdtv.xvid-asap.sample.avi] => 7883092
)
Needs to be inserted to MySQL like:


In other words, the array $torrent->content() needs to be inserted to MySQL as new lines at columns "filename" and "size".

Please help me..

atm i have this in a function:

Code: [Select]
$returnInfo = array();

$returnInfo["totalWords"] = $totalWords;
$returnInfo["uniqueWords"] = count($uniqueWords);
$returnInfo["positiveWords"] = $positiveWords;
$returnInfo["negativeWords"] = $negativeWords;
$returnInfo["rating"] = $mappedrating;

return $returnInfo;

If i recursive print it it says Array instand of my expected values.

p.s., i have found examples where the array get's created in 1 line with all there values but i prefer not to do that since it will be a very long line.

how to connect juice and 1 and milk and 3 and cola and 2? and then sort it by the numbers from high to low?

$a=array('juice','milk','cola');
$a2=array('1','3','2');

For example:
Code: [Select]
DELETE FROM user_question_answer WHERE user_id = 1 AND question_id = 7 AND `answer_id` = 3
This sql query has no error, but reports deleting 0 rows.

user_id and question_id fields are both foreign keys in this table.  Could that be why it's not working, yet not reporting an error?

Thank you for your time.

Hi, I'm not sure if this is a wierd one, I have lots of arrays i'm looping through like this to see them:-


for($i=0; $i <count($confirmed); $i++){//loop through
     print_r_html($confirmed[$i]);
}


Which shows the following :-

Code: [Select]
Array
(
    [0] => AAAAAA-BBBBBB
    [1] => 2
    [2] => 2010-09-29
)
Array
(
    [0] => AAAAAA-BBBBBB
    [1] => 2
    [2] => 2010-09-28
)
Array
(
    [0] => CCCCCC-DDDDDD-EEEEEE
    [1] => 3
    [2] => 2010-09-29
)
Key 0 is a Groupconcat split by "-"
Key 1 shows how many fields are in 0
Key 2 is just the date

What I would like to do is split the first array into 2 arrays, the second in 2, and the third into 3 (therefore ungrouping the groupconcat if you will)
as such:-

Code: [Select]
First into these two:-
Array
(
    [0] => AAAAAA
    [1] => 2
    [2] => 2010-09-29
)
Array
(
    [0] => BBBBBB
    [1] => 2
    [2] => 2010-09-29
)
Second into these two:-
Array
(
    [0] => AAAAAA
    [1] => 2
    [2] => 2010-09-28
)
Array
(
    [0] => BBBBBB
    [1] => 2
    [2] => 2010-09-28
)
Third into these two:-
Array
(
    [0] => CCCCCC
    [1] => 3
    [2] => 2010-09-29
)
Array
(
    [0] => DDDDDD
    [1] => 3
    [2] => 2010-09-29
)
Array
(
    [0] => EEEEEE
    [1] => 3
    [2] => 2010-09-29
)
)
I know I can get out the info from the first of the keys in each array by putting this into the loop:-


for($i=0; $i <count($confirmed); $i++){//loop through
     if($i==0){
             $seperated[] = explode("-",$confirmed[$i]);//split by "-"
     } 
}
    print_r_html($seperated);



but i'm not sure how to copy the other keys at the same time? If anyone has got any ideas that would be great!
thanks in advance
Kev.

Hi,

I have the following code that takes a list from a mySQL db and puts it into an array that shows 'gig date, venue, city' per entry: -

 
Code: [Select]
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{

$array[] = ($row['date'].', '.$row['gl_venue'].', '.$row['gl_city']);
}

$output = json_encode($array);
this outputs JSON like so:
Code: [Select]
["06-05-2011, O'neills, Southend","07-05-2011, Power League, Peterborough","14-05-2011, Queen Victoria hall, Oundle",.......]
how do I add keys into the array so I get something like:
Code: [Select]

{"gigs":[
 { "gig": "date, venue, city",}
]}
 
at least I think so anyway!?!

What I want to do is eventually be able to parse a JSON listing into Objective-C and be able to call key/pairs into various different parts of an app.

I'm pretty new to this so any advice would be great.

Say i have two arrays with custom keys. What would be the easiest way to write a function that would determine if all the keys in arrayOne are in arrayTwo? The example below would return false because keys 3 and 4 are missing in arrayTwo. Any help would be much appreciate. thanks!

Code: [Select]
<?php

$arrayOne['1'] = "adg";
$arrayOne['2'] = "a4g";
$arrayOne['3'] = "346";
$arrayOne['4'] = "etwe";

$arrayTwo['1'] = "xcb";
$arrayTwo['2'] = "acbr";
$arrayTwo['6'] = "yiy";
$arrayTwo['7'] = "mmm";
?>