Learn VBA & Macros in 1 Week!

PHP - Phpchart And Mysql Goes Wrong

Full Excel VBA Course - Beginner to Expert

Phpchart And Mysql Goes Wrong	View Content

Newbie here, would love some help to find out what I'm doing wrong on this code. I'm using phpChart to make a graph. This is my code, but the graph does not appear.

<?php
require_once("phpChart_Lite/conf.php");
include 'connection.php';
?>
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>phpChart - Basic Chart</title>
</head>
<body>
    
<?php

$query = mysqli_query($con, "SELECT krl FROM diesel WHERE sted = 'Borgeskogen' ORDER BY dato ASC");
	    
// set array
$price = array();

// look through query
while($row = mysqli_fetch_assoc($query)){

  // add each row returned into an array
  $price[] = $row['krl'];
}

//$pc = new C_PhpChartX(array(array(11, 9, 5, 12, 14)),'basic_chart');			
$pc = new C_PhpChartX(array($price),'basic_chart');			
$pc->set_animate(true);
$pc->draw();


?>

</body>
</html>

Full Excel VBA Course - Beginner to Expert

What I Am Doing Wrong? Mysql Num Row Error

Similar Tutorials

View Content

Hi guys

I have a code where users can login, I have checked all the database fields, variables etc and they are all correct. I have the code below and I will appreciate it if you help me to see what is wrong?

Code: [Select]
<?php

// Turn off all error reporting
error_reporting(0);

// Report simple running errors
error_reporting(E_ERROR | E_WARNING | E_PARSE);

// Reporting E_NOTICE can be good too (to report uninitialized
// variables or catch variable name misspellings ...)
error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);

// Report all errors except E_NOTICE
// This is the default value set in php.ini
error_reporting(E_ALL ^ E_NOTICE);

// Report all PHP errors (see changelog)
error_reporting(E_ALL);

// Report all PHP errors
error_reporting(-1);

// Same as error_reporting(E_ALL);
ini_set('error_reporting', E_ALL);

?>
<?php include'includes/db/db.php'; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>JSA Dashboard - Login</title>
<link href="styles/layout.css" rel="stylesheet" type="text/css" />
<link href="styles/login.css" rel="stylesheet" type="text/css" />

<link href="themes/blue/styles.css" rel="stylesheet" type="text/css" />


</head>
<body>

<div id="logincontainer">
<?php
$session_email = $_SESSION['email'];
if ($_POST['login'])
{
$email=mysql_real_escape_string(strip_tags($_POST['email']));
$enteredpassword=mysql_real_escape_string(strip_tags($_POST['password']));

if(!$email || !$enteredpassword) {echo "<div class='status error'><p class='closestatus'><a href='' title='Close'>x</a></p>Please enter both email and password, this message appears when you have not entered your email or password to login!</div>";}

   else
   {
$password=md5($enteredpassword);
$getuser=mysql_query("SELECT * FROM users WHERE $email='email'");
while($row = mysql_fetch_array($getuser))
{
$dbemail=$row['email'];
$dbpassword=$row['password'];
}
if (mysql_num_rows($getuser)==0)
{echo "<div class='status error'><p class='closestatus'><a href='' title='Close'>x</a></p>This user doesn't exist</div>";}

else

{

if ($dbpassword !=$password){echo "<div class='status error'><p class='closestatus'><a href='' title='Close'>x</a></p>Password is incorrect!</div>";}

else

{
    $_SESSION['email']=$email; //assign session
           header("Location: main.php"); //refresh
}

}




   }

}

?>
<div id="loginbox">
<div id="loginheader">
<img src="themes/blue/img/cp_logo_login.png" alt="Control Panel Login" />
</div>
<div id="innerlogin">
<form action="" name="login" method='POST'>
<p>Enter your Email:</p>
<input type="text" class="logininput" name="email"/>
<p>Enter your password:</p>
<input type="password" class="logininput" name="password"/>

<input type="submit" class="loginbtn" value="Login" name="login"/><br />

</form>
</div>
</div>
<img src="img/login_fade.png" alt="Fade" />
</div>
</body>
</html>

Mysql Wrong Error?

Similar Tutorials

View Content

hello, if im inserting to database from form, im getting an error, but it is correctly entering the data. any ideas?

Code: [Select]
<?php
include 'config.php';

$query = mysql_query("INSERT INTO jobNO (
`ID` ,
`jobNO` ,
`companyID`
)
VALUES (
NULL,
'$_POST[jobNO]',
'$_POST[companyID]'
)");

mysql_query($query) or die('Error, insert query failed');

echo "1 record added";

?>

What I Am Doing Wrong? Mysql Error

Similar Tutorials

View Content

Hi guys

I am doinga login form for an organization, this form has email, password and pin

If user fills all the fields it will execute the query fine but if user doesnt enter the pin it will come up with an error, the issue is that this pin is not included anywhere in mysql_query I have. Query tries to get the company id from db and echo it out,

so if I dont enter the pin I get the error I have echoes out and another system error which is
Quote

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ..../Dashboard/index.php on line 35

and my line 35 is

while($row=mysql_fetch_array($getpin)){

here is my code

Code: [Select]
<?php include ('includes/db/db.php'); ?>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
<title>Login | Careers Inbox Dashboard Admin</title>

<link rel="stylesheet" href="./css/reset.css" type="text/css" media="screen" title="no title" />
<link rel="stylesheet" href="./css/text.css" type="text/css" media="screen" title="no title" />
<link rel="stylesheet" href="./css/form.css" type="text/css" media="screen" title="no title" />
<link rel="stylesheet" href="./css/buttons.css" type="text/css" media="screen" title="no title" />
<link rel="stylesheet" href="./css/login.css" type="text/css" media="screen" title="no title" />

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /></head>

<body>

<div id="login">
<h1>Dashboard</h1>
<?php
if (isset($_POST['login']) && $_POST['login']){

$email=addslashes(strip_tags($_POST['email']));
$in_password=addslashes(strip_tags($_POST['password']));
$pin=addslashes(strip_tags($_POST['pin']));

$password=md5($in_password);

if (!$email || !$in_password || !$pin) echo "<div class='error'>Please fill all required fields</div>";
else
$getpin=mysql_query("SELECT * FROM users WHERE UserEmail='$email' AND UserPassword='$password'");
while($row=mysql_fetch_array($getpin)){
$pin_email=$row['UserEmail '];
$pin_id=$row['UserId'];
$pin_company_id=$row['company_id'];
}
echo "$pin_company_id";

}

?>

<div id="login_panel">
<form action="" method="post" accept-charset="utf-8" />
<div class="login_fields">
<div class="field">
<label for="email">Email</label>
<input type="text" name="email" value="" id="email" tabindex="1" placeholder="email@example.com" />
</div>

<div class="field">
<label for="password">Password <small><a href="forgotpassword.php">Forgot Password?</a></small></label>
<input type="password" name="password" value="" id="password" tabindex="2" placeholder="password" />
<div class="field">
<label for="pin">Pin Number</small></label><input type="password" name="pin" value="" id="password" tabindex="2" placeholder="pin"/>
</div>
</div>
</div> 

<div class="login_actions">
<input type="submit" name="login" value="Login" class="btn btn-grey"/>

</div>
</form>
</div> 
</div> 

</body>

</html>
thank you in advance.

Am I Doing Something Wrong? Php Retreaving From Mysql

Similar Tutorials

View Content

hello

i have a script that send a checkbox to the database, if it is checked it is sent to mysql as a 1 and not checked sent as 0, but when the info is sent the 1 for checked is sent to title and title is sent to ingredients and etc... these are the scripts

add_recipie.php
<?php
// Start_session, check if user is logged in or not, and connect to the database all in one included file
include_once("scripts/checkuserlog.php");
// Include the class files for auto making links out of full URLs and for Time Ago date formatting
include_once("wi_class_files/autoMakeLinks.php");
include_once ("wi_class_files/agoTimeFormat.php");
// Create the two objects before we can use them below in this script
$activeLinkObject = new autoActiveLink;
$myObject = new convertToAgo;
?>
<?php
// Include this script for random member display on home page
include_once "scripts/homePage_randomMembers.php";
?>
<?php
$sql_blabs = mysql_query("SELECT id, mem_id, the_blab, blab_date FROM blabbing ORDER BY blab_date DESC LIMIT 30");

$blabberDisplayList = ""; // Initialize the variable here

while($row = mysql_fetch_array($sql_blabs)){

$blabid = $row["id"];

$uid = $row["mem_id"];

$the_blab = $row["the_blab"];

$notokinarray = array("fag", "gay", "shit", "fuck", "stupid", "idiot", "asshole", "cunt", "douche");
$okinarray = array("sorcerer", "grey", "shug", "farg", "smart", "awesome guy", "asshole", "cake", "dude");

$the_blab = str_replace($notokinarray, $okinarray, $the_blab);

$the_blab = ($activeLinkObject -> makeActiveLink($the_blab));

$blab_date = $row["blab_date"];

$convertedTime = ($myObject -> convert_datetime($blab_date));
$whenBlab = ($myObject -> makeAgo($convertedTime));

//$blab_date = strftime("%b %d, %Y %I:%M:%S %p", strtotime($blab_date));

// Inner sql query

$sql_mem_data = mysql_query("SELECT id, username, firstname, lastname FROM myMembers WHERE id='$uid' LIMIT 1");

while($row = mysql_fetch_array($sql_mem_data)){

$uid = $row["id"];

$username = $row["username"];

$firstname = $row["firstname"];

if ($firstname != "") {$username = $firstname; } // (I added usernames late in my system, this line is not needed for you)

/////// Mechanism to Display Pic. See if they have uploaded a pic or not //////////////////////////

$ucheck_pic = "members/$uid/image01.jpg";

$udefault_pic = "members/0/image01.jpg";

if (file_exists($ucheck_pic)) {

$blabber_pic = '<div style="overflow:hidden; width:40px; height:40px;"><img src="' . $ucheck_pic . '" width="40px" border="0" /></div>'; // forces picture to be 100px wide and no more

} else {

$blabber_pic = "<img src=\"$udefault_pic\" width=\"40px\" height=\"40px\" border=\"0\" />"; // forces default picture to be 100px wide and no more

}

$blabberDisplayList .= '

<table width="100%" align="center" cellpadding="4" bgcolor="#CCCCCC">
        <tr>
          <td width="7%" bgcolor="#FFFFFF" valign="top"><a href="profile.php?id=' . $uid . '">' . $blabber_pic . '</a>
          </td>
          <td width="93%" bgcolor="#EFEFEF" style="line-height:1.5em;" valign="top"><span class="greenColor textsize10">' . $whenBlab . ' <a href="profile.php?id=' . $uid . '">' . $username . '</a> said: </span><br />
          ' . $the_blab . '</td>
        </tr>
      </table>';

}

}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
    <meta name="Description" content="Web Intersect is a deft combination of powerful free open source software for social networking, mixed with insider guidance and tutorials as to how it is made at its core for maximum adaptability. The goal is to give you a free website system that has a network or community integrated into it to allow people to join and interact with your website when you have the need." />
    <meta name="Keywords" content="web intersect, how to build community, build social network, how to build website, learn free online, php and mysql, internet crossroads, directory, friend, business, update, profile, connect, all, website, blog, social network, connecting people, youtube, myspace, facebook, twitter, dynamic, portal, community, technical, expert, professional, personal, find, school, build, join, combine, marketing, optimization, spider, search, engine, seo, script" />
    <title>CookBookers</title>
    <link href="style/main.css" rel="stylesheet" type="text/css" />
    <link rel="icon" href="favicon.ico" type="image/x-icon" />
    <link rel="shortcut icon" href="favicon.ico" type="image/x-icon" />
    <script src="js/jquery-1.4.2.js" type="text/javascript"></script>
<style type="text/css">
#Layer1 {

height:210px;

}
.style3 {font-size: 24px}
body {

background-color: #3c60a4;
}
</style>
</head>
<body>
<p>
  <?php include_once "header_template.php"; ?>
  </head>
  <body
style="margin:0px;">
  <center>
</p>
<table border="0" align="center" cellpadding="0" cellspacing="0" class="mainBodyTable">
  <tr>
    <td width="235" valign="top">

    <td width="665" colspan="2" align="left" valign="top" style="background-color:#EFEFEF; border:#999 0px; padding:10px;">
<table border="0" cellpadding="6">
                <tr>
                  <td>
                     <form method="POST" action="include/recipe.php">
                              <table cellpadding="0px" border="0" align="left" cellspacing="5px" style="font-size:14px;">
                                <tr>

<td><span class="style3">Add New Recipie:</span><br /></td>

  <tr>
                                  <td><h4 style="margin-bottom:5px; color:brown;">Public:</h4>
                                      <input name="Pub" value="0" type="checkbox" id="Pub" value="checkbox" />
                                </td>
                                </tr>
                                <tr>
                                  <td><h4 style="margin-bottom:5px; color:brown;">Title: </h4>
                                  <input type="text" name="title"></td>
                                </tr>
                                <tr>
                                  <td><h4 style="margin-bottom:5px; color:brown;">Makes: </h4>
                                  <input type="text" name="make"></td>
                                </tr>
                                <tr>
                                  <td><h4 style="margin-bottom:5px; color:brown;">Ingrediants: </h4>
                                  <textarea rows="10" name="ingr" cols="40"></textarea><br></td>
                                </tr>
                                <tr>
                                  <td><h4 style="margin-bottom:5px; color:brown;">Method: </h4>
                                  <textarea rows="10" name="desc" cols="40"></textarea></td>
                                </tr>
                                <tr>
                                  <td><h4 style="margin-bottom:5px; color:brown;">Notes: </h4>
                                  <textarea rows="10" name="note" cols="40"></textarea></td>
                                </tr>
                                <tr>
                                  <td><input type="submit" value="Submit" style="padding:5px 10px;"></td>
                                </tr>
                              </table>
                     </form>

</td>

</tr>

  </table>
  </tr>
</table>
            </td>
</tr>
        </table>

<?php include_once "footer_template.php"; ?>
</body>

insert recipie
<?php
//include("session.php");
include("database.php");
@session_start();

$user = $_SESSION['username'];

//die($user);

$Pub=$_POST['Pub'];
    $title=$_POST['title'];
    $make=$_POST['make'];
    $ingr=$_POST['ingr'];
    $desc=$_POST['desc'];
    $note=$_POST['note'];
    //if($user=="Guest"||$user==""){
    //header("Location: ../index.php");
    //}
    //else{
    $database->AddRecipe($user,$Pub,$title,$make,$ingr,$desc,$note);
    header("Location: ../add_recipie.php");
    //}
?>

Help With Mysql Update Query...cant See What The Heck Is Going Wrong.

Similar Tutorials

View Content

Ok, I'm going start off simple. If I have to provide more code I will.

I am doing an update on a table called countries. Yet my query just will not update the db. Is there anything wrong with this query?

mysql_query("UPDATE countries SET country_id = '{$_POST['update_value']}' WHERE country_id = '{$_POST['original_html']}'") or die(mysql_error());

Mysql Insert Prepared Statement - Whats Wrong?

Similar Tutorials

View Content

Hi, Im just having some trouble with this...maybe a fresh pair of eyes can help?

Im getting a "Warning: mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of elements in type definition string doesn't match number of bind variables" error when I try run this:

Code: [Select]
$date = date("Y-m-d");
$header = $_POST['header'];
$summary = $_POST['summary'];
$content = $_POST['content'];

$query = "INSERT INTO articles (pubdate, title, summary, content) VALUES(?, ?, ?, ?)";
$stmt = $mysqli->stmt_init();

if ($stmt->prepare($query)){

$stmt->bind_param('i,s,s,s', $date, $header, $summary, $content);

$stmt->execute();
$stmt->close();
}
else {
echo "ERROR: SQL statement failure!";
echo "<a href='addnews.php'> -> OK</a>";
}
$mysqli->close();

It looks fine to me, just can't see whats wrong lol!

Please Look At This Code And See What I Am Doing Wrong. It's About Adding And Displaying A Record Using Php , Mysql And Ajax.

Similar Tutorials

View Content

All I am trying to do is add a record on a page without the page refreshing. For that ajax is used. Here is the code. It does not add the record to mysql table. Can anyone tell me what I am doing wrong? record.php

<!DOCTYPE HTML>
<html lang="en"> 
	<head>
		<script type="text/javascript" src="js/jquery-1.11.0.min.js"></script>
		<script type="text/javascript" >
			$(function() {
				$(".submit_button").click(function() {
					var textcontent = $("#content").val();
					var name = $("#name").val();
					var dataString = 'content='+ textcontent + '&name='+name;
					if(textcontent=='')
					{
						alert("Enter some text..");
						$("#content").focus();
					}
					else
					{
						$("#flash").show();
						$("#flash").fadeIn(400).html('<span class="load">Loading..</span>');
						$.ajax({
							type: "POST",
							url: "action.php",
							data: dataString,
							cache: true,
							success: function(html){
								$("#show").after(html);
								document.getElementById('content').value='';
								$("#flash").hide();
								$("#content").focus();
							}  
						});
					}
					return false;
				});
			});
		</script>
	</head>
	<body>
	<?php
		$record_id = $_GET['id']; // getting ID of current page record 
	?>
	
		<form action="" method="post" enctype="multipart/form-data">
			<div class="field">
				<label for="title">Name *</label>
				<input type="text" name="name" id="name" value="" maxlength="20" placeholder="Your name">
			</div>
			<div class="field">
				<label for="content">content *</label>
				<textarea id="content" name="content" maxlength="500" placeholder="Details..."></textarea>
			</div>
			<input type="submit" name="submit" value="submit" class="submit_button">
		</form>
		<div id="flash"></div>
		<div id="show"></div>
		
	</body>
</html>

action.php

if(isset($_POST['submit'])) {
	if(empty($_POST['name']) || empty($_POST['content'])) {
		
		$error = 'Please fill in the required fields!';
		
	} else {
		try {
			
			$name		= 	trim($_POST['name']);
			$content 	= 	trim($_POST['content']);
					
			$stmt = $db->prepare("INSERT INTO records(record_id, name, content) 
				VALUES(:recordid, :name, :content");
			$stmt->execute(array(
				'recordid'		=> $record_id,
				'name'			=> $name,
				'content' 		=> $content
			));
			
			if(!$stmt){
			
				$error = 'Please fill in the required fields.';
				
			} else {
			
				$success = 'Your post has been submitted.';
			
			}
			
		} catch(Exception $e) {
			die($e->getMessage());
		}
	}
}

User Signup Is Inserting To Mysql But The Passwords Coming Up Wrong, Any Advice?

Similar Tutorials

View Content

Hi there I have a problem here, I think I may know what it is but just wanted some guidance on this issue.

I took the logic from a previous help from the people on this forum and here is my landing page:

<?php
// ini_set("display_errors", 1);

// randomly starts a session!

session_name("jeremyBasicLogin");
session_start();

if(isset($_SESSION['username'])) {

// display whatever when the user is logged in:

echo <<<ADDENTRY

<html>
<head>
<title>User is now signed in:<title>
</head>

<body>
<h1>You are now signed in!</h1>
<p>You can do now what you want to do!</p>
</body>
</html>
ADDENTRY;

} else {
// If anything else dont allow access and send back to original page!

header("location: signin.php");

}
?>

This is where the user goes to when they go to this system (not a functional system, ie it doesnt actually do anything its more for my own theory.

As you wont have a session on the first turn to this page it goes to:

signin.php which contains:
<?php
// ini_set("display_errors", 1);

require_once('func.db.connect.php');

if(array_key_exists('submit',$_POST)) {

dbConnect(); // connect to database anyways!

// Do a procedure to log the user in:

// Santize User Inputs
$username = trim(stripslashes(mysql_real_escape_string($_POST['username']))); // cleans up with PHP first!
$password = trim(stripslashes(mysql_real_escape_string(md5($_POST['password'])))); // cleans up with PHP first!

$sql = "SELECT * FROM users WHERE username='$username' AND password='$password'";
$result = mysql_query($sql);

if(mysql_num_rows($result) == 1) {

session_name("jeremyBasicLogin");
session_start();
$_SESSION['is_logged_in'] = true;
$_SESSION['username'] = $username;
//print_r($_SESSION); // debug purposes only!
$_SESSION['time_loggedin'] = time(); // this is adding to the array (have seen the output in the SESSION vars!

// call function to update the time stamp in MySQL?

header("location: index.php");

} else if(mysql_num_rows($result) != 1) {
$message = "You typed the wrong password or Username Please retry!";
}
} else {
$message = "";
}
// displays the login page:
echo <<<LOGIN
<html>
<body>
<h1>Example Login</h1>

<form id="login" name="login" action="{$_SERVER['PHP_SELF']}" method="post">
<label for="username">Username: </label><input type="text" id="username" name="username" value="" /><br>
<label for="password">Password: </label><input type="text" id="password" name="password" value="" /><br>
<input type="submit" id="submit" name="submit" value="Login" />
</form>
LOGIN;
echo "<p>" . $message . "</p>";
echo <<<LOGIN

<p>Please Login to View and Edit Your Entries</p>
<p><a href="register.php">Click Here To Signup</a><p>
</body>
</html>
LOGIN;
?>

This checks through user inputs and hopefully logs them in, when Ive inserted the data into the database itself it works, if I try and login but if a user fills in this form:

signup.php:

<?php
//ini_set("display_errors", 1);

$message ='';

require_once('func.db.connect.php');

if(array_key_exists('submit',$_POST)) {

dbConnect(); // connect to database anyways!

// do some safe protecting of the users variables, apply it to all details!
$username = trim(stripslashes(mysql_real_escape_string($_POST['username']))); // cleans up with PHP first!
$email = trim(stripslashes(mysql_real_escape_string($_POST['email']))); // cleans up with PHP first!
$password = trim(stripslashes(mysql_real_escape_string(md5($_POST['password'])))); // does as above but also encrypts it using the md5 function!
$password2 = trim(stripslashes(mysql_real_escape_string(md5($_POST['password2'])))); // does as above but also encrypts it using the md5 function!

if($username != '' && $email != '' && $password != '' && $password2 != '') {
// do whatever when not = to nothing/empty fields!

if($password === $password2) {
// do database stuff to enter users details

$sql = "INSERT INTO `test`.`users` (`id` ,`username` ,`password`) VALUES ('' , '$username', MD5( '$password' ));";
$result = mysql_query($sql);
if($result) {
$message = 'You may now login by clicking <a href="index.php">here</a>';
}

} else {
// echo out a user message says they got their 2 passwords incorrectly typed:
$message = 'Pleae re enter your password';
}

} else {
// they where obviously where empty
$message = 'You missed out some required fields, please try again';
}

}

echo <<<REGISTER

<html>
<body>
<h1>Register Form</h1>
<p>Please fill in this form to register</p>
<form id="register" name="register" action="{$_SERVER['PHP_SELF']}" method="post">

<table>
<tr>
<td><label for="username">Username: </label></td>
<td><input type="text" id="username" name="username" value="" /></td>
</tr>

<tr>
<td><label for="email">Email: </label></td>
<td><input type="text" id="email" name="email" value="" /></td>
</tr>

<tr>
<td><label for="password">Password: </label></td>
<td><input type="text" id="password" name="password" value="" /></td>
</tr>

<tr>
<td><label for="password">Confirm Password: </label></td>
<td><input type="text" id="password2" name="password2" value="" /></td>
</tr>

<tr>
<td><input type="submit" id="submit" name="submit" value="Register" /></td>
</tr>

<table>

REGISTER;
echo "<p>" . $message . "</p>";
echo <<<REGISTER

</form>
</body>
</html>
REGISTER;
?>

As I said when the user signs up when submitting the above form, it doesnt work, keeps coming up with a different value for the password, so I am about 99% certain its the password, but I have been maticulous about copying in the sanitize function for SQL injections and it just doesnt still work, really puzzled now.

Any helps appreciated,
Jeremy.

Wrong Echo Or Wrong Query?

Similar Tutorials

View Content

I am querying...

$sql = "SELECT `messages_inbox`.`message_id`, `users`.`firstname`, `users`.`lastname`, `users`.`username` AS `from`, '${user_info['username']}' AS `to`, `subject`, LENGTH(`files`) AS `len`, 'inbox' AS `box`, DATE_FORMAT(`messages_inbox`.`time` ,'%T %D-%M-%Y') AS `time` ";

$sql .= "FROM `messages_inbox` INNER JOIN `users` ON `messages_inbox`.`from_id` = `users`.`id` WHERE `to_id` = ${user_info['uid']} AND `messages_inbox`.`deleted` = 0 ORDER BY `messages_inbox`.`message_id` DESC";

and I am trying to output

$displayName = ucwords("${message['firstname']} ${message['lastname']}");

by using

$messages = pm_fetch_all($_GET['box']);

I know my fetch works but for some reason firstname and lastname are only returning the logged in users first name and last name, not the person who sent the message.

Change Database From Mysql 4 To Mysql 5 Affects My Calendar Event Page

Similar Tutorials

View Content

Show Me A Way To Convert Mysql Table To Pdf Or Text Document When User Click Download Button Mysql Procedural

Similar Tutorials

View Content

create table mimi (mimiId int(11) not null, mimiBody varchar(255) );
<?php
//connecting to database
include_once ('conn.php');
$sql ="SELECT mimiId, mimiBody FROM mimi";

$result = mysqli_query($conn, $sql );

$mimi = mysqli_fetch_assoc($result);

$mimiId ='<span>No: '.$mimi['mimiId'].'</span>';

$mimiBody ='<p class="leading text-justify">'.$mimi['mimiBody'].'</p>';
?>
//what is next?

i want to download pdf or text document after clicking button or link how to do that

What Is Wrong???????

Similar Tutorials

View Content

Here is code I have, I can't seem to figure this error out, I bet it is obvious, but I clearly am not seeing it..... Here is error:
Problem with the query:
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 3

(not really that good of an error, but maybe help getting started?)

Code: [Select]
<?php
session_start(); // Must start session first thing
/*
Created By Adam Khoury @ www.flashbuilding.com
-----------------------June 20, 2008-----------------------
*/
// Here we run a login check
if (!isset($_SESSION['id'])) {
   echo 'Please <a href="login.php">log in</a> to access your account';
   exit();
}
//Connect to the database through our include
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$userid = $_SESSION['id'];
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$name = $row["name"];
$phone = $row["phone"];
$username = $row["username"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
$accounttype = $row["accounttype"];
$rank = $row["rank"];
$badges = $row["badges"];
}
// Set error message as blank upon arrival to page
$errorMsg = "";
// First we check to see if the form has been submitted
if (isset($_POST['name'])){
$name = ereg_replace("[^A-Z a-z0-9]", "", $_POST['name']); // filter everything but numbers and letters
$phone = ereg_replace("[^A-Z a-z0-9]", "", $_POST['phone']); // filter everything but spaces, numbers, and letters
$username = ereg_replace("[^A-Z a-z0-9]", "", $_POST['username']); // filter everything but spaces, numbers, and letters
$address = ereg_replace("[^A-Z a-z0-9]", "", $_POST['address']); // filter everything but spaces, numbers, and letters
$city = ereg_replace("[^A-Za-z0-9]", "", $_POST['city']); // filter everything but lowercase letters
$state = ereg_replace("[^A-Za-z0-9]", "", $_POST['state']); // filter everything but lowercase letters
$zip = ereg_replace("[^A-Za-z0-9]", "", $_POST['zip']); // filter everything but lowercase letters
$cell = ereg_replace("[^A-Za-z0-9]", "", $_POST['cell']); // filter everything but lowercase letters
$accounttype = ereg_replace("[^A-Z a-z0-9]", "", $_POST['accounttype']); // filter everything but lowercase letters
$email = stripslashes($_POST['email']);
$email = strip_tags($email);
$email = mysql_real_escape_string($email);
$password = ereg_replace("[^A-Za-z0-9]", "", $_POST['password']); // filter everything but numbers and letters
// Check to see if the user filled all fields with
// the "Required"(*) symbol next to them in the join form
// and print out to them what they have forgotten to put in
if((!$name) || (!$username) || (!$password)){

$errorMsg = "You did not submit the following required information!<br /><br />";
if(!$name){
$errorMsg .= "--- Name";
} else if(!$username){
    $errorMsg .= "--- Username";
   } else if(!$Password){
       $errorMsg .= "--- Password";
   }
} else {
// Database duplicate Fields Check
$sql_username_check = mysql_query("SELECT userid FROM members WHERE username='$username' LIMIT 1");
$username_check = mysql_num_rows($sql_username_check);
if ($username_check > 0){
$errorMsg = "<u>ERROR:</u><br />Your User Name is already in use inside our system. Please try another.";
} else {
// Add MD5 Hash to the password variable
       $hashedPass = md5($password);
// Add user info into the database table, claim your fields then values
$sql = mysql_query("INSERT INTO members (name, phone, username, address, city, state, zip, cell, email, accounttype, password )

VALUES('$name','$phone','$username','$address','$city','$state','$zip','$cell','$email','$accounttype','$hashedPass'") or die ("Problem with the query: $sql<br>" . mysql_error());
printf("Records updated: %d\n", mysql_affected_rows());
echo mysql_error();

echo '<meta HTTP-EQUIV="REFRESH" content="3; url=http://final.net46.net/success.php">';

exit(); // Exit so the form and page does not display, just this success message
} // Close else after database duplicate field value checks
  } // Close else after missing vars check
//Close if $_POST
}

?>

Don't Know What's Wrong

Similar Tutorials

View Content

Hello all,
I'm having trouble with the following code, it's supposed to go like this, you search for a hotel, choose a room, then it takes you to confirmation page before the paypal, but the problem is, in the confirmation page, it shows everything right, the number of nights, the number of guests, all except the number of rooms, it always give me 0 rooms

It's seperated into 3 files, hotelsmanager.php, bookingmanager.php, and book.php

here are the codes

Code: [Select]
while($row = @mysql_fetch_array($result))
{
echo "<tr>";
echo "<td class=\"text\" align=center>".$row['room_type']."</td>";
echo "<td class=\"text\" align=center>".$row['price_per_day']."</td>";
echo "<td class=\"text\" align=center>".$row['people']." People</td>";
echo "<td class=\"text\" align=center>";

?>

<select name="nrooms" id="nrooms" onchange="
//alert('<?php echo $row['id'] ; ?>');
//alert(this.value);
var exist = 0;
if(roomids.length > 0)
{
for(var hh = 0;hh < roomids.length; hh++)
{

if(roomids[hh] == <?php echo $row['id'] ; ?>)
{
exist = 1;
//alert(hh);
roomnumar[hh] = this.value;

}
}
if(exist == 0)
{
roomids.push(<?php echo $row['id'] ; ?>);
roomnumar.push(this.value);
}
}
else
{
roomids.push(<?php echo $row['id'] ; ?>);
roomnumar.push(this.value);
}

document.bookingform.roomid.value = roomids;
document.bookingform.roomnum.value = roomnumar;

">
<option value=0> 0 </option>
<?php
                        for($i = 0; $i < $row['available_rooms']; $i++)
                         {
                         $nr = $i+1;
                         $pr=$nr * $row['price_per_day'];
                         echo "<option value=$nr>$nr ($pr\$)</option>";
                         }
                        echo "</select>
                        </td>";
                        echo "<td align=center>
                         
                        </td>";
echo "</tr>";
echo "<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>";

}
echo "<tr class=\"rooms\">
<td colspan=\"4\"> </td>

<td align=center><input type=\"submit\" value=\"book\" id=\"bookroom\" name=\"bookroom\"/></td>
</tr>";
echo "</table>";
echo "</form>";
print_r($_SESSION['order']);

$_SESSION['order']=0;
unset($_SESSION['order']);

}

}

?>
then booking info

Code: [Select]
<?php include("hotelsManager.php"); ?>
<?php include("config.php"); ?>
<?php include("textManager.php"); ?>
<?php
function echoPostedData()
{

$dbo = new DB();
$hotelObj = new hotelManager();
$hotelID = $_POST['hotelid'];
$datein = $_POST['datein'];
$dateout = $_POST['dateout'];
$roomid = $_POST['roomid'];
$pr = $_POST['tp'];

$_SESSION['hotelID'] = isset($_POST['hotelid']) ? $_POST['hotelid'] : $_SESSION['hotelID'];
$_SESSION['datein'] = isset($_POST['datein']) ? $_POST['datein'] : $_SESSION['datein'];
$_SESSION['dateout'] = isset($_POST['dateout']) ? $_POST['dateout'] : $_SESSION['dateout'];
         $_SESSION['roomid'] = isset($_POST['roomid']) ? $_POST['roomid'] : $_SESSION['roomid'];

$roomsarray = explode(",",$_POST['roomid']);
$_SESSION['roomsarray'] = isset($_POST['roomid']) ? explode(",",$_POST['roomid']) : $_SESSION['roomsarray'];
$roonsNo = $_POST['nrooms'];
$_SESSION['nrooms'] = isset($_POST['roomnum']) ? explode(",",$_POST['roomnum']) : $_SESSION['nrooms'];
Then the confirmation page is

Code: [Select]
<?php
   echoPostedData();
  ?>
</td>
</tr>
<tr>
<td valign="top"> </td>
</tr>
</table>

</td>
</tr>
<tr>
<td valign="top"><img src="images/spacer.gif" width="28" height="10" /></td>
</tr>
<tr>
<td valign="top">
<?php
if(isset($_POST['bookroom']))
  {?>

What Did I Do Wrong?

Similar Tutorials

View Content

Can someone please take a look and see if you can point out what error i made. Everything on the form side is functioning except it doesn't seem to post since its looping back to the form rather than the redirect. Also, within the actual form table, i had to change the section that says Business Hours from a textarea because I couldn't get it to echo the data from the field in the database. Any ideas on that would be greatly appreciated. Sorry if its a bit sloppy, I'm no expert.

Code: [Select]
<?php
   include "config.php";
mysql_connect("$dbhost","$dbusr","$dbpass");
mysql_select_db("$dbname");

session_start();

if (isset($_SESSION['user'])) {

      } else {
    header ('location: login.php');
}

// creates the edit record form
// since this form is used multiple times in this file, I have made it a function that is easily reusable
function renderForm($id, $username, $location, $address, $city, $zip, $county, $website, $map, $email, $phone, $bhours, $ptimes, $pspecials, $vspecials, $error)
{

echo "<center><strong>Edit Location Information</strong></center>";

// if there are any errors, display them
if ($error != '')
{
echo '<div style="padding:4px; border:1px solid red; color:red;">'.$error.'</div>';
}

echo "
<center>

    <form action='' method='POST'>

      <table border='0' frame='box'>
            <tr>
              <td width='96'><div align='right'>Venue ID:</div></td>
              <td colspan='2'><input type='hidden' name='id' value='$id'>$id</td>
            </tr>
            <tr>
                <td><div align='right'><font size='2' face='arial'>Username:</font></div></td>
                <td colspan='2'><input type='text' name='r_username' value='$username'></td>
            </tr>
         <tr>
           <td>Business Name:</td>
           <td colspan='2'><input type='text' name='r_location' value='$location'></td>
        </tr>
         <tr>
                <td><div align='right'><font size='2' face='arial'>Address:</font></div></td>
                <td colspan='2'><input type='text' name='r_address' value='$address'></td>
            </tr>
         <tr>
           <td><div align='right'>City/State:</div></td>
           <td><input type='text' name='r_city' value='$city'></td>
           <td>Format = City, St</td>
         </tr>
         <tr>
                <td><div align='right'><font size='2' face='arial'>Zip:</font></div></td>
                <td colspan='2'><input type='text' name='r_zip'value='$zip'></td>
            </tr>
            <tr>
              <td><div align='right'>County:</div></td>
              <td colspan='2'><input type='text' name='r_county'value='$county'></td>
            </tr>
            <tr>
              <td><div align='right'>Website:</div></td>
              <td colspan='2'><input type='text' name='r_website' value='$website'></td>
            </tr>
            <tr>
              <td><div align='right'>Directions:</div></td>
              <td colspan='2'><input type='text' name='r_map' value='$map'></td>
            </tr>
            <tr>
              <td><div align='right'><font size='2' face='arial'>E-mail:</font></div></td>
              <td colspan='2'><input type='text' name='r_email' value='$email'></td>
            </tr>
            <tr>
                <td><div align='right'><font size='2' face='arial'>Phone #::</font></div></td>
                <td colspan='2'><input type='text' name='r_phone' value='$phone'></td>
            </tr>
            <tr>
                <td height='80'><div align='right'><font size='2' face='arial'>Business Hours:</font></div></td>
                <td width='287'><input type='text' name='r_bhours' cols='45' rows='3' value='$bhours'></td>
                <td width='244'><p>**You must enter </br> after each line to display in rows:</p>
                <p>Mon - Fri 11am to 10pm</br></p>
                <p>Sat - Sun 1PM to 3am</br></p></td>
            </tr>
            <tr>
                <td><div align='right'><font size='2' face='arial'>Poker Times:</font></div></td>
                <td colspan='2'><input type='text' name='r_ptimes' value='$ptimes'></td>
            </tr>
            <tr>
              <td><div align='right'><font size='2' face='arial'>Poker Specials:</font></div></td>
              <td><input type='text' name='r_pspecials' value='$pspecials'></td>
              <td> </td>
            </tr>
            <tr>
              <td><div align='right'><font size='2' face='arial'>Location Specials:</font></div></td>
              <td><input type'text' name='r_vspecials' cols='45' rows='3' value='$vspecials'></td>
              <td><p>**You must enter </br> after each line to display in rows:</p>
                <p>Mon - $0.10 Wings</br></p>
              <p>Fri - 2 for 1 Happy hour</br></p></td>
            </tr>
            <tr>
                <td></td>
                <td colspan='2'><div align='center'><font size='2' face='arial'><a href='edituser.php'>Cancel</a> - </font><input type='submit' value='Update Location'></div></td>
            </tr>
        </table>
</form>

</center>
";
}

// check if the form has been submitted. If it has, process the form and save it to the database
if (isset($_POST['submit']))
{
// confirm that the 'id' value is a valid integer before getting the form data
if (is_numeric($_POST['id']))
{
// get form data, making sure it is valid
$id = $_POST['id'];
$username = mysql_real_escape_string(htmlspecialchars($_POST['username']));
$location = mysql_real_escape_string(htmlspecialchars($_POST['loc_name']));
$address = mysql_real_escape_string(htmlspecialchars($_POST['address']));
$city = mysql_real_escape_string(htmlspecialchars($_POST['city']));
$zip = mysql_real_escape_string(htmlspecialchars($_POST['zip']));
$county = mysql_real_escape_string(htmlspecialchars($_POST['county']));
$website = mysql_real_escape_string(htmlspecialchars($_POST['website']));
$map = mysql_real_escape_string(htmlspecialchars($_POST['map']));
$email = mysql_real_escape_string(htmlspecialchars($_POST['email']));
$phone = mysql_real_escape_string(htmlspecialchars($_POST['phone']));
$bhours = mysql_real_escape_string(htmlspecialchars($_POST['hours']));
$ptimes = mysql_real_escape_string(htmlspecialchars($_POST['ptime']));
$pspecials = mysql_real_escape_string(htmlspecialchars($_POST['pspecial']));
$vspecials = mysql_real_escape_string(htmlspecialchars($_POST['vspecial']));
// check that username field is filled in
if ($username == '')
{
// generate error message
$error = 'ERROR: Please fill in all required fields!';

//error, display form
renderForm($id, $username, $location, $address, $city, $zip, $county, $website, $map, $email, $phone, $bhours, $ptimes, $pspecials, $vspecials, $error);
}
else
{
// save the data to the database
mysql_query("UPDATE vusr SET username='$username', loc_name='$location', address='$address', city='$city', zip='$zip', county='$county', website='$website', map='$map', email='$email', phone='$phone', hours='$bhours', ptime='$ptimes', pspecial='$pspecials', vspecial='$vspecials' WHERE id='$id'")
or die(mysql_error());

// once saved, redirect back to the view page
header("Location: edituser.php");
}
}
else
{
// if the 'id' isn't valid, display an error
echo 'Error!';
}
}
else
// if the form hasn't been submitted, get the data from the db and display the form
{

// get the 'id' value from the URL (if it exists), making sure that it is valid (checing that it is numeric/larger than 0)
if (isset($_GET['id']) && is_numeric($_GET['id']) && $_GET['id'] > 0)
{
// query db
$id = $_GET['id'];
$result = mysql_query("SELECT * FROM vusr WHERE id=$id")
or die(mysql_error());
$row = mysql_fetch_array($result);

// check that the 'id' matches up with a row in the databse
if($row)
{

// get data from db
$id = $row['id'];
$username = $row['username'];
$location = $row['loc_name'];
$address = $row['address'];
$city = $row['city'];
$zip = $row['zip'];
$county = $row['county'];
$website = $row['website'];
$map = $row['map'];
$email = $row['email'];
$phone = $row['phone'];
$bhours = $row['hours'];
$ptimes = $row['ptime'];
$pspecials = $row['pspecial'];
$vspecials = $row['vspecial'];
// show form
renderForm($id, $username, $location, $address, $city, $zip, $county, $website, $map, $email, $phone, $bhours, $ptimes, $pspecials, $vspecials, '');
}
else
// if no match, display result
{
echo "No results!";
}
}
else
// if the 'id' in the URL isn't valid, or if there is no 'id' value, display an error
{
echo 'Error!';
}
}

?>

MOD EDIT: code tags added.

What Am I Doing Wrong???

Similar Tutorials

View Content

$result3 = mysql_query("SELECT User_ID FROM leaderboards WHERE User_ID = '$user'");

if(mysql_num_rows($result3) == 0){

$query1 = "INSERT INTO leaderboards (User_ID, CollegeFootballPoints) VALUES ('$user','$points')";
$result1 = mysql_query($query1);

}else{

$query2 = "UPDATE leaderboards SET  CollegeFootballPoints='$points' WHERE User_ID='$user'";
$result2 = mysql_query($query2);
}

I keep getting this error...'

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in update_collegeFBpoints_points.php on line 40

And the script is not working!

(LINE 40 is

$result3 = mysql_query("SELECT User_ID FROM leaderboards WHERE User_ID = '$user'");
   if(mysql_num_rows($result3) == 0){

specifically mysql_num_rows)

What Went Wrong..

Similar Tutorials

View Content

ok so before this.. if there isnt description for the company..the logo cant be click..only can be clicked if there is description added..im confused..

Code: [Select]

<?
if(isset($_GET[ttid])) {
$ttid = $_GET[ttid];
}

$connection=mysql_connect("$server", "$username", "$password")
or die("Could not establish connection");
mysql_select_db($database_name, $connection)
or die ("Could not select database");

$query = "select master_event.* ,
(DATE_FORMAT(event_datefrom, '%d %M %Y')) as datefrom,
(DATE_FORMAT(event_dateto, '%d %M %Y')) as dateto,
ucase(event_name) as eventname
from master_event
where master_event.event_id = '$ttid '";
$result=mysql_query($query);
while($row = mysql_fetch_array($result)){
$eventname = $row['eventname'];
$eventdesc = $row['event_desc'];
//$companydescription = $row['company_description'];
$eventvenue = $row['event_venue'];
$eventfee = $row['event_fee'];
$datefrom = $row['datefrom'];
$dateto = $row['dateto'];

echo "<font color='#000000' face='arial' ><b> $eventname </b> </font> <br>";
echo "<font color='#000000' face='arial' ><i>Date</i> : $datefrom - $dateto <br>";
echo "<i>Venue</i> : $eventvenue <br>";

$querypstype = "SELECT DISTINCT master_pstype.pstype_id, pstype_desc FROM master_pstype
INNER JOIN master_psevent ON master_psevent.pstype_id= master_pstype.pstype_id
where master_psevent.event_id = '$ttid'
ORDER BY pstype_order";

$resultpstype=mysql_query($querypstype);
while($rowpstype = mysql_fetch_array($resultpstype)){
$pstypeid = $rowpstype['pstype_id'];
$pstypedesc = $rowpstype['pstype_desc'];
echo "<br><font color='#8B3A3A' size='1' face='georgia' ><b><i>$pstypedesc</i></b></font> <br>";

$queryps = "SELECT master_psevent.*, pstype_desc, company_name, company_link, company_description, logo_filename FROM master_psevent
LEFT JOIN master_pstype ON master_psevent.pstype_id = master_pstype.pstype_id
LEFT JOIN master_ps ON master_ps.ps_id = master_psevent.ps_id
WHERE master_psevent.event_id = '$ttid' and master_pstype.pstype_id= '$pstypeid'
ORDER BY pstype_desc,company_name ";

$resultps=mysql_query($queryps);
while($rowps = mysql_fetch_array($resultps)){
$companyname = $rowps['company_name'];
$companyid = $rowps['ps_id'];
$companylinkori = $rowps['company_link'];
$companydescription = $rowps['company_description'];
$logopath = $rowps['logo_filename'];

$describelink = "index.php?ttid=$ttid&content=describe&pstypeid=$pstypeid&psid=$companyid";

echo "<a href=\"$describelink\" target=\"_blank\"><img src=".$logo_dir."/".$logopath." width=\"15%\"></a>";
?>

<br>
<?
}
echo "<br>";
}

}

?>

im new..so to make it simple..the problem is ..i want it to be (if there is description = logo can be click, if no = otherwise)

Where Is Wrong ?

Similar Tutorials

View Content

Need Help, Not Sure What Is Wrong.

Similar Tutorials

View Content

I am trying to create a very basic object but am having troubles.

Code: [Select]
<?php

class item{

public $name;
public $price;

function __construct($name,$price){
$this->name=$name;
$this->price=$price;}

function getName(){
return $this->name;
}

}

$object = new item("car",400);
echo $object->getName();

?>
The HTML output is:

name=$name; $this->price=$price;} function getName(){ return $this->name; } } $object = new item("car",400); echo $object->getName(); ?>

I'm sure that this code is clean but for some reason will not output the desired result! any help would be great. thanks.

Very New To Php, Can Someone Tell Me Where Ive Gone Wrong?

Similar Tutorials

View Content

Anyone See Anything Wrong?

Similar Tutorials

View Content

or should I say can you tell me WHAT is wrong?

getting error on line 19 Parse error: syntax error, unexpected '[' in /home/heaven/public_html/tester/view_thread2.php on line 19

<?php

include("connect.php");

mysql_select_db("heaven_forum") or die ("Could Not Select Database");

$recent = mysql_query("SELECT phpbb_posts.id AS post_id,
phpbb_posts.topic_id AS topic_id,
phpbb_posts.forum_id AS forum_id,
phpbb_posts.poster_id AS poster_id,
phpbb_topics.topic_title AS title,
phpbb_users.username AS usernameFROM phpbb_posts,
phpbb_topics ON phpbb_posts.topic_id=phpbb_topics.id,
users ON phpbb_posts.poster_id=users.idORDER BY post_time DESC LIMIT 5");

//pull array
$recent_row = mysql_fetch_assoc($recent);

//set varibles pulled
$topic_name = $recent ['title'];
$poster = $recent['usernameFROM'];

echo $topic_name;
echo "Posted By: $poster";

?>