vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Insert to DataBase With PHP Problem (https://vborg.vbsupport.ru/showthread.php?t=250733)

SorentoUltimate 09-17-2010 10:26 PM
Insert to DataBase With PHP Problem
 
Hi all

i have that php file
PHP Code:
<?php

function import_poi_sections()
{
  global $vbulletin, $db;

  $db->query_write("INSERT INTO `" . TABLE_PREFIX . "mytable` VALUES (1, 'Sex Activities', 1254009600, 1254009600)");
  $db->query_write("INSERT INTO `" . TABLE_PREFIX . "mytable` VALUES (2, 'Super Markets', 1282521600, 1282521600)");
  $db->query_write("INSERT INTO `" . TABLE_PREFIX . "mytable` VALUES (3, 'WiFi Spots', 1281484800, 1281484800)");
  $db->query_write("INSERT INTO `" . TABLE_PREFIX . "mytable` VALUES (4, 'Ακτοπλοϊκές Εταιρείες', 1284336000, 1284336000)");
  $db->query_write("INSERT INTO `" . TABLE_PREFIX . "mytable` VALUES (5, 'Αρχείο Σημείων', 1269475200, 1269475200)");
  $db->query_write("INSERT INTO `" . TABLE_PREFIX . "mytable` VALUES (6, 'Αρώματα-Ομορφιά-Κομμωτήρια', 1282089600, 1282089600)");
  $db->query_write("INSERT INTO `" . TABLE_PREFIX . "mytable` VALUES (7, 'Αυτοκίνητα', 1284681600, 1284681600)");
  $db->query_write("INSERT INTO `" . TABLE_PREFIX . "mytable` VALUES (8, 'Βενζινάδικα', 1284249600, 1284249600)");
  $db->query_write("INSERT INTO `" . TABLE_PREFIX . "mytable` VALUES (9, 'Βιβλία-Χαρτικά', 1284681600, 1284681600)");

}

?>
the lines 1,2,3 import ok

at the lines 4,5,6,7,8,9 in second field put nothing and not the data from insert command !!!

Any Idea?????

kh99 09-17-2010 10:43 PM
Maybe I'm just stating the obvious, but it seems the greek characters are causing the problem, so it's an issue with character set configuration somewhere.

SorentoUltimate 09-17-2010 10:45 PM
Quote:
Originally Posted by kh99 (Post 2099853)
Maybe I'm just stating the obvious, but it seems the greek characters are causing the problem, so it's an issue with character set configuration somewhere.
i also believe the greek are the problem, all are set to utf-8
no problem, work ok.

but when i try to insert data to sql with php i have the problem !!!

any idea?


All times are GMT. The time now is 10:12 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01618 seconds
  • Memory Usage 1,726KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete