Fix tag counts in db

fix-tag-counts-openphoto.php

<?php
$host = '***';
$user = '***';
$pass = '***';
$dbname = '***';
$owner = 'user@example.com';
$conn = mysql_connect($host,$user,$pass);
mysql_select_db($dbname);


$res = mysql_query("SELECT * FROM photo WHERE owner='{$owner}'");
$allTags = array();
$elementIds = array();
while($row = mysql_fetch_assoc($res))
{
  $tags = (array)explode(',', $row['tags']);
  foreach($tags as $tag)
  {
    $tag = strtolower($tag);
    if(!isset($allTags[$tag]))
      $allTags[$tag] = array('public' => 0, 'private' => 0);

    $allTags[$tag]['private']++;
    if($row['permission'] == 1)
      $allTags[$tag]['public']++;

    $elementIds[] = array('photoId' => $row['id'], 'tag' => $tag);
  }
}

mysql_query("DELETE FROM tag WHERE owner='{$owner}'");
foreach($allTags as $tag => $counts)
{
  mysql_query("INSERT INTO tag(id, owner, countPublic, countPrivate) VALUE('{$tag}', '{$owner}', '{$counts['public']}', '{$counts['private']}');");
}

mysql_query("DELETE FROM elementTag WHERE owner='{$owner}'");
foreach($elementIds as $elementTag)
{
  mysql_query("INSERT INTO elementTag(owner, type, element, tag) VALUE('{$owner}', 'photo', '{$elementTag['photoId']}', '{$elementTag['tag']}');");
}

Any particular reason for using the deprecated MySQL library instead of MySQLi or PDO?

@Daniel15 lazyness. Less to type than using PDO :). Otherwise I use PDO.