Comments by jba1991 (Top 112 by date)

Can anyone help?

I have used json_encode on a variable and echo'd the variable which displays the data on the client side (it is displaying the line of code from the question in the browser).

I just want to be able to get each part of the json encoded data shown in the question and store them into their own variable, so I can echo something like "welcome, $sceen_name" and store it in a PHP session

Sorry. I would like to display the value of res from the function in angular img tag but I have tried the following, but honestly, I have no idea how to do this:

<img ng-source="path/to/file/{{artUrl}}"/>
<img src="myFunction()" />
<img src="this.myFunction();" />

my problem is display the value of res from the function in a angularJS img tag

I have this:

<p id="art">{{album.artUrl}}</p>

<script>
function myFunction() {
var str = document.getElementById("art").innerHTML;
var res = str.replace("-", "/");
document.getElementById("art").innerHTML = res;
}
</script>

What will the img tag look like?

haha nice, that was just simple maths and common sense! I need a coffee! ha thanks

i think t.duration is in milliseconds not seconds

actually, how is time() formatting the result? it doesnt seem correct

that worked :) thanks

SELECT a.albumid as albumid, a.name as name, a.year as year,
g.name as genrename, strftime("%H:%M:%S", sum(t.totaltime), 'unixepoch') as albumduration
FROM album a
JOIN genre g
ON a.genreid=g.genreid
JOIN track t
ON a.albumid=t.albumid
GROUP BY a.albumid, a.name, g.name
ORDER BY a.name

syntax error, unexpected ':'

okay cool. It saying theres a syntax error using :

is there a substitute or can i comment them out or something?

okay and how would i implement this into the sql i already have? do i wrap it in parenthesis?

SELECT strftime('%H-%i-%s', sum(t.duration), 'unixepoch') ??

well SQLite

How could I convert sum(t.duration) into HH:MM:SS from seconds inside SQL? is that possible?

Correct as always. Thanks :)

Haha no not today :P

Yeah I think that was the case. Thanks again, I was looking in the complete wrong area and would have been for quite a while without your help

Correct! This was in fact the problem, and I only got it working using a absolute file path. Many thanks once again for your help :).

I just checked and in the connection file it is executing the catch and not the try when attempting to connect to the file. So it is a connection problem!

I tried changing the file path for the database and an error was displayed saying it didnt recognise one of the table names so it must have been working

Okay. Does the sqlite reference in the pdoDB.class.php have to have an absolute filepath?

Okay (its fine). Its just saying null again.

it has an undefined variable error for db and the same error as before. Its also showing the word null.

Not the same output as when we last tried var_dump

Could it be down to JSONRecordset returning no results?

No luck with that, although I read the link you provided and it sounds like it should work

It hasnt changed the error :(

That goes in the JSONGRecordSet function?

Hi friend :)

This is my index.php file that passes to recordset:

include_once 'classes/pdoDB.class.php';
include_once 'classes/recordSet.class.php';

$action = isset($_REQUEST['action']) ? $_REQUEST['action'] : null;
$subject = isset($_REQUEST['subject']) ? $_REQUEST['subject'] : null;
$id = 'ABC123';

// concat action and subject with uppercase first letter of subject
$route = $action . ucfirst($subject); // eg list course becomes listCourse

$db = Database::getConnection(); // connect to db

header("Content-Type: application/json");

