PHP - Php Keys & Values > Mysql Columns

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.

What I'm trying to do is take two arrays and combine them using array_combine. After they are combined I want to take each key and value pair and use them in a string to build a MySQL query. See below for some pseudo-code  =D


<?php
$fields = array('first_name', 'last_name'); //the fields that will be set with an UPDATE query.
$newvals = array('Joe', 'Blow');//The values that will go into $fields

$arr = array_combine($fields, $newvals);//Each value now has a key of the field it will update.

/**
This is where I want to return my SET string with something like 'SET ' . $arr['first_name']  ' = ' . $arr['first_name_value'] ', etc etc.
*/


There it is, I suppose. Are there any easier ways of doing what I'm trying to accomplish, that is, am I on the right track or just making things harder for myself?
Both arrays will have dynamic values throughout my application, so I need to be able to get both each field and value for each query. Any links to some constructs, etc, etc? That's all I really need and I can post the solution when I've figured it out.

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 this array:

Code: [Select]
<?php
$array = array('one' => array(), 'two' => array(), '_three' => array());
?>
How could I sort that array so it ends up like so:

Code: [Select]
Array
(
    [_three] => Array
        (
        )

    [one] => Array
        (
        )

    [two] => Array
        (
        )
)
Thanks!!

Hi there,

Basic question, but I can't seem to find a page in the PHP docs that answers (though I'm sure such a one exists, I just can't seem to think up the right search terms - anyway)

My question is: is there a short-hand way to use a value from an associative array as the key in another associative array?

So for example, given this array:

$the_array = array(0 => array('name': 'the_name', 'value' : 'the_value'), 1 => etc....);

then this kind of foreach loop doesn't work

Code: [Select]
$new_data = array();
foreach($the_array as $element){
$new_data[$element['name']] = $element['value'];
}

Obviously I can just save out the values, like $name = $element['name'] --- but I was just wondering if there was a more efficient way to do it?

Cheers,

PS. I tried encapsulating with {} - i.e. $new_data[{$element['name']}] --- but that also fails.

I am trying to create an autocomplete form for 'city,state zip'   I want to be able to search by either a distinct zip code that will show 'city, state zip' or by distinct city 'city, state'

Can anyone tell me how to fix my script?


$sql = "SELECT DISTINCT zip,city,state FROM `residential` WHERE `zip` LIKE '$input%' OR `city` LIKE '$input%' OR `state` LIKE '$input%' UNION SELECT DISTINCT city,state,zip FROM `residential`  WHERE `zip` LIKE '$input%' OR `city` LIKE '$input%' OR `state` LIKE '$input%'  UNION SELECT DISTINCT state,city,zip FROM `residential` WHERE  `zip` LIKE '$input%' OR `city` LIKE '$input%' OR `state` LIKE '$input%' LIMIT $limit";

$result = mysql_query($sql);

if (!$result || !mysql_num_rows($result))
exit;

include_once "headers.php";

echo "<response>";

while ($row = mysql_fetch_array($result))
{
   $keywords = "$row[city], $row[state] $row[zip]";
   echo "<keywords>". $keywords ."</keywords>";       
}
while ($row = mysql_fetch_array($result))
{
   $keywords = "$row[city], $row[state]";
   echo "<keywords>". $keywords ."</keywords>";       
}
echo "</response>";

Hello,   I've been going about reading different posts on here and other forums but so far I haven't been able to come across something that works for my purpose so after all the reading I thought I'd finally just ask. I'm rather new at php/sql queries so please bare with me.   First what I'm trying to accomplish.   I need a form with several fields (options) to fetch information from a table that will then display the results based on the options selected.   - from date - to date - employee name - department - branch - product line   In other words, the purpose is to be able to choose a date range (from one day to up to a year or more) and then to be able to choose either ONE employee name to view statistics invididually from a given department and branch or to select a department to view all the statistics for everyone under that given department and/or brach and/or product line.   Now the tricky part is that besides fetching the records, calculations need to be made before the records are displayed and that part right here is what is giving me a huge headache.   This is the query that I have.

SELECT
report_daily_id,
report_date,
emp_id,
emp_fullname,
emp_dept,
emp_branch
prod_line
calls,
tk_time,
hld_time,
ac_time,
tran_calls,
work_time,
tran_rate,
ah_time
FROM daily_report
GROUP BY emp_id, emp_fullname, emp_branch, emp_dept, prod_line

The calculations based on the date range and one or more of the other options need to give me the following results.

SUM(calls) AS 'Total Calls'
SUM(tk_time) / SUM(calls) AS 'Talk Time'
SUM(hld_time) / SUM(calls) AS 'Held Time'
SUM(ac_time) / SUM(calls) AS 'AC Time'
SUM(tran_calls) AS 'Total Trans'
SUM(tran_calls) / SUM(calls) AS 'Tran Rate'
SUM(ah_time) / SUM(calls) AS 'AH Time'

I don't know how else to explain myself past this point but if you have any questions, perhaps I can answer it and give more details.   Thank you,

Hello,
I am trying insert the values of csv file into a table. I want to concatenate the values of some columns of csv into one String column of table by delimiting them my commas.
 
