|
PHP - Help With Data Import - Error 1064
help - can you tell me why this is giving the following error
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `admin`' at line 8
i am trying to import a data file ... first few lines of which are
-- MySQL dump 10.10
-- -- Host: localhost Database: bromleyone -- ------------------------------------------------------ -- Server version 5.0.22-Debian_0ubuntu6.06.10-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; use bromleyone -- -- Table structure for table `admin` -- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(11) NOT NULL auto_increment, `username` varchar(30) NOT NULL default '', `password` varchar(30) NOT NULL default '', `name` varchar(40) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Similar TutorialsHello all,
Appreciate if you folks could pls. help me understand (and more importantly resolve) this very weird error:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC, purchase_later_flag ASC, shopper1_buy_flag AS' at line 3' in /var/www/index.php:67 Stack trace: #0 /var/www/index.php(67): PDO->query('SELECT shoplist...') #1 {main} thrown in /var/www/index.php on line 67
Everything seems to work fine when/if I use the following SQL query (which can also be seen commented out in my code towards the end of this post) :
$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name FROM shoplist, store_master, item_master WHERE shoplist.store_id = store_master.store_id AND shoplist.item_id = item_master.item_id";However, the moment I change my query to the following, which essentially just includes/adds the ORDER BY clause, I receive the error quoted above: $sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name FROM shoplist, store_master, item_master ORDER BY purchased_flag ASC, purchase_later_flag ASC, shopper1_buy_flag ASC, shopper2_buy_flag ASC, store_name ASC) WHERE shoplist.store_id = store_master.store_id AND shoplist.item_id = item_master.item_id";In googling for this error I came across posts that suggested using "ORDER BY FIND_IN_SET()" and "ORDER BY FIELD()"...both of which I tried with no success. Here's the portion of my code which seems to have a problem, and line # 67 is the 3rd from bottom (third last) statement in the code below: <?php
/*
$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
FROM shoplist, store_master, item_master
WHERE shoplist.store_id = store_master.store_id
AND shoplist.item_id = item_master.item_id";
*/
$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
FROM shoplist, store_master, item_master
ORDER BY FIND_IN_SET(purchased_flag ASC,
purchase_later_flag ASC,
shopper1_buy_flag ASC,
shopper2_buy_flag ASC,
store_name ASC)
WHERE shoplist.store_id = store_master.store_id
AND shoplist.item_id = item_master.item_id";
$result = $pdo->query($sql);
// foreach ($pdo->query($sql) as $row) {
foreach ($result as $row) {
echo '<tr>';
print '<td><span class="filler-checkbox"><input type="checkbox" name="IDnumber[]" value="' . $row["idnumber"] . '" /></span></td>';
Thanks
I have a pdo prepared statement that fetches records from mysql database. The records show up on the page. However if there are no records on a page, I get this error message.
"QLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10' at line 4"
Here is my statement
$getCategoryId = $_GET['id'];
$limit = 10;
$offset = ($page - 1) * $limit;
$statement = $db->prepare("SELECT records.*, categories.* FROM records
LEFT JOIN categories ON records.category_id = categories.category_id
WHERE records.category_id = :category_id
ORDER BY record_id DESC LIMIT {$limit} OFFSET ".$offset);
$statement->bindParam('category_id', $getCategoryId);
$statement->execute();
$results = $statement->fetchAll(PDO::FETCH_ASSOC);
If I remove try and catch block, it'll tell me exactly which line is giving the issue. So from the above code, the error has to do with "$statement->execute();". This is where the error occurs.
As far as I know, the above pdo statement is correct. Can you tell me if something is wrong with it?
Edited by helloworld001, 16 December 2014 - 04:14 PM. I have been pulling my hair out for the lasy 3 hours i am trying to update a MySql table but i cant get it too work, i just keep getting MySql error #1064 - You have an error in your SQL syntax; if i just update 1 field it works fine but if i try to update more than 1 field it dosent work, Help Please! <?php $root = $_SERVER['DOCUMENT_ROOT']; require("$root/include/mysqldb.php"); require("$root/include/incpost.php"); $con = mysql_connect("$dbhost","$dbuser","$dbpass"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("$dbame", $con); mysql_query("UPDATE Reg_Profile_p SET build='$build' col='$col' size='$size' WHERE uin = '$uinco'"); ?> Hi guys,
I am having a hard time trying to figure out why this gives me an error?
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10
/**
* Baobab (an implementation of Nested Set Model)
*
* Copyright 2010 Riccardo Attilio Galli <riccardo@sideralis.org> [http://www.sideralis.org]
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
/**
* .. note::
* Each occurrence of the word "GENERIC" across this file is meant to be
* replaced with the name of the tree (which must be a valid string to use
* as SQL table name).
*/
/* ############################### */
/* ###### TABLES AND VIEWS ####### */
/* ############################### */
CREATE TABLE IF NOT EXISTS GENERIC (
tree_id INTEGER UNSIGNED NOT NULL,
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
lft INTEGER NOT NULL CHECK (lft > 0),
rgt INTEGER NOT NULL CHECK (rgt > 1),
INDEX(tree_id),
INDEX(lft),
CONSTRAINT order_okay CHECK (lft < rgt)
) ENGINE INNODB;
DROP VIEW IF EXISTS GENERIC_AdjTree;
CREATE VIEW GENERIC_AdjTree (tree_id,parent,child,lft)
AS
SELECT E.tree_id,B.id, E.id, E.lft
FROM GENERIC AS E
LEFT OUTER JOIN GENERIC AS B
ON B.lft = ( SELECT MAX(lft)
FROM GENERIC AS S
WHERE E.lft > S.lft
AND E.lft < S.rgt
AND E.tree_id=S.tree_id)
AND B.tree_id=E.tree_id
ORDER BY lft ASC;
/* ##### LIST OF TREE NAMES IN USE ##### */
CREATE TABLE IF NOT EXISTS Baobab_ForestsNames (
name VARCHAR(200) PRIMARY KEY
) ENGINE INNODB DEFAULT CHARSET=utf8;
INSERT INTO Baobab_ForestsNames(name) VALUES ('GENERIC')
ON DUPLICATE KEY UPDATE name=name;
/* ##################################### */
/* ########################### */
/* ###### ERRORS CONTROL ##### */
/* ########################### */
CREATE TABLE IF NOT EXISTS Baobab_Errors (
code INTEGER UNSIGNED NOT NULL PRIMARY KEY,
name VARCHAR(50) NOT NULL,
msg TINYTEXT NOT NULL,
CONSTRAINT unique_codename UNIQUE (name)
) ENGINE INNODB;
INSERT INTO Baobab_Errors(code,name,msg)
VALUES
(1000,'VERSION','1.3.1'),
(1100,'ROOT_ERROR','Cannot add or move a node next to root'),
(1200,'CHILD_OF_YOURSELF_ERROR','Cannot move a node inside his own subtree'),
(1300,'INDEX_OUT_OF_RANGE','The index is out of range'),
(1400,'NODE_DOES_NOT_EXIST',"Node doesn't exist"),
(1500,'VERSION_NOT_MATCH',"The library and the sql schema have different versions")
ON DUPLICATE KEY UPDATE code=code,name=name,msg=msg;
DROP FUNCTION IF EXISTS Baobab_getErrCode;
CREATE FUNCTION Baobab_getErrCode(x TINYTEXT) RETURNS INT
DETERMINISTIC
RETURN (SELECT code from Baobab_Errors WHERE name=x);
/* ########################## */
/* ######## DROP TREE ####### */
/* ########################## */
DROP PROCEDURE IF EXISTS Baobab_GENERIC_DropTree;
CREATE PROCEDURE Baobab_GENERIC_DropTree (
IN node INTEGER UNSIGNED,
IN update_numbers INTEGER)
LANGUAGE SQL
DETERMINISTIC
MODIFIES SQL DATA
BEGIN
DECLARE drop_tree_id INTEGER UNSIGNED;
DECLARE drop_id INTEGER UNSIGNED;
DECLARE drop_lft INTEGER UNSIGNED;
DECLARE drop_rgt INTEGER UNSIGNED;
/*
declare exit handler for not found rollback;
declare exit handler for sqlexception rollback;
declare exit handler for sqlwarning rollback;
*/
/* save the dropped subtree data with a singleton SELECT */
START TRANSACTION;
/* save the dropped subtree data with a singleton SELECT */
SELECT tree_id, id, lft, rgt
INTO drop_tree_id, drop_id, drop_lft, drop_rgt
FROM GENERIC
WHERE id = node;
/* subtree deletion is easy */
DELETE FROM GENERIC
WHERE tree_id=drop_tree_id AND lft BETWEEN drop_lft and drop_rgt;
IF update_numbers = 1 THEN
/* close up the gap left by the subtree */
UPDATE GENERIC
SET lft = CASE WHEN lft > drop_lft
THEN lft - (drop_rgt - drop_lft + 1)
ELSE lft END,
rgt = CASE WHEN rgt > drop_lft
THEN rgt - (drop_rgt - drop_lft + 1)
ELSE rgt END
WHERE tree_id=drop_tree_id AND (lft > drop_lft OR rgt > drop_lft);
END IF;
COMMIT;
END;
/* ########################## */
/* ###### APPEND CHILD ###### */
/* ########################## */
/* Add a new child to a parent as last sibling
If parent_id is 0, insert a new root node, moving the
previous root (if any) as his child.
If choosen_tree is 0, use the first available integer as id.
If choosen_tree is not present as tree_id in the table, it is used.
*/
DROP PROCEDURE IF EXISTS Baobab_GENERIC_AppendChild;
CREATE PROCEDURE Baobab_GENERIC_AppendChild(
IN choosen_tree INTEGER UNSIGNED,
IN parent_id INTEGER UNSIGNED,
OUT new_id INTEGER UNSIGNED,
OUT cur_tree_id INTEGER UNSIGNED)
LANGUAGE SQL
DETERMINISTIC
BEGIN
DECLARE num INTEGER UNSIGNED;
START TRANSACTION;
SET cur_tree_id = IF(choosen_tree > 0,
choosen_tree,
IFNULL((SELECT MAX(tree_id)+1 FROM GENERIC),1)
);
IF parent_id = 0 THEN /* inserting a new root node*/
UPDATE GENERIC
SET lft = lft+1, rgt = rgt+1
WHERE tree_id=cur_tree_id;
SET num = IFNULL((SELECT MAX(rgt)+1 FROM GENERIC WHERE tree_id=cur_tree_id),2);
INSERT INTO GENERIC(tree_id, id, lft, rgt)
VALUES (cur_tree_id, NULL, 1, num);
ELSE /* append a new node as last right child of his parent */
SET num = (SELECT rgt
FROM GENERIC
WHERE id = parent_id
);
UPDATE GENERIC
SET lft = CASE WHEN lft > num
THEN lft + 2
ELSE lft END,
rgt = CASE WHEN rgt >= num
THEN rgt + 2
ELSE rgt END
WHERE tree_id=cur_tree_id AND rgt >= num;
INSERT INTO GENERIC(tree_id, id, lft, rgt)
VALUES (cur_tree_id,NULL, num, (num + 1));
END IF;
SELECT LAST_INSERT_ID() INTO new_id;
COMMIT;
END;
/* ############################### */
/* ###### INSERT NODE AFTER ###### */
/* ############################### */
DROP PROCEDURE IF EXISTS Baobab_GENERIC_insertAfter;
CREATE PROCEDURE Baobab_GENERIC_insertAfter(
IN sibling_id INTEGER UNSIGNED,
OUT new_id INTEGER UNSIGNED,
OUT error_code INTEGER UNSIGNED)
LANGUAGE SQL
DETERMINISTIC
main:BEGIN
IF 1 = (SELECT lft FROM GENERIC WHERE id = sibling_id) THEN
BEGIN
SELECT Baobab_getErrCode('ROOT_ERROR') INTO error_code;
LEAVE main;
END;
ELSE
BEGIN
DECLARE lft_sibling INTEGER UNSIGNED;
DECLARE choosen_tree INTEGER UNSIGNED;
START TRANSACTION;
SELECT tree_id,rgt
INTO choosen_tree,lft_sibling
FROM GENERIC
WHERE id = sibling_id;
IF ISNULL(lft_sibling) THEN
BEGIN
SELECT Baobab_getErrCode('NODE_DOES_NOT_EXIST') INTO error_code;
LEAVE main;
END;
END IF;
UPDATE GENERIC
SET lft = CASE WHEN lft < lft_sibling
THEN lft
ELSE lft + 2 END,
rgt = CASE WHEN rgt < lft_sibling
THEN rgt
ELSE rgt + 2 END
WHERE tree_id=choosen_tree AND rgt > lft_sibling;
INSERT INTO GENERIC(tree_id,id,lft,rgt)
VALUES (choosen_tree,NULL, (lft_sibling + 1),(lft_sibling + 2));
SELECT LAST_INSERT_ID() INTO new_id;
COMMIT;
END;
END IF;
END;
/* ################################ */
/* ###### INSERT NODE BEFORE ###### */
/* ################################ */
DROP PROCEDURE IF EXISTS Baobab_GENERIC_insertBefore;
CREATE PROCEDURE Baobab_GENERIC_insertBefore(
IN sibling_id INTEGER UNSIGNED,
OUT new_id INTEGER UNSIGNED,
OUT error_code INTEGER UNSIGNED)
LANGUAGE SQL
DETERMINISTIC
main:BEGIN
IF 1 = (SELECT lft FROM GENERIC WHERE id = sibling_id) THEN
BEGIN
SELECT Baobab_getErrCode('ROOT_ERROR') INTO error_code;
LEAVE main;
END;
ELSE
BEGIN
DECLARE rgt_sibling INTEGER UNSIGNED;
DECLARE choosen_tree INTEGER UNSIGNED;
START TRANSACTION;
SELECT tree_id,lft
INTO choosen_tree,rgt_sibling
FROM GENERIC
WHERE id = sibling_id;
IF ISNULL(rgt_sibling) THEN
BEGIN
SELECT Baobab_getErrCode('NODE_DOES_NOT_EXIST') INTO error_code;
LEAVE main;
END;
END IF;
UPDATE IGNORE GENERIC
SET lft = CASE WHEN lft < rgt_sibling
THEN lft
ELSE lft + 2 END,
rgt = CASE WHEN rgt < rgt_sibling
THEN rgt
ELSE rgt + 2 END
WHERE tree_id=choosen_tree AND rgt >= rgt_sibling
ORDER BY lft DESC; /* order by is meant to avoid uniqueness violation on update */
INSERT INTO GENERIC(tree_id,id,lft,rgt)
VALUES (choosen_tree,NULL, rgt_sibling, rgt_sibling + 1);
SELECT LAST_INSERT_ID() INTO new_id;
COMMIT;
END;
END IF;
END;
/* ################################### */
/* ###### INSERT CHILD AT INDEX ###### */
/* ################################### */
/* Add a new child to parent 'parent_id' at index 'index'.
index is the new child position, 0 will put the new node as first.
index can be negative, where -1 will put the new node before the last one
*/
DROP PROCEDURE IF EXISTS Baobab_GENERIC_InsertChildAtIndex;
CREATE PROCEDURE Baobab_GENERIC_InsertChildAtIndex(
IN parent_id INTEGER UNSIGNED,
IN idx INTEGER,
OUT new_id INTEGER UNSIGNED,
OUT error_code INTEGER UNSIGNED)
LANGUAGE SQL
DETERMINISTIC
BEGIN
DECLARE nth_child INTEGER UNSIGNED;
DECLARE cur_tree_id INTEGER UNSIGNED;
SET error_code=0;
SET new_id=0;
CALL Baobab_GENERIC_getNthChild(parent_id,idx,nth_child,error_code);
IF NOT error_code THEN
CALL Baobab_GENERIC_insertBefore(nth_child,new_id,error_code);
ELSE IF idx = 0 AND error_code = (SELECT Baobab_getErrCode('INDEX_OUT_OF_RANGE')) THEN
BEGIN
SET error_code = 0;
CALL Baobab_GENERIC_AppendChild((SELECT tree_id FROM GENERIC WHERE id = parent_id),
parent_id,
new_id,
cur_tree_id);
END;
END IF;
END IF;
END;
/* ########################### */
/* ###### GET NTH CHILD ###### */
/* ########################### */
DROP PROCEDURE IF EXISTS Baobab_GENERIC_getNthChild;
CREATE PROCEDURE Baobab_GENERIC_getNthChild(
IN parent_id INTEGER UNSIGNED,
IN idx INTEGER,
OUT nth_child INTEGER UNSIGNED,
OUT error_code INTEGER UNSIGNED)
LANGUAGE SQL
DETERMINISTIC
main:BEGIN
DECLARE num_children INTEGER;
SET error_code=0;
SELECT COUNT(*)
INTO num_children
FROM GENERIC_AdjTree WHERE parent = parent_id;
IF num_children = 0 OR IF(idx<0,(-idx)-1,idx) >= num_children THEN
/* idx is out of range */
BEGIN
SELECT Baobab_getErrCode('INDEX_OUT_OF_RANGE') INTO error_code;
LEAVE main;
END;
ELSE
SELECT child
INTO nth_child
FROM GENERIC_AdjTree as t1
WHERE (SELECT count(*) FROM GENERIC_AdjTree as t2
WHERE parent = parent_id AND t2.lft<=t1.lft AND t1.tree_id=t2.tree_id
)
= (CASE
WHEN idx >= 0
THEN idx+1
ELSE num_children+1+idx
END
)
LIMIT 1;
END IF;
END;
/* ###################################### */
/* ###### MOVE SUBTREE BEFORE NODE ###### */
/* ###################################### */
DROP PROCEDURE IF EXISTS Baobab_GENERIC_MoveSubtreeBefore;
CREATE PROCEDURE Baobab_GENERIC_MoveSubtreeBefore(
IN node_id_to_move INTEGER UNSIGNED,
IN reference_node INTEGER UNSIGNED,
OUT error_code INTEGER UNSIGNED)
LANGUAGE SQL
DETERMINISTIC
main:BEGIN
DECLARE node_revised INTEGER UNSIGNED;
DECLARE move_as_first_sibling BOOLEAN;
DECLARE ref_left INTEGER UNSIGNED;
DECLARE ref_node_tree INTEGER UNSIGNED;
SET error_code=0; /* 0 means no error */
SET move_as_first_sibling = TRUE;
SELECT tree_id,lft
INTO ref_node_tree,ref_left
FROM GENERIC WHERE id = reference_node;
IF ref_left = 1 THEN
BEGIN
/* cannot move a parent node before or after root */
SELECT Baobab_getErrCode('ROOT_ERROR') INTO error_code;
LEAVE main;
END;
END IF;
/* if reference_node is the first child of his parent, set node_revised
to the parent id, else set node_revised to NULL */
SET node_revised = ( SELECT id FROM GENERIC WHERE tree_id=ref_node_tree AND lft = -1+ ref_left);
IF ISNULL(node_revised) THEN /* if node_revised is NULL we must find the previous sibling */
BEGIN
SET node_revised= (SELECT id FROM GENERIC
WHERE tree_id=ref_node_tree AND rgt = -1 + ref_left);
SET move_as_first_sibling = FALSE;
END;
END IF;
CALL Baobab_GENERIC_MoveSubtree_real(
node_id_to_move, node_revised , move_as_first_sibling, error_code
);
END;
/* ##################################### */
/* ###### MOVE SUBTREE AFTER NODE ###### */
/* ##################################### */
DROP PROCEDURE IF EXISTS Baobab_GENERIC_MoveSubtreeAfter;
CREATE PROCEDURE Baobab_GENERIC_MoveSubtreeAfter(
IN node_id_to_move INTEGER UNSIGNED,
IN reference_node INTEGER UNSIGNED,
OUT error_code INTEGER UNSIGNED)
LANGUAGE SQL
DETERMINISTIC
BEGIN
SELECT 0 INTO error_code; /* 0 means no error */
CALL Baobab_GENERIC_MoveSubtree_real(
node_id_to_move,reference_node,FALSE,error_code
);
END;
/* ##################################### */
/* ####### MOVE SUBTREE AT INDEX ####### */
/* ##################################### */
DROP PROCEDURE IF EXISTS Baobab_GENERIC_MoveSubtreeAtIndex;
CREATE PROCEDURE Baobab_GENERIC_MoveSubtreeAtIndex(
IN node_id_to_move INTEGER UNSIGNED,
IN parent_id INTEGER UNSIGNED,
IN idx INTEGER,
OUT error_code INTEGER)
LANGUAGE SQL
DETERMINISTIC
main:BEGIN
DECLARE nth_child INTEGER UNSIGNED;
DECLARE num_children INTEGER;
DECLARE parent_of_node_to_move INTEGER UNSIGNED;
DECLARE s_lft INTEGER UNSIGNED;
DECLARE current_idx INTEGER;
SET error_code=0;
SELECT COUNT(*)
INTO num_children
FROM GENERIC_AdjTree WHERE parent = parent_id;
IF idx < 0 THEN
SET idx = num_children + idx;
ELSEIF idx > 0 THEN BEGIN
SELECT parent, lft
INTO parent_of_node_to_move, s_lft
FROM GENERIC_AdjTree WHERE child = node_id_to_move;
IF parent_of_node_to_move = parent_id THEN BEGIN
SELECT count(*)
INTO current_idx
FROM GENERIC_AdjTree
WHERE parent = parent_id AND lft < s_lft;
IF idx > current_idx THEN
SET idx = idx + 1;
END IF;
END;
END IF;
END;
END IF;
SET idx = IF(idx<0,num_children+idx,idx);
IF idx = 0 THEN /* moving as first child, special case */
CALL Baobab_GENERIC_MoveSubtree_real(node_id_to_move,parent_id,TRUE,error_code);
ELSE
BEGIN
/* search the node before idx, and we wil move our node after that */
CALL Baobab_GENERIC_getNthChild(parent_id,idx-1,nth_child,error_code);
IF NOT error_code THEN
CALL Baobab_GENERIC_MoveSubtree_real(node_id_to_move,nth_child,FALSE,error_code);
END IF;
END;
END IF;
END;
/* ####################################### */
/* ####### MOVE SUBTREE REAL LOGIC #######*/
/* ####################################### */
/* If move_as_first_sibling is FALSE, move node_id_to_move after reference_node,
else reference_node is the new father of node_id_to_move */
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_UNSIGNED_SUBTRACTION';
DROP PROCEDURE IF EXISTS Baobab_GENERIC_MoveSubtree_real;
CREATE PROCEDURE Baobab_GENERIC_MoveSubtree_real(
IN node_id_to_move INTEGER UNSIGNED,
IN reference_node INTEGER UNSIGNED,
IN move_as_first_sibling BOOLEAN,
OUT error_code INTEGER
)
LANGUAGE SQL
DETERMINISTIC
main:BEGIN
DECLARE s_lft INTEGER UNSIGNED;
DECLARE s_rgt INTEGER UNSIGNED;
DECLARE ref_lft INTEGER UNSIGNED;
DECLARE ref_rgt INTEGER UNSIGNED;
DECLARE source_node_tree INTEGER UNSIGNED;
DECLARE ref_node_tree INTEGER UNSIGNED;
DECLARE diff_when_inside_sourcetree BIGINT SIGNED;
DECLARE diff_when_next_sourcetree BIGINT SIGNED;
DECLARE ext_bound_1 INTEGER UNSIGNED;
DECLARE ext_bound_2 INTEGER UNSIGNED;
SET error_code=0;
START TRANSACTION;
/* select tree, left and right of the node to move */
SELECT tree_id,lft, rgt
INTO source_node_tree, s_lft, s_rgt
FROM GENERIC
WHERE id = node_id_to_move;
/* select left and right of the reference node
If moving as first sibling, ref_lft will become the new lft value of node_id_to_move,
(and ref_rgt is unused), else we're saving left and right value of soon to be
previous sibling
*/
SELECT tree_id, IF(move_as_first_sibling,lft+1,lft), rgt
INTO ref_node_tree, ref_lft, ref_rgt
FROM GENERIC
WHERE id = reference_node;
IF move_as_first_sibling = TRUE THEN
IF s_lft <= ref_lft AND s_rgt >= ref_rgt AND source_node_tree=ref_node_tree THEN
/* cannot move a parent node inside his own subtree */
BEGIN
SELECT Baobab_getErrCode('CHILD_OF_YOURSELF_ERROR') INTO error_code;
LEAVE main;
END;
ELSE
IF s_lft > ref_lft THEN BEGIN
SET diff_when_inside_sourcetree = -(s_lft-ref_lft);
SET diff_when_next_sourcetree = s_rgt-s_lft+1;
SET ext_bound_1 = ref_lft;
SET ext_bound_2 = s_lft-1;
END;
ELSEIF s_lft = ref_lft and source_node_tree = ref_node_tree THEN BEGIN
/* we have been asked to move a node to his same position */
LEAVE main;
END;
ELSE BEGIN
SET diff_when_inside_sourcetree = ref_lft-s_rgt-1;
SET diff_when_next_sourcetree = -(s_rgt-s_lft+1);
SET ext_bound_1 = s_rgt+1;
SET ext_bound_2 = ref_lft-1;
END;
END IF;
END IF;
ELSE /* moving after an existing child */
IF ref_lft = 1 THEN /* cannot move a node before or after root */
BEGIN
SELECT Baobab_getErrCode('ROOT_ERROR') INTO error_code;
LEAVE main;
END;
ELSEIF s_lft < ref_lft AND s_rgt > ref_rgt AND source_node_tree=ref_node_tree THEN
/* cannot move a parent node inside his own subtree */
BEGIN
SELECT Baobab_getErrCode('CHILD_OF_YOURSELF_ERROR') INTO error_code;
LEAVE main;
END;
ELSE
IF s_lft > ref_rgt THEN BEGIN
SET diff_when_inside_sourcetree = -(s_lft-ref_rgt-1);
SET diff_when_next_sourcetree = s_rgt-s_lft+1;
SET ext_bound_1 = ref_rgt+1;
SET ext_bound_2 = s_lft-1;
END;
ELSE BEGIN
SET diff_when_inside_sourcetree = ref_rgt-s_rgt;
SET diff_when_next_sourcetree = -(s_rgt-s_lft+1);
SET ext_bound_1 = s_rgt+1;
SET ext_bound_2 = ref_rgt;
END;
END IF;
END IF;
END IF;
IF source_node_tree <> ref_node_tree THEN
BEGIN
CALL Baobab_GENERIC_MoveSubtree_Different_Trees(
node_id_to_move,reference_node,move_as_first_sibling);
LEAVE main;
END;
END IF;
UPDATE GENERIC
SET lft =
lft + CASE
WHEN lft BETWEEN s_lft AND s_rgt
THEN diff_when_inside_sourcetree
WHEN lft BETWEEN ext_bound_1 AND ext_bound_2
THEN diff_when_next_sourcetree
ELSE 0 END
,
rgt =
rgt + CASE
WHEN rgt BETWEEN s_lft AND s_rgt
THEN diff_when_inside_sourcetree
WHEN rgt BETWEEN ext_bound_1 AND ext_bound_2
THEN diff_when_next_sourcetree
ELSE 0 END
WHERE tree_id=source_node_tree;
COMMIT;
END;
SET sql_mode=@OLD_SQL_MODE;
DROP PROCEDURE IF EXISTS Baobab_GENERIC_MoveSubtree_Different_Trees;
CREATE PROCEDURE Baobab_GENERIC_MoveSubtree_Different_Trees(
IN node_id_to_move INTEGER UNSIGNED,
IN reference_node INTEGER UNSIGNED,
IN move_as_first_sibling BOOLEAN
)
LANGUAGE SQL
DETERMINISTIC
main:BEGIN
DECLARE s_lft INTEGER UNSIGNED;
DECLARE s_rgt INTEGER UNSIGNED;
DECLARE ref_lft INTEGER UNSIGNED;
DECLARE ref_rgt INTEGER UNSIGNED;
DECLARE source_node_tree INTEGER UNSIGNED;
DECLARE ref_node_tree INTEGER UNSIGNED;
START TRANSACTION;
/* select tree, left and right of the node to move */
SELECT tree_id,lft, rgt
INTO source_node_tree, s_lft, s_rgt
FROM GENERIC
WHERE id = node_id_to_move;
/* The current select will behave differently whether we're moving
the node as first sibling or not.
If move_as_first_sibling,
ref_lft will have the value of the "lft" field of node_id_to_move at end
of move (ref_rgt here is discarded)
else
ref_lft and ref_rgt will have the values of the node before node_id_to_move
at end of move
*/
SELECT tree_id, IF(move_as_first_sibling,lft+1,lft), rgt
INTO ref_node_tree, ref_lft, ref_rgt
FROM GENERIC
WHERE id = reference_node;
IF (move_as_first_sibling) THEN BEGIN
/* create a gap in the destination tree to hold the subtree */
UPDATE GENERIC
SET lft = CASE WHEN lft < ref_lft
THEN lft
ELSE lft + s_rgt-s_lft+1 END,
rgt = CASE WHEN rgt < ref_lft
THEN rgt
ELSE rgt + s_rgt-s_lft+1 END
WHERE tree_id=ref_node_tree AND rgt >= ref_lft;
/* move the subtree to the new tree */
UPDATE GENERIC
SET lft = ref_lft + (lft-s_lft),
rgt = ref_lft + (rgt-s_lft),
tree_id = ref_node_tree
WHERE tree_id = source_node_tree AND lft >= s_lft AND rgt <= s_rgt;
END;
ELSE BEGIN
/* create a gap in the destination tree to hold the subtree */
UPDATE GENERIC
SET lft = CASE WHEN lft < ref_rgt
THEN lft
ELSE lft + s_rgt-s_lft+1 END,
rgt = CASE WHEN rgt <= ref_rgt
THEN rgt
ELSE rgt + s_rgt-s_lft+1 END
WHERE tree_id=ref_node_tree AND rgt > ref_rgt;
/* move the subtree to the new tree */
UPDATE GENERIC
SET lft = ref_rgt+1 + (lft-s_lft),
rgt = ref_rgt+1 + (rgt-s_lft),
tree_id = ref_node_tree
WHERE tree_id = source_node_tree AND lft >= s_lft AND rgt <= s_rgt;
END;
END IF;
/* close the gap in the source tree */
CALL Baobab_GENERIC_Close_Gaps(source_node_tree);
COMMIT;
END;
/* ########################## */
/* ####### CLOSE GAPS ####### */
/* ########################## */
DROP PROCEDURE IF EXISTS Baobab_GENERIC_Close_Gaps;
CREATE PROCEDURE Baobab_GENERIC_Close_Gaps(
IN choosen_tree INTEGER UNSIGNED)
LANGUAGE SQL
DETERMINISTIC
BEGIN
UPDATE GENERIC
SET lft = (SELECT COUNT(*)
FROM (
SELECT lft as seq_nbr FROM GENERIC WHERE tree_id=choosen_tree
UNION ALL
SELECT rgt FROM GENERIC WHERE tree_id=choosen_tree
) AS LftRgt
WHERE tree_id=choosen_tree AND seq_nbr <= lft
),
rgt = (SELECT COUNT(*)
FROM (
SELECT lft as seq_nbr FROM GENERIC WHERE tree_id=choosen_tree
UNION ALL
SELECT rgt FROM GENERIC WHERE tree_id=choosen_tree
) AS LftRgt
WHERE tree_id=choosen_tree AND seq_nbr <= rgt
)
WHERE tree_id=choosen_tree;
END
I'm getting the err msg Error . "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$sqry' at line 1 " while executing query from php5.3.5 but its working directly in mysql5.5.8 Help? I’ve just read several manual pages and forum comments on "Error number 1064" but I still don’t understand what’s going on with the problem I'm having now … Also, I'm surprised that the error message mentions two different line numbers (1 and 35). Here is the error message I get : And here are the contents of my "one_more_visit_to_topic.php" file :
<?php
include("includes/model/database_searches/see_readings.php");
include("includes/model/database_searches/see_watchings.php");
function one_more_visit_to_topic($user_id,$topic_id)
{
global $db;
$request_string='UPDATE forum_topic '.
'SET topic_vu = topic_vu + 1 WHERE topic_id = :topic';
$query=$db->prepare($request_string);
$query->bindValue(':topic',$topic_id,PDO::PARAM_INT);
$query->execute();
$query->CloseCursor();
// Remember that topic has been read by user
if(!(see_if_user_has_read_topic($user_id,$topic_id))) {
$request_string='INSERT INTO forum_read (fr_topic_id,fr_user_id) '.
'VALUES (:topic,:user)';
$query=$db->prepare($request_string);
$query->bindValue(':topic',$topic_id,PDO::PARAM_INT);
$query->bindValue(':user',$user_id,PDO::PARAM_INT);
$query->execute();
$query->CloseCursor();
}
// If user has already received a warning by mail,
// the "alert" value needs to be toggled in the fw_watch table
if(see_if_user_has_been_warned($user_id,$topic_id)) {
$request_string='UPDATE forum_read SET fw_alert = :alt '.
'WHERE fw_topic_id = :topic AND fw_user_id= :user)';
$query=$db->prepare($request_string);
$query->bindValue(':topic',$topic_id,PDO::PARAM_INT);
$query->bindValue(':user',$user_id,PDO::PARAM_INT);
$one=(int)1;
$query->bindValue(':alt',$one,PDO::PARAM_INT);
$query->execute();
$query->CloseCursor();
}
return;
}
?>
Hello, this script originally works by reading a physical copy of 'bans.txt' located in the same directory. How could I get it to read the remote bans.txt located here and parse info from it like the on-site copy? the remote file: http://108.163.211.219/bans.txt Code: [Select] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Data Tables and Cascading Style Sheets Gallery</title> <style>/* Tema: Soft Table - A Simple table style with the use of the soft brown color Author: Newton de G?es Horta Site: -- Country Origin: Brazil */ table { font-size:0.9em; font-family: Arial, Helvetica, verdana sans-serif; background-color:#fff; border-collapse: collapse; width: 100%; } caption { font-size: 25px; color: #1ba6b2; font-weight: bold; text-align: left; background: url(http://www.nghorta.com/csstg/header_bg.jpg) no-repeat top left; padding: 10px; margin-bottom: 2px; } thead th { border-right: 1px solid #fff; color:#fff; text-align:center; padding:2px; text-transform:uppercase; height:25px; background-color: #a3c159; font-weight: normal; } tfoot { color:#1ba6b2; padding:2px; text-transform:uppercase; font-size:1.2em; font-weigth: bold; margin-top:6px; border-top: 6px solid #e9f7f6; } tbody tr { background-color:#fff; border-bottom: 1px solid #f0f0f0; } tbody td { color:#414141; padding:5px; text-align:left; } tbody th { text-align:left; padding:2px; } tbody td a, tbody th a { color:#6C8C37; text-decoration:none; font-weight:normal; display:block; background: transparent url(http://www.nghorta.com/csstg/links_yellow.gif) no-repeat 0% 50%; padding-left:15px; } tbody td a:hover, tbody th a:hover { color:#009193; text-decoration:none; } /* tr:nth-child(even) { background-color: grey; } */ </style></head> <body> <table summary="Submitted table designs"> <thead><tr> <th style="font-size:12px" scope="col"><center>Nickname</center></th> <th style="font-size:12px" scope="col"><center>Admin</center></th> <th style="font-size:12px" scope="col"><center>Banned</center></th> <th style="font-size:12px" scope="col"><center>Reason</center></th> <th style="font-size:12px" scope="col"><center>SteamID</center></th> <th style="font-size:12px" scope="col"><center>Length</center></th> <th style="font-size:12px" scope="col"><center>Status</center></th> </tr></thead> <tbody> <!-- <tr><th scope="row" id="r100"><a href="100.php">rows table template</a></th> <td><a href="http://www.adobati.it">Omar '0m4r' Adobati</a></td><td>Italy</td> <td>Simple, clean and a quite classic table template :)</td> <td><a href="http://www.adobati.it/labs/CSSTable/0m4r.table.css" title="Download the rows table template CSS file">Download</a></td> <td>test</td> <td>test2</td> </tr> --> <?php // Credits to justin as he was able to understand my messy PHP code and do this much better code for me. function buildBanList($arr) { $filename = "bans.txt"; $bans = array(); $tmp_array = array(); // Build Ban Array if (file_exists($filename)) { foreach( $arr as $line ) { if( substr(trim($line), 0, 7) == '"STEAM_' ) { $tmp_array["user_steamid"] = str_replace('"', '', trim($line)); } if( substr(trim($line), 0, 6) == '"time"' ) { $tmp = explode(' ', trim($line)); $tmp_array["user_bantime"] = str_replace('"', '', $tmp[1]); } if( substr(trim($line), 0, 15) == '"modified_time"' ) { $tmp = explode(' ', trim($line)); $tmp_array["user_modified"] = str_replace('"', '', $tmp[1]); } if( substr(trim($line), 0, 7) == '"unban"' ) { $tmp = explode(' ', trim($line)); $tmp_array["user_unban"] = str_replace('"', '', $tmp[1]); } if( substr(trim($line), 0, 7) == '"admin"' ) { $tmp = explode('" "', trim($line)); $tmp2 = explode('(', $tmp[1]); $tmp_array["admin_name"] = str_replace('"', '', $tmp2[0]); } if( substr(trim($line), 0, 6) == '"name"' ) { $tmp = explode('" "', trim($line)); $tmp_array["user_name"] = str_replace('"', '', $tmp[1]); } if( substr(trim($line), 0, 8) == '"reason"' ) { $tmp = explode('" "', trim($line)); $tmp_array["user_reason"] = str_replace('"', '', $tmp[1]); } // Save ban record to main array once detected end. if( substr(trim($line), 0, 1) == '}' ) { // If console ban then set required fields. if( $tmp_array["admin_name"] == "") $tmp_array["admin_name"] = "Console"; array_push($bans, $tmp_array); $tmp_array = array(); } } } //Sort Array by Ban Date $tmp = array(); foreach($bans as &$ma) $tmp[] = &$ma["user_bantime"]; array_multisort($tmp, SORT_DESC, $bans); return $bans; } //Begin Presentation $file = file("./bans.txt"); date_default_timezone_set("Europe/London"); $bans = buildBanList($file); foreach ($bans as $ban) { echo '<tr> '; // Output if ($ban["user_name"] != '') echo '<td style="text-align:center; font-size: 12px">'.$ban["user_name"].'</td><td style="text-align:center; font-size: 12px" class="admin">'; else echo '<td style="text-align:center; font-size: 12px"><span style="color:#FF0000">N/A</span></td><td style="text-align:center; font-size: 12px" class="admin">'; echo $ban["admin_name"].'</td><td style="text-align:center; font-size: 12px">'.date('H:i - d/m/y',$ban["user_bantime"]).'</td>'; /* Unban date. if ($ban["user_unban"] != "0") { echo date('H:i - d/m/y',$ban["user_unban"]); } else { echo "Never"; }*/ echo '<td style="text-align:left; font-size: 11px">'.$ban["user_reason"].'</td>'; // Status $today = strtotime("now"); echo '</td><td style="text-align:center; font-size: 12px">'.$ban["user_steamid"].' </td>'; // Ban Length $date1 = date('y-m-d H:i:s',$ban["user_bantime"]); $date2 = date('y-m-d H:i:s',$ban["user_unban"]); $to_time=strtotime($date1); $from_time=strtotime($date2); $ban_length = round(abs($to_time - $from_time) / 60,0); if ($ban["user_unban"] != "0") { // Days if ($ban_length >= 1440) { $ban_length = round(abs($to_time - $from_time) / 24 / 60 / 60,0); // Years couldn't be arsed to think of another way to do it. if ( $ban_length >= 365 ) { $ban_length = round(abs($to_time - $from_time) / 360 / 24 / 60 / 60,0); if ($bans_length > 1) echo "<td style=\"text-align:center; font-size: 12px\">".$ban_length." Years </td>"; else echo "<td style=\"text-align:center; font-size: 12px\">".$ban_length." Year </td>"; } else echo "<td style=\"text-align:center; font-size: 12px\">".$ban_length." Days </td>"; } // Hours else if ($bans_length >= 60) { $ban_length = round(abs($to_time - $from_time) / 60 / 60,0); if ($bans_length > 1) echo "<td style=\"text-align:center; font-size: 12px\">".$ban_length." Hours </td>"; else echo "<td style=\"text-align:center; font-size: 12px\">".$ban_length." Hour </td>"; } else echo "<td style=\"text-align:center; font-size: 12px\">".$ban_length." Minutes </td>"; } else { echo "<td style=\"text-align:center; font-size: 12px\">Permanent</td>"; } if ($ban["user_unban"] == "0") echo '<td style="text-align:center; font-size: 12px"><span style="color:#FF0000">Banned</span></td>'; else if ( $today > $ban["user_unban"] ) echo '<td style="text-align:center; font-size: 12px"><span style="color:#008000">Expired</span></td>'; else echo '<td style="text-align:center; font-size: 12px"><span style="color:#FF0000">Banned</span></td>'; echo '</tr>'; } ?></table> <center><p>Web-based ULX bans by Russy.</p></center> </div> </body> </html> I've tried experimenting w/ stuff like Code: [Select] $filename = "http://108.163.211.219/bans.txt"; $contents = file_get_contents($filename); but it doesn't seem to want to work. Hello all. Here is my script... Code: [Select] if (isset($_POST['submit'])) { if (is_uploaded_file($_FILES['filename']['tmp_name'])) { echo "<h1>" . "File ". $_FILES['filename']['name'] ." uploaded successfully." . "<br></h1>"; echo "<h2>Displaying contents:</h2>"; readfile($_FILES['filename']['tmp_name']); echo "<br>"; echo $headers; } $handle = fopen($_FILES['filename']['tmp_name'], "r"); $header = fgetcsv($handle); while(! feof($handle)){ while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $import="INSERT into CSVtest($header[0],$header[1],$header[2],$header[3],$header[4]) values ('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]')"; mysql_query($import) or die(mysql_error()); } } fclose($handle); echo "Done"; } This is the way how I insert data into database according to header even it's not arranged same as the table column. If the csv has only "cell,firstname,lastname,," (and my table has only these 3 columns as well) then it still working...but if there are "cell,address,company,firstname,lastname" then it will show me unknown column error. Actually I wish to have a function that even there are many columns in csv that not exist in the table it still can just pick the right column and insert into table. Can anyone give me hints on how to change my script?I know there are many errors...it's really embarrassed to show my low standard script... Thanks in advance. Hi all, I'm developing a website and i need to upload a xml spreadsheet and see data at screen just to verify if it is correct. So far so good. But after the user see the data in the screen, he should be able to import that file to mssql. The problem is, in this second page where i show the data that the XML spreadsheet contains, i don't have the file location to submit the file again. How can i resolve this problem? Any ideas? Thanks in advance. Regards Howdy - good evening dear PHP-Friends, i am new to programming. I have a couple of (hundred) adress( and data ) lines that look like the following: {'url': 'http://Url.org/~dilbert/', 'cname': 'dibert_1', 'name': 'Dilbert_1', 'email': 'dilbert_1@ncf.ca'} {'url': 'http://Url.org/~dilbertwo/', 'cname': 'dilbert_2', 'name': 'Dilbert_2', 'email': 'dilbert_2@hotmail.com'} {'url': 'http://Url.org/~dilberthree/', 'cname': 'dilbert_3', 'name': ' Dilbert_3', 'email': 'dilbert_3@gmail.com'} and so forth.... Well - i want to put the data into the Thnderbird-Adressbook: But the adressbook does not take the data in this format. So what can i do with the data-set. How to Manipulate!? Note: At least a name and a E-Mail-Adress is needed. Nothing more - but - a Mail - Adress is pretty important. i look forward to hear from you if you have any further questions - jus t lemme know! include "connect.php"; if(isset($_POST['submit'])) { $filename=$_POST['filename']; $handle = fopen("$filename", "r"); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $import="UPDATE isc_products(prodavailability,prodinvtrack,prodcurrentinv) values('$data[1]','$data[2]','$data[3]') where vendor_id = '($data[0])' "; mysql_query($import) or die(mysql_error()); } fclose($handle); print "Import done"; } else { print "<form action='inv_update.php' method='post'>"; print "Type file name to import:<br>"; print "<input type='text' name='filename' size='20'><br>"; print "<input type='submit' name='submit' value='submit'></form>"; } ?> I am building this script to import some data via a csv that has three fields. The where statement gives me this error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(prodavailability,prodinvtrack,prodcurrentinv) values('35','1','35') where vendo' at line 1. I'm know my syntax is flawed but can't find a solution to this.... any one point me in the right direction? I know just enough php to get myself in trouble!! lol This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=330652.0 I think this is the right section to post this is in..... Anyway.....I'm building a web site that requires i have functionality to upload a tab delimited file (or some file format that is easiest) via php and insert the data into MYSQL. I've searched for many third party scripts but none seem to work. So I've decided to move to the community to see if someone can give me insight on how i might accomplish this script. I have some third party scripts but I'm not sure if they'd be of any use. Thank you kindly I have this script that is supposed to upload a csv file to a mysql database but I am getting the following error: Successfully uploaded. sending Data...The used command is not allowed with this MySQL version ERROR, could not add the CSV data to your database. Any help would be much appreciated. Thanks! Here is the code: <?php // error_reporting(E_ALL); include_once "config.inc"; $php_self = $_SERVER['PHP_SELF']; $file_open = 0; $page = "<center> <div align='center' style='border: 1px solid #000000; background-color: #000000;padding: 5px; color: #071bfd; width: 550px; font-family: verdana, arial, sans-serif;' > <table align='center' style='border: 1px solid #eff7c2; background-color: #e2feea;padding: 10px; color: #071bfd;' cellspacing=5><tbody> <tr><td style='background-color: #000000;padding: 5px'><u><b><h3><font color='#ffffff'><center>AGTC - CSV Upload Script v1.0a ©2006</center></font></h3></u></b></td></tr> <tr><td><span style=\"font-family: arial, sans-serif;\"><i><b>Instructions on use:</b></i> <br /> Before using this script please read the <a href='README.html'>README.html</a> file to check you have installed it correctly.<br /> Please make sure you are trying to upload a TXT or CSV file only with the extension .txt or .csv at the end of the file name. <br /> Do not exceed the maximum upload size of 2mb.<br /> You can create your files using MS-Excel or similar CSV creator.<br /><br /></td></tr> <tr><td style='background-color: #000000;padding: 5px'> <form enctype='multipart/form-data' action='$php_self' method='post' onSubmit='Alert()'> <input type='hidden' name='MAX_FILE_SIZE' value='2000000' /> <input type='hidden' name='option' value='yes' /> <font color='#ffffff' size='-1'>Locate CSV File: <br /></font><input name='csvfile' type='file' size='70' /> <br /> <center><input type='submit' value='Upload CSV File' /> </td></tr></tbody></table></div></center>"; if(!isset($_POST['option'])){ echo $page; } elseif($_POST['option'] == "yes"){ $uploaddir = './uploads/'; $uploadfile = $uploaddir . $_FILES['csvfile']['name']; if (move_uploaded_file($_FILES['csvfile']['tmp_name'], $uploadfile)) { print "<font face='arial'>Successfully uploaded. "; $notice = 1; chmod($uploadfile, 0777); } else { print "<font face='arial'>ERROR: Upload Failed. "; $notice = 0; } $notice = 1; if ($notice == 1) { echo "\n sending Data..."; flush(); echo "</font>"; if (file_exists($uploadfile)) { $fp = fopen($uploadfile, 'r') or die (" Cannot open the file"); $fileopen = 1; $length = calculate_length($uploadfile); } $replace = "REPLACE"; $field_terminater = ","; $enclose_option = 1; $enclosed = '"'; $escaped = '\\\\'; $line_terminator = 1; $local_option = 1; $sql_query = 'LOAD DATA'; if ($local_option == "1") { $sql_query .= ' LOCAL'; } $sql_query .= ' INFILE \'' . $uploadfile . '\''; if (!empty($replace)) { $sql_query .= ' ' . $replace; } $sql_query .= ' INTO TABLE ' . "`csv_test`"; if (isset($field_terminater)) { $sql_query .= ' FIELDS TERMINATED BY \'' . $field_terminater . '\''; } if (isset($enclose_option) && strlen($enclose_option) > 0) { $sql_query .= ' OPTIONALLY'; } if (strlen($enclosed) > 0) { $sql_query .= ' ENCLOSED BY \'' . $enclosed . '\''; } if (strlen($escaped) > 0) { $sql_query .= ' ESCAPED BY \'' . $escaped . '\''; } if (strlen($line_terminator) > 0){ $sql_query .= ' LINES TERMINATED BY \'' . '\n' . '\''; } $result = mysql_query ($sql_query); echo mysql_error() ; if(mysql_affected_rows() > 1) { echo " <div align=left><b><font color='#071bfd' face='arial'>The CSV data has been added to your database.<br><br> <a href='javascript:history.back()'><<< Return to CSV Upload Script</a></font></div> "; } else { error_log(mysql_error()); echo " <div align=left><b><font color='#e42127' face='arial' > ERROR, could not add the CSV data to your database.</font></div>"; } if ($file_open ==1) { fclose($fp) or die("ERROR: Could not close the file"); } } } function calculate_length($fp) { $length = 1000; $array = file($fp); for($i=0;$i<count($array);$i++) { if ($length < strlen($array[$i])) { $length = strlen($array[$i]); } } unset($array); return $length; } ?> <script language="Javascript"> function Alert() { var question = alert("Confirm this is a CSV file no more than 2mb in size!"); return question; } </script> Hey im agen stuck on code i get You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 but i think i have all correct if i submit i get values but that dont add in database Code: [Select] <?php //Values if(isset($_POST['Submit'])) { $request = preg_replace("/[^0-9a-zA-Z]/","",$_SERVER['REQUEST_URI']); $ip = preg_replace("/[^0-9a-zA-Z]/","",$_SERVER['REMOTE_ADDR']); $referer = preg_replace("/[^0-9a-zA-Z]/","",$_SERVER['HTTP_REFERER']); $agent = preg_replace("/[^0-9a-zA-Z]/","",$_SERVER['HTTP_USER_AGENT']); //Open connection include('connectx.php'); //Test is there connection available $query=("Select * from Error where date='NOW()'"); $result= mysql_query($query); $num=mysql_num_rows($result); //Add data $query=("INSERT INTO Error (id,request,ip,referer,date,agent) VALUES ('NULL','$request','$ip','$referer',NOW(),'$agent'"); if (@mysql_query($query)) { echo('<p>Error code has succesfuly send</p>'); } else { echo ("Error was in submiting code").mysql_error(); } mysql_close(); } ?>any help will become welcome Hey, was just writing rough code for a news feed script, and this error came up: Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 133693565 bytes) in /Applications/XAMPP/xamppfiles/htdocs/cameo/newsfeed.php on line 17 here's the code <?php require_once("vars.php"); //write the query to get the news feed info from the database $query = "SELECT * FROM news_feed"; $result = mysqli_query($dbc, $query); //create beginning tags for the news data table $output = "<table border=\"0\" cellspacing=\"0\" cellpadding=\"3\" name=\"news_data\">"; //display the news feed data $row = mysqli_fetch_array($result); while($row){ $output .= "<tr>" ."<td><h3>".$row['post_title']."</h3>" ."<br />Posted by: ".$row['posted_by']." on ".$row['date']."</td>" ."</tr>" ."<tr>" ."<td>".$row['post_body']."</td>" ."</tr>"; } $output .= "</table>"; echo $output; ?> and heres my vars file if needed <? //common session variables $username = $_SESSION['username']; $is_admin = $_SESSION['is_admin']; //database connection information variables $server = "localhost"; $user = "root"; $pass = ""; $db = "cameo"; //database function variables $dbc = mysqli_connect($server, $user, $pass, $db); //http header and script return variables $index = "/cameo/index.php"; $self = $_SERVER['PHP_SELF']; ?> Hey guys.. I'm new to the forum and have a quick question about some coding i've been doing for my website. A couple index errors are coming up when I run my code, but I believe it all should be working fine. I am going to paste the code, but also upload the files so that you can understand the problem better. ANY help is greatly appreciated. I am currently making a contact form with validation. I know that using ifempty() is probably the best way, but I am unclear as to how to use it. I have two files, an html containing my form, and a php file containing the following code: //Define Variables $FirstName = $_GET['FirstNameTextBox']; $LastName = $_GET['LastNameTextBox']; $PhoneNumber = $_GET['PhoneNumberTextBox']; $EmailAddress = $_GET['EmailAddressTextBox']; $Address = $_GET['AddressTextBox']; $City = $_GET['CityTextBox']; $State = $_GET['StateDropDownBox']; $Zip = $_GET['ZipTextBox']; $error1='*Please enter a First Name<br>'; $error2='*Please enter a Last Name<br>'; $error3='*Please enter a Phone Number<br>'; $error4='*Please choose a state<br>'; $error5='*Please enter a valid email address<br>'; $day2 = mktime(0,0,0,date("m"),date("d")+2,date("Y")); $day3 = mktime(0,0,0,date("m"),date("d")+3,date("Y")); $day7 = mktime(0,0,0,date("m"),date("d")+7,date("Y")); if($FirstName=="") {echo $error1; exit;} if($LastName=="") {echo $error2; exit;} if($PhoneNumber=="") {echo $error3; exit;} if($State=="") {echo $error4; exit;} if($EmailAddress=="") {echo $error5; exit;} if($State == "NY") { echo "$FirstName $LastName - we will get back to you within 2 days, ie before " .date("d M Y", $day2); exit; } if($State == "NJ") { echo "$FirstName $LastName - we will get back to you within 3 days, ie before " .date("d M Y", $day3); exit; } if($State == "Other") { echo "$FirstName $LastName - we will get back to you within 1 week, ie before " .date("d M Y", $day7); exit; } The following errors come up: Notice: Undefined index: FirstNameTextBox in C:\Users\Jonny P\Documents\My Web Sites\JMPMySite\AddContact.php on line 14 Notice: Undefined index: LastNameTextBox in C:\Users\Jonny P\Documents\My Web Sites\JMPMySite\AddContact.php on line 15 Notice: Undefined index: PhoneNumberTextBox in C:\Users\Jonny P\Documents\My Web Sites\JMPMySite\AddContact.php on line 16 Notice: Undefined index: EmailAddressTextBox in C:\Users\Jonny P\Documents\My Web Sites\JMPMySite\AddContact.php on line 17 Notice: Undefined index: AddressTextBox in C:\Users\Jonny P\Documents\My Web Sites\JMPMySite\AddContact.php on line 18 Notice: Undefined index: CityTextBox in C:\Users\Jonny P\Documents\My Web Sites\JMPMySite\AddContact.php on line 19 Notice: Undefined index: StateDropDownBox in C:\Users\Jonny P\Documents\My Web Sites\JMPMySite\AddContact.php on line 20 Notice: Undefined index: ZipTextBox in C:\Users\Jonny P\Documents\My Web Sites\JMPMySite\AddContact.php on line 21 *Please enter a First Name Again, ANY help is greatly appreciated.. it is for a class, but I have honestly exhasted all my sources to figure out what is wrong. Are my codes correct and all there? Thanks for the help! -WPN Hi, Im getting this error with my script that im using to try and echo content for my website: Parse error: syntax error, unexpected T_ECHO in /home/a9855336/public_html/test.php on line 16 my php code is <?php $host="mysql12.000webhost.com"; // Host name $username="a9855336_root"; // Mysql username $password="n4th4n%"; // Mysql password $db_name="a9855336_mail"; // Database name // Connect to server and select databse. mysql_connect($host, $username, $password); mysql_select_db($db_name); $query = "SELECT title, content, FROM members where ID = 1"; $result = mysql_query($query); $row = mysql_fetch_array($result) echo $row['title']; ?> html stuff <?php echo $row['content']; ?> If anyone can help me fix this problem or sugguest a dfiferent way to go about this it would be greatly appriciated. Thanks, Blink359 So when I execute this it'll go for about 130k rows then give a 500 error. Any ideas how to avoid this and get it to complete? Code: [Select] $i=10000000; while($i<=99999999) { $public = $i; $value = rand(10000000, 99999999); mysql_query("INSERT INTO yummy_table (public, value) VALUES('$public', '$value' ) ") or die(mysql_error()); $i++; } echo "done"; |
|||||||