Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: [SQL][MySQL][PHP]Zapytanie i błąd
Forum PHP.pl > Forum > Przedszkole
musiek86
Skrypt wypełnia tabele w bazie i mam taki rekord do dodania
  1. $inserts[] = "INSERT INTO efora__{$nazwa}__settings ('sid', 'name', 'title', 'description', 'optionscode', 'value', 'disporder', 'gid', 'isdefault') VALUES
  2. (1, 'enablecalendar', 'Enable Calendar Functionality', 'If you wish to disable the calendar on your board, set this option to no.', 'yesno', '1', 1, 1, 1),
  3. (...)
  4. (13, 'timezoneoffset', 'Default Timezone Offset', 'Here you can set the default timezone offset for guests and members using the default offset.', 'php\n<select name=\\'upsetting[{\$setting[''name'']}]\\'>\n<option value=\\'-12\\' '.($setting[''value''] == -12?'selected=\\'selected\\'':'').'>GMT -12:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -12).')</option>\n<option value=\\'-11\\' '.($setting[''value''] == -11?'selected=\\'selected\\'':'').'>GMT -11:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -11).')</option>\n<option value=\\'-10\\' '.($setting[''value''] == -10?'selected=\\'selected\\'':'').'>GMT -10:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -10).')</option>\n<option value=\\'-9\\' '.($setting[''value''] == -9?'selected=\\'selected\\'':'').'>GMT -9:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -9).')</option>\n<option value=\\'-8\\' '.($setting[''value''] == -8?'selected=\\'selected\\'':'').'>GMT -8:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -8).')</option>\n<option value=\\'-7\\' '.($setting[''value''] == -7?'selected=\\'selected\\'':'').'>GMT -7:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -7).')</option>\n<option value=\\'-6\\' '.($setting[''value''] == -6?'selected=\\'selected\\'':'').'>GMT -6:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -6).')</option>\n<option value=\\'-5\\' '.($setting[''value''] == -5?'selected=\\'selected\\'':'').'>GMT -5:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -5).')</option>\n<option value=\\'-4\\' '.($setting[''value''] == -4?'selected=\\'selected\\'':'').'>GMT -4:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -4).')</option>\n<option value=\\'-3.5\\' '.($setting[''value''] == -3.5?'selected=\\'selected\\'':'').'>GMT -3:30 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -3.5).')</option>\n<option value=\\'-3\\' '.($setting[''value''] == -3?'selected=\\'selected\\'':'').'>GMT -3:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -3).')</option>\n<option value=\\'-2\\' '.($setting[''value''] == -2?'selected=\\'selected\\'':'').'>GMT -2:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -2).')</option>\n<option value=\\'-1\\' '.($setting[''value''] == -1?'selected=\\'selected\\'':'').'>GMT -1:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -1).')</option>\n<option value=\\'0\\' '.($setting[''value''] == 0?'selected=\\'selected\\'':'').'>GMT ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 0).')</option>\n<option value=\\'+1\\' '.($setting[''value''] == 1?'selected=\\'selected\\'':'').'>GMT +1:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 1).')</option>\n<option value=\\'+2\\' '.($setting[''value''] == 2?'selected=\\'selected\\'':'').'>GMT +2:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 2).')</option>\n<option value=\\'+3\\' '.($setting[''value''] == 3?'selected=\\'selected\\'':'').'>GMT +3:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 3).')</option>\n<option value=\\'+3.5\\' '.($setting[''value''] == 3.5?'selected=\\'selected\\'':'').'>GMT +3:30 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 3.5).')</option>\n<option value=\\'+4\\' '.($setting[''value''] == 4?'selected=\\'selected\\'':'').'>GMT +4:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 4).')</option>\n<option value=\\'+4.5\\' '.($setting[''value''] == 4.5?'selected=\\'selected\\'':'').'>GMT +4:30 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 4.5).')</option>\n<option value=\\'+5\\' '.($setting[''value''] == 5?'selected=\\'selected\\'':'').'>GMT +5:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 5).')</option>\n<option value=\\'+5.5\\' '.($setting[''value''] == 5.5?'selected=\\'selected\\'':'').'>GMT +5:30 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 5.5).')</option>\n<option value=\\'+5.75\\' '.($setting[''value''] == 5.75?'selected=\\'selected\\'':'').'>GMT +5:45 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 5.75).')</option>\n<option value=\\'+6\\' '.($setting[''value''] == 9?'selected=\\'selected\\'':'').'>GMT +6:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 6).')</option>\n<option value=\\'+7\\' '.($setting[''value''] == 7?'selected=\\'selected\\'':'').'>GMT +7:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 7).')</option>\n<option value=\\'+8\\' '.($setting[''value''] == 8?'selected=\\'selected\\'':'').'>GMT +8:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 8).')</option>\n<option value=\\'+9\\' '.($setting[''value''] == 9?'selected=\\'selected\\'':'').'>GMT +9:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 9).')</option>\n<option value=\\'+9.5\\' '.($setting[''value''] == 9.5?'selected=\\'selected\\'':'').'>GMT +9:30 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 9.5).')</option>\n<option value=\\'+10\\' '.($setting[''value''] == 10?'selected=\\'selected\\'':'').'>GMT +10:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 10).')</option>\n<option value=\\'+10.5\\' '.($setting[''value''] == 10.5?'selected=\\'selected\\'':'').'>GMT +10:30 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 10.5).')</option>\n<option value=\\'+11\\' '.($setting[''value''] == 11?'selected=\\'selected\\'':'').'>GMT +11:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 11).')</option>\n<option value=\\'+12\\' '.($setting[''value''] == 12?'selected=\\'selected\\'':'').'>GMT +12:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 12).')</option>\n</select>', '+1', 4, 4, 1),
  5. (...)
  6. (205, 'prunethreads', 'Prune User Posts/Threads', 'For the users that are going to be removed, do you want to remove all of their posts/threads?', 'yesno', '0', 7, 21, 1);";


