Tagged Questions
0
votes
1answer
49 views
PHP, MySQL, Array from HTML Form in Search Query?
I have a search engine with an html form that sends data to a PHP script the queries a MySQL database. In the html form, I have a option that allows multiple selections. Thus far, I have put square ...
0
votes
1answer
18 views
NSARRAY JSON empty
i'm trying to download some data from a mysql server, i would like to use JSON to parse the result of a query.
This is the PHP
<?php
class Prenotazione {
public $ID_prenotazione;
public ...
-2
votes
2answers
40 views
Arrays dont want to cooperate while using PHP and JS with Jquery [closed]
This is very strange problem and I really dont know what should I do.
I take array workers from MySQL database with json_encode
Then i copy it to two other arrays on which I will make operations soon
...
0
votes
3answers
41 views
PHP reading fields in database
I have a script that reads my database table fields. Its not reading the first column which is the id.It reads the other fields and adds them into the array. I have added in the for loop a -1 to get ...
0
votes
3answers
36 views
Looping through results of a sql query
I have a query that returns multiple rows. I can't seem to find a way to store the rows in the $params array. Is there a way to loop throw and store each row in the $params variable
$aResult = ...
0
votes
2answers
60 views
SELECT from multiple Tables and String
I'm trying to get the 'total results' of a query, but kind of struggling to get my head around it and just keep encountering errors. This is my table setup:
exp_channel_data table
entry_id ...
-1
votes
3answers
32 views
php array error in displaying a table
I am trying to display all the data from a mysql table into a html table and the php is getting the data fine but the table isnt displaying it properly this is my code:
<table border="1">
...
0
votes
1answer
39 views
Returning data from SQL query into an array
I have the following code:
$aResult = $db->exec_sql($sql);
//dlog2("matt", __line__, $aResult);
print_r($aResult);
$params = array(
'store_id' => ...
1
vote
1answer
33 views
Creating an associative array from MySQL Query Results I receive only 15 values [closed]
This my code (below).
Any array $zmin has only 15 records (values).
Variable $n1 ($n1 = mysql_num_rows($result);) has more records (values).
Is anything limit for this?
$zmin$[] = ...
1
vote
1answer
32 views
fetch mysql prepared statement as array of hashes
I'm struggling with ruby's mysql gem and prepares statements.
I want to end up with the same as I would do with each_hash over the result, but it's nor supported in prepares statements.
So I came with ...
0
votes
1answer
29 views
[PHP]Edit records,update mysql query
I have a table that looks like this:
survey_id | question_id | option_one | option_two| ... option_ten|
1 | 1 | Yes | No | ... |
1 | 2 ...
0
votes
0answers
24 views
nestedSortable jQuery Plugin with mysql to generate navigation
I have searched high and low to figure out my issue but at this point, I am thinking too hard. What I wish to do is create a navigation editor using the nestedSortable plugin.
I have already ...
-3
votes
3answers
48 views
Convert SQL results into PHP array [closed]
I'm fairly new to PHP and I've been looking around and can't seem to find the specific answer I'm looking for.
I want to make a SQL query, such as this:
$result = mysqli_query($connection, $command)
...
0
votes
2answers
40 views
PHP objects inside arrays (HOW TO: If array key is 0, return 0. Else if array key is 2, return 2. BASIC LOGIC)
What I'm trying to do:
Get a list of names (if more than one) on a single string separated by a comma this way:
Britney Spears, Lady Gaga, Miley Cyrus
What's going on:
We are inside a loop. ...
-3
votes
1answer
56 views
Is this a case for Multidimensional arrays? [closed]
Good day to you all!
I have seen lots of questions here on turning retrieved mySQL data into PHP arrays...but I am green with PHP and cannot seem to make the leap to my own coding. My project is to ...
