$(document).ready(function(){ $(‘input#receive’).click(function(){ $(‘input[type=text]’).each(function() { var input_value = $(this).val(); var input_id = $(this).attr(‘id’); alert(‘Value: ‘ + input_value + ‘, ID: ‘ + input_id); }); }); }); 1 solved Getting the id and values of a textbox [closed]
prepare() goes with execute() Prepared statements basically work like this: Prepare: An SQL statement template is created and sent to the database. Certain values are left unspecified, called parameters (labeled “?”). Example: INSERT INTO mtTable VALUES(?, ?, ?) The database parses, compiles, and performs query optimization on the SQL statement template, and stores the result … Read more
SELECT * FROM TableName WHERE dateColumn = CURDATE() CURDATE() returns current date with time set as 00:00:00. SQLFiddle Demo 2 solved MySQL – Most efficient way to select today’s date with time as 00:00:00 [closed]
One way of doing this is to filter your select by using a subselect in the where clause. I did this really fast just to demonstrate: select * from manufacturer m inner join manufacturer_has_product mhp on m.manufacturer_id = m.manufacturer_id inner join product p on mhp.product_id = p.product_id where m.manufacturer_id in ( select m.manufacturer_id from manufacturer … Read more
Warning: Invalid argument supplied for foreach() You should check that what you are passing to foreach is an array by using the is_array function If you are not sure it’s going to be an array you can always check using the following PHP example code: if (is_array($variable)) { foreach ($variable as $item) { //do something … Read more
str([Month])+ “-” +str([Year]) Create duplicate field and using str function to add the two fields. But this was not help has date field. solved Changing a date format
While most people would use a client to connect to the database-server and create a database and tables, it is not the only solution If your application is starting to get bigger, you might want to ‘migrate’ to a new version of your database. Using a script to perfrom this migration, even if it is … Read more
Here’s a good tutorial about converting deprecated mysql_* PHP code to new mysqli_* code: http://www.phpclasses.org/blog/package/9199/post/3-Smoothly-Migrate-your-PHP-Code-using-the-Old-MySQL-extension-to-MySQLi.html In many cases, you simply need to change “mysql” to “mysqli” for each function call. Remember to change them all! solved The following code returns an 500 error as the code is deprecited in php version 7, How to make … Read more
The problem is that you are getting multiple rows back and storing your id in one variable that gets overwritten every loop. I would recommend you create a class (if u are going the OO way) and add that to the list instead $sortedData = []; class Fotograf { public $Id; public $Firma; } // … Read more
Something like this: mi_page.php <?php if(isset($_POST[‘ebur’])) { $ebur = mysql_real_escape_string($_POST[‘ebur’]); $con=mysqli_connect(“ipaddress”,”user”,”passw”,”account”); // Check connection if (mysqli_connect_errno()) { echo “Falha ao receber moedas, informa o administrador com o codigo 445ebmds. ” . mysqli_connect_error(); } mysqli_query($con,”UPDATE account SET coins=”2000″ WHERE mi_field_on_the_table_account=”$ebur””); mysqli_close($con); } ?> <form method=”post” action =”mi_page.php”> <textarea rows=”4″ cols=”50″ id=”ebur” name=”ebur”> </textarea> <input type=”submit” value=”Enviar” … Read more
As you’re in your own words a noob there’s no time like the present to pick up some good habits 🙂 $email = $_POST[’email’]; $sql=”INSERT INTO users (email) VALUES (‘$email’)”; is a textbook example of an SQL injection vulnerability, and this code will bite you sooner or later. The reason is that you trust the … Read more
you are actually looking for _GET[‘message3’]variable.. do something like that $message = _GET[‘message3’] ; if(isset($message){ $sql = insert your $message variable in database here run the query } etc.. and you are done I assume that you are learning over your localhost and you got the file Sent.jsp solved How do I store the data … Read more
Use count(distinct): select salesname, count(distinct customername) as num_customers, count(*) as num_orders from t group by salesname; 2 solved count in mysql by each value [closed]
Consider this an example: First you have to extract those values using PHP. After the extraction, you can now present it on HTML. You can use a dropdown box (here in this example), to select which category you want to see. index.php <?php // use $_GET variable for your query $category = (isset($_GET[‘category’]) && $_GET[‘category’] … Read more
This is the problematic part: ‘$_SESSION[‘username’]’ Change this to: ‘” . $_SESSION[‘username’] . “‘ 2 solved Why is this giving me an error in PHP and MYSQL [closed]