Okay. I currently have code that works with the connection to the DB; however this mysql_query does not run for some reason. Can anyone point out my obvious error to me. I guess I have been looking at the code entirely too long.
Basically I am trying to batch the process so that I do not have to key 1200 entries.
The Database fields are setup using the following code:
I am also include an example of one of the entries.
CREATE TABLE database_preferences (
preference_owner int(11) NOT NULL default '0',
preference_app varchar(25) NOT NULL default '',
preference_value text NOT NULL,
PRIMARY KEY (preference_owner,preference_app)
) TYPE=MyISAM;
#
Dumping data for table database_preferences
#
INSERT INTO database_preferences (preference_owner, preference_app, preference_value) VALUES (11, 'email', 'a:23:{s:12:"account_name";s:8:"Fred Bob";s:9:"email_sig";s:8:"Fred Bob";s:15:"default_sorting";s:7:"new_old";s:6:"layout";s:1:"2";s:10:"icon_theme";s:5:"idots";s:9:"icon_size";s:2:"24";s:11:"button_type";s:4:"both";s:14:"show_addresses";s:4:"none";s:19:"mainscreen_showmail";s:1:"2";s:16:"use_trash_folder";s:4:"True";s:17:"trash_folder_name";s:5:"Trash";s:15:"use_sent_folder";s:4:"True";s:16:"sent_folder_name";s:4:"Sent";s:18:"addressbook_choice";s:4:"orig";s:25:"js_addressbook_screensize";s:3:"700";s:19:"use_custom_settings";s:4:"True";s:6:"userid";s:7:"fredbob";s:6:"passwd";s:4:"fred";s:7:"address";s:22:"fredbob@demo1.demo.com";s:11:"mail_server";s:14:"demo1.demo.com";s:16:"mail_server_type";s:4:"imap";s:16:"imap_server_type";s:5:"UWash";s:11:"mail_folder";s:4:"mail";}')
<?php
# Open connection to DB
#VARIABLES
$userid="fred"
$password="flinstone";
$first_name="fred";
$last_name="flinstone";
#NUMERICAL VARIABLES
$STRING1=(strlen($first_name)+strlen($last_name)+1);
$STRING2=strlen($userid);
$STRING3=strlen($password);
$STRING4=$STRING2 + 15;
mysql_query("INSERT INTO `database_preferences` ( `preference_owner` , `preference_app` , `preference_value` ) VALUES ('$ID_NUMBER', 'email', 'a:23:{s:12:"account_name";s:$STRING1:"$first_name $last_name";s:9:"email_sig";s:$STRING1:"$first_name $last_name";s:15:"default_sorting";s:7:"new_old";s:6:"layout";s:1:"2";s:10:"icon_theme";s:5:"idots";s:9:"icon_size";s:2:"24";s:11:"button_type";s:4:"both";s:14:"show_addresses";s:4:"none";s:19:"mainscreen_showmail";s:1:"2";s:16:"use_trash_folder";s:4:"True";s:17:"trash_folder_name";s:5:"Trash";s:15:"use_sent_folder";s:4:"True";s:16:"sent_folder_name";s:4:"Sent";s:18:"addressbook_choice";s:4:"orig";s:25:"js_addressbook_screensize";s:3:"700";s:19:"use_custom_settings";s:4:"True";s:6:"userid";s:$STRING2:"$userid";s:6:"passwd";s:$STRING3:"$password";s:7:"address";s:$STRING4:"$userid@demo1.demo.com";s:11:"mail_server";s:14:"demo1.demo.com";s:16:"mail_server_type";s:4:"imap";s:16:"imap_server_type";s:5:"UWash";s:11:"mail_folder";s:4:"mail";
}')");
#Close Connection to DB
?>
