Jump to content

Makwana Prahlad

Members
 View Profile  See their activity

  • Posts

    77

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Everything posted by Makwana Prahlad

  1. Makwana Prahlad
    Hello, @charuswapna Please try this query ,To Any and All keywords Syntax of Any: SELECT column-names FROM table-name WHERE column-name operator ANY (SELECT column-name FROM table-name WHERE condition) Syntax of All: SELECT column-names FROM table-name WHERE column-name operator ALL (SELECT column-name FROM table-name WHERE condition) I hope this query will be useful. Thank you.
  2. Makwana Prahlad
    You can use the HTML download attribute to specify that the target will be downloaded when a user clicks on the hyperlink. <a href="/images/myw3schoolsimage.jpg" download> <img src="/images/myw3schoolsimage.jpg" alt="W3Schools"> </a> https://www.w3schools.com/howto/howto_html_download_link.asp
  3. Makwana Prahlad
    Start by installing the package: npm install html-docx-js --save Next, include it in your code: const htmlDocx= require('html-docx-js'); Now we just need some HTML to convert. Commonly, you might have rich text editors that allow you to capture rich content from users, and this content is stored in a database with HTML intact. It's just a matter of you pulling that content out of the database and passing it to the module's function. For example, let's say you're pulling records from a database table, and you want to combine the content areas, and then push that out to the browser as a download. Note: I'm using Express as the front-end JavaScript framework here. app.get('/course/:name/:id'), async (req, res) => { const { name, id } = req.params; const pages = await getCoursePages(id); let html = ''; for(let i = 0; i < pages.length; i++) { html += pages[i].page; } const docx = htmlDocx.asBlob(html); res.setHeader('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); res.setHeader('Content-Disposition', `attachment; filename=${ sluggify(name) }.docx`); res.setHeader('Content-Length', docx.length); res.send(docx); }); In the above code, you can see that we simply loop over the records from the getCoursePages() method, and concatenate the page property of the individual record. Once we have this concatenated string (which contains HTML), we pass it to the asBlob() method of the html-docx-js package. This creates the necessary Microsoft Word DOCX format, and once you have that, you can send it to the browser after setting the appropriate headers.
  4. Makwana Prahlad
    Hello, @Antonio Testa Please try this code,To Script does not work as expected !!! Move the following code from the <head> to just above the closing </body> tag <script type="text/javascript"> var c = document.id('right_column').getElement('#float_block'); if (window.getSize().x < 1260 /*|| (c && t > p)*/){ document.id('float_block').inject(document.id('float_block_default')); } else{ if (!c) document.id('float_block').inject(document.id('right_column')); } </script> I hope this code will be useful. Thank you.
  5. Makwana Prahlad
    try this <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <style> body { margin: 0; font-family: Arial, Helvetica, sans-serif; } .topnav { position: relative; overflow: hidden; background-color: #333; } .topnav a { float: left; color: #f2f2f2; text-align: center; padding: 14px 16px; text-decoration: none; font-size: 17px; } .topnav a:hover { background-color: #ddd; color: black; } .topnav a.active { background-color: #4CAF50; color: white; } .topnav-centered a { float: none; position: absolute; top: 50%; left: 50%; transform: translate(-50%, -50%); } .topnav-right { float: right; } /* Responsive navigation menu (for mobile devices) */ @media screen and (max-width: 600px) { .topnav a, .topnav-right { float: none; display: block; } .topnav-centered a { position: relative; top: 0; left: 0; transform: none; } } </style> </head> <body> <!-- Top navigation --> <div class="topnav"> <!-- Centered link --> <div class="topnav-centered"> <a href="#home" class="active">Home</a> </div> <!-- Left-aligned links (default) --> <a href="#news">News</a> <a href="#contact">Contact</a> <!-- Right-aligned links --> <div class="topnav-right"> <a href="#search">Search</a> <a href="#about">About</a> </div> </div> <div style="padding-left:16px"> <h2>Responsive Top Navigation with Centered and Right-Aligned Links</h2> <p>Resize the browser window to see the responsive effect.</p> </div> </body> </html> For more information follow link https://www.w3schools.com/howto/tryit.asp?filename=tryhow_css_topnav_centered
  6. Makwana Prahlad
    Hello,@Lisa67000 Please try this code,To sortable table rows $(function() { $( "tbody" ).sortable(); }); table { border-spacing: collapse; border-spacing: 0; } td { width: 50px; height: 25px; border: 1px solid black; } <link href="//code.jquery.com/ui/1.11.1/themes/smoothness/jquery-ui.css" rel="stylesheet"> <script src="//code.jquery.com/jquery-1.11.1.js"></script> <script src="//code.jquery.com/ui/1.11.1/jquery-ui.js"></script> <table> <tbody> <tr> <td>1</td> <td>2</td> </tr> <tr> <td>3</td> <td>4</td> </tr> <tr> <td>5</td> <td>6</td> </tr> <tr> <td>7</td> <td>8</td> </tr> <tr> <td>9</td> <td>10</td> </tr> </tbody> </table> I hope this code will be useful for you. Thank you.
  7. Makwana Prahlad
    Hello,@jamesadrian Please try this code,To Audio Controls <!DOCTYPE html> <html> <body style="text-align: center"> <audio id="Test_Audio" controls> <source src= "https://media.geeksforgeeks.org/wp-content/uploads/20190531165842/Recording1514.ogg" type="audio/ogg"> <source src= "https://media.geeksforgeeks.org/wp-content/uploads/20190531165842/Recording1514.mp3" type="audio/mpeg"> </audio> </body> </html> I hope this code will be useful for you. Thank You.
  8. Makwana Prahlad
    Hello, @lodyne Please try this code,To If Else using ternery operator. public class testpls { public static void main(String[] args){ int time=22; System.out.println(time<=18 ? "Good day. " : time<=22 ? "Good Evening." : "Good Night.." ); } } I hope this code will be usefull for you. Thank You.
  9. Makwana Prahlad
    try it <select> <option style="background-image:url(male.png);">male</option> <option style="background-image:url(female.png);">female</option> <option style="background-image:url(others.png);">others</option> </select>
  10. Makwana Prahlad

    HTML

    Makwana Prahlad replied to Stella's topic in HTML/XHTML

    code is perfectly fine please check your image name or image type like jpg, png, gif, etc... thank you <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> </head> <body> <img src="life-set-life.jpg" alt="image not show"> </body> </html>
  11. Makwana Prahlad
    Hello, @unaumamicorn Please try this code,To Why do we have to create a new object to get user input but not use Scanner.nextLine() directly? Think of the class Scanner as a blueprint. It can read data input from not only the Keyboard, but also Files, and other Sources that have InputStreams, like a network connection. Due to its varied uses, Scanner has to be told which source to read from. import java.util.Scanner; public class ScannerDemo1 { public static void main(String[] args) { Scanner sc = new Scanner(System.in); String name = sc.nextLine(); char gender = sc.next().charAt(0); System.out.println("Name: " + name); System.out.println("Gender: " + gender); } } System.in tells the scanner to read the data from the keyboard. You could provide a file or another InputStream and the Scanner read from there. I hope this information will be usefull for you. Thank you.
  12. Makwana Prahlad
    <html> <head> <!-- Notice how the data-search-pseudo-elements has no explicit value. This sets it to "true". --> <script src="https://use.fontawesome.com/releases/v5.13.0/js/all.js" data-search-pseudo-elements ></script> </head> <body></body> </html>
  13. Makwana Prahlad
    Hello ,@hamedamini846 Please try this code,To javascript example of calculator. <html> <head> <script> function dis(val) { document.getElementById("result").value+=val } function solve() { let x = document.getElementById("result").value let y = eval(x) document.getElementById("result").value = y } unction clr() { document.getElementById("result").value = "" } </script> <style> .title{ margin-bottom: 10px; text-align:center; width: 210px; color:green; border: solid black 2px; } input[type="button"] { background-color:green; color: black; border: solid black 2px; width:100% } input[type="text"] { background-color:white; border: solid black 2px; width:100% } </style> </head> <body> <div class = title >GeeksforGeeks Calculator</div> <table border="1"> <tr> <td colspan="3"><input type="text" id="result"/></td> <!-- clr() function will call clr to clear all value --> <td><input type="button" value="c" onclick="clr()"/> </td> </tr> <tr> <td><input type="button" value="1" onclick="dis('1')"/> </td> <td><input type="button" value="2" onclick="dis('2')"/> </td> <td><input type="button" value="3" onclick="dis('3')"/> </td> <td><input type="button" value="/" onclick="dis('/')"/> </td> </tr> <tr> <td><input type="button" value="4" onclick="dis('4')"/> </td> <td><input type="button" value="5" onclick="dis('5')"/> </td> <td><input type="button" value="6" onclick="dis('6')"/> </td> <td><input type="button" value="-" onclick="dis('-')"/> </td> </tr> <tr> <td><input type="button" value="7" onclick="dis('7')"/> </td> <td><input type="button" value="8" onclick="dis('8')"/> </td> <td><input type="button" value="9" onclick="dis('9')"/> </td> <td><input type="button" value="+" onclick="dis('+')"/> </td> </tr> <tr> <td><input type="button" value="." onclick="dis('.')"/> </td> <td><input type="button" value="0" onclick="dis('0')"/> </td> <td><input type="button" value="=" onclick="solve()"/> </td> <td><input type="button" value="*" onclick="dis('*')"/> </td> </tr> </table> </body> </html> I hope this code will be usefull for you. Thank you.
  14. Makwana Prahlad
    //I hope help you @debis public class ArraysInJava { public static void main(String[] args) { //declaring and creating An array object of double type containing 8 elements double[] d = new double[8]; d[2] = 10.25; //Changing the value of element at index 2 d[5] = 15.35; //Changing the value of element at index 5 methodOne(d); //Passing array to methodOne() //Changes made to array object in the method are reflected in the actual object System.out.println(d[2]); //Output : 25.32 System.out.println(d[5]); //Output : 45.89 } static void methodOne(double[] d) { d[2] = 25.32; //Changing the value of element at index 2 d[5] = 45.89; //Changing the value of element at index 5 } }
  15. Makwana Prahlad
    if(isset($_POST) and $_SERVER['REQUEST_METHOD'] == "POST"){ // Loop $_FILES to exeicute all files foreach ($_FILES['image1']['name'] as $f => $name) { if ($_FILES['image1']['error'][$f] == 0) { if ($_FILES['image1']['size'][$f] > $max_file_size) { $message[] = "$name is too large!."; continue; // Skip large files } elseif( ! in_array(pathinfo($name, PATHINFO_EXTENSION), $valid_formats) ){ $message[] = "$name is not a valid format"; continue; // Skip invalid file formats } else{ // No error found! Move uploaded files if(move_uploaded_file($_FILES["image1"]["tmp_name"][$f], $path.$name)) //Write insert query here. image name $_FILES["image1"]["name"][$f] } } } }
  16. Makwana Prahlad
    Hello , @Sigmahokies Please try this code ,To Images in array public class DeckOfCards extends Applet { public void init() { Image[] clubs = new Image[13]; for (int i = 0; i < clubs.length; i++ ) { clubs[i] = getImage( getDocumentBase(), "c" + (i + 1) + ".gif"); } ... } } I hope this code will be usefull for you. Thank you.
  17. Makwana Prahlad
    Hello , @Fellucca Please try this code,To Tab Menu <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <style> body {font-family: Arial;} .tab { overflow: hidden; border: 1px solid #ccc; background-color: #f1f1f1; } .tab button { background-color: inherit; float: left; border: none; outline: none; cursor: pointer; padding: 14px 16px; transition: 0.3s; font-size: 17px; } .tab button:hover { background-color: #ddd; } .tab button.active { background-color: #ccc; } .tabcontent { display: none; padding: 6px 12px; border: 1px solid #ccc; border-top: none; } </style> </head> <body> <h2>Tabs</h2> <p>Click on the buttons inside the tabbed menu:</p> <div class="tab"> <button class="tablinks" onclick="openCity(event, 'London')">London</button> <button class="tablinks" onclick="openCity(event, 'Paris')">Paris</button> <button class="tablinks" onclick="openCity(event, 'Tokyo')">Tokyo</button> </div> <div id="London" class="tabcontent"> <h3>London</h3> <p>London is the capital city of England.</p> </div> <div id="Paris" class="tabcontent"> <h3>Paris</h3> <p>Paris is the capital of France.</p> </div> <div id="Tokyo" class="tabcontent"> <h3>Tokyo</h3> <p>Tokyo is the capital of Japan.</p> </div> <script> function openCity(evt, cityName) { var i, tabcontent, tablinks; tabcontent = document.getElementsByClassName("tabcontent"); for (i = 0; i < tabcontent.length; i++) { tabcontent[i].style.display = "none"; } tablinks = document.getElementsByClassName("tablinks"); for (i = 0; i < tablinks.length; i++) { tablinks[i].className = tablinks[i].className.replace(" active", ""); } document.getElementById(cityName).style.display = "block"; evt.currentTarget.className += " active"; } </script> </body> </html> I hope this code will be usefull. Thank You.
  18. Makwana Prahlad
    yes direct run by file name
  19. Makwana Prahlad
    Hello, @eef freef Please try this code,To Centering image using HTML: <!DOCTYPE html> <html> <body> <center> <img src="smiley.gif" alt="Smiley face" width="42" height="42"> </center> </body> </html> I hope above code will be useful for you. Thank you.
  20. Makwana Prahlad
    <!DOCTYPE html> <html lang="en"> <head> <!-- Meta Tags for Bootstrap 4 --> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <link rel="shortcut icon" type="image/png" href="Your Favicon Image Link" /> <meta name="description" content="Meta Description for your Page."> <title>Enter Title for Your Page</title> <!-- Bootstrap 4 CSS --> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous"> <style> /* Hide Overflow */ body { overflow-x: hidden; } /* Card Alignment */ .card { margin: 30px; text-align: center; } /* Header Jumbotron */ .jumbotron{ color: #990000; background-color: #fafafa; margin-bottom: -20px; background: #fff; text-align: center; border-radius: 0; } /* Footer Jumbotron */ .jumbotron-fluid { background: lightgrey; padding: 50px; text-align: center; } /* Margin for Menu */ .outframe { padding: 0 20px; } /* Shadow Effect for Button, Collapse & Cards */ .btn-spl { box-shadow: 0 1px 4px rgba(100, 20, 100, .6); border-radius: 0px; } /* Heading with Divider */ .title { line-height: 2.5; text-align: center; } .title span { display: inline-block; position: relative; } .title span:before, .title span:after { content: ""; position: absolute; height: 5px; border-bottom: 1px solid lightgray; border-top: 1px solid lightgray; top: 0; width: 75%; margin-top:35px; } .title span:before { right: 100%; margin-right: 15px; } .title span:after { left: 100%; margin-left: 15px; } </style> </head> <body> <!-- Navbar --> <nav class="navbar fixed-top navbar-toggleable-md navbar-inverse bg-primary"> <button class="navbar-toggler navbar-toggler-right" type="button" data-toggle="collapse" data-target="#navbar" aria-controls="navbar" aria-expanded="false" aria-label="Toggle navigation"> <span class="navbar-toggler-icon"></span> </button> <a class="navbar-brand" href="#"> <img src="assets/images/logo.png" width="30" height="30" class="d-inline-block align-top" alt="logo"> Bootstrap 4 Theme</a> <div class="collapse navbar-collapse" id="navbar"> <ul class="navbar-nav mr-auto ml-auto"> <li class="nav-item outframe"> <a class="nav-link" href="#">Home</a> </li> <li class="nav-item outframe"> <a class="nav-link" href="#">Menu</a> </li> <li class="nav-item dropdown outframe"> <a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"> Dropdown </a> <div class="dropdown-menu" aria-labelledby="navbarDropdown"> <a class="dropdown-item" href="#">Dropdown 1</a> <div class="dropdown-divider"></div> <a class="dropdown-item" href="#">Dropdown 2</a> <div class="dropdown-divider"></div> <a class="dropdown-item" href="#">Dropdown 3</a> </div> </li> </ul> <form class="form-inline my-2 my-lg-0"> <input class="form-control mr-sm-2" type="text" placeholder="Search"> <button class="btn btn-outline-success btn-spl my-2 my-sm-0" type="submit">Search</button> </form> </div> </nav> <br><br> <!-- Carousel --> <div id="slidercaption" class="carousel slide" data-ride="carousel"> <ol class="carousel-indicators"> <li data-target="#slidercaption" data-slide-to="0" class="active"></li> <li data-target="#slidercaption" data-slide-to="1"></li> <li data-target="#slidercaption" data-slide-to="2"></li> </ol> <div class="carousel-inner" role="listbox"> <div class="carousel-item active"> <img class="d-block img-fluid" src="https://img.webnots.com/2017/05/BS_Slide1.jpg" alt="Slide1" width="100%"> <div class="carousel-caption d-none d-md-block"> <h3>Here is a caption for slide 1</h3> <p>Here is short description for slide 1</p> </div> </div> <div class="carousel-item"> <img class="d-block img-fluid" src="https://img.webnots.com/2017/05/BS_Slide2.jpg" alt="Slide2" width="100%"> <div class="carousel-caption d-none d-md-block"> <h3>Here is a caption for slide 2</h3> <p>Here is short description for slide 2</p> </div> </div> <div class="carousel-item"> <img class="d-block img-fluid" src="https://img.webnots.com/2017/05/BS_Slide3.jpg" alt="Slide3" width="100%"> <div class="carousel-caption d-none d-md-block"> <h3>Here is a caption for slide 3</h3> <p>Here is short description for slide 3</p> </div> </div> </div> <a class="carousel-control-prev" href="#slidercaption" role="button" data-slide="prev"> <span class="carousel-control-prev-icon" aria-hidden="true"></span> <span class="sr-only">Previous</span> </a> <a class="carousel-control-next" href="#slidercaption" role="button" data-slide="next"> <span class="carousel-control-next-icon" aria-hidden="true"></span> <span class="sr-only">Next</span> </a> </div> <!-- Hero Header Jumbotron --> <div class="jumbotron"> <h1 class="display-3">Bootstrap 4 Template</h1> <p class="lead">This is a demo theme created with Bootstrap 4. Add some attractive heading for your page here.</p> <hr class="my-4"> <p>Add your subtitle here to explain more about this page in detail.</p> <a class="btn btn-primary btn-lg btn-spl" href="#" role="button">View Facebook Page</a> </div> <h3 class="title"><span>Order Products</span></h3> <!-- Card Deck --> <div class="card-deck"> <div class="card btn-spl"> <img class="card-img-top" src="https://img.webnots.com/2017/04/Bootstrap-Card-Image.png" alt="Card image cap"> <div class="card-block"> <h4 class="card-title">Product 1</h4> <p class="card-text">Here is a longer description of the card and the height will be auto aligned with flex box.</p> <button class="btn btn-primary btn-spl" href="#" role="button">Buy Now</button> </div> <div class="card-footer"> <small class="text-muted">Here is a footer</small> </div> </div> <div class="card btn-spl"> <img class="card-img-top" src="https://img.webnots.com/2017/04/Bootstrap-Card-Image.png" alt="Card image cap"> <div class="card-block"> <h4 class="card-title">Product 2</h4> <p class="card-text">Here is a shorter description of the card.</p> <button class="btn btn-danger btn-spl" href="#" role="button">Buy Now</button> </div> <div class="card-footer"> <small class="text-muted">Here is a footer</small> </div> </div> <div class="card btn-spl"> <img class="card-img-top" src="https://img.webnots.com/2017/04/Bootstrap-Card-Image.png" alt="Card image cap"> <div class="card-block"> <h4 class="card-title">Product 3</h4> <p class="card-text">Here is a longer description of the card and the height will be auto aligned with flex box.</p> <button class="btn btn-secondary btn-spl" href="#" role="button">Buy Now</button> </div> <div class="card-footer"> <small class="text-muted">Here is a footer</small> </div> </div> </div> <hr class="my-5"> <div class="row"> <div class="col-md-6" style="padding:30px 50px;"> <div class="container" style="padding:30px;border:1px solid gray;"> <h3 class="title"><span>Read FAQ</span></h3> <!-- Collapse --> <div id="accordion" role="tablist" aria-multiselectable="true"> <div class="card"> <div class="card-header btn-spl" role="tab" id="firstheading"> <h5 class="mb-0"> <a class="collapsed" data-toggle="collapse" data-parent="#accordion" href="#collapse1" aria-expanded="false" aria-controls="collapse1"> Heading 1 </a> </h5> </div> <div id="collapse1" class="collapse" role="tabpanel" aria-labelledby="firstheading"> <div class="card-block"> Here is the content for the first section. </div> </div> </div> <div class="card"> <div class="card-header btn-spl" role="tab" id="secondheading"> <h5 class="mb-0"> <a class="collapsed" data-toggle="collapse" data-parent="#accordion" href="#collapse2" aria-expanded="false" aria-controls="collapse2"> Heading 2 </a> </h5> </div> <div id="collapse2" class="collapse" role="tabpanel" aria-labelledby="secondheading"> <div class="card-block"> Here is the content for the second section. </div> </div> </div> <div class="card"> <div class="card-header btn-spl" role="tab" id="headingThree"> <h5 class="mb-0"> <a class="collapsed" data-toggle="collapse" data-parent="#accordion" href="#collapse3" aria-expanded="false" aria-controls="collapse3"> Heading 3 </a> </h5> </div> <div id="collapse3" class="collapse" role="tabpanel" aria-labelledby="headingThree"> <div class="card-block"> Here is the content for the third section. </div> </div> </div> <div class="card"> <div class="card-header btn-spl" role="tab" id="headingFour"> <h5 class="mb-0"> <a class="collapsed" data-toggle="collapse" data-parent="#accordion" href="#collapse4" aria-expanded="false" aria-controls="collapse3"> Heading 4 </a> </h5> </div> <div id="collapse4" class="collapse" role="tabpanel" aria-labelledby="headingFour"> <div class="card-block"> Here is the content for the third section. </div> </div> </div> </div> </div> </div> <!-- Form --> <div class="col-md-6" style="padding:30px 50px;"> <div class="container" style="padding:30px;border:1px solid gray;"> <h3 class="title"><span>Contact Us</span></h3> <form> <!-- Text Input --> <div class="form-group"> <label for="username">Enter Username:</label> <input type="text" class="form-control" id="username" aria-describedby="Username" placeholder="Enter Username"> </div> <!-- Single Select --> <div class="form-group"> <label for="singleselect">Choose Option:</label> <select class="form-control" id="singleselect"> <option>Option 1</option> <option>Option 2</option> <option>Option 3</option> <option>Option 4</option> <option>Option 5</option> </select> </div> <!-- Textarea --> <div class="form-group"> <label for="textarea">Enter Your Comment:</label> <textarea class="form-control" id="textarea" rows="5"></textarea> </div> <!-- Submit Button --> <button type="submit" class="btn btn-success btn-spl btn-md">Submit</button> </form> </div> </div> </div> <!-- Footer --> <div class="jumbotron-fluid"> <div class="container"> <h2 style="padding-bottom: 30px">This is a footer section of your page.</h2> <p class="lead">© All Rights Reserved <a href="https://www.webnots.com/">WebNots</a></p> </div> </div> <!-- Bootstrap 4 Scripts --> <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script> </body> </html> . You can further add Google Analytics and advertisement code on the page as in the demo page.This is full Responsive block demo Template
  21. Makwana Prahlad
    Hello, @Aviram Please try this query, To AUTO INCREMENT statement in SQL: CREATE TABLE tenants( apartment_number_first_floor INT IDENTITY(1,1) PRIMARY KEY, family_name VARCHAR (12) DEFAULT NULL, sur_name VARCHAR (8) DEFAULT NULL, telephone_number INT(3) NOT NULL, ); I hope above query will be useful for you. Thank you.
  22. Makwana Prahlad
    try is select * from example where(case when a.insert_time>='12-dec19' and a.status =1 as cars end);
  23. Makwana Prahlad
    Hello, @Megpiri Please try this query,To Change date format for Data conversion: select convert(varchar,getdate(),107) as "Date" I hope above query will be useful for you. Thank you.
  24. Makwana Prahlad
    select * from [TableName] where [ColumnName] Like '%an%' and not [ColumnName] Like '%and%' Hi, Try this, i hope this will work.
  25. Makwana Prahlad
    select * from [TableName] where [ColumnName] Like '%an%' and not [ColumnName] Like '%and%' Hi, Try this, i hope this will work.
×
×
  • Create New...