PHP - Need Help To Assign An Array To A Single Value

Hello
can anyone  help me out with code to create a 2 dimension array from 2 single dimension array. for example
$path = array('base', 'category', 'subcategory', 'item');
$location=array('india','USA','UK','RUSSIA',);
now i need to have a @D array which have the following structure
$final[0]=array('base','india');
$final[1]=array('category','USA');
$final[2]=array('subcategory','UK');
$final[3]=array('item','RUSSIA');

Hi,  learning as I go here, and I appreciate the help in advance ..

I have some working php code that retrieves sql results using php.  I assign the resutls to an array by doing this

$bobreport = array();
while ($row=db2_fetch_array($querystmt)) {
   array_push($bobreport, $row);
}

i can then write the rows of returned data after some column headers using this...

foreach ($bobreport as $value) {

echo "<tr><td>$value[0]</td><td>$value[1] .....

}

The particular report I'm working on now has a redundant date and time in every row that I omit in the foreach loop because I just want to show it once above the table somewhere.  This doesn't seem to work in accomplishing that...

echo "This data was updated ".$bobreport[0][9]." at ".$bobreport[0][10] ;

All I seem to get in the report is "This data was updated at".

Please help.

I came up with this but it outputs the value 3 times... (because there are 3 variables)

ie mathsmathsmaths

How do I fix this or do it the correct way? Thanks

Code: [Select]
$subject = "maths";
$phone = "1235";
$colour = "red";
$all_vars = compact("subject", "phone", "colour");

get_value($subject);

function get_value($variable){
global $all_vars;
foreach($all_vars as $key=>$value){
if ($key = $variable) {
echo $key;
}
}
}

Hi Guys,

I have 6 file upload fileds in an array. When i try to return the error messages at this link: http://www.php.net/manual/en/features.file-upload.errors.php i get an error displayed for every upload box. I was wondering if it is possible to simply return 1 error instead of the 6? For example rather than getting "No File Uploaded No File Uploaded No File Uploaded No File Uploaded No File Uploaded No File Uploaded" i simply get "No File Uploaded". Also If only some files are uploaded no error should be displayed.

The code i am using is:

foreach ($_FILES['image']['error'] as $key => $error)

