Web Development Forum

SELECT blabla FROM a INNER JOIN b ON a.a = b.b Is what I have. However I'd like to sort the results DESC by ID. I'd like to select last [`variable` x 10] of items sorted by ID DESC. Variable provided by PHP (I'll sort things out, I just need …

Hello guys i need to get all currencies in the world is there anyone who knows where to get them in a file so i can import it in my website or someone who can help me to solve with regular expression here is the [WEBSITE](http://www.xe.com/currencytables/?from=INR) where i have fund …

`Unknown column 'topics.id' in 'field list'` `SELECT topics.id topicId,` [...] `topics.id` DOES exist.

What is the difference between following functions? Does these both functions perform same task? $wh_ope=clean($_POST['whop'])?(int)$_POST['whop'] : 0; $wh_ope=(int)clean($_POST['whop']); function clean($str) { $cstr=trim($str); $cstr=addslashes($str); $cstr=strip_tags($str); $cstr=htmlspecialchars($str); return $cstr; }

I'd like to start from the basics if I may please. I've read a few tutorial here and there and I've just created a test application with probably the simplest RPC calls you can possibly have (basically I want to use the RPC call to call a method to print …

I don't think it's code-bound, but here's the code: http://pastebin.com/yWJ5qpwN What happens is... I input 2 different passwords, line 22 is for some reason entirely skipped. The script passes every verification, the SQL record is added, and further execution of code happens. User gets logged in and moved to `index.php` …

i have a problem in showing two columns which is reff_number and Name in a combobox/select box, and now i can only display one column with it, if i have 9000 customer(in bahasa = pelanggan) , it will take an effort to find for user, and it will be easy …

Hi, I need help with the attendance form (index.php). When I tried to update the first row, nothing happened. For the last row, the message says, "**We couldn't update the attendance form at this time.**" Please check lines 96 and 101 to see if got any error. And also I …

I have purchased SMS gateway from one hosting company. How can i integrate my SMS gateway with my website?

I need to create about 1000 users, with random (but normal looking names not "293dsaf81s234" but "Blue Air" (can be random dictionary words)). And I need to generate topics and posts, and many others things. Does anybody know a good way on how to generate dummy content in PHP? What …

How I replace my eregi_replace with preg_replace expression? eregi_replace($word, '<font style="background:' . $color . '";>\\0</font>', $text); and I how do I check preg_replace function is executed or not?

Hi, i have was make small social network website and now i need to use RESTful API for hybrid application. Social network website i make in php, mysql. How to make API now? Do you have some tutorial for API that integrate in existing website? Thanks!

I have been working on this to replace every code that is shared on post in my website but is not working for me. I need everything that appear inside `<pre><code></code></pre>`to replay all the tags and give it a color using css. please if there is any simple way to …

I've created a new member for a website (that I'm making for myself) to see if it works and when I register, I can get in, but when I go to log in after, it won't let me log in and I can re-create the same member multiple times. The …

I am trying to pass a javascript variable into another function and keep getting undefined errors etc. In the first function I have chatName that I want to use as the display title only in the second function, you can see where I want it to appear in the div …

I am newbie to Angular Js. I am trying to use date range filter between two dates which will show the stock within that date. Here is my code. HTML Code: <div ng-app="myApp" ng-controller="myCtrl"> <div> <table> <tr> <td>Start Date</td> <td><input type="text" name="S_Date" ng-model="startDate"/></td> <td>End Date</td> <td><input type="text" name="E_Date" ng-model="endDate"/> </tr> …

I have the following code is asp.net <%@ Page Title="" Language="C#" MasterPageFile="~/Site02.Master" AutoEventWireup="true" CodeBehind="Tasks.aspx.cs" Inherits="DMS.Tasks" %> <%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %> <asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server"> <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server"> <div class="row-fluid sortable"> <div class="box span5"> <div class="priority high"><span>Assigned By Me</span></div> <div class="task high" runat="server" id="Task01"> <div class="desc"> <div class="title">Test 45</div> …

I have installed Node.js but without going deep into Node at this point all I want to do is use an optimizing tool for Node. The instructions are straight forward but they are not working. I'm hoping someone can help get me started, the tutorials I've watched haven't been helpful.

$city = "Amersfoort"; if ($stmt = $mysqli->prepare("SELECT District FROM City WHERE Name=?")) { $stmt->bind_param("s", $city); $stmt->execute(); $stmt->bind_result($district); $stmt->fetch(); printf("%s is in district %s\n", $city, $district); $stmt->close(); } This brings many questions: - What is `s` on the line 4? Do I need to bother with that? - What if I …

hi, all i am new in php developing i need to know how i could make a user data hidden or inactive to the viewer of my website without deleting this user data from my database can i do that using php code? if yes what is this coding criteria …

`INSERT INTO 'members' ('username', 'password', 'email') VALUES ('axe', 'axe', 'weql')` - `#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''members' ('username', 'password', 'email') VALUES ('axe', 'axe', 'weql')' at line 1`

Hi, In an excel file, I have 10 headings and that file contains more than 6000 records. I upload file using oleread.inc and excelreader file. It takes time to upload recods in table minimum 4 - 6 minutes. How to decrease the time and insert records in table fastly.

I'm getting two errors detailed below: Notice: Undefined index: username in C:\wamp\www\member.php on line 8 Call Stack # Time Memory Function Location 1 0.0006 131808 {main}( ) ...\member.php:0 ( ! ) Notice: Undefined index: passwd in C:\wamp\www\member.php on line 9 Call Stack # Time Memory Function Location 1 0.0006 131808 …

I have this code session_start(); $username = $_SESSION['username']; function getUserRole($username, $roleid){ $con=dbConnect(); $query="select * from user inner join userrole on user.id = userrole.userid inner join role on role.id = userrole.roleid where username = $username"; $sql=$con->prepare($query); $sql->bindValue(':username',$username); $sql->bindValue(':roleid',$roleid); $sql->execute(); $row = $sql->fetch(); $username = $row['username']; $roleid = $row['roleid']; if($row > 0){ …

I think this is called "foreign key" and "local key" ? I have a table `users`, these users have `rank`. It's an `int`. There is a table named `rank`, this table has field where hexadecimal string is placed `FF0000`. Is there a way to `SELECT * FROM users` and `SELECT …

Hi, I have a page for sending SMS by selecting anyone organization, By selecting organization, it will calculate how many customers are there to send SMS, It will display the SMS Count along with all managers names using JQUERY AJAX. For counting this value,it takes so much time in online, …

Sir, please help me to locate the error, if user not found or wrong user name password etc then all codes work fine but when I enter correct user name and password then no result. <?php session_start(); require_once("includes/connect.php"); require_once("includes/functions.php"); if(isset($_POST['login'])) { $muser=clean($_POST['username']); $mpass=clean($_POST['password']); if(empty($muser)) { echo ('<script type="text/javascript">alert("User name must …

Hi guys I was hoping you could help I would like to add 10000 records in mysql db.All once with after running a single php script. in one of the fields should generate 10000 rand generated numbers. Any suggests would really help. I was thinking of a for loop. [CODE] …

Hey everyone, I have a question. I have a web app where you have a table that will either update, delete, or add a user. The update works great but the delete is weird. It deletes just fine, but I ask for a confirmation first before the action is completed. …

I'm trying to do something, but it doesn't work out, the primary suspect is incorrect query, but I don't know whether it's correct or not. I could try running it in phpMyAdmin, but then I don't know how these are escaped. The result is: `array(5) { ["current_field"]=> NULL ["field_count"]=> NULL …

Sir I have these codes <!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" /> <META HTTP-EQUIV="Pragma" CONTENT="no-cache"> <META HTTP-EQUIV="Expires" CONTENT="-1"> <title>Stock</title> <style type="text/css"> html { overflow: auto; } body { font-family: Georgia, "Times New Roman", Times, serif; } #container { position: absolute; margin: …

i scan my invoice and i had 5 column item_no ,descrption ,qty,unit price, total Amount and ihave 20 rows i need to trans rows to excel file or .txt i need to help to make programm by vb.net or asp.net : scan the invoice then send data rows to table …

I know this is very basic but i am not able to get the fuction return a string. Instead it is returning the value 1. Below is the code: <?php function getUserRole($username, $roleid){ include "data.php"; $con=dbConnect(); $query="select * from user inner join userrole on user.id = userrole.userid inner join role …

Hi, I want to translate text from one language(eg, malay) to other languages(eg, english) in java/jsp . How to do this. Help me please. urgent! Thanks

My code here suppose to grab list of injection string from table:* injection_text*, column: *injection_code* and inject it at the tail of the URL's crawled by my program, the URL's crawled are stored table: *pages_crawl*. my program suppose to display the result of the injection. the purpose of this program …

Hey everyone, I have a question. I created a page that pop-ups when a user clicks a link and that page displays a table of the information that it pulls from the database that I have created. I want to be able to have a user click an update button …

Greetings! I am the freelance web designer doing projects in EU. I’ve done a lot of them for Envato. But recently it turned out that I might be a subject to EU tax authorities’ investigation, as well as thousands of other Envato authors in EU. I’ve described my problem on …

Hi, I'm trying to install Grunt with Node.js using this command and this is my first time using Node or Grunt so take it slow :-) $ npm install -g grunt-cli Each time I try to run the above code I get this error; I've searched online for the answer …

Hi, I have many records in my table minimum 3000k records. When I select SMS Page , it has two ajax pages, for calculation, So, the SMS Page is taking so much time to complete the task. I want to reduce the time of this page without affecting anywhere. How …

Hi I am trying to do the same thing. I would like to save the Facebook user timeline details OR messages in MySQL database. Timeline details are visible in screen total posts are like this http://screenshot.co/#!/2dcbee03ff , if I want to see the 'messages' only I can see in the …

Hi I have a php application which runs on an IIS Server and I want to create/append a file on an other server or PC Can I do it if I use fopen and I create a folder on that other server or PC which I grant write access to …

Hi all, I have a text box. When users press enter, it triggers the submit function: commentContent.keydown(function(e){ if(commentContent.is(":focus") && (e.keyCode || e.which) == 13 && !e.shiftKey) { e.preventDefault(); commentForm.submit(); } }); This then prepends the content of the text box into the HTML. `commentsHere.prepend(commentData);` However, when I search for this …

Sir I have follwing data var1= '5,487,256.36 ' var2= '245,868.48 ' How to get this sum with Js or with any other method. Basically I want to use it with PHP. var3= '5,733,124.84' Please

Hey everyone, I am trying to use JQuery to help me load a page on my page so that the user does not have to refresh or move to a new page. So far, I have the code so that the next page's contents will display, but the update button …

I am trying to create a table in html/php that is dynamic sized but allows users to edit rows of the table, I have 99% of this done and the last piece is to send edited values VIA ajax to an edit page where I update to the database and …

Hi, i recently created a bit of script to pull images from a database and display them horizontally using a scroll bar. i have now decided to try and integrate it with jquery to give it a bit of life. At first, i use the jquery plugin to use 5 …

Hi Everyone, I created a script where rows gets cloned, then I created a script to check if a specific code exists in the database. This all works fine. My problem is my status message when a code exist, it shows on the first row but not the rest. I …

I need to prevent this urls: index.php/test/ must be redirect to index.php index.php/test/test/ must be redirect to index.php I need this to be automatically, because i have multiple pages (index.php, team.php and etc...) Without bring the names of the pages in htaccess Important: i have this urls: index.php?page=5 (this need's …

form: <form> <table> <tr> <th>Subject</th> <th>Description</th> <th>Final Grade</th> <th>Remarks</th> </tr> <!-- You can loop this one, depends on the subjects. Subject must not be encoded. Baka lalagyan ng maling subject. I just base it to your design so naging ganito. --> <tr> <td><input type="text" name="grades[][subject]" id="grades[][subject]" value="" /></td> <td><input type="text" …