Podczas wykonywania otrzymuje błąd
  1. Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /opt/lampp/htdocs/e-fora/pliki/formularz/mybb_wypelnianie_tabel2.php on line 218

Tj odnosnie tekstu zaczynającego sie od (13, a kończącego sie przed (...)
(205,
. Nie wiem gdzie i co jest nie tak, nie widze, moze mnie ktos nakierowac?
melkorm
Odpal w zwykłym edytorze, przeformatuj kod to zobaczysz, zresztą forum nie parser.
musiek86
Mam odpalone w notepad++ który koloruje ale skrypt jest tak napisany ze wszystko mam w kolorze szarym co utrudnia mi to nieco, wiec jesli widzisz błą to łaskawie wskaż mi go.
Dodam jeszcze iż nie chce by ten kod był analizowany, konkretniej mowiąc w tabeli optionscode ma znajdować sie słowo w słowo tekst php\n<select name=\\'upsetting[{\$setting[''name'']}]\\'>\n<option value=\\'-12\\' '.($setting[''value''] == -12?'selected=\\'selected\\'':'').'>GMT -12:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -12).')</option>\n<option value=\\'-11\\' '.($setting[''value''] == -11?'selected=\\'selected\\'':'').'>GMT -11:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -11).')</option>\n<option value=\\'-10\\' '.($setting[''value''] == -10?'selected=\\'selected\\'':'').'>GMT -10:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -10).')</option>\n<option value=\\'-9\\' '.($setting[''value''] == -9?'selected=\\'selected\\'':'').'>GMT -9:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -9).')</option>\n<option value=\\'-8\\' '.($setting[''value''] == -8?'selected=\\'selected\\'':'').'>GMT -8:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -8).')</option>\n<option value=\\'-7\\' '.($setting[''value''] == -7?'selected=\\'selected\\'':'').'>GMT -7:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -7).')</option>\n<option value=\\'-6\\' '.($setting[''value''] == -6?'selected=\\'selected\\'':'').'>GMT -6:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -6).')</option>\n<option value=\\'-5\\' '.($setting[''value''] == -5?'selected=\\'selected\\'':'').'>GMT -5:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -5).')</option>\n<option value=\\'-4\\' '.($setting[''value''] == -4?'selected=\\'selected\\'':'').'>GMT -4:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -4).')</option>\n<option value=\\'-3.5\\' '.($setting[''value''] == -3.5?'selected=\\'selected\\'':'').'>GMT -3:30 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -3.5).')</option>\n<option value=\\'-3\\' '.($setting[''value''] == -3?'selected=\\'selected\\'':'').'>GMT -3:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -3).')</option>\n<option value=\\'-2\\' '.($setting[''value''] == -2?'selected=\\'selected\\'':'').'>GMT -2:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -2).')</option>\n<option value=\\'-1\\' '.($setting[''value''] == -1?'selected=\\'selected\\'':'').'>GMT -1:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -1).')</option>\n<option value=\\'0\\' '.($setting[''value''] == 0?'selected=\\'selected\\'':'').'>GMT ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 0).')</option>\n<option value=\\'+1\\' '.($setting[''value''] == 1?'selected=\\'selected\\'':'').'>GMT +1:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 1).')</option>\n<option value=\\'+2\\' '.($setting[''value''] == 2?'selected=\\'selected\\'':'').'>GMT +2:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 2).')</option>\n<option value=\\'+3\\' '.($setting[''value''] == 3?'selected=\\'selected\\'':'').'>GMT +3:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 3).')</option>\n<option value=\\'+3.5\\' '.($setting[''value''] == 3.5?'selected=\\'selected\\'':'').'>GMT +3:30 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 3.5).')</option>\n<option value=\\'+4\\' '.($setting[''value''] == 4?'selected=\\'selected\\'':'').'>GMT +4:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 4).')</option>\n<option value=\\'+4.5\\' '.($setting[''value''] == 4.5?'selected=\\'selected\\'':'').'>GMT +4:30 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 4.5).')</option>\n<option value=\\'+5\\' '.($setting[''value''] == 5?'selected=\\'selected\\'':'').'>GMT +5:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 5).')</option>\n<option value=\\'+5.5\\' '.($setting[''value''] == 5.5?'selected=\\'selected\\'':'').'>GMT +5:30 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 5.5).')</option>\n<option value=\\'+5.75\\' '.($setting[''value''] == 5.75?'selected=\\'selected\\'':'').'>GMT +5:45 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 5.75).')</option>\n<option value=\\'+6\\' '.($setting[''value''] == 9?'selected=\\'selected\\'':'').'>GMT +6:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 6).')</option>\n<option value=\\'+7\\' '.($setting[''value''] == 7?'selected=\\'selected\\'':'').'>GMT +7:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 7).')</option>\n<option value=\\'+8\\' '.($setting[''value''] == 8?'selected=\\'selected\\'':'').'>GMT +8:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 8).')</option>\n<option value=\\'+9\\' '.($setting[''value''] == 9?'selected=\\'selected\\'':'').'>GMT +9:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 9).')</option>\n<option value=\\'+9.5\\' '.($setting[''value''] == 9.5?'selected=\\'selected\\'':'').'>GMT +9:30 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 9.5).')</option>\n<option value=\\'+10\\' '.($setting[''value''] == 10?'selected=\\'selected\\'':'').'>GMT +10:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 10).')</option>\n<option value=\\'+10.5\\' '.($setting[''value''] == 10.5?'selected=\\'selected\\'':'').'>GMT +10:30 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 10.5).')</option>\n<option value=\\'+11\\' '.($setting[''value''] == 11?'selected=\\'selected\\'':'').'>GMT +11:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 11).')</option>\n<option value=\\'+12\\' '.($setting[''value''] == 12?'selected=\\'selected\\'':'').'>GMT +12:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 12).')</option>\n</select> zmienne nie maja być podmieniane a kod analizowany przez parser.

EDIT:
Juz sobie poradziłem konstruując skrypt w nieco innej formie. Do zamknięcia.
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.