|
i got the eroor
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\test1\register.php on line 54
Heres my code:
<?php
session_start();
if(isset($_SESSION['tbl_info'])!="")
{
header("Location: home.php");
}
include_once 'dbconnect.php';
if(isset($_POST['btn-signup']))
{
$username = mysql_real_escape_string($_POST['username']);
$email = mysql_real_escape_string($_POST['email']);
$password = md5(mysql_real_escape_string($_POST['pass']));
$LastName = mysql_real_escape_string($_POST['LastName']);
$FirstName = mysql_real_escape_string($_POST['FirstName']);
$MidName = mysql_real_escape_string($_POST['MidName']);
$Age = mysql_real_escape_string($_POST['Age']);
$Bdate = mysql_real_escape_string($_POST['Bdate']);
$Address = mysql_real_escape_string($_POST['Address']);
$Contact = mysql_real_escape_string($_POST['Contact']);
$FathersName = mysql_real_escape_string($_POST['FathersName']);
$FOccupation = mysql_real_escape_string($_POST['FOccupation']);
$MothersName = mysql_real_escape_string($_POST['MothersName']);
$MOccupation = mysql_real_escape_string($_POST['MOccupation']);
$ElemSchool = mysql_real_escape_string($_POST['ElemSchool']);
$YearGradElem = mysql_real_escape_string($_POST['YearGradElem']);
$HighSchool = mysql_real_escape_string($_POST['HighSchool']);
$YearGradhs = mysql_real_escape_string($_POST['YearGradhs']);
$username = trim($username);
$email = trim($email);
$password = trim($password);
$LastName = trim($LastName);
$FirstName = trim($FirstName);
$MidName = trim($MidName);
$Age = trim($Age);
$Bdate = trim($Bdate);
$Address = trim($Address);
$Contact = trim($Contact);
$FathersName = trim($password);
$FOccupation = trim($password);
$MothersName = trim($password);
$MOccupation = trim($password);
$ElemSchool = trim($password);
$YearGradElem = trim($password);
$HighSchool = trim($password);
$YearGradhs = trim($password);
$query = "SELECT email FROM tbl_info WHERE email='$email'";
$result = mysql_query($query);
$count = mysql_num_rows($result);
if($count == 0){
if(mysql_query("INSERT INTO tbl_info (username,email,password,LastName,FirstName,MidName,Age,Bdate,Address,Contact,FathersName,FOccupation,MothersName,MOccupation,ElemSchool,YearGradElem,HighSchool,YearGradhs) VALUES('$username','$email','$password','$LastName','$FirstName','$MidName','$Age','$Bdate','$Contact','$FathersName','$FOccupation','$MothersName','$MOccupation','$ElemSchool','$YearGradElem','$HighSchool','$YearGradhs)"))
{
?>
<script>alert('successfully registered ');</script>
<?php
}
else
{
?>
<script>alert('error while registering you...');</script>
<?php
}
}
else{
?>
<script>alert('Sorry Email ID already taken ...');</script>
<?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>test</title>
<link rel="stylesheet" href="style.css" type="text/css" />
</head>
<body>
<center>
<div id="login-form">
<form method="post">
<table align="center" width="30%" border="0">
<tr>
<td><input type="text" name="username" placeholder="User Name" required /></td>
</tr>
<tr>
<td><input type="email" name="email" placeholder="Your Email" required /></td>
</tr>
<tr>
<td><input type="password" name="password" placeholder="Your Password" required /></td>
</tr>
<tr>
<td><input type="text" name="LastName" placeholder="Your Last Name" required /></td>
</tr>
<tr>
<td><input type="text" name="FirstName" placeholder="Your First Name" required /></td>
</tr>
<tr>
<td><input type="text" name="MidName" placeholder="Your Middle Name" required /></td>
</tr>
<tr>
<td><input type="text" name="Age" placeholder="How old are you?" required /></td>
</tr>
<tr>
<td><input type="text" name="Bdate" placeholder="Your Birthday" required /></td>
</tr>
<tr>
<td><input type="text" name="Address" placeholder="Where do you live?" required /></td>
</tr>
<tr>
<td><input type="text" name="Contact" placeholder="Your Contact Info" required /></td>
</tr>
<tr>
<td><input type="text" name="FathersName" placeholder="Your Father's name" required /></td>
</tr>
<tr>
<td><input type="text" name="FOccupation" placeholder="Occupation" required /></td>
</tr>
<tr>
<td><input type="text" name="MothersName" placeholder="Your Mother's name" required /></td>
</tr>
<tr>
<td><input type="text" name="MOccupation" placeholder="Occupation" required /></td>
</tr>
<tr>
<td><input type="text" name="ElemSchool" placeholder="Elem School" required /></td>
</tr>
<tr>
<td><input type="text" name="YearGradElem" placeholder="Year Graduated" required /></td>
</tr>
<tr>
<td><input type="text" name="HighSchool" placeholder="HighSchool" required /></td>
</tr>
<tr>
<td><input type="text" name="YearGradhs" placeholder="Year Graduated" required /></td>
</tr>
<tr>
<td><button type="submit" name="btn-signup">Sign Me Up</button></td>
</tr>
<tr>
<td><a href="index.php">Sign In Here</a></td>
</tr>
</table>
</form>
</div>
</center>
</body>
</html>
|
|
|
|
|
I am not a PHP dev
according to your question , i googled mysql_query and reached php api reference site[^]
Under Return Values paraparaph , i saw the following info
Quote: For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource on success, or FALSE on error.
So in short that function fails and returns FALSE (boolean) , This means something was wrong in query string or somewhere else
You should check the $result variable whether it is a boolean or resource
here is the sample from api page
$result = mysql_query('SELECT * WHERE 1=1');
if (!$result) {
die('Invalid query: ' . mysql_error());
}
|
|
|
|
|
I have a table with a couple rows. Ech row has a class of either black or blue. Black rows have black background, blue rows have blue background. Currently when the cursor hovers over any row, its background turns purple.
When the mouse cursor leaves a row, its background reverts back to what it was.
The functionality that I cannot get to work is when a new row is clicked. When a new row is clicked I would like the background of the old row which was previously clicked to revert back to its original color.
I want the clicked row to remain gray until another row is clicked or when the cursor hovers over it but it is not working.
<style>
body { font-family: San-Serif; color:white;}
table { border-collapse: collapse;}
th { text-align: left; }
tr.black { background-color: black; }
tr.blue { background-color:blue;}
</style>
<style>
.markedBlack, .markedBlue{background:gray}
</style>
<script type="text/javascript" language="javascript" src="https://code.jquery.com/jquery-2.1.4.min.js"></script>
<script>
$(document).ready(function() {
$("tbody tr").mouseover(function() {
$(this).css("background","purple");
});
$(".black").mouseout(function() {
$(this).css("background","black");
});
$(".blue").mouseout(function() {
$(this).css("background","blue");
});
$(".black").click(function(){
$(this).removeClass("black").addClass("markedBlack");
});
$(".blue").click(function(){
$(this.blue").removeClass("blue").addClass("markedBlue");
});
$(".markedBlack").click(function(){
$(".markedBlack").removeClass("markedBlack").addClass("black");
$(this).addClass("markedBlack");
});
$(".markedBlue").click(function(){
$(".markedBlue").removeClass("markedBlue").addClass("blue");
$(this).addClass("markedBlue");
});
});
</script>
<table>
<thead>
<tr>
<th>Title1</th><th>Title2</th><th>Title3</th>
</tr>
</thead>
<tbody>
<tr class="blue">
<td>blue</td> <td>blue</td> <td>blue</td>
</tr>
<tr class="black">
<td>black</td> <td>black</td> <td>black</td>
</tr>
<tr class="blue">
<td>blue</td> <td>blue</td> <td>blue</td>
</tr>
<tr class="black">
<td>black</td> <td>black</td> <td>black</td>
</tr>
</tbody>
</table>
modified 21-Mar-16 15:56pm.
|
|
|
|
|
First of all, there's no need to use Javascript to change the colour of the row on hover - just use the :hover pseudo-class instead.
tbody tr:hover { background-color: purple; }
There's no need to remove the class from the row; just add a new class that overrides the colour.
tr.selected { background-color: gray; }
Add that before the :hover rule, so that the row still changes colour when you hover over it.
Then, you just need to handle removing the selected class from all other rows when you click a non-selected row:
$("table tbody").on("click", "tr", function(){
var $tr = $(this);
if ($tr.is(".selected")) {
$tr.removeClass("selected");
}
else {
$tr.closest("tbody").find("tr").removeClass("selected");
$tr.addClass("selected");
}
});
Example: JSFiddle[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hello, thanks for replying. Your solution is very close to what I need. The only problem is as it stands when a row is clicked it's background color doesn't change until I move the mouse cursor off the row after clicking it.
modified 21-Mar-16 14:18pm.
|
|
|
|
|
So change the CSS to set the background colour of the hovered selected row to gray:
tr.selected, tr.selected:hover { background-color: gray; }
JSFiddle[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I’m work with Prestashop (PS) 1.6 in localhost for temp. So far, everything is ok until I’m use layered navigation block in my category.
I have created a filter template in the module config and set 3 filters just in one category (for example category 'B') for testing only. There are sub-category filter, product price filter and attribute filter. As often as I’m click via category block, which the category haven’t layered navigation's setting, everything is ok, all products item are showed in the current category. But when I’m click which the category have layered navigation's (category 'B') setting all products doesn’t appear at all in front office. And even, product price filter and attribute filter doesn’t appeared too.
So my conditions now
I have checked all products in BO->Cataloque->Product are resides at its right category and each of them has right attribute too.
I have tried disabled, reset & reinstalling the module, but is not worked
I have re-index price, attribute and url in module configuration, but is not worked too
So, what’s wrong with my PS 1.6 or do I have missed step for my layered navigation? Thanks in advanced for any solution.
modified 19-Mar-16 16:55pm.
|
|
|
|
|
Hi Friends,
I have to start a coupons/deals website where I can publish deals and coupons from major online stores. I heard about few paid wordpress themese which is very easy to manage whether you are technical or non-technical, but I'm not sure It would be right way or not because I will be need to make many customization in order to improve user behavior of website.
So, please help me to know what is good idea.. Should I go with any wordpress theme or hire a PHp developer to create it in core PHP?
Example - I have to create something like this site: 33Coupons.in
|
|
|
|
|
The site you have mention is WordPress site, If you're non tech guy, then I suggest to go with WordPress.
|
|
|
|
|
how do you get the url to consume a webservice with a very simple web client that can only run
http:\\someweb\somefunc\variable=2
it's and arduino module.
Thanks
|
|
|
|
|
Your question isn't clear. Please specify if you're trying to write a web service that will be consumed by IoT-type devices, or if you're trying to consume web service data on an IoT device.
Or, I guess, if it's neither of those.
|
|
|
|
|
The first one.
for exmaple: the hello world web service in
Your first C# Web Service[^]
how i consume it from address bar of internet explorer? modules can be simple browser.
may be its more simple if i use wcf?
I'm trying
this[^]
see please the line:To call service operations mapped to GET in Internet Explorer
but i cant make it work.
Thanks.
modified 16-Mar-16 9:21am.
|
|
|
|
|
|
|
|
Hi , I have a task in college to make a online webpage, The data inserted by user should be sent to his mobile number which was also inserted by him . message should be like you have subscribe to this Webpage or something related to this..please guide me for this.
Thanx
|
|
|
|
|
Google will find you many article/samples on the subject.
|
|
|
|
|
|
Having worked with MEF a fair amount, I can tell you that it is ridiculously easy to use once you understand how it works, but it does require quite a bit of planning. You extensibility approach will make a huge difference down the road, and it's not necessarily trivial to change it once you get started.
Also, the Windows store version of MEF (2) is NOT suitable for enterprise-class application in my experience. Stick with the original.
I tend to hybrid things a little and use MEF for modular support and dependency injection. Leveraging it as a dependency injection framework means that you have a built-in system for extensibility, providing that you make use of MEF Metadata appropriately. If you're not comfortable with that, you will likely want to build resource factory classes and export those from your plugins, it'll save you headaches in the long run.
Some resource sites:
MSDN: Managed Extensibility Framework (MEF)[^]
CodePlex: Managed Extensibility Framework - Home[^]
|
|
|
|
|
Thank you for your reply ,
Actually i am referring MEF but it is new to me , Can you give me a demo example to clear out my thought.
|
|
|
|
|
Without context a sample would be effectively useless. Take a look at the MSDN page, it lays out a very basic Export/Import pattern with a CompositionContainer.
|
|
|
|
|
HOW TO DISTINGUISH BETWEEN LEFT AND RIGHT MOUSE CLICK WITH JQUERY? - Pro-Tek Blog
|
|
|
|
|
I have 222 pictures.
I want to give my target user a single URL he can click.
Once he clicks, I want him to go to a simple screen with some sort of organized thumbnails.
From there, I want him to be able to click, and see the full sized pic
From the resulting full sized pic, I want him to be able to click and download that pic.
How many lines of code, and how many separate web pages, and how many subdirectories on my host would be involved in this ?
I wouldn't be surprised in the least if this problem has been solved a thousand times before, and an auto-bot of some sort could do all this work for me with a single click.
Advice welcome.
|
|
|
|
|
C-P-User-3 wrote: How many ... Impossible to answer, until it's written.
|
|
|
|
|
From The Original Post: I wouldn't be surprised in the least if this problem has been solved a thousand times before, and an auto-bot of some sort could do all this work for me with a single click.
No surprise, indeed; the tools are there, and very good.
There exists a small culture of active nerds who have created several freeware apps to do just this.
- Gallery
- Piwigo
- Coppermine
- Zenphoto
- TinyWebGallery
- phpAlbum
- 4images
- Pixelpost
- Plogger
- iGalerie
- Lychee
- Gallery 2
The tech support guy at my host showed me where they are; click/click, your gallery is up.
|
|
|
|
|