10,942 Topics
 | |
| | [code=sql]DELIMITER $$ DROP PROCEDURE IF EXISTS `hrprocess_temp`.`sp_alltabinsert1` $$ CREATE DEFINER=`invensis`@`%` PROCEDURE `sp_alltabinsert1`(empid varchar(10),fname varchar(45),lname varchar(45), fathername varchar(30),dob varchar(20),gender varchar(6),maritalstatus varchar(9),spousename varchar(15),children varchar(8), commadd varchar(250),permadd varchar(250),mobileno varchar(15),landlineno varchar(15),email varchar(40), languages varchar(25),nationality varchar(25),bloodgroup varchar(5),drivingno varchar(20),panno varchar(15), passportno varchar(15),imagepath varchar(100),resumepath varchar(1000),skill varchar(250),deptname varchar(30), Course varchar(20),Specialize varchar(35),institute varchar(25),PassYear varchar(10), Organization varchar(25),Designation varchar(25),FromDt varchar(15),ToDt varchar(15),ReasonsChange …  |
| | please help me it usually gives me error ( it says cant enter the values ) [CODE] <?php $host = "localhost"; $con = mysql_connect("localhost","awah","password") or die ("error to connect to the server"); // contact the table and enter the form mysql_select_db("kigalifinders_clanteam_admin", $con); $query = mysql_query("INSERT INTO contacts(from, subject, message) value('$_POST[email]','$_POST[subject]','$_POST[messgae]')"); … |
| | I'm trying to write some php that will allow a user to edit an order they previously placed. But in the same way they made the order if that makes sense. So this is my jQuery code to send values to a php page: [CODE]$('#submit').live('click',function(){ var postData = {}; postData['data[order_id]'] …  |
| | I'm trying to teach myself a bit more php/mysql so that I can implement better usability on my osCommerce site. I've set up a bit of space on the web server and the db server so that I can play about with stuff and I'm close to doing what I … |
| | hay gays i want to retrieve xml data from three table stored in mysql. i used the below code it works fine but first it retrieve one record from first table than iterate to second table and print the whole table and then iterate to third table and print the …  |
| | Hi i'm new to php and i'm developing one admin tool which involves a form. The form involves more database interaction. My main interest with this form is to upload images to database with file system which i'm able to do. My form consists of fields like..... "Photo Taken by","Number … |
| | Hey guys, In my DB, i've got appointments set, and i need to select all appointments which are an hour or less away. For example i want to do something to the following (Dont worry, i know this wont work as is) [CODE]SELECT * FROM timetable WHERE time has one … |
| | hi all, i am trying to create a room booking system in php. now i want to check if a period exists within a given month. i ask the user for the month and how many days they want to come, now i want to look in mysql (where i … |
| | Hello! I've made a site called 'About us' on norwegian it means 'omoss' in my code;) But when i am displaying my code the hole page is white! I can't find the error. Can someone pleas help me? [CODE]<?php include('connect.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"> …  |
| | PHPMYSQL - How do you perform a double SELECT query or check against multiple fields? Does anyone know how this can be achieved? What i want is from a search page that has multiple search areas such as name / description / functions and be able to type multiple search … |
| | Hi, I am trying to get a live search facility working but my code is not working, I was wondering if someone could help me out and see if there are any mistakes or things I can change: Index.php [CODE] <form id="jobSearch" method="get" action=""> <input type="text" id="searchJobs" class="JobSearchBox" name="z" onkeyup="showResult(this.value)" … |
| | I'm looking to re-order a table while keeping the table's id column constant. ie, Links has entries in no particular order, whereas LinksPopular is a duplicated table but I want it ordered by category X, while leaving the id category unchanged. That way the first most popular is at id … |
| | I have a query which generates an xml file from data collected. There are 2 columns in the data (reason, TotTime) but they are joined together into one column using the concat command. Currently the results are ordered by reason, but I want to limit my results to only the … |
 | So let me start by saying I am new to PHP so any extra advice is helpful, working on a large scale personal project hoping to get better with PHP because of it. Now I have a script that displays my database just as I like, and next to each … |
| | I am having huge trouble with this Mysql_real_escape_string to prevent SQL Injection. I have tried everywhere possible to input it in my code. My code looks a lot different than most peoples. I mean my login/registration system works PERFECT.. besides that it's not protected from SQL Injection yet which is … |
| | how is MYSQL works and i want to know how set up database table with MYSQL |
| | |
| | Hi All, I need to use the results of this query as an array to exclude files from a tree. The file and folder names that I enter into $exclude work fine but I can not seem to add the results from the query to the array. Below is the … |
| | Hey everyone.. I am relatively new to PHP and JS and I need help. I need to populate a dropdown list from a db(mysql). I can do it just with PHP. The problem arises when I add another of the same dropdown to my form using javascript. I need the … |
| | hey everyone i need your help i want to create a mailling list in php and mysal but i dont know how to do it , so please if you know how to do it please tell me or if you know where i can get it also tell me … |
 | Hi, I am developing a program which requires access to my websites' MySQL. I keep getting errors trying to connect to it. My firewall is allowing the connection but MySQL won't accept it. How can I solve this problem? Thanks in advanced Kieran :) |
| | Hi * I have spent the last 18 hrs or so trying to get the wright sql code or think of an alternative but I just can't get my head around it. If any one can help me it would be awsome. What I am trying to acheive is getting … |
| | Hey everybody, I'm new to PHP, and am having a seemingly simple problem, (Probably a stupid error on my part, atleast I really hope so) I hope you can help me deal with this, and to say thanks for any efforts, I will build 1,000's of backlinks for you, for …  |
| | Hi all, I want to ask how i insert the selected data (Institution Name) and the input text data (School name) into MYSQL?? Thanks~ my database as below: [CODE=SQL]-- -- Database: `inno_education` -- -- -------------------------------------------------------- -- -- Table structure for table `institution` -- CREATE TABLE IF NOT EXISTS `institution` ( … |
| | oh hey guys, i got this little issue where i can read from the database. but i cannot write to it.. here be my full code. live site at [url]http://downloadavirus.net[/url] [CODE]<?php $params = $_SERVER['QUERY_STRING']; $url = $_POST["url"]; $username = "--------"; $password = "--------"; $database = "--------"; mysql_connect(localhost, $username, $password); @mysql_select_db($database) … |
| | Im Writing a c# Code that Takes an Excel Sheet ,creates the Corresponding SQl table and Dumps the data in a new table in SQL. Now My problem is: In the " create table" command , i have to specify the DATATYPE for the column !i.e. CREATE TABLE "table_name" ("column … |
| | Hi, My sql database contains a video table which has a video 'adddate' field. I need to change the code [COLOR="Red"].$video['adddate'].[/COLOR] from the following format: 2010-11-02 to 11-2010 I've changed it in .tpl files doing the following: {assign var='vidMthYr' value=$videos[i].adddate} {$vidMthYr|date_format:"%m-%Y"} However that does not work in my .php code … |
| | Hi guys, I'm trying to create the simplest of databases. The database needs all the standard tasks, such as: add record, delete record, show all records. I need this accessible on the internet, so anyone can check it out. I will probably put it in a password protected directory, unless … |
| | Hi, This code is from an older thread. I'm want to use the code, but I'm having some difficulty with the MySQL table creation. Here's the code: [CODE]<? session_start(); require("connection.php"); if(isset($_POST['submit_btn_name']) && $_POST['submit_btn_name']!='') { $title = mysql_real_escape_string($_POST['title']); $date = mysql_real_escape_string($_POST['date']); $author = mysql_real_escape_string($_POST['author']); $type = mysql_real_escape_string($_POST['type']); $description = mysql_real_escape_string($_POST['description']); $vidName … |
| | Hi, I have a table `Categories` with fields (category_id, category, parent_category_id) I want to write in a single query to replace the parent_category_id with the corresponding category_name. [CODE] // OBJECTIVE: To return all category names and parent category names // if category is root (no parent), parent category name is … |
The End.