[Allowing Users to Upload Their Music?]

I've dealt with all this on a video site and also my search engine.

Thanks for your post. The post helps! I would be looking to know if it has worked out for yourself? Or have you nevertheless gotten law suites too? Did you have had to pay one fine before? Or would you say I could be one would could go about what you wrote in your post above?

[Allowing Users to Upload Their Music?]

I understand your post. Though, I have had heard from website owners how they have had gotten law suites, usually they do not specify this much further, and other website owners do not mention this at all. So in regards to your post I was not sure if it would work out by doing in that way.

 

To what type of lawyer may I have to go to?

[Allowing Users to Upload Their Music?]

There are websites like Soundcloud, Soundclick, MySpace and more.

 

The Question:

How to not get a law suite as a website owner when copyright protected music or in other words music from the retail has gotten uploaded?

 

Will moderating it and having it frequently taken down do the job?

 

I know that the users themselves could get researched too. The site owner could get requested to give out IP addresses. Though, I kept this separately from that question.

 

I basically would be looking to be safe and not get a law suite.

 

I would appreciate the suggestions a lot.

[External Hard Drives Respond Very Slow - Winodws 8]

I can click on the HDD icon in Windows Explorer and have them spin up. When it comes to your suggestion in the "Power Options" I only have those options like "when to put the computer to sleep".

I would appreciate it if somebody who knows about this issue would let me know.

[PHP datetime Ago Function?]

Thanks Monkuar, I tried the second link and it worked out great.

[PHP datetime Ago Function?]

I did google, I found various ones, but not necessarily something I liked too much. Then I found one and I did not know what "granulaty" is.

[PHP datetime Ago Function?]

Hey, does anybody know a good function, where I can have the trendy "time ago" functionality?

 

A good tutorial would be cool, too.

 

I would be using the datetime function off MySQL.

[Making Cartoon Movies?]

Does anybody know what type of software (program) is used to make a cartoon movie (like Dragonball Z)?

[External Hard Drives Respond Very Slow - Winodws 8]

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.

[Auto-Save with Draft for Web Based Text-Editor?]

 

Auto Save Plugin for the CKEditor which automatically saves the content (via HTML5 LocalStorage) temporarly (for example when a login session times out). And after the content is saved it can be restored when the editor is reloaded.

The auto save plugin for CKEditor does its job the way its described in the quote above.

 

I was wondering if there is a way to have the web based text editor for my blog, the way the Wordpress text editor is, with an auto save (draft) function?

 

Is there a web based text editor with such function, which would enable me this?

[Learning PHP OOP CRUD?]

mogosselin, thanks for the response. I also meant using "pdo". Though, as of now, I am using "bindValue()" with this I can freely use SELECT, INSERT, UPDATE and DELETE. So I figured it out "till to this" on how to do this with OOP and prepared statements.

[Finding a job in USA as a programmer]

I guess one definitely needs a workplace first for a working visa. I guess it can get difficult,. Yet, you could try working for Facebook? Have you thought about that before?

[Perpared Statements and Printing a Column on Screen?]

The Connection:

<?php

$dsn = "mysql:dbname=phpblog;host=localhost";
$user = "root";
$password = "";
try{
    $pdo = new PDO($dsn, $user, $password);
}catch(PDOException $e){
    echo "Connection failed: " . $e->getMessage();
}

?>

The Script:

<?php

$query = $pdo->prepare("SELECT * FROM posts WHERE id = ?");
$query->bindValue("1", $_GET['post_id']);
$query->execute();

?>

I want to print the column "headline" on screen.

 

I know how to do it with a foreach loop:

Example:

foreach($query as $data){
    echo $data['headline'];
}

What can I do there?

[PDO Inserting Data?]

Thanks for the responses.

 

I have had mispelled the column "post" into "posts" in MySQL.

 

After correcting the spelling mistake it is working now.

[PDO Inserting Data?]

This UPDATE script works:

$query = $pdo->prepare("UPDATE posts SET headline = ? WHERE id = ?");
    $query->bindValue("1", $_POST['headline']);
    $query->bindValue("2", "2");
    $query->execute();

Though, this INSERT script does not work:

$query = $pdo->prepare("INSERT INTO posts (headline, post) VALUES (?, ?)");
    $query->bindValue("1", $_POST['headline']);
    $query->bindValue("2", $_POST['post']);
    $query->execute();

Nothing gets added, when executing this script.

 

The connection:

<?php

$dsn = "mysql:dbname=phpblog;host=localhost";
$user = "root";
$password = "";
try{
    $pdo = new PDO($dsn, $user, $password);
}catch(PDOException $e){
    echo "Connection failed: " . $e->getMessage();
}

?>

Any suggestions why the INSERT script is not working?

[Learning PHP OOP CRUD?]

NetKongen, the MVC tutorial gets the criticism of teaching bad methods?

[Learning PHP OOP CRUD?]

Hey sorry that I am asking this question, though I have gotten around to learn connecting to a database and also do the retrieve, yet I am not necessarily getting to learn doing INSERT, UPDATE and DELETE the proper way.

 

The tutorials available are often not best, I have found a good book ("Object Oriented Programming in PHP5") which teaches SELECT, yet not necessarily INSERT, UPDATE and DELETE.

 

I am really wondering how does one get to learn CRUD with PHP OOP, how did you people learn this? How can I learn INSERT, UPDATE and DELETE as well with PHP OOP?

