PHP - Ssrs Php Sdk, Having A Hard Time To Get This To Work...

Hey guys,

this is what I'm trying to do.
I want to print on the member's profile page, a list of the products he has bought so far.

I've come with two solutions:

A) add a new field to the products' table, with the ID of every clients that bought that product;
B) add a new field to the members table, with the ID of every products he bought;

These are pretty similar approaches, but I've no idea on how can this be done.

It would look like:

Bought: 2, 3, 4, 5,

I dont know how to write this data or how to read it.

Any idea?
Thanks!

Ok all I need some help with this. I have been stuck for two days. Basically I have a form that asks a registrant their gender and age, then my script spits out a list of race categories they qualify for. The situation calls for the registrant to be able to register for any category YOUNGER than them, but not older.

Screen Shot #1 shows my database setup (this can be changed if you have any better ideas...) that holds the race category information.

Here is the sql statement I am using to pull a female racer information, where $race_age is their submitted age.

"SELECT * from counts where female=1 and $race_age < age_end and $race_age > age_start"

This works, but doesn't pull any categories YOUNGER Than their age.

I'm stumpped Thanks for any help in advance.

I'd like to detect emails that hard bounce after i send out my newsletter, and then delete them from the table that stores them in my database.

Any ideas? Thank you.

In ubuntu 18.10 ,  i created a folder name db in the external usb hard dirve changed the ownership to the www-data the apache2 server and set the permissions to 777 , i run this php code and get the permission error:

<php
 chdir('/media/user/e46cafba-2656-4e42-b1c9-6417f28839df/db/');
 system('./rs');
?>    

but the php code cannot change to the dir and get the error:

[21-Feb-2019 10:43:26 UTC] PHP Warning:  chdir(): Permission denied (errno 13) in /home/user/www/html/rse4db.php on line 5

 

hey guys

so I have this code:
$result = mysql_query("SELECT * FROM pec_mssgs  ORDER BY (y / m) DESC, d ASC");

while($row = mysql_fetch_array($result))
  {
  
  
echo "&bull;<a style='text-decoration: underline; font-weight: bold;' href='../index?id=".$row['id']."'>". $row['m']."/".$row['d']."/".$row['y'] . "  -  ".$row['title']."</a>";
echo "<br /><br />";


  }

in my database instead of doing date I have 3 rows d, m, y, which correlate to day, month, year.

now currently its echo out a list and sorting by year then month then day this way the events which are happening soonest will be at top.

the problem is it shows events that has already passed.

what do I do?

It will be way to much work to to back and recode the application to just use date.

is there a way I can create a var. using my d/m/y then compare that var. to the current date or something?

thanks for the help.

This topic has been moved to MySQL Help.

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

 hello, i seem to be stuck again and this bug is difficult for me to solve.

if(isset($_POST['boards']))
	$boards[] = $_POST['boards'];
$allboards = implode("",$boards[0]);
echo $allboards;

outputs (browser source)...
hello
world

I have a combobox with the "multiple" property.  when two items are selected, the combobox "name" property has an array that passes to the $_POST variable. what i would like is those two words to be displayed on the same line.
I have tried rtrim($var, "\r\n") but that does nothing.

the reason i need them on the same line is because i would change then to "hello, world" and then add them as a mysql query, for example... $query = "SELECT hello, world FROM table...

hello,

if i have

$big=3410

how can i take the last 2 digits of that to make it so that i only get the 10?

hope this makes sence.

Hi guys. First of, English is not my spoken language so have patience

I've google it and done some reading regarding "hard refresh" but i cant find the information i'm looking for.
Lets say that i visit a website that i've visit 6 month earlier, and what if they done some changes that require a so called hard refresh. How should people know that the site require a ctrl+5?
I mean, i could be visit sites that looks different without my knowledge, that could been changed several month ago?

How does it work? Is it manage automatically or is it up to the webmaster to implate some codes like
Code: [Select]
<?php
header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT"); // Date in the past
?>
I dont know much about site development and i try to learn as much as i can. Is there no better way to handle this.

And my second question.
Where should i paste codes like this to solve the cache problem? In the header.php?

hello dear php-experts


how to testrun a drive with command-line?

note: i had several blank screens during the last week

does this somewhat have to  do with the hard-drive?

which tests can be done?

Hi all,

I have created a successful registration and login page for what will eventually be a squash league website.

I am struggling with the following issue.

When a player logs in using their email address and password I want to populate some drop down boxes which are relevant to the person who has just logged in.

These drop downs should show all the leagues the logged in user belongs to and the other drop down should show all the players the currently logged in player has ever played against so that they could view a head to head.

So my code works but currently I have the id of the player who has logged in hard coded in my sql statements.

I'm wondering if anyone can help me so that I can pass in the id of the player who is logged in as obviously the whole site is not going to work with hard coded values.

The code is as follows:

Code: [Select]
<?php

include_once $_SERVER['DOCUMENT_ROOT'] . '/includes/magicquotes.inc.php';

require_once $_SERVER['DOCUMENT_ROOT'] . '/includes/access.inc.php';

if (!userIsLoggedIn())
{
 include 'login.html.php';
 exit();
}

if (!userHasRole('Squash Administrator'))
{
 $error = 'This page is only for Squash Administrators.';
 include 'accessdenied.html.php';
 exit();
}

