10,946 Topics
 | |
 | Hi Everyone, Can anybody suggest me. I have mysql with two database operations and production. My operations db have master master syncing on live server . I want to make production's master slave syncing onsame live server . Is it possible. How can do it?. Please help me. Thanks in … |
 | Inline Code Example HereI m working on a MLM project in which i have to store member automatically in binary tree form like 1 is root 2 is child of 1 3 is child of 1 Then 4 is child of 2 5 is child of 2 6 is child …  |
 | I am trying to create a mysql query that groups people and the ranks them. I use the following to rank them without the grouping and get that result: SELECT rank, performance, wind,athlete,dob,prov,pos,place,date FROM (SELECT performance, wind,name,surname,dob,prov,pos,place,date, @curRank := IF(@prevRank = performance, @curRank, @incRank) AS rank, @incRank := @incRank + …  |
 | hello everyone [{ "uid": "BR-M12068", "registeredDate": "Thursday May 11th 2017 03:56:37 PM", "file_path": "BR-M12068.pdf", "file_thumbnail_path": "BR-M12068thumb.png", "test_type": "Free", "title": "Medical Bills", "createdAt": "Thursday June 29th 2017 05:02:19", "chkTime": "Thursday June 29th 2017 05:01:53 PM", "chkoutTime": "Thursday June 29th 2017 05:02:29 PM" }, { "uid": "BR-M12068", /// first data "registeredDate": "Thursday … |
| | I am using the following mysql query: CREATE TEMPORARY TABLE temp_table ENGINE=MyISAM AS (SELECT age, performance, wind,name,surname,dob,prov,pos,place,date, @curRank := IF(@prevRank = performance, @curRank, @incRank) AS rank, @incRank := @incRank + 1, @prevRank := performance, CONCAT(name,' ',surname) AS 'athlete' FROM results p, ( SELECT @curRank :=0, @prevRank := NULL, @incRank := … |
 | **Am was already created form like this and working perfect but on last two forms not working, it displays warning-Undefined variable: reg_no and cost. Am trying to follow algorithm as previous forms but nothing happen. My goal is to update inserted data and here is my form** <?php @session_start(); if(!isset($_SESSION['b_lname'])){ … |
 | i want a private messaging system using php and mysql...someone plz help |
 | Hello Everyone. Please how can i make a Like button in PHP.. i want the button to be clicked. the button see the far i 've gone with the attachements... like feature starts from... line 84 - 107  |
 | |
| | Hello pls i am making a comment feature for my log. I want the comments to be submited from a form in the "READ_MORE.PHP" , and i want the form to be processed in a "COMMENT.PHP" page were the form values are insertrd in the Comment table... (which has 5 …  |
| | Hello all, I am stuck at some logic and can't able to find stuffs for my research.I have a web based data Entry app in php.Now there will be atleast 2 operators for data entry.now when they login they will redirected to same page.I fetch one file at a time.Here … |
| | Hi All, I am having a system which receive data from around 30K gps . Each unit will be inserting concurrently around 1 minute. 1.What tweak should I add to cater for this? I target my ram to be 48Gb with 24 cpus. 2. Once the data grow should I … |
 | Hello, I am trying to rename database MySQL: RENAME DATABASE old_db_name TO new_db_name; 1 kesalahan ditemukan dalam analisis. A rename operation was expected. (near "" at position 0) Query SQL: RENAME DATABASE wwwsoulf_revsoul TO wwwsoulf_revsoul2 MySQL menyatakan: Dokumentasi #1064 - You have an error in your SQL syntax; check the … |
 | Hi I have the following form at [http://test.genealogyresearchassistance.co.uk/newLinks.php](http://test.genealogyresearchassistance.co.uk/newLinks.php) The code is <form id="add" action="add.php" method="get"> <label for="name" id="name">Name of site</label> <input type="text" name="name" required="yes"><br/> <label for="link" id="link">Link of site</label> <input type="url" name="link" required="yes"><br/> <label for="desc" id="desc">A bit about the site</label> <textarea name="desc" required="yes"></textarea><br/> <label for="location"> Location:</label> <?php include 'database_conn.php'; $sql …  |
 | Hey, I have two columns. Ride and booking. In table booking there is the foreign key of ride. The intention is that 30-day and later bookings will be removed. If I run this query, I get the error message: mysql 1451 can not delete or update a parent row The … |
 | I am rather new to Normalization. I understand the concept of how it organizes the tables but I fail to see how I can use the data to show up correctly in my query using pdo. I have 3 tables: employees: id | name 1 user1 2 user2 2 user3 …  |
| | Hi, I'm back ^_^ Ok, I almost have this cute thing working. I know I am close but I have no idea how to get this working the right way. I am Left Joining a few tables and I want to filter the results after multiple values. ...... Ex: Options … |
| | I want to search a combination of values from any given field that has a list of items. Example: id | nume | denumiri_job 1 | my_list | chair,apple,snake,can How can I search for 2 or more elements from the field list? For example if I input in my search … |
 | Admin USERNAME: IT-1 PASSWRD: IT-1 Nw use index.php file t lgin. If an errr ccurs that “Multiple lgins nt allwed” then run errr.php and try again. 2. Nw yu will see the Accunt Details f Admin. 3. Fllwing ptins are available in the interface: Hme: My accunt: T view the … |
| | Am trying to create edit-form but there are some problem which I cant determine by my self. I cant echo inserted record and updating. <?php include("db_con.php"); $edit_reg_no = filter_input(INPUT_GET, 'edit_customer_detail', FILTER_VALIDATE_INT, ['options' => ['default' => NULL]]); if(isset($_POST['update'])){ $update_reg_no = $edit_reg_no; //getting the text data from the fields $d_fname = $_POST["d_fname"]; … |
| | Hello SQL Gurus, This Query below is doing the job but it is horrible slow. Is there any way to make the query faster ? Perhaps a join .. inner outer, left ? I am looooost. Thanks for any help. SQLQuery1.SQL.Clear; SQLQuery1.SQL.Text:= 'SELECT * FROM orders_batch WHERE invoice_no=:elorder_no'; SQLQuery1.params.parambyname('elorder_no').Asstring := … |
| | Hello all, i have been searching and now i am coming here to ask for some help. can i use a php function in bind_param? If so, how can i go about doing it? my function does have a return in it rather than an echo and when i echo … |
 | Am able to use this code to bind a.id = :auc_id in order to display certain result needed for menu code, but when i introduce it in the submenu i dont get any result below are the codes for menu and submenu' MENU works fine, display whats need to be … |
| | Hi not sure if this is possible so wanted some guidance.. I have a database with 3 columns.. id, data,timestamp id is auto increment and data is json array and timestamp is unix timestamp.. the field I wanted to update was data but I wanted to replace just a part …  |
 | hi guys, anyone can sauggest me which institutes are best to learn oracle in india . |
| | hello everyone , i have follwoing table structure check_id(pk) | user_id(fk) | check_in_time( timestamp ) | check_out_time( timestamp ) | is_checked_out(0 or 1) | checked_by | family_id now i want to calculate average of all checkIn and checkOut of user per day and then plot these data in graph this … |
 | I am using OS Ticket and I have another site for Members Area,I am trying to join the 3 tables that have the information that corresponds to the customer by EMAIL. the first table is:qbcd_ticket: ticket_id | number | user_id | user_email_id | status_id | dept_id | and more... 5 … |
 | Hi, Imagine there is a tbl called "users" and it has a column called "your blog url". Now, imagine you want to display that blog's url in an iframe on one of your pages. How would you code it ? I did the following but the iframe fails to load … |
 | I need to separate the questions to atleast up to unemployment and after clicking the button it will go to another page and it resume the user from answering the question.. Thanks in advance.. <?php include('connection.php'); ?> <?php session_start(); if(!isset($_SESSION['id']) || $_SESSION['privilege'] != 'user'){ if(session_destroy()) // Destroying All Sessions { … |
 | These are the options available in t_plan table id plan_name -- --------- 4 - free 5 - Gold 6 - Silver 7 - Platinum etc My object is to as user click on an option in the form it will populate the following input boxes next to select box from … |
 | Hi, I am new to this concept. I donot know how to make certain coulmns to be readonly , but when uploading it into server , I have to access that column value, I used this comment but it is not working. Here $avst is my excel file object. $avst->getActiveSheet()->protectCells('A5:D5', … |
 | First Input is No. of Kids. How to create Age Group field for each kid. e.g. If 1 is selected create 1 age group field. If 2 is selected create 2 Age group fields. And so on. **First Input** <select name=""> <option selected>No. of Kids</option> <option value="">1</option> <option value="">2</option> <option … |
| | I have a code that is working to show images and description. But I am trying to get it to loop through 3 pictures wide, then loop again. and display them, I am going to add pagination to the script, but before i do that i need it to loop. … |
| | I am working on creating a BEFORE UPDATE trigger which should display an error message if I UPDATE a student's EnrolledDate with a future date. For example, the last inserted EnrolledDate in the Student table is '2016-10-18', so any other record after that date should flag an error message saying … |
 | Hello, Recently I am starting to code my scripts in PDO method to manage the information in a mysql database. In this case I am having an issue how to use the best practice conditions when dealing with a POST **int** value. With the posted values I am making a … |
 | HELP HELP HELP!!! I need an assistant on a project am working on using php/javascript. Its a forced matrix. HOW DOES IT WORK? A person is automatically assigned three downlines without any referral based on id. Starting with the admin, lets say 100 persons register, three will be placed under … |
 | Only one of mysql databases stopped working. Unfortunately, it was the most important database: Table was marked as crashed and should be repaired. It happened on MySQL 5.6, and I don’t know how to overcome this error. I need to restore microsoft my sql 2000.  |
| | Hey everyone, I have a MYSQLI statement that i would like to add pagination to. I would like to have it set to 5 per page, and not have a negative value if you are on page 1 (disables back link) Every tutorial i have been seeing allows for a … |
 | Output PDF is overwrite, please solve this. advanced thanks <?php require('mysql_table.php'); class PDF extends PDF_MySQL_Table { function Header() { //Title $this->SetFont('Arial','',18); $this->Cell(0,6,'World populations',0,1,'C'); $this->Ln(10); //Ensure table header is output parent::Header(); } } //Connect to database mysql_connect('localhost','root',''); mysql_select_db('pro'); $pdf=new PDF(); $pdf->AddPage(); //First table: put all columns automatically $pdf->Table('select * from products'); … |
| | Ladies & Gentleman, Or should I say 'Gentle Ladies' and 'Hard Men' (tough guys)! :winky: Here is my very latest (New Code) reg.php. I have modified it by: * Removing outdated strip tags, mysqli_escape_string. * Bound input parameters on the user reg form. * Added htmlspecialcharacters code on output to … |
 | Actually the form below is a registration form, and i only have ' username, email, password and confirm password field' so i want to add another field name job, but keeps getting error. see the code below; if (!preg_match("/^[a-zA-Z ]+$/",$name)) { $error = true; $name_error = "Name must contain only … |
| | New Friends! :) The following is my member registration code as of latest. ISSUE 1: I get this error: Parse error: syntax error, unexpected '_' (T_STRING), expecting ',' or ')' in C:\xampp\htdocs\e_id\register_edited.php on line 10 What is wrong ? I copied the "'images/'_$FILES['avatar']['name']);" from a youtube tutorial on how to … |
| | Hi, i am beginer to codeignitor,i know how to write basic active queries in CI. i want to know how to write a query(having multiple conditions,double parentheses) in which supports CI. query is: $query="SELECT * FROM `apply_special_leave` WHERE ((`from_date` <= '$dt1' AND '$dt1' <= `to_date`) OR (`from_date` between '$dt1' AND … |
 | Im going through a tutorial online that would allow users to post status to their wall and to their friends but im getting the error : Warning: mysqli_query(): Couldn't fetch mysqli in /storage/h7/475/1137475/public_html/template_status.php on line 15 It is storing to the db but its not displaying on the user profile. … |
 | Hello everybody I'm looking for someone to help me about my problem, im trying to display user details after login with allow user to edit some fields . the user can edit these fields password repassword description address telephone email and these two fields not allow to edit only display … |
| | Guys & My Ladies, This LOGIN.php was working lastnight and so I don't know why not now. The ELSE at 53 gets triggered even though I have typed the right password! What do you think of line 16 ? ... if($numrows >1) I tried the following but no luck: if($numrows) if($numrows … |
| | I'm trying to build a script that adds multi entries into same single cell or mysql row. The script tries monitoring what you are browsing via the: <pre><input type="text" name="browse_url" size="120"></pre> and then record your viewed urls into the same row (position: 0), column: browsings like so: 1.com,2.com and so … |
| | Buds! How to code so php forces mysql to show only the final row of the column ? The followings are how I coded (2 copied youtube tuts) to show all rows to allow user to delete multiple rows: SAMPLE 1 [php] <?php session_start(); require "conn.php"; require "site_details.php"; ?> <!DOCTYPE … |
| | Programmer Experts, I'm embarking on an interesting project to gain work experience in php. Just stuck on one thing and wondering if you can help. You probably used Team Viewer. This is where I create a Team Viewer session and get a unique number and if I give you it … |
 | ive just done a simple register form where i can check username exists and before i put the username exists in the register works but when i have the username check in it doesnt work can someone check this over for me the script and error log are as follows: … |
The End.