|
How to sync database offline and online application
|
|
|
|
|
Depends on what database you are using and how you did everything.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
If you want to keep it synchronized, there is no sense in keeping the application offline. 
Offline applications are meant to keep a fraction of database content, and the updated content is kept offline in the databases, until application is online. Then the data is synchronized. Thus, your question makes very less sense because both are contradiction to each other.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Hi, I don't know if this is the appropriate forum for my question but here goes. I've heard many people and read many posts that claim that since Entity Framework is both a unit of work and a repository rolled into one, there is no need to create separate layers and write codes for them in N-Tier applications.
After reading posts arguing against this claim that we do not need Repository and UnitOfWork patterns when using EF, I want to know what the verdict in the community is on this.
If we do need to use Repository and UnitOfWork patterns can someone please point me to a good tutorial(WebForm and MVC) on how to implement them in an N-Tier app. Thanks in advance.
modified 26-Mar-16 0:52am.
|
|
|
|
|
MadDashCoder wrote: there is no need to create separate layers and write codes for them in N-Tier applications.
Here's a contrary opinion, with a pretty good explanation:
Repository Pattern with C# and Entity Framework, Done Right - YouTube[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
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.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
