Tripic

July 16, 2010

ok first things first heres the var dump from my controller

array(2) { ["title"]=> string(13) "My Blog Title" [0]=> array(4) { ["title"]=> string(4) "Test" ["body"]=> string(5) "Test1" ["date"]=> string(19) "0000-00-00 00:00:00" ["author"]=> string(1) "1" } }

heres the error i get when i try to go through the view file

A PHP Error was encountered

Severity: Warning

Message: preg_match() [function.preg-match]: Compilation failed: nothing to repeat at offset 2

Filename: libraries/Parser.php

Line Number: 161

the code for the cotroller

<?php

class Blog extends Controller {

function Blog(){

parent::Controller();

//$this->load->scaffolding('blog_entries');

}

function index(){

$this->load->helper('html');

$this->load->library('parser');

$this->load->library('ion_auth');

$data ['title'] = "My Blog Title";

$dbdata ['query'] = $this->db->get('blog_entries');

foreach($dbdata['query']->result() as $row) { $data[] = array('title' => $row->title, 'body' => $row->body, 'date' => $row->date, 'author' => $row->author); }

// var_dump($data);

$this->parser->parse('blog_view', $data);

}

?>

the code for the view file

<head>

<?

echo link_tag('awesomewinds.css');

$this->load->helper('url');

?>

<? echo $title ?>

</head>

<body>

<tr>

<td>

<tr>

</tr>

<tr>

</tr>

<tr>

<tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</td>

</div></td>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td>

<tr>

</tr>

</table>

</td>

</tr>

<tr>

</tr>

</table>

</td>

</tr>

</table>

</td>

</tr>

</table>

</td>

</tr>

</table>

</body>

March 9, 2010

oddly enough it was pointed out to me that i had a typo for userinfo_id killed the whole thing

March 8, 2010

Im not sure if it will work but it does in c++ try changing +1 to ++

March 8, 2010

Hello. Today I was about to create something like small login script. So, I made a script and its sucesfully working, BUT. The file that should NOT be able to access with instantly typing in address bar link, opens like it doesn't reqs login. So can anybody script me something for that? Thanks.

what do you mean redirect if your just trying to get the login script to redirect to a new page try using the header function but if its a login script i would assume your sending failures to one url and sucessful logins to another

March 8, 2010

Ok the $query is defined in the first code i put up i think but here it is anyways i am using a new one now but if you think this was better i have it backed up my new one is below it doesnt work

$query="INSERT INTO users (user_id, user_name, user_pass, user_type, Member_Since)VALUES ('NULL','".$user_username."','".$user_pass."','".$user_type."','NULL')";	$queryb="INSERT INTO user_info (user_infoid, user_first_name, user_last_name, user_street_address, user_state, user_zip, user_phone, user_fax, user_email_address, user_city, user_apartment_number)VALUES ('NULL','".$user_first_name."','".$user_last_name."','".$user_street."','".$user_state."','".$user_zip."','".$user_phone."','".$user_fax."','".$user_email."','".$user_city."','".$user_apt."')";

yes i need the id from users to post in user info and i rewrote the code but it is still only posting to users and not user_info I will post my new code and upload the file as well i cant figure out where im going wrong

<?php


$user_email = $_POST['user_email']; 
$user_emailv = $_POST['user_emailv'];
$user_pass = $_POST['user_passv'];
$user_passv = $_POST['user_pass'];
$user_first_name = $_POST['user_first_name'];
$user_last_name = $_POST['user_last_name'];
$user_street = $_POST['user_street_address'];
$user_apt = $_POST['user_apartment_number'];
$user_city = $_POST['user_city'];
$user_state = $_POST['user_state'];
$user_zip = $_POST['user_zip'];
$user_phone = $_POST['user_phone'];
$user_fax = $_POST['user_fax'];
$user_username = $_POST['user_esername'];
$user_type = $_POST['type'];
?>
<?php
if($user_email != $user_emailv){ 
	echo 'Verification Email  does not match Email Please Use your Browsers Back button to fix this ';
	return;
}
if($user_pass != $user_passv){
	echo 'Your passwords Do not match Please Use your Browsers Back button to fix this ';
	return;
}
?>


<?php require_once('Connections/live.php'); 
$live;
mysql_select_db ($database_live);
// Insert Data into User Table of database
mysql_query("INSERT INTO users (user_id, user_name, user_pass, user_type, Member_Since)VALUES ('NULL','".$user_username."','".$user_pass."','".$user_type."','NULL');");
// End of User Table Insert 
$id = mysql_insert_id();//Get the id of the last record inserted to the database 
// Insert Data into User Information Table of database 
mysql_query("INSERT INTO user_info (user_infoid, user_first_name, user_last_name, user_street_address, user_state, user_zip, user_phone, user_fax, user_email_address, user_city, user_apartment_number, user_id)VALUES ('NULL','".$user_first_name."','".$user_last_name."','".$user_street."','".$user_state."','".$user_zip."','".$user_phone."','".$user_fax."','".$user_email."','".$user_city."','".$user_apt."','".$id."');");
// End of User Information Table Insert
mysql_close();
header("location: ./index.php");
?>

[attachment deleted by admin]

March 8, 2010

Ok here goes I cleaned up my code some what still not the best in the world but easier to understand i think the first table post fine but nothing post to the second table at all the first table is users the second is user_info any ideahs or sugestions are greatley apreciated

<?php


$user_email = $_POST['user_email']; 
$user_emailv = $_POST['user_emailv'];
$user_pass = $_POST['user_passv'];
$user_passv = $_POST['user_pass'];
$user_first_name = $_POST['user_first_name'];
$user_last_name = $_POST['user_last_name'];
$user_street = $_POST['user_street_address'];
$user_apt = $_POST['user_apartment_number'];
$user_city = $_POST['user_city'];
$user_state = $_POST['user_state'];
$user_zip = $_POST['user_zip'];
$user_phone = $_POST['user_phone'];
$user_fax = $_POST['user_fax'];
$user_username = $_POST['user_esername'];
$user_type = $_POST['type'];
?>
<?php
if($user_email != $user_emailv){ 
	echo 'Verification Email  does not match Email Please Use your Browsers Back button to fix this ';
	return;
}
if($user_pass != $user_passv){
	echo 'Your passwords Do not match Please Use your Browsers Back button to fix this ';
	return;
}
?>


<?php require_once('Connections/live.php'); 
$live;
mysql_select_db ($database_live);
// Insert Data into User Table of database
mysql_query("INSERT INTO users (user_id, user_name, user_pass, user_type, Member_Since)VALUES ('NULL','".$user_username."','".$user_pass."','".$user_type."','NULL');");
// End of User Table Insert 
$id = mysql_insert_id();//Get the id of the last record inserted to the database 
// Insert Data into User Information Table of database 
mysql_query("INSERT INTO user_info (user_infoid, user_first_name, user_last_name, user_street_address, user_state, user_zip, user_phone, user_fax, user_email_address, user_city, user_apartment_number, user_id)VALUES ('NULL','".$user_first_name."','".$user_last_name."','".$user_street."','".$user_state."','".$user_zip."','".$user_phone."','".$user_fax."','".$user_email."','".$user_city."','".$user_apt."','".$id."');");
// End of User Information Table Insert
mysql_close();
header("location: ./index.php");
?>

March 8, 2010

HAve you checked your database to make sure the corosponding id exist I have had a problem with that before when i kept playing with my table and then deleting it then when i went to setup the dynamic page the first 12 ids where used up and deleted

March 8, 2010

Ok I tried that but now its not adding anything to the database at all I know im missing something really stupid here but i cant figure out whati am missing i have atached 3 files live.php is the conection file i know theres no pass its not ready for publication im working on it on a linux server isetup on my network createemployee.php is the actual form that the data comes from and createemp.php is the file that should be doing what i want it to but i cant seem to get it to work. Ohh and thanks for the return; ideah i should have known that but for some reason compleley forgot about it guess thats what happens after 5 years of no real programing

[attachment deleted by admin]

March 8, 2010

Ok this is my lates attempt but now its not posting anything at all prior to this if i tried to run one then use mysql close(); it would only run the first of the 2 i cant figure out where i am going wrong Please help

if  ($user_email == $user_emailv){
if ($user_pass == $user_passv){
$live;
mysql_select_db ($database_live);
$sql ="INSERT INTO users (user_id, user_name, user_pass, user_type, Member_Since)VALUES ('NULL','".$user_username."','".$user_pass."','".$user_type."','NULL')";
if( isset($user_first_name) )
{
  #  get the user id  
  $user_id = mysql_insert_id( $conn );
$sql .="INSERT INTO user_info (user_infoid, user_first_name, user_last_name, user_street_address, user_state, user_zip, user_phone, user_fax, user_email_address, user_city, user_apartment_number, user_id)VALUES ('NULL','".$user_first_name."','".$user_last_name."','".$user_street."','".$user_state."','".$user_zip."','".$user_phone."','".$user_fax."','".$user_email."','".$user_city."','".$user_apt."','".$user_id."')";
  $result = mysql_query( $sql,$conn );
}
mysql_free_result( $result );	

mysql_close();

echo "Did it work";
}
else{
echo "Your passwords do not match";
}
}
else{
echo "Your email adreeses do not match";
}
?>

March 8, 2010

Ok So heres what i am trying to do. I am creating a system that will have four diferent user groups each usergroup will have there own sign up page. Now the USer login information for each group will all go under one table users but the rest of the information for each group will go to a different table for each group for example

username
userid
userpassword
usertype

will all go into user table while userfirstname etc goes into table user_info for some reason i cant seem to get my insert statment to write to both at the same time can anyone tell me what im doing wrong

<?php require_once('Connections/live.php'); ?>
<?php
$user_email = $_POST['user_email']; 
$user_emailv = $_POST['user_emailv'];
$user_pass = $_POST['user_passv'];
$user_passv = $_POST['user_pass'];
$user_first_name = $_POST['user_first_name'];
$user_last_name = $_POST['user_last_name'];
$user_street = $_POST['user_street_address'];
$user_apt = $_POST['user_apartment_number'];
$user_city = $_POST['user_city'];
$user_state = $_POST['user_state'];
$user_zip = $_POST['user_zip'];
$user_phone = $_POST['user_phone'];
$user_fax = $_POST['user_fax'];
$user_username = $_POST['user_esername'];
$user_type = $_POST['type'];
?>
<?php
if  ($user_email == $user_emailv){
if ($user_pass == $user_passv){
$live;
mysql_select_db ($database_live);
$query="INSERT INTO users (user_id, user_name, user_pass, user_type, Member_Since)VALUES ('NULL','".$user_username."','".$user_pass."','".$user_type."','NULL')";
$queryb="INSERT INTO user_info (user_infoid, user_first_name, user_last_name, user_street_address, user_state, user_zip, user_phone, user_fax, user_email_address, user_city, user_apartment_number)VALUES ('NULL','".$user_first_name."','".$user_last_name."','".$user_street."','".$user_state."','".$user_zip."','".$user_phone."','".$user_fax."','".$user_email."','".$user_city."','".$user_apt."')";
mysql_query($query) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_query($queryb) or trigger_error(mysql_error(),E_USER_ERROR);
echo "Did it work";
}
else{
echo "Your passwords do not match";
}
}
else{
echo "Your email adreeses do not match";
}
?>

January 29, 2007

this isnt resolved

January 28, 2007

ok right now its poping up the module name for each menu item so the module name keeps coming up over and over i only want it to sho up once hers a pic so you can see what its doing now
[URL=http://img236.imageshack.us/my.php?image=example1nm4.jpg][IMG]http://img236.imageshack.us/img236/5189/example1nm4.th.jpg[/img][/URL]

heres the modified vertion of your code that i adapted to get it to work like this
[code]
<?php require_once('../Connections/TEst.php'); ?>
<?php
mysql_select_db($database_TEst, $TEst);
?>
<?php
// connect to db.
$sql = "
SELECT
brg_modules.Module_Name AS mname,
brg_menu.title AS cname,
brg_menu.icon AS cimg,
brg_menu.url AS curl
FROM
brg_modules,brg_menu
WHERE
brg_modules.id = brg_menu.module;";

if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
$mname = '';
while ($row = mysql_fetch_assoc($result)) {
if ($row['mname'] != $mname) {
$mname = $row['mname'];
$cname = $row['cname'];
$curl = $row['curl'];
echo "<table><tr><td>$mname</td></tr>";
}
echo "<tr><td><ahref='$curl'>$cname</a></td></tr><tr><td> </td></tr></table>";
}
}
} else {
echo "Query failed ".mysql_error();
}
?>[/code]

