10,946 Topics
 | |
 | Hi all, I have to clarify a few ambiguites regarding mysql client to use for i running database scripts 1).Firstly i want to flush the root password set by me earlier using :mysqladmin -u root password 'root password goes here'. 2).Second i am faced with a problem of "Acces denied … |
| | unable to insert values into mysql table, only showing blank page. but after commenting mysql query code it's displaying echo $success part and not throwing any error message. code: if(!empty($_POST)) { // keep track validation errors $first_nameError = null; $last_nameError = null; $mobile_number1Error = null; $addressError = null; $magent_cityError = … |
| | Hi, am interfacing gps tracker TK106 with our online platform. The data we get from gps device is in this format (06667778889-9BP05000066677788899140815A0533.8206N00009.7045W000.0165936157.6200000000-L0000F51C) Instractions form [this site](http://sourceforge.net/p/opengts/patches/1/) explains the variours data sets in the string above, for example the first 11 digits 06667778889 is the device's programmable ID ,used in placed … |
 | studentmgt.php $search = $_GET['search']; echo $search; ?> <div align="center"> <div style="width:700px;text-align:left;padding-top:5px;"> <?php if (isset($confirmation)) { echo $confirmation; } ?> <form method="get" action="<?php $_SERVER['PHP_SELF'] ?>"> <br/> <?php //LOAD STUDENTS INFO $result = mysql_query("SELECT * FROM `student` INNER JOIN `group` ON group.group_id = student.group_id INNER JOIN `access` ON access.access_level_id = student.access_level_id ORDER …  |
 | Hi, The following code selects and displays a record from the "emailtbl" table as desired except for the the date and it doesn't update the "lastused" (date) field to the "numbers" table via "lastused.php" include. No error messages. I need help. <html><head> </head> <BODY> <?php include ("lastused.php"); include ("counter.php"); $id="''"; … |
| | hi, i have an import csv script but it does not get entered into the database. only "uploaded successfully" and the data is echoed but nothing in the database is something wrong with it? and is it sql injection safe? <?php if(isset($_SESSION['sess_user_id'])) { if (isset($_POST['ubmit'])) { require "connection.php"; $session = …  |
 | Hy io have this php script(if you can call php script) anyway i whant that every result to show it one down the another(mysql grid table) but with that kind of search....i've tryied but unf nothing.... this is the "code" <?php $i = 0; if ($_REQUEST["string"]<>'') { $search_string = " … |
| | How to create a JDBC for Oracle and MySQL?  |
 | This is my script when any registed user click on checkbox then he insert tbl1 table and we set a cookie and run events after 36 minute event will run and insert data in to another table called tbl2 my code is <form action="course01.php" method="POST"> <input type="checkbox" name="chk1" value="701" />I … |
| | is it possible to run a php script using mysql event if so how to do that i mean syntex thanks in advance. |
| | While pressing start button in control panel it's showing some problem detected. |
 | Hi, I need some help with my college work, with the database I am designing. # Assuming I want this to happen: # **Main Category:** Level1 Level1 >Level1.1 >Level1.2 >>Level1.2.a >>Level1.2.b >>>Level1.2.b.a >>Level1.2.b.a.a >>>Level1.2.b.b How do I design this? Thank you!  |
 | Hey guys, so I'm considering moving my mysql scripts to be compliant with PHP 5.5 and above (mysqli). Is it a pretty staightforward transition? Can functions basically just be replaced with the new verions, or are there other things that have to be done as well? Also, I'm interested to …  |
| | Look at my table design below. It is a table that shows the roles of users. CREATE TABLE `userrole` ( `userid` bigint(20) unsigned NOT NULL, `roleid` int(10) unsigned NOT NULL, PRIMARY KEY (`userid`,`roleid`), KEY `fk_userrole_roleid` (`roleid`), CONSTRAINT `fk_userrole_userid` FOREIGN KEY (`userid`) REFERENCES `user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE, … |
| | Hi all, i am hoping i will be able to get some quick help here. Ok i am basically building a web application where the user will be able to add,update,delete and edit fields in a database. So far i am on the Update part. I have a page called … |
| | This is my query : CREATE TABLE userrole ( userid BIGINT NOT NULL, roleid INT NOT NULL, PRIMARY KEY(userid,roleid), CONSTRAINT fk_userid FOREIGN KEY (userid) REFERENCES user(user_id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT fk_roleid FOREIGN KEY (roleid) REFERENCES role(role_id) ON DELETE CASCADE ON UPDATE CASCADE ) So, what i want … |
 | I have a table with highschools in different cities. I want to give the user the option to choose a certain city and view the schools there, or view all schools. This is my original query: SELECT * FROM highschools WHERE city = '$givenCity' I need to compare 'city' to …  |
| | Hi, I have a query that has a condition that count persons whose blood pressure, weight and height are calculated whose age is greater than 3. I have made this query and this query is working fine but there is a condition that if the age is greater then 2 … |
| | In reference to this: http://sqllessons.com/categories.html *Change parentid NULL to 0* Let's say I have 6 levels of subcategories. How do I have chained select dropdown based on the main category which has a 0 value under parentid, then show it's subcategoryLevel1 > SubcategoryLevel2 > and so on. Stops when there … |
| | I have developed an application and will like to synchronize it with the online version. Both has the same table sturcture. Can I get the script that will help me perform this task. |
| | Hey guys, so here's what I'm trying to do: I've made an HTTP script in the game Second Life, it uses an application/x-www-form-urlencoded url to send information to my Php script on my website. Here's the script: <?php define('DB_NAME', 'vangua01_access_list'); define('DB_USER', 'vangua01_admin2'); define('DB_PASSWORD', 'askljflnfldsakn'); define('DB_HOST', 'localhost'); $action=$_POST['action']; if($action == 'connect') … |
| | Hi guys i have an sql query string that in my view there is something wrong with it but i an handicaped since i am very new to sql so my question is, is there any way of optimizing this query string select t1.cat,t1.site from (select cat,site from news where … |
| | |
| | Hi, i found this code [online](http://www.macrostash.com/2011/09/17/demo-use-a-php-mysql-database-to-load-markers-on-a-google-map/#comment-2675). After installing and running code on my website, the screen shows nothing back, though code is firmly in place. <script type='text/javascript' src='jquery-1.6.2.min.js'></script> <script type='text/javascript' src='jquery-ui-1.8.14.custom.min.js'></script> <style> BODY {font-family : Verdana,Arial,Helvetica,sans-serif; color: #000000; font-size : 13px ; } #map_canvas { width:100%; height: 100%; z-index: 0; … |
| | Hi.. I want to call mysql Stored procedure with OUT parameter. Its worked in phpamyadmin But in php it returning empty result. I have used the following php script. Can anyone help me? <?php include("dbcon.php"); $countryname="india"; $rs1 = mysql_query( 'CALL countCountry($countryname,@totalcount)' ); $rs = mysql_query( 'SELECT @totalcount as totalcount' ); … |
 | I have a table called Report Card Table. In that table there is colum called expiry date. I would like to know everybody who's card is expring in less than or equal to 90 days |
| | Hey guys, so I've been having an errorwith Php/MySQL for a long time with something I'm trying to do. I posted it in the PHP section before I found this subforum, so I'm just going to place the link to it below. Was hoping maybe I'd have a better chance … |
 | Hello Pals... Help with this code...I am unable to hold Angularjs tag with Php variables $vid = "{{task.vid}}"; //this where the Errors comes in :( $s = $db->query("SELECT * FROM reply WHERE post_id_fk = '$vid'") or die($db->error.__LINE__); Please how can i go about this? Thank you! |
 | I want if the user clicks submit to return the the selected value when the form reloads that what I try and no luck <?php $getData = $db->prepare("SELECT * FROM first_university_degree_list"); if ($getData->execute()) { $res = $getData->get_result(); while ($data = $res->fetch_array()) { ?> <option value="<?php echo $data['univ_degree']; ?>" <?php if($FirstUniversityDegree … |
| | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <form action="#" method="post"> UserName: <input type="text" name="username"><br /> Passward: <input type="text" name="passward"><br /> Name: <input type="text" name="name"> <input type="submit" name="Submit" value="Sent"> </form> <?php $con=mysql_connect("localhost","root","","firstphp"); if(isset($_POST['Submit'])) { $UserName = $_POST['username']; $Password … |
| | Is there any software out there with GUI that i can use to install mysql and phpmyadmin on my vps account? Am new to vps,thx... |
| | Hello all, I am needing some guidance on how to build an array from POST Variables an then insert the data into mysql. Here is what I have M Variable from submitted form $parentid ="7638sds"; $child3_1_name =$_POST['chld3_1_name']; $child3_1_age =$_POST['child3_1_age']; $child3_2_name =$_POST['chld3_2_name']; $child3_2_age =$_POST['child3_2_age']; $child3_3_name =$_POST['chld3_3_name']; $child3_3_age =$_POST['child3_3_age']; $cnt="3"; $childrenContainer =" … |
 | i have three table i attached db files with query result i am getting. my query is below select tts.transaction_id,tts.service_type,tt.theme_name from transactions tts inner join users tu on tu.user_id=tts.user_id inner join themes tt where tts.user_id = 71 and tts.service_type in ('purchased','startup_service') group by tts.theme_transaction_id; i am not getting write theme … |
| | i have two postcodes entered by user. i format them validate and check if they do exist then i get postcode1's postal city name from mysql server. i have two districts both arrays one called innerLondon array and the second outterlondon array i fetch postal city name with my script … |
 | Hello all, My master master synchronization working properly but from yesterday after 4pm my sinking get stopped. My uplink working properly but downlink not working.I failed to found any issues. Please tell me why such master master get stopped and any solution for it. |
| | Hello, What's the latest mysql syntax to insert into 2 tables: "INSERT INTO student as t, study_report as s(t.group_id, t.access_level_id, t.stu_username, t.stu_fname, t.stu_lname, t.stu_email, t.stu_address, t.stu_telp, t.stu_hp, t.stu_wa, t.stu_skype, t.stu_facebook, t.stu_twitter, s.group_id, s.stu_fname, s.stu_lname) VALUES('".$group_id."','".$access_level_id."', '".$username."', '".$stu_fname."','".$stu_lname."', '".$stu_email."', '".$stu_address."','".$stu_telp."','".$stu_hp."','".$stu_wa."','".$stu_skype."','".$stu_facebook."','".$stu_twitter."', '".$group_id."', '".$stu_fname."','".$stu_lname."')"; I have an error appears: You have an error … |
| | I am trying to make a vehicle advertising website like autotrader or ebay. I am using html, css, jsp, java and mysql for the database.Basically I want the user to be able to search for a vehicle (advert) via a form, then they are directed to a results page after …  |
| | I have a question about how to set up a page in php to allow the user to create reports from a mysql database and display in a grid on the page. I want them to build the query and save it to the another table and list on their … |
 | After very little success in using JQuery .post methods I wanted to try asking this here before giving up. I am serving a couple JS based games on a site using PHP as members can log into the site and through sessions/cookies remain logged and play games under their account. …  |
 | Hi, I'm still very new to MySQL and I'm having some issues trying to generate the right set of results. I have two tables, that follow the structure as below: mod_site_content +----+-----------+--------------+ | id | pagetitle | content | +----+-----------+--------------+ | 1 | home | <p> ... </p> | | … |
 | i want to upload the employee profile picture into mysql database using php. i tried this coding. image uploaded successful but when i fetch that image on browser it shows me text character like this (ÿØÿà JFIFHHÿáLExifMM*bj(1r). one more problem is below 20kb size images only uploaded into mysql. how to …  |
| | i have the following sql query i seem to be having this error "Incorrect syntax near the keyword 'INSERT'" |
 | Hi All, I'm not sure if this is a technical issue, preference or a question about best form. I have a 'users' table and a 'contacts' table. 'users' and 'contacts' have no direct relation. Both contain an email address for each record in their own table. I want to send … |
 | Hi, i'm developing an app with python where I need to link it to MySQL? Can somebody tell me how I would do that? Anything would be gladly appreciated! |
| | Hi all, i would like to ask, if i have **3 tables in database** and i have a **search bar** in my web page to **search staff id** to update details. The staff id being searched in search bar is assume as **$search_id = $_POST['searchid'];** The 3 tables in database … |
| | Hi all ; please help me what is the expected problem in this code ??! function SearchGrid($query,$updateOk=FALSE,$DeleteOk=FALSE) { $tbl.="<script> var prev=1; function HighLightRow(rowno){ if (rowno%2==0) tblsearch.rows[prev].bgcolor='#66FF99'; else tblsearch.rows[prev].bgcolor='#CCCC99'; tblsearch.rows[rowno].bgcolor='white'; prev=rowno; } </script> "; $result=mysql_query($query); $tbl.="<table id=tblsearch align =center border=0 > <tr bgcolor=gray>"; $RowNum =mysql_num_fields($result); //name of field :) .... for($col=0;$col<$RowNum;$col++) … |
| | Is there another function for creating php sockets apart from this socket_create(AF_INET, SOCK_STREAM, SOL_TCP); ? Really need to know, thanks. |
| | how to convert this old fastioned mysql statements to pdo? <?php error_reporting(0); define("host","localhost"); define("user","root"); define("password",""); define("db","pass2"); $connect_db=mysql_connect(host,user,password) or die("cannot connect"); mysql_select_db(db, $connect_db); $username=strtolower(addslashes($_POST['username'])); $password=strtolower(addslashes($_POST['password'])); $sql="SELECT * FROM users WHERE username='$username' AND password='$password'"; $result=mysql_query($sql); $row=mysql_fetch_array($result); $count=mysql_num_rows($result); if($count==1 && $_POST['userlevel'] == "admin") { session_start(); $_SESSION['id']=$row['id']; header("location: admin.php"); } else if($count==1 && $_POST['userlevel'] …  |
| | Hello Guys, I coded the following and worked 100% perfectly but I want to do it ajaxly ! how to make all of this sending by ajax with animation(fadeIn,fadeOut) this my code: product.php url: product.php?id=4 <div id="product_page_desc"> <?php foreach ($products as $info) { ?> <div style="background:#fff;box-shadow: 0 0 1px #cd9db1;float: … |
| | Dear Everyone, I have a central Database which I want to spread across our regional offices for faster access and performance. Requirements: 1. A transaction that is effected in a regional office must be syncronized to the central database and vice versa. 2. The databases have primary keys auto-generated. There … |
The End.