10,940 Topics

Member Avatar for
Member Avatar for seularts

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 …

Member Avatar for diafol
0
6K
Member Avatar for mario_5

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 …

Member Avatar for rproffitt
-1
243
Member Avatar for Mhecha

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"]; …

Member Avatar for Mhecha
0
447
Member Avatar for ppohlmann

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 := …

Member Avatar for ppohlmann
0
374
Member Avatar for michael.dewitt.716

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 …

Member Avatar for michael.dewitt.716
0
553
Member Avatar for david_105

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 …

Member Avatar for david_105
0
564
Member Avatar for t_thakar

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 …

Member Avatar for cereal
0
277
Member Avatar for mahe_1
Member Avatar for rproffitt
0
136
Member Avatar for KaleBeatroot

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 …

0
247
Member Avatar for patk570

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 …

Member Avatar for cereal
0
405
Member Avatar for UI

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 …

Member Avatar for diafol
0
2K
Member Avatar for Christian_10

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 { …

Member Avatar for diafol
0
315
Member Avatar for Arjun_9

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 …

Member Avatar for rproffitt
0
1K
Member Avatar for Antony Rayan

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', …

Member Avatar for rproffitt
0
216
Member Avatar for Vishal_19

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 …

Member Avatar for diafol
0
323
Member Avatar for patk570

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. …

Member Avatar for patk570
0
440
Member Avatar for Daron_1

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 …

Member Avatar for AndrisP
0
214
Member Avatar for developer707

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 …

Member Avatar for cereal
0
358
Member Avatar for JOSHUA_19

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 …

Member Avatar for rproffitt
-2
485
Member Avatar for Diogo_2

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.

Member Avatar for erichton
0
392
Member Avatar for patk570

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 …

Member Avatar for patk570
0
659
Member Avatar for Jack_20

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'); …

Member Avatar for Kevin_28
0
4K
Member Avatar for UI

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 …

Member Avatar for UI
0
387
Member Avatar for Lord_2

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 …

Member Avatar for diafol
0
330
Member Avatar for UI

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 …

Member Avatar for UI
0
337
Member Avatar for shashigowda

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 …

Member Avatar for diafol
0
353
Member Avatar for Teri_1

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. …

Member Avatar for diafol
0
1K
Member Avatar for hani_1

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 …

Member Avatar for rproffitt
0
1K
Member Avatar for UI

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 …

Member Avatar for diafol
0
352
Member Avatar for UI

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 …

Member Avatar for UI
0
358

The End.