• 0

[jQuery] Updating MySQL table with link click


Question

Basically I've been trying for 3 hours to make the table update with a click of a link using jQuery. The link ID is up and the link points to nowhere because I don't want the url changing. I'm wondering if anybody can assist me with how to make the column in the table update (+1 each click).

Thanks,

S2

23 answers to this question

Recommended Posts

  • 0

Ah sorry, I misread your post.

To do that without the page reloading when the link is clicked, you'll need to make an AJAX call to a script on the server which will then alter the table.

So, your javascript would do something like this when your link is clicked;

$.ajax({
   type: "GET",
   url: "the-script.php"
 });

and then the script on the server would do something like

// connect to database
//...

$query = "YOUR SQL QUERY TO UPDATE THE TABLE";
$res = mysql_query($query);

  • 0

Seems you're quite unclear on how most of the technologies you'll need to achieve this even work.

Also you're not giving nearly enough information to the potential people willing to help you.

Your question gives away that you're new at this, and this implies lots of baby steps and holding your hand for whoever wants to help you...

Seriously, sit down and write an extensive description of your database, your html, your javascript skills, AND the exact thing you're trying to achieve, so that someone can guide you using knowledge that you already have.

Here's how something like what you're describing usually works:

1. Browser renders HTML elements, Javascript attaches event listeners for the click events of the desired elements

2. User clicks the element, the listener Javascript function gets executed by the Browser

3. In the function you should achieve an asynchronous call(I see you sort of want to not refresh the page at all?) to the Server, where your only chance of manipulating your database lies

4. your piece of code at your server does the work related to the updating of the database, depending on the data passed by the Browser, and potentially coming back with a result status code

5. potentially, you update the HTML in the Browser depending on the response code/message, for the User to see

I hope this helps

  • 0
  On 15/04/2011 at 13:24, XakepaBG said:
..., sit down and write an extensive description of your database, your html, your javascript skills, AND the exact thing you're trying to achieve, so that someone can guide you using knowledge that you already have.

;)

  • 0

I know I'm not giving the best explanations but I'm sure you can gather what I am after.

I'll explain it here: I have a link that when I press it I want it to update a column in the MySQL table based on the ID of the "post". I don't want the URL to change and it needs to refresh back to the normal page.

Please give me any help you can offer, it's all I really ask.

  • 0

OK, you should be able to figure what this quick example I made for you does. :)

Actually, Neowin's code highlighter/formatting is pretty rubbish. Here's a pastie link: http://pastie.org/1800656

