Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 09-17-2010, 11:26 PM
SorentoUltimate's Avatar
SorentoUltimate SorentoUltimate is offline
 
Join Date: Jul 2009
Location: Moschato, Athens, Greece
Posts: 338
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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?????
Reply With Quote
  #2  
Old 09-17-2010, 11:43 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 09-17-2010, 11:45 PM
SorentoUltimate's Avatar
SorentoUltimate SorentoUltimate is offline
 
Join Date: Jul 2009
Location: Moschato, Athens, Greece
Posts: 338
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kh99 View Post
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?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:01 PM.


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.04684 seconds
  • Memory Usage 2,191KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete