PHP - Mysql Query Fails If Php Variable Is Empty

I'm not sure what i have done wrong here...
all it says is "Query was empty"


<?php
SESSION_START();

?>

//some html

<?php

if($_SESSION['email']){

$mysql = "SELECT id,firstname FROM users WHERE 'id'='".$_SESSION['email']."'";
$res = mysql_query($sql) or die(mysql_error());

if(mysql_num_rows($res) == 0){
session_destroy();
echo"Please <a href=\"/index.html\">Login</a> or <a href=\"/register.php\">Join Us.</a>";
}else{
$row = mysql_fetch_assoc($res);
echo "welcome back, <a href=\"./index.php?act=profile&id=".$row['id']."\">".$row['firstname']."</a>\n";

}
}else {
echo"Please <a href=\"/index.html\">Login</a> or <a href=\"/register.php\">Join Us.</a>";

}
?>

hello dear experts   good day

dear friend - i need your help.

import urllib
import urlparse
import re
# import peewee
import json
from peewee import *



#from peewee import MySQLDatabase ('cpan', user='root',passwd='rimbaud')


db = MySQLDatabase('cpan', user='root',passwd='rimbaud')

class User(Model):
    name = TextField()
    cname = TextField()
    email = TextField()
    url = TextField()

    class Meta:
        database = db # this model uses the cpan database


User.create_table() #ensure table is created


url = "http://search.cpan.org/author/?W"
html = urllib.urlopen(url).read()
for lk, capname, name in re.findall('<a href="(/~.*?/)"><b>(.*?)</b></a><br/><small>(.*?)</small>', html):
    alk = urlparse.urljoin(url, lk)

    data = { 'url':alk, 'name':name, 'cname':capname }

    phtml = urllib.urlopen(alk).read()
    memail = re.search('<a href="mailto:(.*?)">', phtml)
    if memail:
        data['email'] = memail.group(1)


data = json.load('email') #your json data file here

for entry in data: #assuming your data is an array of JSON objects
    user = User.create(name=entry["name"], cname=entry["cname"],
        email=entry["email"], url=entry["url"])
    user.save()

guess that there a data-file must exist: one that have been created by the script during the parsing... is this right?

)
martin@linux-70ce:~/perl> python cpan_100.py
Traceback (most recent call last):
  File "cpan_100.py", line 47, in <module>
    data = json.load('email') #your json data file here
  File "/usr/lib/python2.7/json/__init__.py", line 286, in load
    return loads(fp.read(),
AttributeError: 'str' object has no attribute 'read'
martin@linux-70ce:~/perl>

this script does not work



 

)
martin@linux-70ce:~/perl> python cpan_100.py
Traceback (most recent call last):
  File "cpan_100.py", line 47, in <module>
    data = json.load('email') #your json data file here
  File "/usr/lib/python2.7/json/__init__.py", line 286, in load
    return loads(fp.read(),
AttributeError: 'str' object has no attribute 'read'
martin@linux-70ce:~/perl>

well i suppose that in the first part of the script - the parser - part we parse data and - therefore we should create a file.
I guess that this file is taken up within the second part of the script...

load data .

well why the script does not work!?
 

I need to check post values with existing database values and my check isn't working for the values below.

Code: [Select]
//This one works
if ((isset($_POST['companystageas'])) && ($_POST['companystageas'] != $info['stage']))
{
$details = '';
update_company_actions($info['companyid'], 10, $details);
}


//These all fail
if ((!isset($_POST['companystateas'])) && (($_POST['companycountryas'] != $info['country']) || ($_POST['city'] != $info['city'])))
{
$details = $_POST['companycityas'].', '.$_POST['companycountryas'];
update_company_actions($info['companyid'], 11, $details);
}
else if ((isset($_POST['companystateas'], $_POST['companycityas'])) && (($_POST['companystateas'] != $info['state']) || ($_POST['companycityas'] != $info['city'])))
{
$details = $_POST['companycityas'].', '.$_POST['companystateas'];
update_company_actions($info['companyid'], 11, $details);
}

if ((isset($_POST['capitalrequestedas'])) && ($_POST['capitalrequestedas'] != $info['capitalrequested']))
{
$details = '';
update_company_actions($info['companyid'], 12, $details);
}

I am getting an empty query error on this line

Code: [Select]
$mysql->query($insert);


here is my code
Code: [Select]
if(isset($_POST['submit'])){
$firstName = $_POST['firstName'];
$lastName = $_POST['lastName'];
$companyName = $_POST['companyName'];
$homePhone = $_POST['homePhone'];
$cellPhone = $_POST['cellPhone'];
$companyPhone = $_POST['companyPhone'];

//checking the values are filled
//echo $firstName. " " . $lastName . " " . $companyName . " " . $homePhone . " " . $cellPhone . " " . $companyPhone;

$insert = $mysql->query("INSERT INTO names('firstName','lastName','companyName'), phone('home','cell','company') values('$firstName','$lastName','$companyName','$homePhone','$cellPhone','$companyPhone'");

$mysql->query($insert);

if($insert){
echo "success";
}
else
{
mysql_error();
}

}


I got a connection to the database, I tested for it. I can't find the problem.
this is the error I get

Warning: mysqli::query() [mysqli.query]: Empty query in C:\wamp\www\test\formData.php on line 23

which is this line
Code: [Select]
$mysql->query($insert);

I have this line in my code

$result2 = mysqli_query($link, 'Select * from categories where cat_loc ='.$nav['id']);

how do I say "if $result2 is empty or false"? (basically if it didn't find any cat_loc = to $nav['id'])

 to echo '</li>';

i am pulling the login date from the databases and i want it to check if the variable is empty and if it is echo Never Loged In and if it not empty echo the date
          <?php
          include'db.php';
  $id=$_GET['id'];
  $sql=mysql_query("SELECT * FROM admin WHERE id='$id'")or die(mysql_error());
  while($row=mysql_fetch_array($sql))
  {
  $date=$row['login_date'];
  if($date > 0)
  {
  echo"Never Loged In";
  }
  else
  {
  echo"$date";
  }
  }
  ?>

I'll try to explain this as easily as possible. 
I'm working on making a little link shortener site just for fun/practice as a beginner with php.
I originally used the source code 'lilurl' as a base to start out, but now I'm adding stuff to it for actual practice.
I need some help though.
I have two files, my index and my external php file.  The external file is called on at the beginning of the index with require_once.
The user submits a url into the PHP_SELF form and a url is returned, and it works all great.  Now I'm trying to add the option to make a custom url suffix. 
Code: [Select]
<form action="<?php echo $_SERVER['PHP_SELF']?>" method="post">

<fieldset>
<label for="longurl">Enter a URL:</label>
<input type="text" name="longurl" id="longurl" />
<input type="text" name="suffix" id="suffix" />
<input type="submit" name="submit" id="submit" value="Shrink!" />
</fieldset>

</form>[/code]
The form looks like this.  I added the 'suffix' textbox. 

So after the user submits the code, it goes back up to the top (phpself).
A variable is set for the url the user has inputted as "$longurl", like this.
Code: [Select]
$longurl = trim(mysql_escape_string($_POST['longurl']));So I added this.
Code: [Select]
    $suffix = ($_POST['suffix']);And to check if it worked, I went down the the bottom of the index and had it echo the suffix variable.  When I entered in code into the suffix text box, it would be echoed at the bottom of the page, so the variable did receive the value. 

So here's where the external file comes in. 
It is called on by require_once at the very beginning of the index.  It is full of functions.  One of the functions generates a random string of numbers (that I coded) to be used as the url suffix (uses the $id variable).  So my plan was to erase the $id = $rand1 . blah blah stuff and put $id = $suffix.  $suffix being the variable from the index that the user inputted.  Make sense?  Well whenever I try it, it always acts the like the variable is empty, even when I echo it on the index it returns the value of the textbox.  Does anyone know what I'm doing wrong?  Could it be because since I call on $suffix in the external file, and it's only been declared in the index that it's treating it like a new/empty variable? 

[spoiler]
Someone also explained it to me like this.
-I call upon the external file.
-I declare the variable is the value of the text box.  (Which means it's currently empty because the form has not been submitted.)
-Then, the form is submitted as PHP_SELF.

-The external file is called upon again.
-The variable is then assigned a value. 
It's hard to explain, but basically that the variable in the external file is not told about the new value of the variable because they are declared after the external file is called upon? :\

So I tried moving the  $suffix = ($_POST['suffix']); before the external file is called upon, but the same thing happens.  It's hard to explain the situation, but I've tried a lot of things and can't get it to work.[/spoiler]

Hello all,

I am a beginner at PHP and trying to form an IF statement, I'm running into a problem which I cannot seem to solve.
Due to my lack of syntax knowledge I would appreciate if someone could point me in the right direction.

The combo variables are sent to this page through a form and defined as these variables at the top of the page.
e.g $combo0 = $_POST["combo0"];

When the results are displayed any form field which was left blank or empty I want to show "N/A" if data is detected in being sent through the form I then want the "Else" statement to take affect.

Currently when I run the below statement N/A is echoed despite if data was sent through the form fields or not....

if (empty($scrap))  {
echo "<h3>Submitted Scrap Results</h3> No scrap parts were booked off";
}
elseif (empty($combo0) || empty($combo1) || empty($combo2) || empty($combo3) || empty($combo4)) {
echo "N/A";
}
else {
echo "<h3>Submitted Scrap Results</h3> <b>Reason:</b> " .$combo0." - ".$combo1." - ".$combo2." - ".$combo3." - ".$combo4."
<br /> <b>on machine</b> " .$mid. " - <b>No. Scrap</b> " .$noscrap. "";
}

Anyone any ideas?

Hi, I hope you guys can help me out. I only know basic PHP and also SQL.  I haven't tried using connecting database yet.

My problem is that I'm trying to INSERT a data into an existing table using access but when it reaches $rs = odbc_exec(); it returns an error that the query was empty.

Here is the code:
Code: [Select]
$conn=odbc_connect('trial','','');
if (!$conn)
  {exit("Connection Failed: " . $conn);}
$sql = "INSERT INTO Data (FirstName, LastName, BusinessName)
VALUES ('$fname', '$lname', '$bname')";

$rs=odbc_exec($sql, $conn);

$rs = @odbc_exec($conn,$sqlstring);

if (!$rs)
{
echo "An error has occured. Please try again", odbc_errormsg($conn);
}
else
{
echo "The record was successfully inserted.";
}

odbc_close($conn);

and here is the error:
Quote

An error has occured. Please try again[MySQL][ODBC 5.1 Driver][mysqld-5.5.20]Query was empty



I really hope you could help me out.

Thanks.

How would I write this in php?:

Code: [Select]
If $url does not begin with 'http://'
$url = ''
I want to assign nothing to the variable if it doesn't begin with http://

Thanks! 

Is if($variable) the same as if(!empty($variable)), just different syntax?

Hi,

I want to pull data from db, where sometimes all rows and sometimes rows matching given "username".

Here is my code:

	//Grab Username of who's Browsing History needs to be searched. 
	if (isset($_GET['followee_username']) && !empty($_GET['followee_username'])) 
{ 
    $followee_username = $_GET['followee_username']; 
    
    if($followee_username != "followee_all" OR "Followee_All") 
    { 
        $query = "SELECT * FROM browsing_histories WHERE username = \"$followee_username\""; 
        $query_type = "followee_username"; 
        $followed_word = "$followee_username"; 
        $follower_username = "$user"; 
        echo "$followee_username"; 
    } 
    else 
    { 
        $query = "SELECT * FROM browsing_histories"; 
        $query_type = "followee_all"; 
        $followed_word = "followee_all"; 
        $follower_username = "$user"; 
        echo "all"; 
    } 
} 
	

 

When I specify a "username" in the query via the url:

browsing_histories_v1.php?followee_username=requinix&page_number=1

I see result as I should. So far so good.

 

Now, when I specify "all" as username then I see no results. Why ? All records from the tbl should be pulled!

browsing_histories_v1.php?followee_username=all&page_number=1

This query shouldv'e worked:

	$query = "SELECT * FROM browsing_histories"; 
	

I have tried the following variations but non works

if($row['relation'] = "" ){

if($row['relation'] = '' ){

if($row['relation'] = NULL ){

if($row['relation'] IS NULL ){

if(strlen($row['relation']) = 0 ){

So how would one refer to a cell that is empty?

Can anyone tell me the best way to handle empty search field on a mysql Query? The query below if $name is left blank but the other fields are filled it shows no results, currently i use if.... else.... but that means i have a lot of code replicated, is there a better way?


$sql = "SELECT private.username,
se.age,
se.ro,
se.suc,
se.bu,
se.fu,
com.in,
com.ol,
se.di,
se.bo,
se.uin
FROM Reg_Profile_public AS se
INNER JOIN Reg_Profile_Private AS private
USING (uin)
INNER JOIN Reg_Profile_public_Com AS com
USING (uin)
WHERE se.age BETWEEN '$low' AND '$high' AND se.ro=''$name";