<?php
if('POST' === $_SERVER['REQUEST_METHOD']){
  printf(
    "You sent me the number %d, at %s.",
    empty($_POST['number']) ? 0 : $_POST['number'] ,
    date('r')
  );
  exit;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">;html xmlns="http://www.w3.org/1999/xhtml">lt;head>
				<meta http-equiv="content-type" content="text/html; charset=utf-8" />
				<link rel="stylesheet" type="text/css" media="screen" href="http://yui.yahooapis.com/3.3.0/build/cssreset/reset-min.css" />
				<link rel="stylesheet" type="text/css" media="screen" href="http://yui.yahooapis.com/3.3.0/build/cssbase/base-min.css" />
				<link rel="stylesheet" type="text/css" media="screen" href="http://yui.yahooapis.com/3.3.0/build/cssfonts/fonts-min.css" />
				<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js" type="text/javascript"></script>
				<style type="text/css">
				</style>
				<title>
						Demo
				</title>
		</head>
		<body>

      <?php foreach(range(1, 15) as $number): ?>
        <span class="clickable"><?php echo $number; ?></span>
      <?php endforeach; ?>

      <div id="response"></div>

      <script type="text/javascript">
        //<![CDATA[
        $(document).ready(function(){
          $('span.clickable').each(function(){
            $(this).click(function(){
                $.ajax({
                  type: 'POST',
                  url: './index.php',
                  data: 'number=' + $(this).html(),
                  success: function(response){
                    $('#response').html(response);
                  }
                });
            });
          });
        });
        //]]>
      </script>

		</body>
</html>

  • 0
  On 16/04/2011 at 13:22, Shazer2 said:

Anyone? Could someone else give me a hand with this. I don't really know what URL to give the link, because I wanted it updated without the page URL having to change, but do the same as the form submission but update the MySQL table. Ideas?

XakepaBG made some good points; You really need to provide more information - what form submission are you talking about?

My previous post outlined what you need to do to update the database without reloading the page.

There's varying opinions on what you should use for the href attribute for javascript-only links. href='#' is popular, but will require the onclick (or jquery bound) event to return false or run preventDefault() on the event object so that the browser doesn't try navigating to # (which won't reload the page, but will scroll it. Another approach is to use href='javascript:void(0)'. You won't have to use javascript in your click handler to cancel the event's default behaviour using this approach - so it's probably better than the # approach.

The best approach is to have the link actually go to a valid URL but have javascript override that behaviour to provide a better user experience. This way, users without javascript enabled can still click the link to make the database change (but the browser will have to (re)load a page) and users with javascript enabled get the enhanced experience of being able to do exactly the same thing but without the browser reloading the page.

Using my previous code as an example and this HTML;

<a id='link' href="the-script.php">Click me</a>

$('#link').click(function(){
    // Make the call to the script that performs the database update asynchronously (ie, by not reloading the page)
    $.ajax({
        type: "GET",
        url: "the-script.php"
    });
    return false; // Prevent the browser from navigating to the-script.php
});

Edit: Regarding AnthonySterling's solution; you will need to write the code that updates the database yourself. We're not psychic, we have no idea what changes you want to be made in the database. Put an SQL query that does what you want in the if statement at the top. Similarly, you'll need to generate the actual links with correct post IDs.

  • 0

Thanks for that code, Mouldy Punk. I believe we ARE getting places, but what I need to do is send the ID of the "post" so a part of it can be updated in the table. How can I send the ID as a value to the the-script.php to be used to update in the DB.

Not sure how to go about this, I'm calling this jQuery in a mysql_fetch_array loop too, because that's how I pull the "post" data from the database.

  • 0

Without seeing your existing code, it'll be tricky for us to give you more help really. You'll need to somehow make the post ID accessible to the click event of each link.

For example, if you had a series of links (one for each post) that went along the lines of;

<a href='#' onclick="javascript:clickHandler(1); return false;">Click me</a>

where the parameter of clickHandler is different for each link (it's the post ID)

The you could have the javascript function that'll post that post id to the PHP script on the server;

function clickHandler(post_id){
     $.ajax({
                  type: 'POST',
                  url: 'the-script.php',
                  data: 'post_id=' + post_id
      });
}

Then the PHP script on the server would take that post id and do a mysql query using it;

&lt;?php
$post_id = $_POST['post_id'];
// connect to db
mysql_query('do something with $post_id');
// etc.
?&gt;

  • 0

Alright, I'm getting a better idea of what I need to do, but I can't seem to get it to execute the clickHandler function. Here is my code, see if you can help me from there.

&lt;?php
            $sql = mysql_query("SELECT * FROM `posts` ORDER BY up DESC") or die(mysql_error());
            while ($posts = mysql_fetch_array($sql)) {
                echo "&lt;b&gt;".$posts['user']."&lt;/b&gt; (&lt;a href=\"inc/up.php\" id=\"up\" onclick=\"javascript:clickHandler(1); return false;\"&gt;&lt;img src=\"inc/images/up.png\"></a>.$posts['up']." &lt;img src=\"inc/images/down.png\">.$posts['down'].")&lt;br /&gt;&lt;br /&gt;";
                echo "&lt;i&gt;\"".$posts['np']."\"&lt;/i&gt;&lt;hr /&gt;";

                echo "
                function clickHandler(post_id){
                    $.ajax({
                        type: 'POST',
                        url: 'inc/up.php',
                        data: 'post_id=' + post_id
                    });
                }
                &lt;/script&gt;";
            }
            ?&gt;

  • 0
  On 16/04/2011 at 06:29, Shazer2 said:

Xakepa, I'm obviously a beginner at this. I didn't ask for you to spoonfeed me, don't treat me like that. I learn off examples. From what Mouldy Punk showed me I think I can achieve this, I'll try me best and make an edit if I can get it.

Lol, you post a thread showing your complete ignorance of the subject and when somebody tries to help you get bitchy. :rolleyes:

  • 0

jQuery and PHP code to pull posts from database, display a a link to put +1 onto it.

$sql = mysql_query("SELECT * FROM `posts` ORDER BY up DESC") or die(mysql_error());
            while ($posts = mysql_fetch_array($sql)) {
                echo "&lt;b&gt;".$posts['user']."&lt;/b&gt; (&lt;a href=\"inc/up.php\" id=\"up\" onclick=\"javascript:clickHandler(1); return false;\"&gt;&lt;img src=\"inc/images/up.png\"></a>.$posts['up']." &lt;img src=\"inc/images/down.png\">.$posts['down'].")&lt;br /&gt;&lt;br /&gt;";
                echo "&lt;i&gt;\"".$posts['np']."\"&lt;/i&gt;&lt;hr /&gt;";

                echo "
                &lt;script type=\"text/javascript\"&gt;
                $('#up').click(function() {
                    $.ajax({
                        type: 'POST',
                        url: 'inc/up.php',
                        data: 'id=' + ".$posts['id']."
                    });
                });
                &lt;/script&gt;";
            }