I feel like paying for this on Elance or Fiverr. I am not sure how else to learn this by now, I have tried quite a bit, I have looked at scripts and tutorials and books. And it has just gotten as far as connecting to the database and doing the "fetching" ("SELECT", or also "retrieve").

 

Too bad that what is available is not necessarily best. Otherwise I would say one could understand the principle quickly and also pick up on a programming language quickly.

 

Please bear with me, I would appreciate suggestions.

[Checking the Database Connection]

Thanks for the answer.

 

It looks like too many tutorials do not show how to do it right and it gets difficult to find the right way to even just do the request calls to the database.

[Checking the Database Connection]

The Script:

pdo_connect.php:

<?php
$dsn = "mysql:host=localhost;dbname=2354";

$db = new PDO($dsn, "root", "");

?>

pdo_test.php:

<?php
    try{
        require_once("pdo_connect.php");
    }catch(Exception $e){
        $error = $e->getMessage();
    }

?>
<!DOCTYPE html>
<html>
<head>
    <title>Database Connection with PDO</title>

</head>
<body>
<h1>Connection with PDO</h1>
<?php
    if($db){
        echo "<p>Connection successful.</p>";
    }elseif(isset($error)){
        echo "<p>$error</p>";
    }

?>
</body>
</html>

I have just watched a tutorial and tried out this script. The issue is that I am getting the following notice alongside with the error message:

Notice: Undefined variable: db in C:\xampp\htdocs\oophp\pdo_test.php on line 18

SQLSTATE[HY000] [1049] Unknown database '2354'

By the way this notice does happen in the tutorial as well.

 

My question is: How to have this in ways, where the notice does not occur?

 

[Is There a "Sure" Way to Make Money Online?]

Maybe some experienced people could be letting me know when it comes this?

 

I thought of a  "file storage" web app like "YouSendIt", I also thought of a "web host" web app as a "reseller".

 

With this I am getting caught up in thoughts, that the traffic could not happen.

 

Is there something, where one could be more "sure" that the traffic may happen, and with this the "clicks" too, even if it are a $100 or $200 per month?

 

I would appreciate the suggestions a lot.

[PHP OOP Class Return]

Addendum:

To what you wrote after that: I did not even think this code would be poor. It also disappoints. On "Stackoverflow" one gets told that "90% of the tutorials out there are poor". I get to think this could be true, yet it also disappoints.

 

One of the comments on the tutorial:

This tutorial is rather to confuse newbies and to teach wrong techniques.

I will pay more attention to this.

[PHP OOP Class Return]

You wrote: "Time to do some reading."

[PHP OOP Class Return]

Its not a good tutorial if it is defining $pdo as global! In fact all it has doing is wrapping procedural code inside of a class.

Do you have a suggestion? I really am trying to learn OOP. I thought I could be learning good with "CRUD".

Do you have "something" where I could be seeing the "difference" with what you have had mentioned?

A boolean value maybe? Return true if the article has been deleted or the article has been updated.

Are you also saying that the "execute" part will do this already? Though, I understand that the return of "true" would happen on success.

 

ginerjm,

 

Thanks for the answer. I understand what you are saying, though I thought I could be learning OOP with a "CRUD" tutorial. I also feel like after those few tutorials I could be going ahead and read the books.

[PHP OOP Class Return]

Script:

<?php

class Article{
    public function fetch_all(){
        global $pdo;

        $query = $pdo->prepare("SELECT * FROM `articles` ORDER BY `article_timestamp` DESC");
        $query->execute();

        return $query->fetchAll();
    }

    public function fetch_data($article_id){
        global $pdo;

        $query = $pdo->prepare("SELECT * FROM `articles` WHERE `article_id` = ?");
        $query->bindValue(1, $article_id);
        $query->execute();

        return $query->fetch();
    }

    /*
     * These have gotten added later on.
     */
    
    public function delete($id){
        global $pdo;

        $query = $pdo->prepare("DELETE FROM `articles` WHERE `article_id` = ?");
        $query->bindValue(1, $id);
        $query->execute();

        // The "return" here.

    }

    public function edit_page($title, $content, $aticle_id){
        global $pdo;

        $query = $pdo->prepare("UPDATE `articles` SET `article_title` = ?, `article_content` = ? WHERE `article_id` = ?");

        $query->bindValue(1, $title);
        $query->bindValue(2, $content);
        $query->bindValue(3, $article_id);

        $query->execute();

        // The "return" here.
    }

}


?>

I have this from a tutorial. In the function "fetch_all()" it uses "fetchAll()" at the spot where the "return" is, and in the function "fetch_data()" it uses "fetch()" at the spot where the "return" is.

 

My Question:

What may have to use for the function "delete()" and the function "edit_page()" at the spot where "return" would be?

[Function For Using Absolute Path?]

include($_SERVER['DOCUMENT_ROOT'] . "/cms/includes/header.php");

This gets inlucded in a sub directory for example than the stylesheets will not load anymore, when I have used "/" or also "../", that is why I have used "http://localhost/" to load the styelsheets, with that it works then.

 

This was what I actually meant.

 

Though, I have had just checked it and using the following indeed works for myself now:

<link rel="stylesheet" type="text/css" href="/cms/assets/style.css" />

With the "forward slash" at the beginning.

 

So, basically always starting with the "project name" in the "href" could be working then.