switch ($route) {
case 'listStudents':
$id = $db->quote($id);
$sqlCourseStudents = "SELECT studentid, forename, surname, stage, email
FROM student
WHERE coursecode=$id
ORDER BY surname, forename";

$rs = new JSONRecordSet();
$retval = $rs->getRecordSet($sqlCourseStudents);
echo $retval;
break;

And this is the recordset file:

include_once 'pdoDB.class.php';

abstract class RecordSet {
protected $db;
protected $stmt;

function __construct() {
$this->db = Database::getConnection();
}
function getRecordSet($sql, $params = null) {
if (is_array($params)) {
$this->stmt = $this->db->prepare($sql);
$this->stmt->execute($params);
}
else {
$this->stmt = $this->db->query($sql);
}
return $this->stmt;
}
}

class JSONRecordSet extends RecordSet {
function getRecordSet($sql, $elementName = "ResultSet", $params = null) {
$stmt = parent::getRecordSet($sql, $params);
$recordSet = $stmt->fetchAll(PDO::FETCH_ASSOC);
$nRecords = count($recordSet);
if ($nRecords == 0) {
$status = 'error';
$message = json_encode(array("text" => "No records found"));
$result = '[]';
}
else {
$status = 'ok';
$message = json_encode(array("text" => ""));
$result = json_encode($recordSet);
}
return "{\"status\": \"$status\", \"message\":$message, \"$elementName\" :{\"RowCount\": $nRecords ,\"Result\": $result}}";
}
}

how do i implement the keypress and keyup events into the jQuery code?

This seems useful.

in this code:

onkeypress="if(this.value.match(/\D/)) this.value=this.value.replace(/\D/g,'')"
onkeyup ="if(this.value.match(/\D/)) this.value=this.value.replace(/\D/g,'')"

which part is only allowing digits? and How can I allow it to accept a dot as well?

Sorry im not very familiar with jQuery yet. But I am using it for client-side validation for a project, I want to prevent the submission of a form if there are invalid characters(all characters except 0-9 and .) in the form input.

Ha yeah i already did that and deleted my comment but you saw it :p.

I accepted your solution but I have another question:

How can I add on 7 days when inserting date() in the database (SQLite)?

Okay I understand what you are saying and it definately gave me an idea in how to solve my problem. I didnt even think of only displaying data after a certain date!

I will ensure (as always) that I will mark the answer as accepted once I have fixed it, but I will wait in case I need to expand my question.

Thanks again

Yeah, my database date is DATETIME and is set using default value CURRENT_TIMESTAMP. So can i get the database date (as on object, not as string) and then compare it with getDate() and it should work?

Thanks. I want to check it with the database date. Would I use getDate() for the current date and then compare that to the date in the database? Also, is timestamp a string?

Also, to make 10,11 and 12 greater than 2,3,4 etc would I just change ('d-m-y') to ('dd-mm-yyyy')?

Might this be a PHP version problem? Im also having trouble with date_add.

I got it! :). thanks, I think I need to do a bit of research on how to do a count properly cause its caused me so much stress!

Thank again Sascha, youve been great.

This is my pagination code so far:

$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;

$perPage = isset($_GET['per-page']) && $_GET['per-page'] <= 20 ? (int)$_GET['per-page'] : 5;

$start = ($page > 1) ? ($page * $perPage) - $perPage : 0;

