chiba

August 31, 2012

I am new to Oracle and need to write a script to extract data from three tables.

The code below works and produces results. For every transaction in the transaction_table it produces a row with the customers details.

select
u.account_id,
u.currency_code,
u.country_of_residence_name,
t.bet_desc,
t.event_name,
t.amount,
t.settled_dt,
t.acc_stat_summ_id

from transaction_table t

inner join customer_details u
on t.account_id = u.account_id

where u.country_of_residence_name = 'Canada'
and t.bet_desc = 'Withdrawal'
and t.event_name = 'Bank Transfer'
and t.settled_dt> '01 Aug 2012'

But I need to link it to a further table , how can this be done? I tried he following but got no results.

select
u.account_id,
u.currency_code,
u.country_of_residence_name,
t.bet_desc,
t.event_name,
t.amount,
t.settled_dt,
t.acc_stat_summ_id

from transaction_table t

inner join customer_details u
on t.account_id = u.account_id


inner join bank_transfers b
on t.acc_stat_summ_id = b.bank_transfer_id

where u.country_of_residence_name = 'Canada'
and t.bet_desc = 'Withdrawal'
and t.event_name = 'Bank Transfer'
and t.settled_dt> '01 Aug 2012'

August 26, 2012

I solved it by adding

ob_start( ); to my init.php file.

August 25, 2012

