Lines Matching refs:con
32 if ($con = mysqli_connect(GETID3_DB_HOST, GETID3_DB_USER, GETID3_DB_PASS)){ variable
37 …blockquote style="background-color: #FF9933; padding: 10px;">'.mysqli_error($con).'</blockquote>');
40 if (mysqli_select_db($con,GETID3_DB_DB)){
45 …blockquote style="background-color: #FF9933; padding: 10px;">'.mysqli_error($con).'</blockquote>');
115 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
116 $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $from).'")';
117 mysqli_query_safe($con, $SQLquery);
159 function mysqli_query_safe($con, $SQLquery) { argument
165 $result = mysqli_query($con, $SQLquery);
167 if (mysqli_error($con)) {
168 …/div><div style="color: blue; padding: 10px;">'.htmlentities(mysqli_error($con)).'</div><hr size="…
173 function mysqli_table_exists($con, $tablename) { argument
174 return (bool) mysqli_query($con, 'DESCRIBE '.$tablename);
209 if (mysqli_table_exists($con, GETID3_DB_TABLE)) {
210 $SQLquery = 'DROP TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
211 mysqli_query_safe($con, $SQLquery);
214 if (!mysqli_table_exists($con, GETID3_DB_TABLE)) {
215 $SQLquery = "CREATE TABLE `".mysqli_real_escape_string($con, GETID3_DB_TABLE)."` (";
249 mysqli_query_safe($con, $SQLquery);
253 $result = mysqli_query_safe($con, 'DESCRIBE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'…
259 …mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` ADD `e…
260 mysqli_query_safe($con, 'OPTIMIZE TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`');
264 …mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE…
265 mysqli_query_safe($con, 'OPTIMIZE TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`');
270 …mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` ADD `t…
271 mysqli_query_safe($con, 'OPTIMIZE TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`');
275 …mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` ADD `r…
276 …mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` ADD `a…
277 …mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` ADD `p…
278 mysqli_query_safe($con, 'OPTIMIZE TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`');
283 …mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE…
284 …mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE…
285 …mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE…
286 …mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE…
287 …mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE…
288 …mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE…
308 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
309 $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $filename).'")';
310 mysqli_query_safe($con, $SQLquery);
347 $SQLquery = 'DELETE from `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
349 mysqli_query_safe($con, $SQLquery);
360 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
364 $result = mysqli_query_safe($con, $SQLquery);
369 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
370 $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")';
371 mysqli_query_safe($con, $SQLquery);
385 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
389 $result = mysqli_query_safe($con, $SQLquery);
393 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
394 $SQLquery .= ' WHERE `filename` LIKE "'.mysqli_real_escape_string($con, $row['filename']).'"';
395 mysqli_query_safe($con, $SQLquery);
406 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
408 $result = mysqli_query_safe($con, $SQLquery);
522 $SQLquery = 'UPDATE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` SET ';
523 …$SQLquery .= ' `last_modified` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['file…
524 …$SQLquery .= ', `md5_file` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['md5_…
525 …$SQLquery .= ', `md5_data` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['md5_…
526 …$SQLquery .= ', `md5_data_source` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['md5_…
527 …$SQLquery .= ', `filesize` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['file…
528 …$SQLquery .= ', `fileformat` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['file…
529 …$SQLquery .= ', `audio_dataformat` = "'.mysqli_real_escape_string($con, !empty($ThisFileInfo['audi…
530 …$SQLquery .= ', `video_dataformat` = "'.mysqli_real_escape_string($con, !empty($ThisFileInfo['vide…
531 …$SQLquery .= ', `vbr_method` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['mpeg…
532 …$SQLquery .= ', `audio_bitrate` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['audi…
533 …$SQLquery .= ', `video_bitrate` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['vide…
534 …$SQLquery .= ', `playtime_seconds` = "'.mysqli_real_escape_string($con, !empty($ThisFileInfo['play…
535 …$SQLquery .= ', `track_volume` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['repl…
536 …$SQLquery .= ', `comments_all` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['comm…
537 …$SQLquery .= ', `comments_id3v2` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['tags…
538 …$SQLquery .= ', `comments_ape` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['tags…
539 …$SQLquery .= ', `comments_lyrics3` = "'.mysqli_real_escape_string($con, !empty($ThisFileInfo['tags…
540 …$SQLquery .= ', `comments_id3v1` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['tags…
541 …$SQLquery .= ', `warning` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['warn…
542 …$SQLquery .= ', `error` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['erro…
543 …$SQLquery .= ', `album` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['comm…
544 …$SQLquery .= ', `genre` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['comm…
545 …$SQLquery .= ', `comment` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['comm…
546 …$SQLquery .= ', `artist` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['comm…
547 …$SQLquery .= ', `tags` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['tags…
548 …$SQLquery .= ', `encoder_options` = "'. mysqli_real_escape_string($con, trim((!empty($ThisFileInfo…
549 $SQLquery .= ', `title` = "'. mysqli_real_escape_string($con, $this_track_title).'"';
550 $SQLquery .= ', `remix` = "'. mysqli_real_escape_string($con, $this_track_remix).'"';
551 $SQLquery .= ', `track` = "'. mysqli_real_escape_string($con, $this_track_track).'"';
552 …$SQLquery .= ' WHERE (`filename` = "'. mysqli_real_escape_string($con, isset($ThisFileInfo['filena…
557 …$SQLquery = 'INSERT INTO `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` (`filename`, `las…
558 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['filenamepath'] …
559 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['file_modified_time'] …
560 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['md5_file'] …
561 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['md5_data'] …
562 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['md5_data_source'] …
563 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['filesize'] …
564 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['fileformat'] …
565 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['audio']['dataformat'] …
566 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['video']['dataformat'] …
567 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['audio']['bitrate'] …
568 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['video']['bitrate'] …
569 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['playtime_seconds'] …
571 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['tags'] …
572 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['comments']['artist'] …
573 $SQLquery .= '"'.mysqli_real_escape_string($con, $this_track_title).'", ';
574 $SQLquery .= '"'.mysqli_real_escape_string($con, $this_track_remix).'", ';
575 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['comments']['album'] …
576 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['comments']['genre'] …
577 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['comments']['comment'] …
578 $SQLquery .= '"'.mysqli_real_escape_string($con, $this_track_track).'", ';
579 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['comments'] …
580 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['tags']['id3v2'] …
581 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['tags']['ape'] …
582 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['tags']['lyrics3'] …
583 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['tags']['id3v1'] …
584 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['warning'] …
585 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['error'] …
586 …$SQLquery .= '"'.mysqli_real_escape_string($con, trim((!empty($ThisFileInfo['audio']['encoder']) ?…
587 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['mpeg']['audio']['LAME']) ? …
588 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['replay_gain']['track']['vol…
592 mysqli_query_safe($con, $SQLquery);
597 $SQLquery = 'OPTIMIZE TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
598 mysqli_query_safe($con, $SQLquery);
608 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
611 $result = mysqli_query_safe($con, $SQLquery);
622 $SQLquery = 'UPDATE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
624 $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")';
625 mysqli_query_safe($con, $SQLquery);
631 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
632 $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")';
633 mysqli_query_safe($con, $SQLquery);
643 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
646 $result = mysqli_query_safe($con, $SQLquery);
654 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
655 $SQLquery .= ' WHERE `filename` LIKE "'.mysqli_real_escape_string($con, $row['filename']).'"';
656 mysqli_query_safe($con, $SQLquery);
664 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
666 $result = mysqli_query_safe($con, $SQLquery);
691 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
692 $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")';
693 mysqli_query_safe($con, $SQLquery);
714 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
715 …$SQLquery .= ' WHERE (`encoder_options` = "'.mysqli_real_escape_string($con, $_REQUEST['encodedbyd…
716 $result = mysqli_query_safe($con, $SQLquery);
738 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
739 $result = mysqli_query_safe($con, $SQLquery);
753 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
755 $result = mysqli_query_safe($con, $SQLquery);
790 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
793 $result = mysqli_query_safe($con, $SQLquery);
817 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
822 $result = mysqli_query_safe($con, $SQLquery);
858 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
861 $result = mysqli_query_safe($con, $SQLquery);
898 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
903 $result = mysqli_query_safe($con, $SQLquery);
941 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
944 $result = mysqli_query_safe($con, $SQLquery);
976 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
980 $result = mysqli_query_safe($con, $SQLquery);
1064 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1067 $result = mysqli_query_safe($con, $SQLquery);
1344 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1347 $result = mysqli_query_safe($con, $SQLquery);
1470 …$SQLquery = 'SELECT `filename`, `encoder_options` FROM `'.mysqli_real_escape_string($con, GETID3_…
1471 …$SQLquery .= ' WHERE (`encoder_options` LIKE "'.mysqli_real_escape_string($con, $_REQUEST['showtag…
1474 $result = mysqli_query_safe($con, $SQLquery);
1502 …$SQLquery = 'SELECT `encoder_options`, COUNT(*) AS `num` FROM `'.mysqli_real_escape_string($con, …
1506 $result = mysqli_query_safe($con, $SQLquery);
1524 …$SQLquery = 'SELECT `tags`, COUNT(*) AS `num` FROM `'.mysqli_real_escape_string($con, GETID3_DB_T…
1528 $result = mysqli_query_safe($con, $SQLquery);
1543 …$SQLquery = 'SELECT `filename`, `tags` FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'…
1544 …$SQLquery .= ' WHERE (`tags` LIKE "'.mysqli_real_escape_string($con, $_REQUEST['showtagfiles']).'"…
1547 $result = mysqli_query_safe($con, $SQLquery);
1579 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1583 $result = mysqli_query_safe($con, $SQLquery);
1591 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1592 $SQLquery .= ' WHERE (`md5_data` = "'.mysqli_real_escape_string($con, $row['md5_data']).'")';
1594 $result2 = mysqli_query_safe($con, $SQLquery);
1627 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1628 $SQLquery .= ' WHERE (`artist` = "'.mysqli_real_escape_string($con, $_REQUEST['m3uartist']).'")';
1629 $SQLquery .= ' AND (`title` = "'.mysqli_real_escape_string($con, $_REQUEST['m3utitle']).'")';
1631 $result = mysqli_query_safe($con, $SQLquery);
1640 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1645 $result = mysqli_query_safe($con, $SQLquery);
1655 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1656 $SQLquery .= ' WHERE (`artist` = "'.mysqli_real_escape_string($con, $row['artist']).'")';
1657 $SQLquery .= ' AND (`title` = "'.mysqli_real_escape_string($con, $row['title']).'")';
1659 $SQLquery .= ' AND (`remix` = "'.mysqli_real_escape_string($con, $row['remix']).'")';
1662 $result2 = mysqli_query_safe($con, $SQLquery);
1687 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1688 $SQLquery .= ' WHERE (`artist` = "'.mysqli_real_escape_string($con, $row['artist']).'")';
1689 $SQLquery .= ' AND (`title` = "'.mysqli_real_escape_string($con, $row['title']).'")';
1691 $result2 = mysqli_query_safe($con, $SQLquery);
1742 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1743 $SQLquery .= ' WHERE (`fileformat` = "'.mysqli_real_escape_string($con, $fileformat).'")';
1744 $SQLquery .= ' AND (`audio_dataformat` = "'.mysqli_real_escape_string($con, $audioformat).'")';
1746 $result = mysqli_query_safe($con, $SQLquery);
1761 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1764 $result = mysqli_query_safe($con, $SQLquery);
1835 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1837 $result = mysqli_query_safe($con, $SQLquery);
1871 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1875 $result = mysqli_query_safe($con, $SQLquery);
1886 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1890 $result = mysqli_query_safe($con, $SQLquery);
1911 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1912 …$SQLquery .= ' WHERE (`genre` LIKE "'.mysqli_real_escape_string($con, $_REQUEST['genredistribution…
1914 $result = mysqli_query_safe($con, $SQLquery);
1935 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1938 $result = mysqli_query_safe($con, $SQLquery);
1952 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1956 $result = mysqli_query_safe($con, $SQLquery);
1989 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1993 $result = mysqli_query_safe($con, $SQLquery);
2015 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
2018 $result = mysqli_query_safe($con, $SQLquery);
2036 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
2037 …$SQLquery .= ' WHERE (`vbr_method` = "'.mysqli_real_escape_string($con, $_REQUEST['vbrmethod']).'"…
2038 $result = mysqli_query_safe($con, $SQLquery);
2052 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
2055 $result = mysqli_query_safe($con, $SQLquery);
2178 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
2179 $result = mysqli_query_safe($con, $SQLquery);
2183 echo 'Spent '.number_format(mysqli_query_safe($con, null), 3).' seconds querying the database<br>';