$replies = $db->prepare("
SELECT SQL_CALC_FOUND_ROWS * FROM replies
WHERE replyThreadID=:replyThreadID LIMIT {$start}, {$perPage}");
$replies->bindParam(':replyThreadID', $ID);
$replies->execute();
$replies = $replies->fetchAll(PDO::FETCH_ASSOC);

$totalQuery = $db->query("SELECT COUNT(*) FROM replies WHERE replyThreadID=:threadID");
$totalQuery->bindParam(':threadID', $ID);
$total = $totalQuery->execute();
echo $total;

And this is the error I get:

PDOException: SQLSTATE[HY000]: General error: 1 near "FROM": syntax error

The error is in the $replies SQL statement

Hi. I still cant get this working, Ive tried everything! Did you have a look at the error I was getting?

Yes! Good job man, thanks. Why did you have to include[0]? thats something to do with the first array result isnt it?

array (size=1)
0 =>
array (size=1)
'UnreadCount' => string '0' (length=1)


What is var_dump? some kind of debugging?

I made them changes but its still saying the same thing about an undefined index for UnreadCount

Did you find out what the error was?

Ive tried that and im getting an undefined index. I must be missing some syntax or something?

$db = Database::getConnection();
$query = 'SELECT Count(*) AS UnreadCount FROM messages WHERE messageTo = :to AND messageRead = 0';
$output = $db->prepare($query);
$output->bindParam(':to', $s_username);
$success = $output->execute();
if ($success){
$results = $output->fetchAll();
$unreads = $results['UnreadCount'];
if (count($unreads) > 0){

the undefined index is on the line where I assign UnreadCount to $unreads

Thanks! that works.

it returns the same results for:
count > 0
count > 1
count < 1

array (size=1)
0=>
array (size=2)
'COUNT(*)' => string '0' (length=1)
0 => string '0' (length=1)

Hi. Thats exactly what I need. I looked at your SQL fiddle and thats what I want to work. How to I call replyCount and store it into a variable?

Yeah. Unless I change it to > 1 instead of > 0. And even if there are records that should be returned, when using > 1, it doesnt show as (new).

Did you find anything?

Its doing the same as before :(

I see! So because it returned true or false it means there was only 1 record which is why the count was saying there was > 0 records, even though (i thought) there wasnt!

Does that mean something like this should work:

$success = $output->execute();
if ($success){
$results = $output->fetchAll();
if (count($results) > 0){
$msg = '<li>My Messages (new)</li>';
} else {
$msg = '<li>My Messages</li>';
}
}

Thanks for the info and the link, it seems that using 2 queries to get the count is a prefered way by most.

For future reference though, I took the braces off and I am now getting this error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 near "FROM": syntax error'

anyone?

That sounds correct, I just checked out DISTINCT and that should work. Many many thanks for you help!

Yeah it does because it adds a report everytime, rather than adding a count. I am aware I could use multiple tables to do this, but I really just want to use 1. Is there a way of getting round this?

Thanks that worked! I have a follow up:

How can I get just one username instead of the amount in the table? (e.g. user1 having 3 reports in the table shows in the table for the code above 3 times)

Yeah I can and I've just done that. Thanks, I think I need a break!

I tried this:

$reportsQuery = "SELECT COUNT(*) AS countReported FROM reports WHERE reportedUser = :username";
$reportsOutput = $db->prepare($reportsQuery);
$reportsOutput->bindParam(':username', $username);
$success = $reportsOutput->execute();
echo "<td>".$reportsOutput['countReported']."</td>";

but got this Error:

Fatal error: Cannot use object of type PDOStatement as array

I've sorted the time. Thanks.

Is there a way to do this for the time part of a current timestamp?

Ah i understand. thanks!

How can I convert the string into a datetime?

Thanks for that it seems useful but I'm getting this error:

"Warning: date_format() expects parameter 1 to be DateTimeInterface, string given "

And this is my code:

$posted = $row['auctionPosted'];
$date=$posted;
date_add($date,date_interval_create_from_date_string("7 days"));
$remaining = date_format($date,"Y-m-d");

That is correct... Embarrassing as well! Ha. Thanks

I like the sound of the first approach. What do you mean by hidden file? How could I do that?

Well I presume I did it wrong, rather than it not working.

I tried to check if the blank inputs were blank using isset, and if they werent i would make $about the value of $db_about (for example) to be put into the DB but it didnt work.

Thanks :D

No, I understand how to do this part, but I mean using the htmlspecialchars part too, or can I just pass each field into a function (seen on the first page of the link you provided) after submitting?

This is what I currently have now after creating a function. However, I am getting an error of an undefined index for the lines $name, $last and $by.



$query = 'SELECT * FROM threads WHERE threadTopic=:topic';
$output = $db->prepare($query);
$results = $output->execute(array(':topic' => $topic));
if (count($results) > 0) {
echo "<table>\n";
echo "<tr><th>$topic</th><th>Replies</th><th>Last activity</th></tr>\n";
if ($results) {
$row = $output -> fetchAll();
$name = $row['threadName'];
$last = $row['lastActive'];
$by = $row['threadBy'];
$rand = rand(000, 999);
echo "<tr>\n";
echo "<td>$name</td>";
echo "<td class=\"text-center\">$rand</td>";
echo "<td class=\"text-center\">$last<br>By: $by</td>";
}
echo "</tr>\n";
echo "</table>";
}
}

Thanks I'll definately try this. I've used functions before but they always slip my mind.

Anyone?

Thanks!

Im having another problem that you may be able to help me with.

Currently I have a basic function where the reports table works and contains the userID and the username, each row showing who was reported (ive havent yet added the date created and report text but I will).

On another page (admin page), I want to list all of the users in a table and sort it by the amount of reports a user has in the reports table. I have listed the userID and username from the users table but im unsure how I can connect the amount of reports from the reports table, to the information from the users table.

This is what I have so far:

$db = Database::getConnection();
//select only users with activated accounts to display
$query = 'SELECT * FROM users WHERE activated=1';
$output = $db->query($query);
$results = $output->fetchAll(PDO::FETCH_ASSOC);
if (count($results) > 0) {
echo "<table cellspacing=\"0\">";
echo "<tr><th>UserID</th><th>Username</th><th>Report Count</th></tr>";
foreach($results as $result){
echo "<tr>\n";
echo "<td>$result[userID]</td>";
echo "<td>$result[username]</td>";
//select data from reports page
$displayReports = "SELECT * FROM fh_reports";
$reportCount = $db->prepare($displayReports);
$reportCount->execute();
//display report count next to respective username from above
echo "</tr>\n";
}
}

If I create the reports table and have userID and reports as columns, would I join the user table and reports table on userID? Meaning that each report in the reports table will be associated with a userID and from there would I count the amount of rows where userID = XX?

Thanks very much Ravi,

Sorry for such a vague question, but I didnt even know what to search Google for so came here.

I just looked for the difference between empty and null, using empty will not work for me in this case i dont think.

What if I used "if($loginUser === NULL)"?

Would it work if I do "if(empty($loginUser))" and in the else statement execute the code to log in?

would you take a look at the code Ive posted in the comments below? I would greatly appreciate your help.

//make a new instance for the person class
$person = new Person("Mike");
$person->setAge(20);
$person->setGender("Male");
echo "<p>my name is ".$person->getName()." and I am a ".$person->type. ", ".$person->getAge()." and I am ".$person->getGender." . I can communicate by".$person->sound."</p>";



This is what I added to the useanimal.php file. I am getting errors "Undefined property: Person::$getGender" which is the echo line from the code above. and this error " Cannot access protected property Person::$sound" on the same line.

abstract class Human{
public $type;
protected $age;
protected $name;
protected $movement;
protected $sound;
protected $gender;

protected function __construct($name = null, $type=null, $movement=null, $sound=null){
$this->setName($name);
$this->gender = $type;
$this->movement = $movement;
$this->sound = "speaking";
}

public function setName( $name ) {
$this->name = $name;
}
public function getName() {
return $this->name;
}

public function setAge( $age ) {
$this->age = $age;
}

public function getAge() {
return "I am {$this->age} years old";
}

public function setGender($gender) {
$this->gender = $gender;
}
public function getGender() {
return $this->gender;
}
}

class Person extends Human {

function __construct( $name = null ) {
/** call the parent constructor rather than re-write it. Notice in the Cat class
* we re-write the constructor - not normally good practice of course to duplicate the code
* I do it in the Cat class just to demonstrate that you can
*/
parent::__construct( $name, 'Person', 'On Foot', 'Speaking' );
}
}



This is what I added to the animal.class.php file.

I have just created a new abstract class for Human. Then I will create a new class which extends Human called Person. I will comment what I have added below.

I need to create a person class the same way a dog class has been created but I am unfamiliar in how to do it. I've tried similar ways to the dog class and the cat class but because it passes different parameters (gender, height instead of movement and sound) i think I am doing it wrong.

These classes arent mine but ive been tasked with understanding how to create a new instance for a person class.

I think you may be right there David, but still no success! I dont have a clue what is going on, I added the condition brackets ({}) for the 'else's' i missed as well but its doing the same thing

Okay cool. So where in the code would I put the isset function? does it replace any existing code?

Thanks but this doesnt solve the problem that I have.

I cant believe that. Sometimes I think I just shouldn't be doing web you know! Thanks a lot though. :)

Int(8) with auto increment

Thanks you!

Why doesn't that work in the while?

Ah cool thank you.

As soon as you mentioned a where clause it kind of ticked. Thanks again!

Oh i see. Thanks anyways :)

.toString() and return false are the parts that make the code work?

Thanks a lot :)

Thanks.

I think I found the problem, but im not sure that is what caused the error.

I had two different functions doing the same thing, but one had an 'else if' in it.

Hi. Here is an example of how you can set the opacity of an element using CSS (the code would go into your CSS file):

divName
{
opacity:0.4;
filter:alpha(opacity=40); /* For IE8 and earlier */
}

0 would be fully transparent and 1 would be fully opaque for the 'opacity' atrribute, and 0/100 would be the same for the filter:alpha attribute

Ah okay cool! :)

Thanks!

in your example, what is 'ctrl'?

You got it! thanks! just goes to show how a single character can have you puzzled for hours!!

Hi.

Thanks for your comment but I want to achieve this without using jQuery. I should probably have mentioned that in my post!

And no I haven't used a break-point.