39,320 Topics

Member Avatar for
Member Avatar for nova37
Member Avatar for pritaeas
0
90
Member Avatar for thecameraman

I am trying to create at user search for my website and I'm not sure where to start. My table name is users with user_id, user_name, name I'd like to be to search and have a page come up with the top 5 closest results. Sorry if this question has …

Member Avatar for thecameraman
0
581
Member Avatar for subrata_ushasi

Hi all, I have dropdown in html consisting value country name. Instead of entering country name one by one into the mysql table I want to transfer by php programming . Is it possible ? If so ,any one can suggest....... Thanks in advance. Subrata

Member Avatar for subrata_ushasi
0
145
Member Avatar for cartergarth

I have 2 tables: 1. users - user_id(PK), firstname, middlename, lastname 2. user_shift_schedule - shift_code(PK), user_id(FK), effectivity_date I want to get all rows with the latest effectivity_date for each user_id. This is what I've got so far: [CODE]SELECT users.user_id ,users.firstname ,users.middlename ,users.lastname ,user_shift_schedule.shift_id ,MAX(user_shift_schedule.effectivity_date) FROM users JOIN user_shift_schedule ON users.user_id=user_shift_schedule.user_id …

Member Avatar for cartergarth
0
265
Member Avatar for rahman86

hey everyone. i am creating a seating system using php. it is to determine which people to their seats in the event. the problem is if I want to visualize the position of the seating using pictures in php is it possible? if yes, how can i do this? The …

Member Avatar for rahman86
0
399
Member Avatar for nova37

[CODE] <?php // initiate curl and set options $ipin = '69.72.129.3'; $ch = curl_init(); $ver = 'v1/'; $method = 'ipinfo/'; $apikey = '100.hva7qa7893wzcsc3x8dk'; $secret = 'uHZVvYK5'; $timestamp = gmdate('U'); // 1200603038 // echo $timestamp; $sig = md5($apikey . $secret . $timestamp); $service = 'http://api.quova.com/'; curl_setopt($ch, CURLOPT_URL, $service . $ver. $method. …

Member Avatar for nova37
0
230
Member Avatar for Warl30ck

The error : syntax error, unexpected T_STRING But I checked all string objects and they worked separately.. [CODE]mysql_query("INSERT INTO downloadlogs(id, name, ip, time) VALUES('" . $Gid. "', '" . $nFile . "', '" . $IP . "', '" . date("l jS \of F Y h:i:s A") . "')")or die(mysql_error()); [/CODE] …

Member Avatar for vaultdweller123
0
298
Member Avatar for grant.baker

Hello all, I've been having an issue with php variables recently. I don't have much experience working with sessions, but I know that domain.com and [url]www.domain.com[/url] are viewed differently when working with sessions. The problem I have is with included files. I am calling .../logbook/header.php from ...logbook/Graphs/index.php. When I use …

Member Avatar for grant.baker
0
224
Member Avatar for s0bigg

I am using a php script for sending email alerts to a list of recipients that I have in MySQL. I want to automate the unsubscribe process for recipients because right now I have a static page where they have to manually enter their info. Since anyways I am calling …

Member Avatar for diafol
0
1K
Member Avatar for israillaky

I have a MySql database that uses a time field to track when the entry was inserted. Now I want to query the table for entries by a time range. I would prefer to use MySql to extract the records instead of extracting all records then iterating and comparing time …

Member Avatar for israillaky
0
717
Member Avatar for ARKaMAN

Hello, what am I doing wrong? It just errors out or posts blanks. [CODE]'$edate=implode('-', {$_POST['edate']})',[/CODE] Is the thing not working [CODE]<?php include_once 'resources/init.php'; $sql="INSERT INTO Client ( firstname, lastname, email, invoice, company, arenew, contact, wink, wint, wind, vtype, usera, yeara, sdate, edate, viprek, notes) VALUES ('$_POST[firstname]', '$_POST[lastname]', '$_POST[email]', '$_POST[invoice]', '$_POST[company]', …

Member Avatar for diafol
0
134
Member Avatar for HecGL35

Hello. I need some help in solving a php code project. I have a combo box field (months) that pulls all 12 months from a MYSQL table. The combo box is populated using php. I want to know how can I evaluate the value in the Select tag to do …

Member Avatar for diafol
0
174
Member Avatar for thedonedeal

I'm working on a Visual Basic application and would like to have it send its results (either an XML file or database rows) from the application to a database online for processing. I'm more familiar with MySQL/PHP but have no idea where to get started on with this. What I …

Member Avatar for thines01
0
113
Member Avatar for filipgothic

Can someone explina me this error on 42 I have to make Questionnaire with database so I made it like this but won't load site. here is code [CODE]<?php include 'config.php'; $err = array(); if($_POST['doAnketa'] == 'Anketa') { foreach($_POST as $key => $value) { $data[$key] = filter($value); } if(empty($err)) { …

Member Avatar for filipgothic
0
166
Member Avatar for BenzZz