{

if ($error == UPLOAD_ERR_NO_FILE)

{

echo "No File Uploaded";

}


I have tried using "break;" which works in leaving only 1 error, however the error is still displayed if less than 6 files are uploaded.

All help greatly appreciated.

Thanks

Quote from: Hollows on August 20, 2010, 11:29:25 AM

I have an array that is pulling 10 results from a db like this -


<?php
$result = mysql_query("SELECT * FROM inbox ORDER BY id DESC LIMIT 0,10");
while ($row = mysql_fetch_array($result)) {

<div class="<?php echo $row['class'];  ?>">
<?php
echo $row['name'];
echo $row['message'];
?>
</div>


basically 'class' is defined in an earlyier part of the script and is used to tell the css what class to display - as I'm sure you can see.

What I'd like todo then be able to update the class of a message once I have read it, so update the class table with something like 'read' so the css will then be based on .read not what ever was set by the form, either using a link or form button inside each of the 10 results from the array.

I've managed to update one by using -
Code: [Select]
mysql_query("UPDATE shoutbox SET class = 'read' WHERE id = ''XX"); // XX should be row id

But I had to set that myself and point the id to the row id I wanted to change - How can I have that already populated with the row for the id that triggered it?


To be clear so it looks like -

Name
Message
read button
_____________
Name
Message
read button
_____________
Name
Message
read button
_____________

and so on...


Would I be better going by check boxes and one submit button? If so how could I implement that?


I can provide the full code I've written if it helps

Thank you in advance

Hi all, I am using foreach statement to gather records and program levenshtein to detect any misspellings and suggesting the correct words.   The thing is i am unable to convert all those strings into a single array.   After trying to correct this issue so many times, i wonder if it is really possible to convert strings into a single array?   Any input is welcome  

Hi guys,
I am using this oAuth library https://github.com/elbunce/oauth2-php
But more specifically these lines of code:

protected function getToken($token, $isRefresh = true) {
try {
$tableName = $isRefresh ? self::TABLE_REFRESH : self::TABLE_TOKENS;
$tokenName = $isRefresh ? 'refresh_token' : 'oauth_token';

$sql = "SELECT $tokenName, client_id, expires, scope, user_id FROM $tableName WHERE token = :token";
$stmt = $this->db->prepare($sql);
$stmt->bindParam(':token', $token, PDO::PARAM_STR);
$stmt->execute();

$result = $stmt->fetch(PDO::FETCH_ASSOC);

return $result !== FALSE ? $result : NULL;
} catch (PDOException $e) {
$this->handleException($e);
}
}


However, this is retuning no value.
If I modify the code to be:

protected function getToken($token, $isRefresh = true) {
return $token;
}

It returns the $token value, so the $token is definitely being passed to the function.

The code should return an associative array: i.e., $token["expires"], $token["client_id"], $token["userd_id"], $token["scope"], etc
Also $token should not === NULL.

PS. I run a few checks on

$tableName = $isRefresh ? self::TABLE_REFRESH : self::TABLE_TOKENS;
$tokenName = $isRefresh ? 'refresh_token' : 'oauth_token';

And they are returning the correct values.

Which from my thinking narrows it down to:

$sql = "SELECT $tokenName, client_id, expires, scope, user_id FROM $tableName WHERE token = :token";
$stmt = $this->db->prepare($sql);
$stmt->bindParam(':token', $token, PDO::PARAM_STR);
$stmt->execute();

$result = $stmt->fetch(PDO::FETCH_ASSOC);

return $result !== FALSE ? $result : NULL;


Any and all help is greatly appreciated.

Thanks in advance.

Hi

I have a results page from a  MySQL query and I have implemented pagination to present data in chunks of 25 per page in a table view (each row => 1 entry).

My problem is that next to each data row, I have a selection checkbox, and if the user clicks on it, he can download the selected entries. This thing worked OK before I employed paginated view, when I presented all data in one page. Now, if I select e.g. 2 entries in page 1, then I jump to page 12 and select another 2 entries, if I click on the "Retrieve" button, I get only the last 2 entries (from the last page visited).

How can I solve this problem? With JS? Can I use PHP only?

PHP script return 20 UL LIST values like,

< ul >

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T

< /ul >

How to display UL LIST into row wise 5 columns like

A B C D
E F G H
I J K L
M N O P
Q R S T (20 ITEMS)

Edited December 7, 2019 by aveeva

Hi, I've been scratching my head for a while now about how to do this, I'm relatively new to php and mysql and perhaps foolishly taking on creating a user area for a website.  I have everything else working, all of my register account functions and confirmations and all of the login scripts etc. 

I have created a profile page which returns various information to the user (this bit works fine) and I've got some nice show/hide toggles running with some javascript/css but my intention is to allow the user to change thier information (e-mail address, contact phone number and also whether they are subscribed to the e-mail list), it also displays any support tickets or messages.

So after the long intro, here's what I'm struggling with...  I have a form in a visibility toggled <div> which submits a 'change_email' script, so a user wants to change their e-mail, clicks on change, the <div> appears, they bang in the new e-mail and hit submit.

My php script appears to work (because it doesn't throw up any errors), until you realise that actually it's not updated the record in the db...

I'm using mysql_query("UPDATE users SET email='$new_email' WHERE username='$user'");

Do I need to setup variables for all of the information in the db (name, username, password, email, contno etc etc) and include them in the command to get it to work or should that just pick the correct record and then update it? If that is the case is there a way I can include 'blank' variables so I don't have to set them all up...

e.g.  mysql_query("UPDATE users SET user='',password='',email='$new_email', etc WHERE username='$user'");

Many thanks in anticipation

alright, soI want to query a table and grab the last record in a desc order and assign it plus one.

My code so far for testing is:



<?php
ini_set('display_errors',1);
error_reporting(E_ALL|E_STRICT);

 include "connect.php";

$result = mysql_query("SELECT * FROM tickets ORDER BY id DESC LIMIT 1");

echo "<table cellpadding='4' cellspacing='4'><tr>
<th>id</th></br>

</tr>";while($row = mysql_fetch_array($result))
  {
  echo "<tr><td>" . $row['id'] . "</td></tr>";
  }
echo "</table>";


?>




So I can display the returned value, but how can I assign the returned value to a php variable?

Hi All,   I hope someone can help!   I've got some code that passes an array of values via an ajax call. This works fine and I can see my values in the specified div:

$("#container").html(data);

What I'd like to do, is get that info and pass it to a cookie. However, I'm struggling a tad. I currently have this:

var set_me = html(data);
$.cookie('choice',set_me, {expires: 7, path: '/'});
alert( $.cookie("choice") );

But sadly it's not working. I think it's something simple but this is new to me some need some help please   Thanks

does anyone knows how to fill this value to a variable (code below works on the screen):

Code: [Select]
(str)$txt->value;
echo (str)$txt->value;
I need to get the value from the code above into $myvalue (code below does not work):

Code: [Select]
(str)$txt->value;
$myvalue = (str)$txt->value;
echo $myvalue;

I have a page that lists out some basic information about each quiz this particular student has taken (call it "quiz summary"). I am creating another page that will have all details of a particular quiz by itself (call it "quiz detail").

If I have a link for each quiz on the "quiz summary" page, how do I tell the "quiz detail' page which link they clicked on? Or which quiz they have selected.

I was thinking it would work if I assigned a session variable to each link and then the "quiz detail" page could verify which returns true still and show details for that quiz. Would this logic work? Npot sure how to do it anyone though.

thanks for any help!

Completely new to PHP here,

so on my website I'd like a specific image to appear according to whether or not the user in my DB has a row called 'premium', with a value of 1. I've tried figuring it out on my own but I'm stuck. I watched a video of someone doing something similar so this is what I have currently, but I'm aware it's totally incorrect.

//init.php file

<?php
if (session_status() == PHP_SESSION_NONE) {//php >5.4
  session_start();
}
$_SESSION['user_id'] = 1;   
$db = new PDO('mysql:host=127.0.0.1;dbname=loginsystem', 'root', '');
$userQuery = $db->prepare("
	SELECT idUsers, uidUsers, emailUsers, pwdUsers, premium
	FROM users 
	WHERE idUsers =:user_id
	");
	$userQuery->execute(['user_id' => $_SESSION['user_id']]);
	
	$user = $userQuery->fetchObject();

//webpage in which the image will appear
 

<?php
require_once '../includes/init.php';
?>
 <?php if($user-> premium): ?>
      <img src="../../img/premium.png" alt="Swiftify+"></a>
<?php else: ?>
      <img src="../../img/swiftify.png" alt="Swiftify+"></a>
<?php endif; ?>