January 28, 2007

Cool i will give this a shot i think i know what to do for the tables its just getting the header got each module to only list once each and get the menu links to list all of the recors that are a child to the module above it

January 28, 2007

How are you aproaching this is it all on one page ie you select apple from the drop down box and it populates the feilds so you can edit and update or do you have a list some place with the items where you click on the item name ie lick on apples and it brings you to a page to edit apples. Im just a bit lost here is your problem populating the drop down box or poulating the fields after you have chosen what you want to edit

January 28, 2007

Ok so heres the problem and im still fairley new to php.
Im trying to build a completley dynamic menu system for my website using two tables
thae parent table being Modules and the child table being menu basically what i want to do
is for evry module that is set to be a menu and on the side of the page i tell it to it creates a table as follows
[table]
[tr][td]Module Name[/td][/tr]
[tr][td]$menu here[/td][/tr]
[tr][td][/td][/tr][/table]

now basically I want it to take each module and create that table to where it has the module name ie. Header at
the top of the table and all menu items that are a child to that module in the second row . then i want th single blank row just for style purpouse before it moves on to do the same thing with the next module. Im assuming the best way to do this is with an array and all though i have a basic understanding of what the array does i havent got a clue how to use it and reading the php bible to figure it out is just confusing me so im hoping some one can show me a simple example that i can work off of or if im wrong and going about this all wrong smack me around a bit and get me set strait. any help is greatley apreciated.. Tripic

Sign In

Tripic

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by Tripic

[CI] preg_match() error

Problems Inserting to multiple tables

'next' button

Redirect is site is instantly entered [:S]

Problems Inserting to multiple tables

How can I write a php mysql page the will post to more then one table

Dynamic Page

How can I write a php mysql page the will post to more then one table

How can I write a php mysql page the will post to more then one table

Problems Inserting to multiple tables

[SOLVED] Dynamic Menu

[SOLVED] Dynamic Menu

[SOLVED] Dynamic Menu

Dynamically choosing menu field

[SOLVED] Dynamic Menu

Browse

Activity

Important Information