if(isset($_REQUEST['email']))
{
 include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
 
 $email = mysqli_real_escape_string($link, $_REQUEST['email']);
 $sql = "SELECT id, firstname, lastname, email FROM player WHERE email = '$email'";
 $result = mysqli_query($link, $sql);
 if(!$result)
 {
  $error = 'Unable to select players firstname from the database.' . mysqli_error($link);
  include 'error.html.php';
  exit();
 }
 
 while($row = mysqli_fetch_array($result))
 {
  $players[] = array('id' => $row['id'], 'firstname' => $row['firstname'], 'lastname' => $row['lastname'], 'email' => $row['email']);
 }

 //
 //POPULATE THE OPPONENTS DROP DOWN BOX TO SHOW ALL PREVIOUS OPPONENTS
 //

 $sqlid = "SELECT id FROM player WHERE email = '$email'";
 $playerid = mysqli_query($link, $sqlid);
 $sql = "SELECT DISTINCT player.firstname, game.player2_id AS opponent_id
 
FROM player INNER JOIN game
                
                ON player.id = game.player2_id

WHERE player1_id = '$row['id']'

UNION

SELECT DISTINCT player.firstname, game.player1_id AS opponent_id

FROM player INNER JOIN game
                
                ON player.id = game.player1_id

WHERE player2_id = '$row['id']'";

 $result = mysqli_query($link, $sql);
 if(!$result)
 {
  $error = 'Unable to populate the players dropdown from the database.' . mysqli_error($link);
  include 'error.html.php';
  exit();
 }
 
 while($row = mysqli_fetch_array($result))
 {
  $opponents[] = array('id' => $row['opponent_id'], 'firstname' => $row['firstname']);
 }

include 'squash.html.php';

}

?>
Thanks for your help and time in advance.

Does somebody know, where the issue is when the external hard drives respond very slow to a point where one can not copy over a small sized file?   I have this issue with different types of external hard drives.   I am using Windows 8.
Edited by glassfish, 01 December 2014 - 09:36 AM.

This topic has been moved to PHP Applications.

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

hello dear php-experts good day     well at the moment i try to figure out how to test the healthy of my harddrive.
How do I use SMART tools to check on my notebooks  hard drive? That is the question of the day for me. i want to run a SMART-Test on my notebook to test the harddrive.

i have opensuse 13.1 on the machine: and the SMART-Tools are installed.


SMART (Self-Monitoring, Analysis, and Reporting Technology) is a technology included in most hard drives today.


Short test: According to the documentation, this command can be given during normal system operation (unless run in captive mode).


i can run the test: 

smartctl --test=short /dev/sda1

see here what happens:  

martin@linux-70ce:~> su
	Passwort:
	linux-70ce:/home/martin # smartctl --test=short /dev/sda1
	smartctl 6.2 2013-07-26 r3841 [i686-linux-3.11.10-25-desktop] (SUSE RPM)
	Copyright (C) 2002-13, Bruce Allen, Christian Franke, www.smartmontools.org
	
	=== START OF OFFLINE IMMEDIATE AND SELF-TEST SECTION ===
	Sending command: "Execute SMART Short self-test routine immediately in off-line mode".
	Drive command "Execute SMART Short self-test routine immediately in off-line mode" successful.
	Testing has begun.
	Please wait 2 minutes for test to complete.
	Test will complete after Tue Jan 20 00:29:16 2015
	
	Use smartctl -X to abort test.
	linux-70ce:/home/martin #

hmm - this seems to be a short (quick ) test. But i have to wait to see the results. Question: do they come to the terminal - are they are shown in the terminal?



btw: i also can run the Long Test:

The long test can also be run on a live system, and will do a lot deeper testing on the device, however it will take significantly longer to finish.
smartctl --test=long /dev/sda smartctl



well - how can i run tests on all the partitions:  is this possible to do this with only one single step?

                                                                             cfdisk (util-linux 2.23.2)
	
	                                                                                Festplatte: /dev/sda
	                                                                       GrM-CM-6M-C~_e: 320072933376 Bytes, 320,0 GB
	                                                               KM-CM-6pfe: 255   Sektoren pro Spur: 63   Zylinder: 38913
	
	         Name                       Flags                     Part. Typ              Dateisystemtyp                       [Bezeichner]                    GrM-CM-6M-C~_e (MB)
	 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
	                                                               PrimM-CM-$re          Freier Bereich                                                           164,63               *
	         sda4                                                  PrimM-CM-$re          LVM2_member                                                             1990,20               *
	         sda2                                                  PrimM-CM-$re          LVM2_member                                                            21475,89               *
	         sda5                       NC                         Logische              swap                                                                    2155,88               *
	         sda6                       NC                         Logische              ext4                                                                   21475,89               *
	         sda7                       NC                         Logische              ext4                                                                  272799,63               *
	                                                               Pri/Log               Freier Bereich                                                            10,84               *

but what can i do if i want to Get it all:


there are options to do that - getting it all:

The next and last command will output all the information the drive can possibly give. In the response below I have selectively removed a lot of output because there is a lot information to go through. My main point is the command and something I will get to in just a second.

smartctl -a /dev/sda Device Mode

since the harddrive has differnet partitions - the question arises: how to test all at once?

question: which way to get the drive  tested in one single step
are there options to do that - getting it all in a single command.



look forward to any and all hints and help

greetings

PHP date and time function is not showing correct time on my local system

I have the following php code

date_default_timezone_set("Africa/Lagos");

$date = date('d-m-y h:i:s');

echo "Server Time ".$date ."<br>";

echo "The time is " . date("h:i:sa")."<br>";

$current_datetime = date("Y-m-d") . ' ' . date("H:i:s", STRTOTIME(date('h:i:sa')));

echo "Current time1: ".$current_datetime . "<br>";

 

Output

Server Time 21-05-21 09:55:39
The time is 09:55:39am
Current time1: 2021-05-21 09:55:39

 

Expected Output

Server Time 21-05-21 10:55:39
The time is 10:55:39am
Current time1: 2021-05-21 10:55:3

 

Any help would be appreciated.

 

Edited May 21 by Ponel