?&gt;

up.php that processes the click:

include("connect.php");

$id = $_POST['id'];
$id = mysql_real_escape_string($id);

mysql_query("UPDATE `posts` SET up += 1 WHERE id='$id'") or die(mysql_error());

Just updating so I could gather more help, it still isn't posting an ID so if you know why, please help.

  • 0

Upload this somewhere, in a folder of its own and name it index.php. Once it's live, have a play around with it, if you have any specific questions, let me know.

&lt;?php
function records(){
  return array(
    array(
      'title' =&gt; 'PHP is cool',
      'id'    =&gt; 1,
      'votes' =&gt; rand(1, 10)
    ),
    array(
      'title' =&gt; 'jQuery is cool',
      'id'    =&gt; 2,
      'votes' =&gt; rand(1, 10)
    ),
    array(
      'title' =&gt; 'AJAX is cool',
      'id'    =&gt; 3,
      'votes' =&gt; rand(1, 10)
    ),
  );
}

if('POST' === $_SERVER['REQUEST_METHOD']){

  list($direction, $id) = explode('-', $_POST['data']);

  $filter = array(
    'up'    =&gt; 'up = up + 1',
    'down'  =&gt; 'down = down + 1'
  );

  if(array_key_exists($direction, $filter)){
    $sql = sprintf(
      "UPDATE table SET %s WHERE id = %d LIMIT 1;",
      $filter[$direction],
      $id
    );

    echo $sql;
    exit;
  }

}
?&gt;
&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">;html xmlns="http://www.w3.org/1999/xhtml">lt;head&gt;
    &lt;meta http-equiv="content-type" content="text/html; charset=utf-8" /&gt;
    &lt;link rel="stylesheet" type="text/css" media="screen" href="http://yui.yahooapis.com/3.3.0/build/cssreset/reset-min.css" /&gt;
    &lt;link rel="stylesheet" type="text/css" media="screen" href="http://yui.yahooapis.com/3.3.0/build/cssbase/base-min.css" /&gt;
    &lt;link rel="stylesheet" type="text/css" media="screen" href="http://yui.yahooapis.com/3.3.0/build/cssfonts/fonts-min.css" /&gt;
    &lt;script src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js" type="text/javascript"&gt;&lt;/script&gt;
    &lt;style type="text/css"&gt;
      td.votable{
        text-align: center;
        cursor: pointer;
      }
    &lt;/style&gt;
    &lt;title&gt;
      Demo
    &lt;/title&gt;
  &lt;/head&gt;
  &lt;body&gt;

    &lt;table&gt;
      &lt;thead&gt;
        &lt;tr&gt;
          &lt;th&gt;Title&lt;/th&gt;
          &lt;th&gt;Votes&lt;/th&gt;
          &lt;th&gt;Vote Up&lt;/th&gt;
          &lt;th&gt;Vote Down&lt;/th&gt;
        &lt;/tr&gt;
      &lt;/thead&gt;
      &lt;tbody&gt;
      &lt;?php foreach(records() as $record): ?&gt;
        &lt;tr&gt;
          &lt;td&gt;&lt;?php echo $record['title']; ?&gt;&lt;/td&gt;
          &lt;td&gt;&lt;?php echo $record['votes']; ?&gt;&lt;/td&gt;
          &lt;td class="votable" id="up-&lt;?php echo $record['id']; ?&gt;"&gt;Up&lt;/td&gt;
          &lt;td class="votable" id="down-&lt;?php echo $record['id']; ?&gt;"&gt;Down&lt;/td&gt;
        &lt;/tr&gt;
      &lt;?php endforeach; ?&gt;
      &lt;/tbody&gt;
    &lt;/table&gt;

    &lt;script type="text/javascript"&gt;
    //&lt;![CDATA[
      $(document).ready(function(){
        $('td.votable').each(function(){
          $(this).click(function(){
            $.ajax({
              type: 'POST',
              url: './index.php',
              data: 'data=' + $(this).attr('id'),
              success: function(response){
                alert(response);
              }
            });
          });
        });
      });
    //]]&gt;
    &lt;/script&gt;

  &lt;/body&gt;
