I have just uploaded my php files onto a free hosting server and tried to access the website. I got this error " mysql_fetch_array() expects a resource in parameter 1" or something like that. By the way, the files did work on my local machine.
What is the problem? and how do I go about fixing it?
To answer your question, here is an example. I hope the example I'm giving will help you.
<?php
$name = "Dani";
if($name== "Dani"){
echo $name; => this will output Dani
$name .= " Web"; => this will concatenate the string " Web" to the "Dani"
}
echo $name; => this will output "Dani Web"
?>
That is an example of what I am using... Once the page is loaded, click twice on the page. you will see the footer disappear. Any idea to why this is happening?
I'm making my first jQuery mobile app and using a fixed bottom navbar. But the app is acting a little weird. When I tap the background twice, the navbar disappears or moves up a little. how can I fix this problem?
That works exactly the same as the if-statement that I had but it still causes the same error which is not changing the URL to index.php and users can still view the content of it.. I just took out the jQuery files out and it seems to work fine without them. I guess the problem is caused by jquery mobile or jquery..
How can I determine how many lines of text to display in JS? Let's say I want to show users 3 lines of text and if they want to see more, they will toggle the div.
Yeah, on the home page, I have got a session variable that checks whether users are logged in or not. What I am facing though is that once they go to the login.php and log in successfully. Then they are redirected to the home page and can view the content of it, but the url doesn't change to home.php and unfortunately stays as log_in.php which is the script being written in the first post. This is what I have got in the login.php page. Nah, I didn't do any checking for the session variables on it yet. It is wierd to have the URL changed when users log in or out. I never had this problem ever. Do you think jQuery for mobile is causing it?
I'm using jQuery for mobile and making the app show users a dailog box to let them enter their credentials when they want to log into the app. Ok. it redirects them to the home page but the url stays as mysite.com/login.php rather than mysite.com/index.php This removes the menu bar on the bottom but it appears if the page is refreshed which I don't want my users to do. Since I'm using a dialog box for the log in page, how would I display any errors if username/password isn't correct? If I do though, they will be redirected to the actual login.php page and dialog box disappears.
Why is that ? any help will be appreciated. Thank you.
<?php
include('funcs/connector.php');
$port = new MySqlDatabase();
$port ->connect('root','','myDB') or die(mysql_error());
session_start();
$user = mysql_real_escape_string($_POST['username']);
$pass = mysql_real_escape_string($_POST['password']);
$query = "SELECT username, password FROM USERS WHERE `username` = '$user' AND `password`='$pass' ";
$result = mysql_query($query) or mysql_error();
$row = mysql_fetch_assoc($result);
if( $username == $row['username']){
$_SESSION['username'] = $row['username'];
header('Location:index.php');
}else{
echo "this is wrong";
}
Ah, I know where the problem is. Instead of compairing $user == $row['username'], I was compairing $username == $row['username'] which in this case $username is not defined.
I'm having trouble to get this code to work as I wanted. My application is running on the top jQuery for mobile framework. The message I'm getting is this "undefined". I enter the right username and password but don't know what is undefined.
<?php
include('funcs/connector.php');
$port = new MySqlDatabase();
$port ->connect('root','','deco3500') or die(mysql_error());
session_start();
$user = mysql_real_escape_string($_POST['username']);
$pass = mysql_real_escape_string($_POST['password']);
$query = "SELECT username, password FROM USERS WHERE `username` = '$user' AND `password`='$pass' ";
$result = mysql_query($query) or mysql_error();
$row = mysql_fetch_assoc($result);
if( $username == $row['username']){
$_SESSION['username'] = $row['username'];
header('Location:index.php');
}else{
echo "this is wrong";
}
I'm just having a tiny problem with this function. the toggle function works fine but what I want to do is to display the date whenever particular buttons are clicked or active.
function showDate(element){
if(element == "#selection3" || element == "#selection4"){
document.getElementById("dateinput").style.visibility = "visible";
}else{
document.getElementById("dateinput").style.visibility = "hidden";
}
}
function toggle_element(element){s
$(element).toggle();
}
<input id="toggle_button" type="button" value="Number of players per game" onclick="toggle_element('#selection1');">
<div id="selection1" style="display:none;">
<div id="container1" style="width: 75%; height: 400px; margin-left: 1%; margin-right:10%; "></div>
<p></p>
</div>
<input id="toggle_button" type="button" value="Score vs Age" onclick="toggle_element('#selection2');">
<div id="selection2" style="display:none;">
<div id="container2" style="width:75%; height: 400px; margin-left: 1%; margin-right:10%; "></div>
<p></p>
</div>
<input id="toggle_button" type="button" value="Number of games played per day" onclick="toggle_element('#selection3');">
<div id="selection3" style="display:none;">
<div id="container3" style="width: 75%; height: 400px; margin-left: 1%; margin-right:10%; "></div>
<p></p>
</div>
<div id = "dateinput" >
Start Date:<input type="text" onfocus="showCalendarControl(this);" id = "start_date" name = "start_date" value = "2012-10-01" onchange= "">
End Date:<input type="text" onfocus="showCalendarControl(this);" id = "end_date" name = "end_date" value = "2012-10-25" onchange= "">
<input type="submit" value="Update" onClick= "graph_chosen()">
</div>
I want to display the date whenever selection 3 is active only. I'd appreciate quick help with this
Even though it is an easy task, we still need to have a look at your work you've done. I will get you started on that one. Next time, do post your code that you have trouble with.
for( int i=0; i<150; i++){
System.out.println("the output is " + i);
}
Try playing around with this snippet until you get your head around it. To explain it, the variable i starts at 0 and increases by one every time it enters the loop.
OK. Since the code isn't posted to see how things are structured, I can give a hint how you can achieve this.
I'm assuming you've set up your database tables and the script to retrieve the data from the tables. Store the data retrieved from the database in an associate array inside a function so it will be easy to call it in your other files. Then, access the indexed data that was stored in the array.
In your html code, you'd have something like this.
Apparently, you don't have a function called session_is_registered.In the case that it is defined in another file in the same directory, then add this line in the top of the page
One of the files contains about 3000 records or more. What is a possible way of importing them all into the database using SQL command line? Because it is time-consuming to go through each record and add this line "INSERT INTO table_name ........" to it.
I'm supposed to integrate different sources of data into one database. I am given these types of sources:
.txt
.csv
.html
.xls
access file as well.
what attributes should I be looking at to construct a global schema because all of them have different attributes? But I can say there are a few things in common between them like name, DOB, Country, CountryName.
A few hints on how to approach it will be good. Any useful website that illustrates or explains well the concepts would be awesome.
I'm just wondering how the read more feature is achieved in PHP. It is like facebook where it displays a couple of lines then if you're interested in reading more about the status or article click 'read more link' which expands the box.
I wanted to call a function from the xxx.php which let's assume has these functions:
function check_user($username, $password){
}
function delete(){
}
function log_out(){
}
None of these functions includes the header function to redirect users. So in my login.php after the valdiation is successful, users will be redirected to index.php
inside my login.php, I have something not simple like this though :)
The problem is that it concatnates the url from header function to the current url. So you're on login.php, it will add #index.php => login.php?#index.php
maybe unauthorised user finding an url like delete.php?id=3 in the browser history and changing IDs by hand or programatically
How could they do that? They don't have access to my files on the server.I guess if they try accessing delete.php?id=3, they will be rejected because a session is not set which means they need to log in.
@iamthwee... PHPacademy is my favourite youtube channel.
@blocblue.. Thanks for the reply. My answer is precise to the question. PHP code will NEVER run in HTML file unless technology has evolved ?? Just to be sure, I tested putting PHP code in HTML file that is living on web server. It didn't work.
@broj1.. Thanks for the suggestion. Tell me more about the security side. More on how to secure the app. Or even referring me to websites that you think useful..
You were checking if the username was equal to the boolean returned by isset(),
No way. This can't be true. Well, actually I was echoing a variable that was supposed to store the username value. But, it was giving 1 instead of the name of the user logged in.
Yeah, you're correct. I have included the file containing the functions.But in the form attribute 'action', I left it empty. I've just realised the first post wasn't so sensible. OK. I worte it really fast because I was in a hurry.
I'm just wondering if there is another of calling functions in a different php file without making the app run strangley. So what I have got are a few forms without specifying their action.
<?php
1- checking for the fields
2- if they are not empty and so on, a function in functions.php will be called then users will be redirected from this page not from the functions.php because I am using some functions in different ways.
?>
<form action="" method="post">
fields stuff
</form>
when I redirect users from login.php to index.php, it adds a hash at the end of the url. E.g localhost/login.php#index.php or something like this.
Is there a way I can solve this easily without specifying action for forms? or specify action to trigger the right function maybe?
Woot woot. That is ridiculous. Am I missing that simple logic? LOL at myself. BTW, I don't see so much difference between what I have done and what you've tweaked up there.
they sound pretty much the same. In my solution, if the user is set then do a little more checking to see if the username is equal to the username in the database.
Like simplypixie said, You won't be able to run PHP code within HTML files (e.g index.html) so the files have to be with the extension of .php (e.g index.php). The reason being is that you're telling the browser to interpert PHP code within HTML which doesn't make sense to the borswer. It will render it as a simple text. However, if you do it the other way around, it will render html code within your php file without any issue.
I hope this helps you a little. If you post your code here so we can have a look and tell you if it is broken or not.
@blocblue: why is that incorrect?
simplypixie commented: Much better explanation than mine :-)+7
With my script, I could call the decode_json function in php which basically takes an array and converts to JSON format. I was able to get the data passed to AJAX function in my JS. Although, the series object in highcharts didn't make sense so I didn't know how to pass the data to it.
That didn't work for me. I try checking if the username in a session is equal to the name in the database table, then they'll get the edit/delete buttons.