$im="INSERT into TB1 (col1, col2 ) values ('$a[2]','$a[3]')";
$b = "";
$b=".'$a[6]'."||".'$a[7]'."||".'$a[8]'."||".'$a[9]'.";
$im1=$im+"UPDATE TB1 set latlng=.'$aline'.";
mysql_query($im1) OR die(mysql_error());

I need to enter the value of $a[6] till $a[9] into a string column with delimiters and insert into the column col3 of TB1 with value as $a[4].
I am stuck up here could anyone help me with this issue.

Hi all,

Just curious why this works:

Code: [Select]
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){
$import="INSERT into $prodtblname ($csvheaders1) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]')";
}
And this does not:

$headdata_1 = "'$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]'";
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){
$import="INSERT into $prodtblname ($csvheaders1) values($headdata_1)";
}it puts $data[#'s] in the database fields instead of the actual data that '$data[0]','$data[1]'... relates to.

I wrote a script to create the values in $headdata_1 based on the number of headers in $csvheaders1 but can't seem to get it working in the sql statement.

Thanks

I have looked all over the net on how to fix this... I am creating a baseball statistical website and I have 2 tables with identical columns (2012hitting and 2013hitting). I am trying to create a page where I can 1) group each year's statistics (which I have been able to do) and 2) have a row named "Career Totals". Each table has about 15 columns, various stats. How can I add the data from my 2012hitting table to my 2013hitting table into a Career Totals row for each player?

This is what I'm trying now:

Code: [Select]
/* CONNECTION VARIABLES */

$id = $_GET['id']; // get var from URL


/* Get data. */
$sql = "SELECT * (sum(2012hitting.hr) +sum(2013hitting.hr)) as totalhr FROM 2012hitting, 2013hitting WHERE id='$id'";
$result = mysql_query($sql);

?>


<?php
$alternate = "2";
while ($row = mysql_fetch_array($result)) {
$field1 = $row["season"];
$field2 = $row["team"];
$field3 = $row["games"];
$field4 = $row["ave"];
$field5 = $row["slg"];
$field6 = $row["r"];
$field7 = $row["h"];
$field8 = $row["rbi"];
$field9 = $row["bb"];
$field10 = $row["k"];
$field11 = $row["hr"];
$field12 = $row["dbl"];
$field13 = $row["tpl"];
$field14 = $row["sb"];
$field15 = $row["obp"];
$field16 = $row["ops"];
if ($alternate == "1") {
$color = "#ffffff";
$alternate = "2";
}
else {
$color = "#E4E4E4";
$alternate = "1";
}
echo "<tr bgcolor=$color><td align='center'>$field1</td><td align='center'>$field2</td><td align='center'>$field3</td><td align='center'>$field4</td><td align='center'>$field5</td><td align='center'>$field6</td><td align='center'>$field7</td><td align='center'>$field8</td><td align='center'>$field9</td><td align='center'>$field10</td><td align='center'>$field11</td><td align='center'>$field12</td><td align='center'>$field13</td><td align='center'>$field14</td><td align='center'>$field15</td><td align='center'>$field16</td></tr>";
}
echo "</table>";
?>
Thank you in advance!

So I have a database that is structured like this: https://imgur.com/a/DdyTqiE
Sample data: https://imgur.com/a/kYwmuO1
For each appointment, a student can have multiple categories, such as 'Academic Probation, Re-Admit' etc...

I would like to loop through this table, and get a count of how many were 'is_no_show' and 'is_cancelled' per (unique) category with respect to 'scheduled_student_services.' 
For example, in the sample data, we see that the first appointment has 4 categories (Academic Probation, Entering Cohort Year 20051, First Generation, and Re-Admit'). Now one of these categories  - Academic Probation matches up with what they were scheduled for - '1st Term Probation Advising'.  And they cancelled this appointment, so we want the count of cancellations under Academic Probation to go up by 1. 

How would I approach this? I know I probably need to do two loops but I'm not sure the PHP syntax for this. Any suggestions or tips would be helpful. Thank you for your time!

I have a table called "friends" and 4 columns called:  id......friend_1......friend_2.......date

I want to retrieve all of the friends of the user that is logged in, so if the table looks like:

friend_1.........friend_2
3.........................6
6.........................8
12.......................3

the result if the users id is 3 would be:
6
12
and if the users id was 6 it would be:
3
8


the query I have right now partially works, just note sure how to modify it to get the full result I want.

Code: [Select]
$get_friends = mysql_query("SELECT * FROM friends WHERE (friend_1='".$session."' OR friend_2='".$session."')");
while($friends = mysql_fetch_array($get_friends))
{
print $friends['friend_1'];
}with the code above if you use the table I showed above and assumed that $session = 3, the result is:
3
12

but should be:
6
12

hopefully that's pretty straight forward, thanks in advanced.

Hey guys seem to have tricky question here, I am just wondering how I could do the following:   I have an SQL table that contains these columns:     As you can see there is a 'Make' column and a 'Model' column and each row displays what make it is.   I now want to associate the 'Makes' with the 'Models' in another table just like this example:   BMW        AUDI        VOLVO        FORD        TOYOTA X5            All Road    XC90           Focus        Supra 3 Series   A1             C30              Mustang    Yaris 5 Series                                         Galaxy   So for example if the first table has a row that contains the make 'AUDI' within the 'Make' column I then want it to take the value of the 'Model' and list it into my other table under the 'AUDI' column, any ideas how I can do this with PHP?   Thanks!