PHP - Is There A Way To Join Several Arrays Stored In One Variable?

Hi,

I have a function where I want to sort an an array of this type:

0 = {'fruit' => 'banana', 'color' => 'yellow', 'age' => '1', 'weight' => '2', 'brand' => 'dole', 'store' => shaws'}
1 = {'fruit' => 'apple', 'color' => 'red', 'age' => '3', 'weight' => '5', 'brand' => 'fuji', 'store' => 'foodmaster'}
etc etc.

I then want to array_multisort this array with different parameters. One way is to sort by fruit, then color, then brand. The second way by age, then store.

Code: [Select]
//This is how I sort it for my first way
//Let's call the array $rows
function sort($rows) {
foreach($rows as $key => $value) {
        $fruit[$key] = $value['fruit'];
$color[$key] = $value['color'];
$brand[$key] = $value['brand'];
    }

    array_multisort($fruit, SORT_ASC, $color, SORT_ASC, $brand, SORT_ASC $rows);
}
I want to try to reuse this function by passing in the keys that I want to sort with. Like doing sort($rows, array('fruit', 'color', 'brand')), then sort($rows, array('age', 'store')). Is this possible?

         

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=308855.0

 wrote a stored procedure this morning and i don’t know how to get the values out of it through a class function in php or phpmyadmin.

here is what i wrote :

public function totalProcedures($friend_name,$session_id) 
{ /* *query to fetch stored procedure */ 
try { 
//executing the stored procedure 
$sql_sp="CALL timeline (:friend, :session,@updates, @group_posts)";
$stmt_sp= $this->_db->prepare($sql_sp); 
$stmt_sp->bindValue(":friend",$friend_name);
$stmt_sp->bindValue(":session",$session_id); 
$stmt_sp->execute();
$rows=$stmt_sp->fetch(PDO::FETCH_ASSOC); 
$stmt_sp->closeCursor(); // closing the stored procedure 
//trying to get values from OUT parameters.
$stmt_sp_2=$this->_db->prepare("select @updates,@group_posts");
$stmt_sp_2->execute();
return $stmt_sp_2->fetch(PDO::FETCH_ASSOC);
} catch (PDOException $ei)
{
echo $ei->getMessage(); } 
}

can someone helpme how to get results.

here is the storedprocedu

DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `timeline`(IN `friend` VARCHAR(255), IN `session_id` VARCHAR(255), OUT `updates` VARCHAR(62555), OUT `group_posts` VARCHAR(62555))
BEGIN


select * FROM updates where author in (friend,session_id)  order by time desc limit 5;



select * FROM group_posts where author_gp in (friend,session_id) order by pdate desc limit 5;
END$$
DELIMITER ;

i get the result in php myadmin as follows:

 how do i do this inside a php class function.

CALL timeline('shan2batman','aboutthecreator', @updates, @group_posts);

 

I have this thing that i am trying to make but i cant get it to work.. can anyone help?

Code: [Select]
function sql_read( $dbname,$dbusername,$dbpassword )
{
$names = array();
$password = array();


$connect = @mysql_connect("mysql11.000webhost.com",$dbusername,$dbpassword) or die("Could Not Connect");
@mysql_select_db ($dbname) or die("Could not find DataBase");


$query = mysql_query("select * from users");
$numrows = mysql_num_rows($query);

if ($numrows > 0){

while($row = mysql_fetch_assoc($query)){

$names[] = $row["uname"];
$password[] = $row["password"];
$id = $row["id"];

}
$return = array($names,$password,$id);

}else{
$return = array();
}


return $return[];
}



$names = array();

$names = sql_read("XXXXXX","XXXXXX","XXXXXXX")[0];


The error i get is
Code: [Select]
Parse error: syntax error, unexpected '[' in /home/a5480952/public_html/sql/index.php on line 28
Line 28 is "$names = sql_read("XXXXXX","XXXXXX","XXXXXXX")[0];"

Please help... i REALLLLD need help with this.. ask questions if you want to know more about what i am trying to do... thanks!

I'm having troubling with trying to create a function to spit out a single array with the following array. I can write it in a away that looks through the arrays manually. 

the results i am trying to generate is that each item in generated array.

Array to convert

array(
    "account" => array(
        "login",
        "register",
        "logout",
        "edit",
    ),
    "p" => array( 
        "report",
    ),
    "array1.0" => array( 
        "array2.0" => array(
            "array3.0",
            "array3.1
        ),
        "array2.1",
    ),

generating the array will look like this

 

Array ( 
[0] => account 
[1] => account/login 
[2] => account/register 
[3] => account/logout 
[4] => account/edit 
[5] => p 
[6] => p/report 
[7] => array1.0 
[8] => array1.0/array2.0
[9] => array1.0/array2.0/array3.0
[10] => array1.0/array2.0/array3.1
[11] => array1.0/array2.1

)

The idea is that id generates a single array with combined labels and arrays inside, etc. I just can't figure out how to create a script that will create this array even If I add a new value or array. 

 

Often times I need to convert between PHP Arrays, MySQL, XML, JSON sqlite etc. Lately I've been just building PHP arrays with all the data. Its a big hassle though when theres a lot of data. I'm thinking I should have one central location that I store data in, then export to other formats from there, but I dont know what that central location should be. I like MySQL because I'm used to it. Sometimes its not an option though, like if I need to make a really light script, I dont want the hassle of connecting to MySQL. Would XML be the best place to store data, then from the XML file I can convert it to whatever format I want?

I'm working on a project and cannot figure out why one piece of code works in one project but not in this one.

Code: [Select]
$username = "voltageme5";
$result = $mysqli->query("call usernameCheck($username)");

returns
string(43) "Unknown column 'voltageme5' in 'field list'"

Here is the stored routine:

Code: [Select]
CREATE PROCEDURE `database`.`table` (IN memUsername varchar(45))
BEGIN
select count(*) as total from members where username = memUsername;
END

Whats weird is that in the PHP code if i replace the variable with a string, it works. It's only with the variable in the call that it errors out like that. I'm new to this stored procedure thing so I'm sure I'm missing something stupid.

Hi Everyone,

I have this php page that runs couple of MS SQL stored procedures to fetch me values from SQL Server, however I have run into a problem where not more then 2 stored procedures are executed at same time. For instance below mentioned code only fetches me values for 1st and 2nd SP's. If I need values from the 3rd stored procedure then I would have to comment either one of the first two stored procedure.   Can someone please tell me what is that I am doing wrong.   I am relatively new to PHP, so please be gentle. Any help would be highly appreciated.

Thanks.

<?php


if($conn = mssql_connect('host', 'user', 'pass')) echo 'Connected to SQLEXPRESS<BR>';
if(mssql_select_db("database",$conn)) echo 'Selected DB: SomeDatabase<BR>';

$variable1=something;

$sql_statement =  mssql_init("stored_procedure1 '$variable1'", $conn);
$result=mssql_execute($sql_statement);

$x=0;

while ($row = mssql_fetch_assoc($result))
    {
    $column2[$x]= $row['column2'];
    $column1= $row['column1'];
    
$x++; }

    
echo "Value 1: $column1      </br>";
echo "Value 2: $column2[0]  </br>";
echo "Value 3: $column2[1]  </br>";
echo "Value 4: $column2[2]  </br>";
echo "Value 5: $column2[3]  </br>";
echo "Value 6: $column2[4]  </br>";
echo "Value 7: $column2[5]  </br>";


mssql_free_statement($sql_statement);



$sql_statement =  mssql_init("stored_procedure2 '$variable1'", $conn);
$result=mssql_execute($sql_statement);


$x=0;

while ($row = mssql_fetch_assoc($result))
    {
    $someval1[$x]= $row['somecolumn1'];
    $someval2[$x]= $row['somecolumn2'];
    $someval3= $row['somecolumn3'];
    $someval4= $row['somecolumn4'];
    $someval5= $row['somecolumn5'];
    $someval6= $row['somecolumn6'];

$x++; }

    
echo "Something1: $someval1[0]</br>";
echo "Something2: $someval3 </br>";
echo "Something3: $someval2[0] </br>";
echo "Something4: $someval4 </br>";
echo "Something5: $someval6 </br>";
echo "Something6: $someval5 </br>";


mssql_free_statement($sql_statement);


$sql_statement =  mssql_init("stored_procedure3 '$variable1'", $conn);
$result=mssql_execute($sql_statement);


$x=0;

while ($row = mssql_fetch_assoc($result))
    {
    $somevaluecheck= $row['somecolumncheck'];

$x++; }
    
echo "SomethingCheck: $somevaluecheck </br>";


mssql_free_statement($sql_statement);


?>

Hello,

Here's my system. Once a user is successfully logged in, a new instance of a User class is created. The constructor of this class grabs the details of the logged-in user from a database and stores them inside properties in the User class.

The problem is, obviously I'd want to access these properties from any page I require them to be able to display user data, so I looked into storing the User object in a Session.

When I tried implementing this, I ran into a bunch of errors and I couldn't figure it out.

Here's an example:

After a user has logged in, I had the following code:
Code: [Select]
$_SESSION['user'] = new User($this->username);
I was under the impression that this assigns a user object to a session. But it's not working as I receive this error:

Quote

Notice: Undefined index: user in ../v2/admin/index.php on line 18



Then on the page I want to display the name of the current user logged-in, I had this code:
Code: [Select]
$_SESSION['user']->get_Name();
But then I get this error:
Quote

Fatal error: Call to a member function get_IP() on a non-object in ../v2/admin/index.php on line 18



Can tell me what I have to do, to make this work?


Thanks.

How can I run php code that is stored in a database?

I have my pages created by grabbing the contents of a pageBody mySQL table cell, but some pages require further php to be able to display correctly.

For example, I have a players page, which will list all players, and some information about them. The players and information is all saved in a players table in my database (separate to the pages table where pageBody is stored). I use simple php to grab all the players and format all of their information so it can be displayed on the page.

This is the flow of information that I would like:
User clicks on players page browser loads content page (this is a template page), and grabs the pageid from $_GET browser then reads pages table in database to get the pageBody associated with the pageid The pageBody will contain more php, which will run the players script to retrieve the list, and display
Doing it the above way will make it much easier to extend the website to include more types of pages that has to run additional php scripts.
The only way I can think of this working is by doing this:
user clicks on players page
browser loads content page, grabs pageid from $_GET browser checks the pageid for the one associated with players (hard coded into the php script) browser then loads the players.php script instead of going to the database This above way means that I will need to edit the index.php page everytime I add a new list type (example, coaches, volunteers etc).

Anyone have any suggestions? I know my question is long, but I was finding it hard to explain it in an easy to understand way, but I'm still not sure if I have :S.

Cheers
Denno

I am trying to make a  setup file for a website I'm developing, and am having the database tables and stored procedures created automatically.  However, I'm having issue getting the stored procedures to be created.  Here is my code:
Code: [Select]
$db->Q("
DELIMITER $$
CREATE PROCEDURE `Database`.`Procedure_Name`(in sp_uid mediumint(20) unsigned, in sp_user varchar(15), in sp_pass varchar(20), in sp_email varchar(30))
BEGIN
Insert Into Table Values (sp_uid, sp_user, md5(sp_pass), sp_email, '1', '1', '0');
Select true;
END$$
");
Assume that the "$db->Q()" works just fine, as I'm having issues no where else with it.  This automatically connects to the database and runs a query with whatever is inside the "()".  The tables are being created just fine, but no stored procedures are being created.  I've tried everything I can think of, and googled my question many different ways without finding an answer or work-through.  Does anyone know what I am doing wrong?

Thanks in advance.

I am writting a php function that uses mysql to get user data - pretty common, right

Well, my issue is that I need to run a check in my file system.  Users profile pictures are stored in my image directory as .png's.  I need to have my function check that directory and if an image matches their id, then return their information.  I only want the user data if they have an image uploaded.

Here is my current function:

Code: [Select]
function fetch_users_login($limit)
{
$limit = $limit(int);

$sql = "SELECT
                `users`.`id`,
                `users`.`firstname`,
                `users`.`lastname`,
                `users`.`username`,
`user_privacy`.`avatar`
            FROM `users`
LEFT JOIN `user_privacy`
            ON `users`.`id` = `user_privacy`.`uid`
WHERE `users`.`status` > 2
AND `user_privacy`.`avatar` = 1
ORDER BY `users`.`id` DESC
LIMIT 0, {$limit}";

$result = mysql_query($sql) or die(mysql_error());

$users = array();

$i = 0;

while(($row = mysql_fetch_assoc($result)) !== false)
{
$users[$i] = array(
'id' => $row['id'],
'firstname' => $row['firstname'],
'lastname' => $row['lastname'],
);

$users[$i]['avatar'] = getUserAvatar($row['username']);

$i++;
}

return $users;
}

hey guys

i have this code

FILE NAME "index.php"
Code: [Select]
<?php

// make a connection to the database
mysql_connect ("localhost", "root", "vertrigo") or die ('Error: I Failed To Connect To The Database ' . mysql_error());
mysql_select_db ("test");

// Get Data
 $query = mysql_query("SELECT * FROM TestTable");

// display the data and loop
while ($row = mysql_fetch_array($query)) {
echo "<br /> ID: ".$row['ID']."<br /> First Name: ".$row['FName']."<br /> Last Name: ".$row['LName']."<br /> Contact Number: ".$row['CNumber']."<br />";}


?>

<form method="post" action="update.php">
<table border="1" align="center">
  <tr>
    <td align="right" width="220">ID:&nbsp;</td>
    <td align="left" width="220">&nbsp;<input type="text" name="ID" size="30" /></td>
  </tr>
  <tr>
    <td align="right" width="220">First Name:&nbsp;</td>
    <td align="left" width="220">&nbsp;<input type="text" name="FName" size="30" /></td>
  </tr>
  <tr>
    <td align="right" width="220">Last Name:&nbsp;</td>
    <td align="left" width="220">&nbsp;<input type="text" name="LName" size="30" /></td>
  </tr>
  <tr>
    <td align="right" width="220">Contact Number:&nbsp;</td>
    <td align="left" width="220">&nbsp;<input type="text" name="CNumber" size="30" /></td>
  </tr>
  <tr>
    <td align="right" width="220"><input type="reset" value="Reset" />&nbsp;</td>
    <td align="left" width="220">&nbsp;<input type="submit" value="Update Database" /></td>
  </tr>
</table>
</form>

and i also have this code

FILE NAME "update.php"
Code: [Select]
<?php
$ID = $_POST['ID'];
$FName = $_POST['FName'];
$LName = $_POST['LName'];
$CNumber = $_POST['CNumber'];

mysql_connect ("localhost", "root", "vertrigo") or die ('Error: I Failed To Connect To The Database ' . mysql_error());
mysql_select_db ("test");

$query="INSERT INTO testtable (ID, FName, LName, CNumber)VALUES ('".$ID."','".$FName."', '".$LName."', '".$CNumber."')";

mysql_query($query) or die ('Error Updating Database');

echo "Database Updated Sucsessfully With: ".$ID." ".$FName." ".$LName." ".$CNumber ;

?>

ok so the script is working like a charm
its sending the data to the database as i want it to.
the problem i have is that i want to be able to update the info that is already on the database

lets say i want to change a phone/contact number
i have typed the ID number into the ID text field and the same first and last name into there correct boxes and then typed in the new phone number
i then click submit and i get the error ""Error Updating Database""
i have looked all over the forum and net to see what i have done wrong to not allow this code to update

can anyone help me out here please
im quite new to the php language and could really do with some pointers

thanks
Steve

I have a PHP page that offers various information from a single text file. This text file is

encrypted on the server HD.

Upon initial entry into the page, the user enters an encryption/decryption KEY and the

encrypted file is decrypted to clear text and it is available for viewing.

I have some parameters that I store in PHP session variables. I do this since various

subsequent actions by the user will require these parameters. The code is written and the whole process seems to

work well.

Since the info in these session variables is sensitive, I need to understand WHERE they are

stored. I know that it is a file on the HD, but after hours of reading the PHP Manual on

sessions, I am not finding where (HD directory) that storage is.

I have a typical shared hosting account for my web site. Mostly I want to discover is, are

the session variables in y User/file hierarchy, or are they stored in a system area where

the PHP is installed.

Whew. Sorry this was so long.

Thank you,
xphp