Hi, The following code is working without errors: [CODE] <table> <tr> <td>Booking No.</td> <td>Driver Id</td> <td>Time Booked</td> <td>From</td> <td>Pick Up Time</td> <td>To</td> <td>No. of Passengers</td> <td>Distance</td> <td>Cost</td> </tr> <?php $stmt = $dbh->prepare("SELECT * FROM Booking WHERE cust_id = '$username' "); $stmt->execute(); while($row = $stmt->fetch(PDO::FETCH_ASSOC)){ echo "<tr><td>".$row['booking_no']."</td>". $row['driver_id']."</td>". $row['time_booked']."</td>". $row['pick_up_dest']."</td>". $row['pick_up_time']."</td>". …

Member Avatar for BenzZz
0
86
Member Avatar for microbert

Hi, I have a While Loop to display my MySQL info. This makes a list of all my data, in one row. But what I want is it to display it in a table with 5 columns so that the data is more readable. this is my code: [CODE] while …

Member Avatar for broj1
0
4K
Member Avatar for Yoong Sin Jie

I am a student , I dont know much for the php , I using the HTML ,PHP, XAMPP and MYSQL The 3 tier architecture normally are consider Model ,view and controller. For the part of controller , Normally how are you people coding , I really need help . …

Member Avatar for Yoong Sin Jie
0
276
Member Avatar for thecameraman

Hello I am trying to make a friend request system and I have it so it displays all the friend request and at the end there is a button that says "Yes" and one that says "No" I would like the Yes button to change "0" to "1" and No …

0
161
Member Avatar for Riteman

I know that php is same like HTML. I have the codings. But wondering how to execute it...? I use Dreamweaver but in vain.. i get no result.. some body pls help me.. It asks me to set a server for it. Though i set, no result obtained...!

Member Avatar for minitauros
0
200
Member Avatar for klemme

Hi, I want to get information from each session set, EXCEPT when the session name is 'navigation': So basically: Create an exception for the session called 'navigation'.. [CODE] foreach ($_SESSION as $name => $value) // $name = navn på session: f.eks. 1 eller 2 - $value indeholder antallet der er …

Member Avatar for pritaeas
0
921
Member Avatar for Aamit

Hi, I need some deep knowledge Regex Vs Dom. Is Regex much faster then Dom or not? Like processing speed, reliable or not . If any one share link or article it helpful for me.

Member Avatar for pritaeas
0
174
Member Avatar for PF2G

Hi, i'm doing a page where user can register and give up of a course: [CODE]<td width="5%"> </td> <td> PROGRAMAÇÃO: <br/> <?PHP $cc=$_GET['cod']; $sql_prog = "SELECT prog_curso FROM cursos WHERE cod_curso=".$cc; $query_prog = mysql_query($sql_prog, $connect); while ($row = mysql_fetch_array($query_prog)) { echo $row['prog_curso']; } ?> <br/> </td> <?PHP if(is_logged()) { ?> …

Member Avatar for pritaeas
0
150
Member Avatar for baig772

Hi all i want to check regular expression of a text field value i.e. it should not contain any '.,@' and other special characters except '_' and '-'. How can i write my rule in [code]preg_match()[/code] ?

Member Avatar for baig772
0
152
Member Avatar for subrata_ushasi

Hi all, I have a login page in localhost(website link : [url]www.csoftindia.net[/url]) . When I logged in it is showing alternate html "you are logged in as..." but when moving another page like news or other page session is lost either or it is not destroying session. Subrata

Member Avatar for baig772
0
632
Member Avatar for tamildinesh

i am used wkhtmltopdf for convert the web page to pdf. but i have a following error [CODE] **WKPDF couldn't determine CPU ("").**[/CODE] how to solve it, does any one know plz tel me how to solve it. Thank you

Member Avatar for diafol
0
107
Member Avatar for deyesborn

I am using mysql_fetch_array to fetch result from a table of my database and I want to exclude results from particular users from being fetch together with others. Example: [CODE]$result = mysql_query("SELECT * FROM users") or die(mysql_error()); echo "<table border='1' cellpadding='10'>"; echo "<tr> <th>ID</th> <th>First Name</th> <th>Last Name</th> <th>Sex</th> <th>Username</th></tr>"; …

Member Avatar for deyesborn
0
189
Member Avatar for anthonyjpv

I know that php can validate data input before querying to the database but which is more preferable by the developer or user experience? validation thru php? or validation thru javascript? whats your insight about this? thank you!

Member Avatar for anthonyjpv
0
134
Member Avatar for zidaine

hi i'm a newbie in php, plz help me with this. how can i put the value of my database to a textbox? can u give me a sample code.. thx...

Member Avatar for Persi
0
2K
Member Avatar for issaru07

i know this is a simple error but i just couldnt spot the error and i run the query seems fine. really appreciated... pleasee help Parse error: syntax error, unexpected '=' in D:\xampp\htdocs\book\admin-order-details.php on line 16 [CODE] <?php $objConnect = mysql_connect("localhost","root","boon84") or die(mysql_error()); $objDB = mysql_select_db("db-test"); $id = $_GET['id']; strSQL …

Member Avatar for issaru07
0
124
Member Avatar for elbeato

jQuery issue here. After calling some ajax, I'm having a problem getting a particular div to reload a php file. The only solution that I've come up with is to completely reload the page, but this is really undesirable, because this function is being used as part of a simple …

Member Avatar for elbeato
0
171

The End.