Php MySQL How to Updated/Insert into a database row

Question

Table_A

+--------+-----------+---------+ | id | name | views | +--------+-----------++--------+ | num | text | int | +--------+-----------+---------+ | 1 | Video 1 | 10 | | NULL | NULL | 0 | | NULL | NULL | 0 | | NULL | NULL | 0 | | NULL | NULL | 0 | +--------+-----------+---------+ <a href="video.php?id=video1&idtitle=Hello%20Video1"> <a href="video.php?id=video2&idtitle=Hello%20Video2"> <a href="video.php?id=video3&idtitle=Hello%20Video3">

I'm trying to make the script do something like this.

1.User click on link
2.User is on video.php?id=video1
3.Mysql then add a +1 to my id column #1
4.then take the video title from $videoName
5.Mysql take the title inside of $videoname and store it on name column #2
6.Mysql then add +1 to Views everytime ID 1 is view
7.Mysql is now finish with Row 1
8.Now Mysql will repeat that same step if video.php?id=video2 and so on,

How can i make this happen?

 $id = $_GET['id']; $videoName = $_GET['idtitle']; $pdo = new PDO('mysql:localhost;dbname=videocount', 'root', ''); $userip = $_SERVER["REMOTE_ADDR"]; if($userip){ $pdo->query("UPDATE Table_A SET (`id`, `name`, `views`) VALUES (NULL,$videoName, views+1)"); }

I also try the code below but still no luck.

 if($userip){ $pdo->query("INSERT INTO `videocount`.`Table_A` (`id`, `name`, `views`) VALUES (NULL, '$videoname', 'views'+1)"); }

fusion3k · Accepted Answer · 2016-01-27 02:24:59Z

UPDATE instead of UPDATED, VALUES instead of VALUE. In addition you have to add a WHERE condition to your query to select record to update.

This is ~~another~~ correct syntax:

$pdo->query( "UPDATE `Table_A` SET `views`=`views`+1 WHERE `id`='$id'" );

Edit:

To update also the video name you can perform this query:

$pdo->query( "UPDATE `Table_A` SET `name`='{$videoName}', `views`=`views`+1 WHERE `id`='$id'" );

On the border, you should bind the variable values to avoid errors with titles special characters.

See more about binding and MySQL UPDATE syntax

How can i get that file $videoName? to updated video name on my database?

Xiaosong Guo · Accepted Answer · 2016-01-27 02:08:53Z

I think there is a little confusion about data view logic.

First of all, you need to save all data into database, then list them for user. When the use click the link to view this video, the column of views need to be updated.

Collectives™ on Stack Overflow

Php MySQL How to Updated/Insert into a database row

2 Answers 2

Edit:

3 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Edit:

3 Comments

Comments

Linked

Related