10,940 Topics

Member Avatar for
Member Avatar for CarterLangley

Can never seem to get things to work! <?php if(isset($_POST['add'])) { $person_id = $_POST['person_id']; if (isset($_POST["cv"])) { $cv=1; } else { $cv=0; } if (isset($_POST["document_id"])) { $document_id=1; } else { $document_id=0; } if (isset($_POST["application_form"])) { $application_form=1; } else { $application_form=0; } if (isset($_POST["passport"])) { $passport=1; } else { $passport=0; } …

Member Avatar for CarterLangley
0
261
Member Avatar for mydreamgirl

I have applied indexes and analyzed my table, but query on select is still very slow. Anything else can I do to speed it up?

Member Avatar for cereal
0
77
Member Avatar for Alhussaini.Eng

**Hello Every body.** My toturial today how to make token input in the send data by form to the database by using php mysql it's so easily and useful . most people why use it or what's token take me to more secure. i answer : Did you ever think …

1
254
Member Avatar for CarterLangley

Hey guys, the code below is where I am having the problem. The error I am getting when trying to insert the record is *Could not enter data: Unknown column '3' in 'field list'* <?php session_start(); include("db_connect.php"); if(($_SESSION['user_id']) && ($_SESSION['access_level'] == 1 ) ) { ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD …

Member Avatar for CarterLangley
0
190
Member Avatar for prem2

Hi team, Kindly, clarify the below query, i am confused the difference between in and like statements in the mysql. mysql> select count(id) as tablename from postings where is_active=1 and publish in (2) ; result -- 38 mysql> SELECT COUNT(*) FROM tablename WHERE is_active=1 and publish like '%2%'; result -- …

Member Avatar for diafol
0
360
Member Avatar for Shft

Hi, I just recently started a website with the hope of connecting a program I made with the licensing database that I've already created. I have all the usernames and passwords I need. on a side note, I'm using Visual FoxPro 9. But each time I try to connect I …

Member Avatar for pritaeas
0
111
Member Avatar for amna zafar

I am displaying the complete record of the user in the My profile section, I am fetching all the rows , but the problem is within the rows I've got two fields as arrays, which are 'secondarySubject' and 'secondaryGrade' now I want the display to be something like this 2002-2004 …

Member Avatar for diafol
0
354
Member Avatar for zeemon

Hi, I need a master - master database configuration for a website wherein i need only a few tables to be in sync. All the links i tried on google give examples for full database replication. Does anyone know how to sync individual tables?

0
101
Member Avatar for amanu092

I want to develop a voip billing system in php and mysql. Do you gays able to help me by giving me some tutorial links.Or some technical suggestion as how to start and how can I do it final.Thanks all in advance for reading my query and trying to help …

Member Avatar for williamwalker
0
307
Member Avatar for nadiam

hey guys. so first of im kinda confused as to which forum i should post to but i hope you guys arent mad if this isnt the appropriate forum. moving on, i have these bunch of images that i want to be able to be displayed after a button click …

Member Avatar for diafol
0
3K
Member Avatar for joshmac

I have some code that I edited for importing csv into mysql using PDO to bind parameters. I thought it was working before, but tested it again and the issue I have is that only one line (the fourth line) of the csv file is getting imported. The first line …

Member Avatar for joshmac
0
373
Member Avatar for lukwagomedia

Hello everyone. I'm quiet new here and trying to get som helpÃ¥ from you guys. My main problem is that I have made a form which I want to use to post data to my database. But it seem to never work. Firsta problem was; everytime the page loads the …

Member Avatar for lukwagomedia
0
174
Member Avatar for nadiam

hey guys, so im not sure if this is the right forum, sorry if its not. anyway, i have to create a webpage that can do seating arrangements graphically. it would be like those seating plan softwares out there but this would be online. users can choose tables/chairs/etc which guests …

Member Avatar for nadiam
0
500
Member Avatar for johnsapante

I have a problem of creating mysql that return a single value, calculated from values in a column.what kinds of function i think to use?

Member Avatar for rch1231
0
201
Member Avatar for baloch123

Hi I have dropdown list of domain names.Which is populated by mysql query(1st query). And when dropdown value is selected that value is used in another mysql query(2nd query). I've a submit button,when it is clicked.It is working perfectly. But i want to remove submit button and i need a …

Member Avatar for diafol
0
18K
Member Avatar for rpv_sen

Hi i am using array for uploading images but i am unable to insert it into database as well as in the folder. can anyone please help me to resolve it. $name = $_GET['name']; $gititle = $_POST['gititle']; $number_of_file_fields = 0; $number_of_uploaded_files = 0; $number_of_moved_files = 0; $uploaded_files = $_POST[$_FILES['images']['name'][$i]]; echo …

Member Avatar for Rahman_1
0
327
Member Avatar for LRNPHP

Hi Everyone, I'm building an app that inserts data into table A, then I want a trigger to kick off before new data is inserted into table B to confirm that the value exists in column string_Value and then take the data and add it into TABLE C. Is this …

Member Avatar for diafol
0
222
Member Avatar for ethan.david.376

How can I generate a weekly report given an end date and a start date? How should the query be? I try this one but it's returning an error. "SELECT * FROM table WHERE date >= startdate AN date<='enddate GROUP BY WEEK BETWEEN startdate AND enddate"

Member Avatar for veedeoo
0
152
Member Avatar for anita_86

Hi, I am working on a script where I want to select parent id for a new user and save his parent id along with parents parent ids in mysql table. $last_id = mysql_insert_id(); //select parent id of last inserted user $sel = mysql_query("SELECT * FROM tbl_new_agent WHERE new_agnt_id = …

Member Avatar for EvolutionFallen
0
389
Member Avatar for nadiam

hey guys so this piece of coding is simple and straight forward but theres something wrong with it and its bugging me out because i can't figure out what the problem is. the error i get is this: You have an error in your SQL syntax; check the manual that …

Member Avatar for Assembly Guy
0
276
Member Avatar for nadiam

hey guys so basically what i want to do is populate a table with details from a database. That is part of the problem. When i write the php coding to do that the other elements on the webpage sort of disappear. Ill attach some screenshots to make it clearer. …

Member Avatar for nadiam
0
225
Member Avatar for CarterLangley

Hi all, I have a table which holds 130 companies and their related details. I have done the code to insert the information into the table when new companies come along. But now I need to display the existing information. I am looking at doing it using a form for …

Member Avatar for diafol
0
283
Member Avatar for dorkwad

Hi i'm looking to create a dynamic website that allows me to showcase my personal picture collection. I want a table in a MySQL database that has the fields: -Image ID -Image Name -Actualimage -Description -Date Added -Views then i want a PHP script that creates a page (i assume …

Member Avatar for asadjaved64
0
2K
Member Avatar for rpv_sen

Hi Friends I am trying to insert into my table. But i am getting an error message as below Notice: Undefined index: img_path in D:\xampp-portable\htdocs\cgoogle\entergoogle\addpages.php on line 21 Notice: Undefined index: img_path in D:\xampp-portable\htdocs\cgoogle\entergoogle\addpages.php on line 23 can any one please help me to resolve. **my code is** <?php if(isset($_POST['Submit'])) …

Member Avatar for rpv_sen
0
339
Member Avatar for urbanthistleuk

Hello, I am just after some information if anyone knows how to create a system in php that auto assigns a user at random when a record is logged in a mysql database I have been tasked to build a logging system for which uses a database to store the …

Member Avatar for urbanthistleuk
0
413
Member Avatar for paramesh23
Member Avatar for Wale Adegbite

I will appreciate if anybody can put me through how to convert project coded in PHP MySQL into standalone .exe

Member Avatar for diafol
0
78
Member Avatar for oanahmed

Hi Friends! I want to create a dynamic website. So, to create it I need to know PHP and MySQL. I went to [amazon.com](http://www.amazon.com) and searched for books. I was showed by results of **learning php and mysql**, **learning php** and **learning mysql** book names. I couldn't figured whether should …

Member Avatar for oanahmed
0
345
Member Avatar for Borderline

Hi I'm trying to create a page for a stallion showing his offspring. I used the distinct query in the hope of showing each of his children only once, but I'm assuming that because the other data in the row differs (there is a unique reference number called runid) the …

Member Avatar for Borderline
0
255
Member Avatar for Iikeloa

Hi I have this table name age John 14 Katy 14 Mark 15 and I want the number of rows where the age is equal to 14 , so in this example the result should be (2) but my problem is that I dont know how to start , so …

Member Avatar for urvisha
0
162

The End.