&lt;/html&gt;

http://pastie.org/1803131

I've uploaded the script above to my server here: http://dev.anthonysterling.com/neowin/

It won't be there indefinitely though. :)

  • 0
  On 17/04/2011 at 00:14, Shazer2 said:

jQuery and PHP code to pull posts from database, display a a link to put +1 onto it.

$sql = mysql_query("SELECT * FROM `posts` ORDER BY up DESC") or die(mysql_error());
            while ($posts = mysql_fetch_array($sql)) {
                echo "&lt;b&gt;".$posts['user']."&lt;/b&gt; (&lt;a href=\"inc/up.php\" id=\"up\" onclick=\"javascript:clickHandler(1); return false;\"&gt;&lt;img src=\"inc/images/up.png\"></a>.$posts['up']." &lt;img src=\"inc/images/down.png\">.$posts['down'].")&lt;br /&gt;&lt;br /&gt;";
                echo "&lt;i&gt;\"".$posts['np']."\"&lt;/i&gt;&lt;hr /&gt;";

                echo "
                &lt;script type=\"text/javascript\"&gt;
                $('#up').click(function() {
                    $.ajax({
                        type: 'POST',
                        url: 'inc/up.php',
                        data: 'id=' + ".$posts['id']."
                    });
                });
                &lt;/script&gt;";
            }
?&gt;

up.php that processes the click:

include("connect.php");

$id = $_POST['id'];
$id = mysql_real_escape_string($id);

mysql_query("UPDATE `posts` SET up += 1 WHERE id='$id'") or die(mysql_error());

Just updating so I could gather more help, it still isn't posting an ID so if you know why, please help.

The reason why I was using the onclick attribute instead of using a jquery selector's click event is because you'd need a unique ID for every link. You've got <a id='up'> being generated multiple times in a while loop. HTML ids should be unique on a page, there should be no duplicates. Look at the final output (view source in your browser), the code you generate makes no sense - there's multiple $('#up').click() binds and multiple <a id='up'> elements - the browser has no way of telling which click function goes with which <a> element.

The method I mentioned previously would mean that the javascript function is output just once. Each of the onclick javascript calls give that single function different parameters (post IDs) making it send the right post ID. It is much simpler to use vanilla javascript, like I mentioned, to set up the function call than try and bind multiple event listeners using jQuery.

  • 0
  On 17/04/2011 at 08:55, AnthonySterling said:

Upload this somewhere, in a folder of its own and name it index.php. Once it's live, have a play around with it, if you have any specific questions, let me know.


http://pastie.org/1803131

I've uploaded the script above to my server here: http://dev.anthonysterling.com/neowin/

It won't be there indefinitely though. :)