Why am I getting this error message after I fill out the form and press submit? The data is entered correctly into the database, but the header doesn't work. :'(

Warning: Cannot modify header information - headers already sent by (output started at /home/content/27/9433527/html/site/includes/overall/header.php:3) in /home/content/27/9433527/html/site/register.php on line 69

<?php
include 'core/init.php';
include 'includes/overall/header.php';
if(empty($_POST)===false)
{
$required_fields = array('username','password','password_again','first_name','last_name','email');
foreach ($_POST as $key=>$value)
{
	if (empty($value) && in_array($key, $required_fields)===true)
	{
		//if one error is found then break out
		$errors[] = 'Fields marked with an asterisk are required';
		break 1;
	}
}
if(empty($errors)===true)
{
	// triple === type checks as well as the value
	if (user_exists($_POST['username']) ===true)
	{
		$errors[] = 'Sorry the username \''.htmlentities($_POST['username']) . '\' is already taken.';	
	}
	if (preg_match("/\\s/",$_POST['username']) == true)
	{

		$errors[] = 'Your username must not contain any spaces.';	
	}
	if (strlen($_POST['password']) < 6)
	{
		$errors[] = 'Your password must be at least 6 characters';
	}
	if ($_POST['password'] !== $_POST['password_again'])
	{
		$errors[] = 'Your passwords do not match';	
	}
	if (filter_var($_POST['email'],FILTER_VALIDATE_EMAIL)===false)
	{
		$errors[] = 'A valid email address is required';

	}
	if (email_exists($_POST['email'])===true)
	{
		$errors[] = 'Sorry the email \'' .$_POST['email'] . '\' is already in use';
	}
}
}
?>
<h1>Register</h1>
<?php
if (isset($_GET['sucess']) && empty($_GET['sucess']))
{
echo 'You\'ve been registered sucessfully.';
}
else
{
	if (empty($_POST) === false && empty($errors)===true)
	{
		$register_data = array(
			'username' => $_POST['username'],
			'password' => $_POST['password'],
			'first_name' => $_POST['first_name'],
			'last_name' => $_POST['last_name'],
			'email' => $_POST['email']
		);
		register_user($register_data);
		header('Location: register.php?sucess');
		exit();
	}
	else if (empty($errors) === false)
	{
		echo output_errors($errors);	
	}
?>
<p>Please fill out the form below to register an account.</p>
<form action="" method="post">
	<ul>
		<li>
		Username*:<br />
		<input type="text" name="username">
		</li>
		<li>
		Password*<br />
		<input type="password" name="password">
		</li>
		<li>
		Password again*<br />
		<input type="password" name="password_again">
		</li>
		<li>
		First Name*:<br />
		<input type="text" name="first_name">
		</li>
		<li>
		Last Name*:<br />
		<input type="text" name="last_name">
		</li>
		<li>
		Email address*:<br />
		<input type="text" name="email">
		</li>
		<li>
		<input type="submit" value="Register">
		</li>
	</ul>
</form>
<?php
}
include 'includes/overall/footer.php'; 
?>

July 29, 2012

Cheers

July 29, 2012

Can someone explain why this table sits outside of the div?

<?PHP
mysql_connect('mickey','mouse', 'donald');
mysql_select_db('duck');

$sql = mysql_query("SELECT * FROM Links");

$limit = 1;
$count = 0;
$output = "";

echo "<table border='1'>";

while ($row = mysql_fetch_array($sql))
{
$Name = $row['Name'];
$Description = $row['Description'];
$Link = $row['Link'];
if ($count < $limit)
{
	if ($count ==0)
	{
		$output .=  "<tr>";
	}
	// Title
	$output .= "<td>Site name</td><td>Category</td>";

}
else
{
	$count = 0;
	$output .= "</tr><tr><td><a href='$Link'>$Name</a></td><td>$Description</td>";
}
$count++;
}
$output .= "</tr></table>";
?>

<body>
<div id="page">

<?php include("include_header.php"); ?>

<div id="mainContainer">
<?php include("include_menu.php"); ?>

<div id="main">
<h2>Links</h2>

<p>The contents of the table below are held in a MySQL database and the table is rendered dynamically when the page is loaded.</p>
<?php echo $output ?>
<p>Table</p>
<div class="clear">

</div><!--main end-->
<div class="clear">
</div>
</div><!--mainContainer end-->
<div class="clear">
</div>

<?php include("include_footer.php"); ?>

</body>
</html>

#page
{
margin-right:auto;
margin-left:auto;
width:900px;
/*height:590px;*/
height:auto;
}

#header
{
width:900px;
height:80px;
}

#mainContainer
{
margin-top:5px;
margin-left:auto;
margin-right:auto;
background-color:#6e6e6e;
-moz-border-radius: 5px;
border-radius: 5px;
width:890px;
/*height:700px;*/
height:auto;
padding:5px;
overflow:hidden;
}
#main
{
background-color:#FFFFFF;
-moz-border-radius: 5px;
border-radius: 5px;
width:736px;
/*height:695px;*/
height:auto;
margin:0 auto;
float:right;
/*overflow: auto;*/
padding-left:5px;
border: 2px solid #000; 
overflow:hidden;
}
#menu
{
background-color:#FFFFFF;
-moz-border-radius: 5px;
border-radius: 5px;
width:135px;
/*height:695px;*/
height:100%;
float: left;
padding-left:5px;
padding-bottom:5px;
border: 2px solid #000;
}
#footer
{
width:890px;
height:60px;
background-color:#6e6e6e;
-moz-border-radius: 5px;
border-radius: 5px;
margin-top:5px;
padding:5px;
}
#footerContent
{
background-color:#FFFFFF;
-moz-border-radius: 5px;
border-radius: 5px;
width:886px;
height:56px;
text-align:center;
border: 2px solid #000;
}

July 16, 2012

So it's better to have a php page for each of my pages; index.php, about.php, photos.php,... and have header.php, footer.php, menu.php for common parts of all pages?

July 16, 2012

Hi all,

I have built a site where the pages are stored on a mysql database and there is one index.php file that all the page data is loaded into. Is this a good way of building a site. Each page in the database is only HTML content. I understand that I cannot put php or javascript into the database, is this correct?

:confused:

Sign In

chiba

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by chiba

Help writing an Oracle script to join three tabels

Warning: Cannot modify header information

Warning: Cannot modify header information

PHP Query sits outside of main div

PHP Query sits outside of main div

Different ways of building a site HTML, PHP, MySQL+PHP,...

Different ways of building a site HTML, PHP, MySQL+PHP,...

Browse

Activity

Important Information