10,940 Topics
| |
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 … |
The End.