That's really handy. Thanks a lot.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Cloud storage of course is not for all types of files users have but more users should be taking advantage of the cloud because otherwise their files are not backed up at all. Most regular users do not do that so automatic backup of their data is a good idea. The cloud is just another service/tool.
    • People do this with their iPhones and Androids. Smart people use cloud services as backups. No company deletes your account just like that. No company blocks your data for no reason. Having an external SSD and a paid cloud service is a must for anyone who works and for anyone who has sensitive data that needs to be backed up several times. Every CEO of a company has a corporate cloud service on their devices, but home users shouldn't use it, why?
    • Camtasia screen recorder now has a free version that works in your browser by Aditya Tiwari TechSmith, the minds behind Camtasia, has announced an online version of its popular screen recording and video editing tool. The web-based version, called Camtasia Online, is now available through popular web browsers like Google Chrome and Safari. Camtasia Online is essentially a stripped-down version of its desktop counterpart. It is designed to let you screen record, customize, share, and collaborate on high-quality videos without needing to download any software or purchase a subscription. Screen recording tools are often used to create step-by-step walkthroughs and tutorials, personalized feedback or coaching, and showcase a product or service. Camtasia has been around since 2002 and is primarily accessible through paid offerings. The screen recorder has over 34 million users globally. TechSmith offers a free trial of the desktop version, but the exported files automatically include a watermark. That's not the case with its modern counterpart, according to the company, which doesn't require any subscription. Note that while the online screen recorder is free to use, you still need a TechSmith account to use it. "While this first release focuses on streamlined creation, it will continue to grow in capability, and users can move projects into the Camtasia desktop editor for more advanced editing when needed,” TechSmith's CTO, Tony Lambert, said in an emailed statement. The web-based version allows you to create 1080p short clips (Scenes) of up to 5 minutes in length, with options to record a specific app, window, or the entire screen. It can record the screen, camera, and microphone on separate layers for more flexibility during editing. You can record multiple scenes and export them as a single video file. Camtasia Online offers a variety of visual effects and backgrounds, and the ability to pick a custom size and position on the screen. For instance, you can place the screen recording in the top-left or bottom-right corner of the screen, depending on your preference. Camtasia Online comes with more than 85 pre-defined "looks" to match your preference, its maker said. You can remove the background, add borders, drop shadows, make corners round, add reflections, and more, before and after recording a scene. You can also trim a video after recording with support for reversible changes. The online screen recorder also lets you collaborate with other users by sending invitation links. You can either give them access to the entire project or just a single scene. You can also preview the scenes before exporting them or re-record if something doesn't feel right. TechSmith also offers integration with Camtasia 2025's desktop version, allowing you to utilize additional features such as transitions, annotations, and dynamic captions. You can click on the Export button to download the project and use it in the desktop editor. Overall, Camtasia Online could be a suitable option for quick screen recording sessions and a viable choice for beginners. However, one downside is that it can be a bit tricky to download the video file directly through your browser. First, click on the "Export to Screencast" option in Export settings, which opens TechSmith's online hosting service. Then, make sure you're signed in to your TechSmith account, and click on More > Download to download the video file to your device.
    • Intel is pretty consistent about dropping a new CPU every year, typically in Q3. The fact that we are starting to get more information now implies they are on track.
    • TerraMaster D4 SSD review: Palm-sized DAS with up to 32TB of storage over USB4 by Steven Parker TerraMaster is back with another disk enclosure. I was offered the chance to take a look at their new D4 SSD, which is a palm-sized DAS that supports four M.2 SSDs ahead of its launch, today, on June 17. This follows our review of the all SATA D9-320 that we did last month, and the D5 Hybrid and D8 Hybrid, both of which are essentially multi-disk (HDD and SSD) enclosures for external backup, or to expand the capacity of a NAS. Here are the full specs of it: TerraMaster D4 SSD Dimensions: 138 x 60 x 140 mm Weight: 419g (with 3x M.2 SSDs) Power: 24W (100V to 240V AC) 50/60 HZ, Single Frequency System Fan: 50 x 50 x 10mm x3 Max Noise Level: 19 dB(A) using M.2 SSDs in standby mode; Test environment noise: 17.3dB(A); Test distance: 1m Compatible Disk Types: PCIe NVMe M.2 2280 SSD Reading Speed (max.) Writing Speed (max.) 3257 MB/s (Samsung 990 Pro 4TB x4 RAID0; 1600MB/s 4TB x1 3192 MB/s (Samsung 990 Pro 4TB x4 RAID0; 1500MB/s 4TB x1 Power Consumption: 15.0 W (Fully loaded Seagate 2TB M.2 SSDs in read/write state) 6.0 W (Fully loaded Seagate 2TB M.2 SSDs in hibernation) Raw Capacity: 32TB (8TB SSD x4) RAIDs Supported: SINGLE DISK Power saving: Hibernation Ports: USB4 40Gbps DC IN 12V Barrelport (MSRP) Price: $299.99 First, I should mention that TerraMaster only put SINGLE DISK support in the RAID specification, however unlike the D9-320 9-bay HDD enclosure, I was surprised to see that it actually supports both Striped and Spanned volumes in Windows 11, so you can get RAID1 in Windows 11 with this if you wanted, or simply combine all of the available drives into a single volume spanning the size of all drives combined. Technically, they are correct with the only SINGLE disk support, that is, if you plan to connect it to a NAS. Because it connects over USB, this means you will only be able to create usbshares, not storage pools. However, it is a nice surprise that Windows supports more functions with this D4 SSD than a NAS offers, which may also result in how you decide to use it. Also, for some reason, they have put that it weighs 600 grams. I think this is the package weight, because I weighed the D4 SSD after putting in three SSDs, and it came to 419 grams, which is really light! What's in the box D4 SSD device USB Type-C cable (C to C) 0.8m Power adapter Quick installation guide Limited warranty notice Bag of 2x M.2 screws I should mention that the "Quick Installation Guide" is simply a card with a QR code that links to https://start.terra-master.com. It requests your email and product details, which then opens to a full online User Guide. After getting to the end of the online User Guide (37 pages), which frustratingly encountered really slow page loads at times, there's a link to download a PDF of the User Manual. Design The design of the D4 SSD matches that of the F8 SSD Plus that I reviewed last year; in fact, it shares almost the same dimensions, but is 3.7cm shorter than its full NAS SSD counterpart, which is another example of how TerraMaster disk enclosures closely match their NAS sibling. It is essentially a metal frame with what I would call a matte black plastic cover. It is a bit of a dust and fingerprint magnet, too, but a quick wipe, and it's all gone, unlike what you would see with a glossy plastic exterior. It has a slightly textured feel to it and definitely feels premium, but also not in such a way that it would easily slip out of your hand. On the front, the D4 SSD is completely bare aside from a small sticker with D4 SSD printed on it; both sides are the same, with the TERRAMASTER logo stamped in the center. Unlike the D5-, D8 Hybrid, and NAS' in the same class (2- and 4-bay,) the logos do not double as ventilation on the D4 SSD. Around the back is a pretty bare affair with regulatory information stamped on it, then you have the Type C USB4 port and barrel power port input along with the screw that once removed, lets you slide off the cover to access the internals and manage the M.2 SSDs. Top Bottom The top uses the full surface area aside from the power button to assist with ventilation, and on the bottom, there are two 50 x 50 x 10mm intake fans that are very quiet. Installation Well, like the D9-320, there's hardly anything to it. Take off the screw around the back and screw in your PCIe NVMe M.2 2280 SSDs. They run at a (combined) max speed of USB4 (40 Gbps). TerraMaster includes a screw on each M2 connector, so need to go hunting, there are also two "backup screws" included in the box. For our review, we used two MP44Q 4TB NVMe SSDs ($224.99 on Amazon or Newegg) that TEAMGROUP supplied us with, and a 2TB Rocket 4 Plus ($219.99 on Newegg) that Sabrent sent to us. They are all PCIe 4.0 x4 drives. TerraMaster also uploaded a video to YouTube that shows how to install the storage options. Usage First, a bit of background on the capabilities of the D4 SSD. The ASMedia ASM2464PDX chip offers four lanes at PCIe 4.0 x 1; however, you can only expect to see up to 3257 MB/s speeds, and that will need to be in a RAID configuration; it basically translates to speeds you would expect from a traditional PCIe 3.0 SSD. This drops to around half that speed if the disks are being used independently in SINGLE disk mode. Here is how TerraMaster breaks it down: Unlike the D9-320 that we recently tested, it is not possible to daisy chain the D4 SSD with multiple units. As of writing, TerraMaster is not offering it in any other sizes (so, there is no D8 SSD option). RAID Happily, you can create a Striped or Spanned Volume of the disks in Windows, but be aware that it will only combine the total size of the smallest-sized SSD (so if you have 2TB + 4TB + 4TB, a volume of 3x 2TB will be created). In TOS 6 the same is true with the default TRAID setting, which is basically TerraMaster's own flavor of RAID5. Creating a storage pool on the D4 SSD in TOS 6 Creating a 3.71TB Storage pool (using two 4TB SSDs in TRAID) took around three hours to synchronize. On the official website, it is suggested that you download TPC Backupper, which is not included in the box, on a USB or onboard storage in the D8 Hybrid. There's a card that also instructs to download TPC Backupper. Still, I find that a bit of a shame because even most Razer or Logitech keyboards and mice include the setup program for Synapse or Logitech Options when you connect these devices to your Windows PC. Upon installing TPC Backupper by AOMEI a web page automatically opens in the default browser, thanking for a successful installation of what is actually a rebranded version of the free AOMEI Backupper Standard, and it "helpfully" suggests upgrading to a paid version for more features. The nag to upgrade to a paid version of the software seems a bit desperate if you ask me. I decided to emulate a daily backup that I usually do with the excellent SyncFolder, which basically backs up my Documents and Pictures folders from my main PC to my NAS Cloud drive. For this, I used the TPC Backupper app that I mentioned earlier. D4 SSD attached to local PC, local disk backup to D4 SSD over USB The process took a little under ten minutes to back up 34,979 files in 2,213 folders totaling 35,7GB into an .afi image file on a Striped volume. Restoring to the same local SSD only took 2m30s, which is impressive. D9-320 attached to local PC, backup to NAS over network Next, I backed up the same Documents and Pictures folders from the Striped volume in the D4 SSD to my Cloud backup over the network, and this took 11m20s. Restoring to the D4 SSD took just under three minutes, which is only half a minute longer than restoring the same data locally. Local PC backup over LAN to D4 SSD attached to NAS over USB Lastly, I ran the backup with the D4 SSD attached directly to my TerraMaster F4-424 Max over USB, so this meant copying the Documents and Pictures folder from my local PC over my LAN to the D4 SSD. The process took 14m33s to back up 34,979 files in 2,213 folders totaling 35,7GB into an .afi image file on the Simple volume, which is a little longer over the network than with the D4 SSD attached via USB to my local PC. Restoring the data locally over the network only took 1m30s, which was a minute quicker than restoring from the D4 SSD when attached locally, for some reason. Drive speed Striped volume Simple volume However, back to the drive setup, I ran CrystalDiskMark 8.0.5 in Windows 11 24H2 with the D4 SSD attached to that PC. I included both RAID and SINGLE disk mode, and the results definitely align with TerraMaster's drive speed claims, mentioned earlier in this review. I tried to measure the noise, but it did not register over the (roughly) 50dB of ambient noise of my work-from-home office. We will have to take TerraMaster's word for the claim about noise levels being as low as 19 dB. The Cooler Master NR200P Max towers above the TerraMaster D4 SSD Conclusion TerraMaster markets the D4 SSD as "specifically designed for media creation and video production applications," but also says that it "serves as an ideal external storage expansion solution for Mac mini and can be used as a Mac OS boot drive." Sorry, but I do not have a Mac mini to test this claim. TerraMaster also claims that this would suit gamers, for its "seamless experience indistinguishable from running on a local drive, with truly zero-latency performance." So it really has several use case applications depending on your wishes, and affordability to populate with up to four (large) SSDs. It looks premium, but it is what it is, essentially a plastic shell of a DAS. But it does not feel cheap either, the bottom intake fans are quiet, and overall, it is a nice-looking device that will not take up much room anywhere you place it. The added bonus here is RAID support, unlike with the D9-320 in Windows. However, do not expect RAID support on any NAS other than TerraMaster's own TOS 6 because you cannot create a storage pool over USB (at least in Synology DSM). Say you had a few one- or two-terabyte SSDs lying around, you could stick them all in and create a striped volume for anything up to 8TB for a really large storage volume in Windows. If I had any complaints at all, it would be how it does not really fully support 3rd party NAS' for creating a storage pool, but that would probably require an eSATA port. Secondly, I would have preferred to have seen a toolless method for installing and managing the SSDs. Most modern motherboards now use the toolless method of a clip or latch for M.2 SSDs, and given that the D4 SSD only supports 2280-sized SSDs, I don't feel this is a huge ask. You can purchase the TerraMaster D4 SSD for $299.99 from today (June 17) on the official website. As an Amazon Associate, we earn from qualifying purchases.
  • Recent Achievements

    • Experienced
      dismuter went up a rank
      Experienced
    • One Month Later
      mevinyavin earned a badge
      One Month Later
    • Week One Done
      rozermack875 earned a badge
      Week One Done
    • Week One Done
      oneworldtechnologies earned a badge
      Week One Done
    • Veteran
      matthiew went up a rank
      Veteran
  • Popular Contributors

    1. 1
      +primortal
      693
    2. 2
      ATLien_0
      269
    3. 3
      Michael Scrip
      209
    4. 4
      +FloatingFatMan
      186
    5. 5
      Steven P.
      142
  • Tell a friend

    Love Neowin? Tell a friend!